Embedded Files
Post date: Jan 31, 2013 4:52:32 AM
Data Collection Script Catalog for Transaction and Reconciliation Issues in Oracle Receivables Release 12 [ID 974434.1]
Modified:22-Jan-2013
Type:HOWTOStatus:PUBLISHEDPriority:3
Comments (0)
In this Document
Applies to:
Applies to:
Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
Goal
Goal
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.
Fix
Fix
Reconciliation Scripts
Reconciliation Scripts
Standalone Diagnostics
Standalone Diagnostics
Extract Scripts: These can be used for all accounting methods including MFAR
Extract Scripts: These can be used for all accounting methods including MFAR
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
SLA Script
SLA Script
Script Name
Description
Input Parameters
Supply the following when prompted:
1). product_rule_code
Data Corruption Script
Data Corruption Script
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)
Community Discussions
Community Discussions
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.
Page updated
Google Sites
Report abuse