R12: PA: About Additional Information of Patch 25040280 (Doc ID 2369138.1)

Last updated on NOVEMBER 15, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.