Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem:
Fatal error in Accounting Entries Exceptions Report
Log files:
Payables_Accounting_Process_280609.txt reports fatal error for IMDAAD LLC 102736
Account From Date: 01-JUN-09 Submit Transfer to GL: Yes Summarize Report: No
Account To Date: 28-JUN-09 Submit Journal Import: No Invoice Batch Name:
Document Class: All Validate Accounts: Yes Payment Batch Name:
Account From Date: 01-JUN-09 Submit Transfer to GL: Yes Summarize Report: No
Account To Date: 28-JUN-09 Submit Journal Import: No Invoice Batch Name:
Document Class: All Validate Accounts: Yes Payment Batch Name:
Solution:
Execute the following steps::
1. Download undoatg.zip from ftp://ftp.oracle.com/support/hidden/patchsets/AP/scripts/undoatg.zip
If you already have a copy of this script from a previous SR verify that you have version
undoatgh 1.8 or higher. If not download a new copy. The version can be found on the first
line of the undoatgh.sql script.
2. Stop all users from using concurrent or on-line accounting until this process is finished.
3. Create a table of the events to undo.
create table SR_7662297_992 as
select distinct accounting_event_id
from ap_accounting_events_all
where accounting_event_id in (134530, 134531, 134572)
and source_id in (117733);
4. Undo the Events and report for later GL manipulation
Run UndoAtgh.sql
Enter Org ID: 358
Enter option 1 for Display Selected Event Details
Enter option 1 to display AP Accounting Data
Enter option 3 for Accounting Events in an Existing Table
Enter table name = SR_7662297_992
Undo the Events Now: Y
Enter Y to Sweep to Currently Open Period
Enter the Currently Open Period Name: XXXXXX (any valid period that's currently open)
Enter N to not delete events IDs (You will only get this prompt on 11i.AP.K and above)
COMMIT; <<< the script does not self-commit
5. Run the Payables Accounting process with the following parameters:
Account from date:
Account to date:
Document class: ALL
Validate accounts: Y
Debug: Y
If your concurrent process does not show a debug parameter, please use note 198799.1 to
display this parameter and generate a debug log of the Accounting process.
Verify there are no exceptions on the output.
6. Allow users to run the accounting process again.
7. Upload a fresh aplist for invoice_id 117733
Relevant Research => Analysis
1. Download undoatg.zip from ftp://ftp.oracle.com/support/hidden/patchsets/AP/scripts/undoatg.zip
If you already have a copy of this script from a previous SR verify that you have version
undoatgh 1.8 or higher. If not download a new copy. The version can be found on the first
line of the undoatgh.sql script.
2. Stop all users from using concurrent or on-line accounting until this process is finished.
3. Create a table of the events to undo.
create table SR_7662297_992 as
select distinct accounting_event_id
from ap_accounting_events_all
where accounting_event_id in (134530, 134531, 134572)
and source_id in (117733);
4. Undo the Events and report for later GL manipulation
Run UndoAtgh.sql
Enter Org ID: 358
Enter option 1 for Display Selected Event Details
Enter option 1 to display AP Accounting Data
Enter option 3 for Accounting Events in an Existing Table
Enter table name = SR_7662297_992
Undo the Events Now: Y
Enter Y to Sweep to Currently Open Period
Enter the Currently Open Period Name: XXXXXX (any valid period that's currently open)
Enter N to not delete events IDs (You will only get this prompt on 11i.AP.K and above)
COMMIT; <<< the script does not self-commit
5. Run the Payables Accounting process with the following parameters:
Account from date:
Account to date:
Document class: ALL
Validate accounts: Y
Debug: Y
If your concurrent process does not show a debug parameter, please use note 198799.1 to
display this parameter and generate a debug log of the Accounting process.
Verify there are no exceptions on the output.
6. Allow users to run the accounting process again.
7. Upload a fresh aplist for invoice_id 117733
Relevant Research => Analysis
