Skip to main content

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

Comments

Popular posts from this blog

R12 Oracle E-Business Tax Configuration Guide

Applies to: Oracle E-Business Tax - Version: 12.0 to 12.2 Information in this document applies to any platform. Abstract R12 Oracle E-Business Tax Configuration Guide Document History R12 Oracle E-Business Tax Configuration 1. Tax Basic Tax Configuration Tax Definition: comprises the tax data that you set up for each tax regime and tax that your company or institution is subject to. The Tax Authority designates the regulations and rates that apply to the tax regime. Required Task List a) External Dependencies Create First Party: Legal Entity and Establishments Create Reporting and Collecting Tax Authorities b) Tax Configuration Create Tax Authorities Party Tax Profiles Create Tax Regimes Create First Party Legal Entity Party Tax Profile Create Tax Create Tax Status Create Tax Jurisdictions Tax Rate Responsibility: Tax Manager Path: Tax Managers -> Tax Managers -> Home Complete the following setup tasks: -Legal Entities and Establishments -Reporting and Collecting Tax Authorities ...

Create Accounting for a Payment generates errors 95333 and 95359

Create Accounting for a Payment generates errors 95333 and 95359 Error: 95333: A conversion rate does not exist to convert USD to AUD for the conversion type Corporate and conversion date 20-MAR-09 for line -25. Please use the Daily Rates form in General Ledger to enter a conversion rate for these currencies, conversion date and conversion type. 95359: There is no accounted amount for the subledger journal entry line. Please inform your system administrator or support representative that: The source assigned to the accounting attribute Accounted Amount has no value for extract line number 88547. Please make sure the source assigned to the accounting attribute Accounted Amount has a valid value, or assign a different source to this accounting attribute. Solution: 1. Specify a conversion rate for the currencies and conversion date mentioned in the error message 95333 Navigation under the General Ledger responsibility: Setup > Currencies > Currency Rates Manager > Daily Rates ...

R12: Payables Holds Explained – Why They are Applied and How to Remove

Invoice Validation checks the matching, tax, period status, exchange rate, and distribution information for invoices you enter. If an invoice has a hold, you can release the hold by correcting the exception that caused Invoice Validation to apply the hold by updating the invoice or the purchase order, or changing the invoice tolerances. Then resubmit Invoice Validation to release the hold. In the Invoice Holds tab, you can manually release certain invoice holds, even if you have not resolved the matching error condition. Here are some of the regular holds and explanation Account Holds Payables uses holds with this type to identify invoices with invalid or incorrect accounts. An invalid account prevents payment of an invoice and prevents Payables from creating accounting entries for an invoice or payment. Dist Acct Invalid:  Invoice distribution distributed to invalid account. To release the holds you must correct account and resubmit invoice validation. ERV Acct Invalid: ...