R12: PA: About Additional Information of Patch 25040280
(Doc ID 2369138.1)
Last updated on NOVEMBER 15, 2022
Applies to:
Oracle Project Foundation - Version 12.1.3 and laterInformation in this document applies to any platform.
Goal
Explanation of Additional Information described in the readme of patch 25040280
README
Additional Information
Read Me
UNDO_ACCOUNTING is a Generic Public API in addition to the existing REVERSE_JOURNAL_ENTRIES and DELETE_JOURNAL_ENTRIES. It has the intelligence to decide
to call either Reverse Journal Entries or the Delete Journal Entries APIs based on the Transfer Status of the Accounting Journal. If the event has to be swept,
pass the date into the parameter : P_GL_DATE and P_SWEEP_REQUIRED: 'Y'
At any time:
1) Use existing Delete Journal Entries API for Accounting Journal Not Transferred to GL or new UNDO_ACCOUNTING
1) Use Reverse Journal Entries API for Accounting Journal Transferred to GL or new UNDO_ACCOUNTING
How to uptake the new API:
Like the earlier Delete or Reverse Journal Entries APIs, please call the API with EVENT_ID.
On completion of the execution, OUT parameter P_ARRAY_ERRORS contains the list of undo accounting errors if for the event.
Sample code for reading out parameter P_ARRAY_ERRORS to get undo accounting errors.
IF P_ARRAY_ERRORS.count > 0 THEN
FOR i IN 1..P_ARRAY_ERRORS.count LOOP
dbms_output.put_line(' application id '||P_ARRAY_ERRORS(i).application_id);
dbms_output.put_line('Event id'||P_ARRAY_ERRORS(i).event_id);
dbms_output.put_line('Entity id '||P_ARRAY_ERRORS(i).entity_id );
dbms_output.put_line('Ledger id '|| P_ARRAY_ERRORS(i).ledger_id);
dbms_output.put_line(' Message number '||P_ARRAY_ERRORS(i).message_number);
dbms_output.put_line('Encoded Msg '||P_ARRAY_ERRORS(i).encoded_msg);
dbms_output.put_line('Ae header id '||P_ARRAY_ERRORS(i).ae_header_id);
dbms_output.put_line('Ae line num '||P_ARRAY_ERRORS(i).ae_line_num);
dbms_output.put_line('Accounting batch id '||P_ARRAY_ERRORS(i).accounting batch id);
dbms_output.put_line('error_source_code '||P_ARRAY_ERRORS(i).error_source_code);
dbms_output.put_line('request id '||P_ARRAY_ERRORS(i).request id);
END LOOP;
END IF
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |