R12- AR Tables and Changes

in Oracle E-Business Suite & Oracle Fusion Applications; Here goes... AR R12 Tables New Tables Description of Change AR_REC_TRX_LE_DETAILS_ALL Added detail level table under AR_RECEIVABLES_TRX_ALL to record the ...
+ Post Reply + Post New Topic
Results 1 to 2 of 2
  1. #1
    Ramji's Avatar
    Ramji is offline Forum Guru
    Points: 18,040, Level: 85
    Join Date
    14 Jan 2012
    Location
    Nomad
    Posts
    523
    Points
    18,040

    R12- AR Tables and Changes

    Here goes...
    AR R12 Tables
    New Tables
    Description of Change
    AR_REC_TRX_LE_DETAILS_ALL
    Added detail level table under AR_RECEIVABLES_TRX_ALL to record the relationship between a receivables activity and the sets of asset and liability tax codes by legal entity.
    AR_DEFERRAL_REASONS
    Revenue Deferral Reasons
    AR_DEFERRED_LINES_ALL
    Revenue Deferral Reasons
    AR_RDR_PARAMETERS_GT
    Revenue Deferral Reasons
    AR_REVIEWED_LINES_GT
    Revenue Deferral Reasons
    Changed Tables
    Table Name
    Description of Change
    RA_CUSTOMER_TRX_LINES_ALL
    Added numerous columns to support E-Business Tax and line-level Ship To, Added Payment extension identifier.
    AR_MEMO_LINES
    Added tax_product_category to support E-Business Tax uptake.
    AR_TRX_LINES_GT
    Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag.
    AR_TRX_LINES_TMP_GT
    Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag.
    AR_ARCHIVE_DETAIL
    Added numerous columns to support E-Business Tax and line-level Ship To,
    RA_BATCH_SOURCES_ALL
    Obsoleted invalid_tax_rate_rule column.
    HZ_CUST_SITE_USES
    Migrated tax_code, tax_header_level_flag, tax_reference, and tax_classification to ZX_PARTY_TAX_PROFILE and ZX_REGISTRATIONS tables.
    AR_CASH_RECEIPTS_ALL
    Added Payment extension identifier and obsoleted, approval_code,
    address_verification_code, payment_server_order_num, Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID, Added legal_entity_id column.
    AR_RECEIPT_METHODS
    Added Payment Channel Code and obsoleted, payment_type_code, merchant_ref, merchant_id, auto_print_program_id
    RA_CUSTOMER_TRX_ALL
    Added Payment extension identifier and Payment Attributes,
    obsoleted payment_server_order_num, approval_code, address_verification_code, Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID, Added legal_entity_id column.
    RA_INTERFACE_LINES_ALL
    Added Payment extension identifier and Payment Attributes, and obsoleted payment_server_order_num, approval_code, address_verification_code, Added legal_entity_id column, Added parent_line_id and deferral_exclusion_flag.
    AR_AUTOREC_EXCEPTIONS
    Renamed column REMIT_BANK_ACCT_ID to REMIT_BANK_ACCT_USE_ID
    AR_BATCHES_ALL
    Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_BATCH_SOURCES_ALL
    Renamed column DEFAULT_REMIT_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_INTERIM_CASH_RECEIPTS_ALL
    Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_RECEIPT_METHOD_ACCOUNTS_ALL
    Renamed column BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_TRX_HEADER_GT
    Added legal_entity_id column
    AR_TRX_HEADER_TMP_GT
    Added legal_entity_id column
    AR_LINE_CONTS_ALL
    Added contingency_id as a foreign key to AR_DEFERRAL_REASONS
    AR_TRX_CONTINGENCIES_GT
    Added contingency_id, expiration_event_date and completed_flag.
    Obsolete Tables
    Table Name
    AR_TA_ASGN_TO_INT_ALL
    AR_TA_CASHAPP_OB_ALL
    AR_TA_CR_AGEN_INF_ALL
    AR_TA_CUST_HIER_CHILD
    AR_TA_CUST_HIER_PARNT
    AR_TA_CUST_INT_ALL
    AR_TA_CUST_TRXSTR_ALL
    AR_TA_DEDN_ASSGNS_ALL
    AR_TA_DEDN_INT_ALL
    AR_TA_DEDN_RELATE_ALL
    AR_TA_LEGACY_CUST_INT
    AR_TA_LEGACY_STAT_INT
    AR_TA_PAYMNT_HIST_ALL
    AR_TA_PROF_ASSGNT_ALL
    AR_TA_PROMOTIONS_ALL
    AR_TA_PROMOTIONS_INT
    AR_TA_PROM_CUST_ALL
    AR_TA_PROM_CUST_MAP
    AR_TA_PROM_LINES_INT
    AR_TA_PROM_PAYMNT_ALL
    AR_TA_PROM_PAYMNT_TYP
    AR_TA_PROM_PRODS_ALL
    AR_TA_PROM_STATUS_MAP
    AR_TA_RECON_INFO_ALL
    AR_TA_RECV_TRXSET_ALL
    AR_TA_REMIT_HIST_ALL
    AR_TA_REMIT_PROF_ALL
    AR_TA_RISK_COMENT_ALL
    AR_TA_RULES_ALL
    AR_TA_RULE_OUTPUT
    AR_TA_RULE_SETS_ALL
    AR_TA_RULE_SET_LN_ALL
    AR_TA_TRX_SETS_ALL
    AR_TA_TRX_SET_LN_ALL
    AR_TA_TRX_TO_CREATE
    AR_TA_TRX_TYP_INT_ALL
    AR_TA_VERSIONS
    New Views
    View Name
    Description of Change
    AR_MEMO_LINES_VL
    Added tax_product_category.
    AR_SHIP_ADDRESS_V
    Removed hz_loc_assignments.
    RA_CUSTOMER_TRX_LINES_V
    Added numerous columns
    AR_DOCS_RECEIVABLES_V
    AR_FUNDS_CAPTURE_ORDERS_V
    ARBR_DOCS_RECEIVABLES_V
    ARBR_DOCUMENT_LINES_V
    ARBR_FUNDS_CAPTURE_ORDERS_V
    AR_CBA_BANK_BRANCH_CONTACTS_V
    AR_CBA_BANK_ACCOUNT_CONTACTS_V
    AR_CBA_EFT_USER_NUMBER_V
    AR_LINE_DEFERRAL_REASONS
    Revenue Deferral Reasons
    AR_LINE_CONTINGENCIES_V
    Revenue Deferral Reasons
    AR_RDR_ITEMS_V
    Reasons, Validation Set for RDR setup
    Changed Views
    View Name
    Description of Change
    AR_AUTOMATIC_RECEIPTS_FORMAT_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.
    AR_BOE_AUTO_RECEIPTS_V
    Added Payment extension identifier to view
    AR_BOE_REMIT_RECEIPTS_CBUNR_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.
    AR_BOE_REMIT_RECEIPTS_NONCBR_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.
    AR_BOE_REMIT_RECEIPTS_V
    Modified the view to accommodate the data model changes related to payment uptake project
    AR_BR_ASSIGNMENTS_V
    Modified the view to accommodate the data model changes related to payment uptake project
    AR_BR_MAIN_REMIT_BATCH_V
    Modified the view to accommodate the data model changes related to payment uptake project
    AR_CASH_RECEIPTS_V
    Added Payment extension identifier and payment channel identifier to view
    AR_CUSTOMER_BILLS_TRX_V
    Added Payment extension identifier and payment channel identifier to view
    AR_REMITTED_RECEIPTS_FORMAT_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.
    RA_CUSTOMER_TRX_CM_V
    Modified the view to accommodate the data model changes related to payment uptake project
    Added Payment extension identifier and the payment channel identifier to view
    RA_CUSTOMER_TRX_PART_CB_V
    Modified the view to accommodate the data model changes related to payment uptake project
    Added Payment extension identifier and the payment channel identifier to view
    RA_CUSTOMER_TRX_PARTIAL_V
    Modified the view to accommodate the data model changes related to payment uptake project
    Added Payment extension identifier and the payment channel identifier to view
    AR_AEL_GL_REC_V
    Made changes to support the new Internal Bank Account data model.
    AR_AEL_SL_REC_V
    Made changes to support the new Internal Bank Account data model.
    AR_CUSTOMER_BILLS_TRX_V
    Made changes to support the new Internal Bank Account data model.
    AR_BR_MAIN_REMIT_BATCH_V
    Made changes to support the new Internal Bank Account data model.
    AR_BATCHES_V
    Made changes to support the new Internal Bank Account data model.
    AR_BATCH_REMIT_V
    Made changes to support the new Internal Bank Account data model.
    AR_BOE_REMIT_RECEIPTS_V
    Made changes to support the new Internal Bank Account data model.
    AR_CASH_RECEIPTS_V
    Made changes to support the new Internal Bank Account data model.
    AR_INTERIM_CR_LINES_V
    Made changes to support the new Internal Bank Account data model.
    AR_CASH_RECEIPTS_V
    Added legal_entity_id column
    AR_CUSTOMER_BILLS_TRX_V
    Added legal_entity_id column
    AR_PAYMENT_SCHEDULES_PMT_V
    Added legal_entity_id column
    AR_PAYMENT_SCHEDULES_TRX2_V
    Added legal_entity_id column
    RA_CUSTOMER_TRX_CR_TRX_V
    Added legal_entity_id column
    RA_CUSTOMER_TRX_PARTIAL_V
    Added legal_entity_id column
    RA_CUSTOMER_TRX_PART_CB_V
    Added legal_entity_id column
    AR_PAYMENT_SCHEDULES_V
    Added legal_entity_id column
    RA_CUST_TRX_LINE_GL_DIST_V
    Added column user_generated_flag
    Bharat says Thanks.


  2. #2
    y1452001 is offline Junior Member
    Points: 30, Level: 1
    Join Date
    29 Sep 2012
    Posts
    3
    Points
    30

    Re: R12- AR Tables and Changes

    SELECT ac.REMIT_BANK_ACCT_USE_ID,
    cb.BANK_ACCOUNT_NAME,
    ac.REMITTANCE_BANK_ACCOUNT_ID
    FROM ra_customer_trx_all ra ,
    ar_cash_receipts_all ac ,
    ar_receivable_applications_all aaa,
    CE_BANK_ACCOUNTS cb,
    CE_BANK_ACCT_USES_ALL ca
    WHERE aaa.application_type = 'CASH'
    AND aaa.cash_receipt_id = ac.cash_receipt_id
    AND aaa.applied_customer_trx_id = ra.customer_trx_id
    AND ra.CT_REFERENCE='10001' – SO ORDER NUMBER
    AND cb.BANK_ACCOUNT_ID = ca.BANK_ACCOUNT_ID
    Ra.org_id = ac.org_id
    AND cb.ORG_ID = ‘82’
    Question -> Returning multiple rows? How to get sales order beneficiary name, account?

Other Solutions
  1. Link between Invoice Tables - GL Tables
    By tomloera in forum Oracle Financials
    Replies: 0
    Last Post: 02-15-2011, 03:35 PM
  2. tables in a DBC and free tables
    By ali0482 in forum Interview and Jobs Discussions
    Replies: 1
    Last Post: 09-02-2010, 05:17 PM
  3. Link between PO Tables and AP Tables
    By Monziac in forum Oracle Apps Technical
    Replies: 8
    Last Post: 01-13-2010, 01:44 PM