R12 Receivables changes

Receivables

10.1 New Tables

Table Name	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

10.2 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.

10.3 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

 

10.4 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

 

10.5 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