Post date: Jan 31, 2013 4:52:32 AM
Modified:22-Jan-2013
Type:HOWTOStatus:PUBLISHEDPriority:3
Comments (0)
In this Document
Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
This note contains a catalog of scripts that collect data to assist Support/Development in debugging issues regarding Transactions and Reconciliation.
WARNING: Please only use these scripts when advised by Support.
AR_XLA_EXTRACT_INV : AR_XLA_EXTRACT_INV_120.sql
AR_XLA_EXTRACT_BR : AR_XLA_EXTRACT_BR_120.sql
AR_XLA_EXTRACT_CM : AR_XLA_EXTRACT_CM_120.sql
AR_XLA_EXTRACT_TRX : AR_XLA_EXTRACT_TRX_120.sql
AR_XLA_EXTRACT_MISC : AR_XLA_EXTRACT_MISC_120.sql
AR_XLA_EXTRACT_ADJ : AR_XLA_EXTRACT_ADJ_120.sql
AR_XLA_EXTRACT_RECP : AR_XLA_EXTRACT_RECP_120.sql
Script Name
Description
Input Parameters
Supply the following when prompted:
1). product_rule_code
Script Name
Description
This scripts checks the data integrity between AR and XLA schema with known issues and identifies the data issue with known corruptions.
Input Parameters
Supply the following when prompted:
1) org_id
2) low and high gl_date
Enter format DD-MON-YYYY
3) document_type
Provide the value for this parameter based on the affected document :
Transaction : T
Receipt : R
Adjustment : A
Reconciliation : E
All entities : X (or NULL)
4) document_id
Provide the value for this parameter based on the chosen document above :
Transaction : customer_trx_id
Receipt : cash_receipt_id
Adjustment : adjustment_id
Reconciliation : customer_trx_id/cash_receipt_id/adjustment_id
All entities : 0 (or NULL)
Still have questions? Use the live My Oracle Support Receivables Community window below, to search for similar discussions or start a new discussion on this subject.