My Oracle Support Banner

R12: PA: Patch 25040280付属のRedeMeに記載されたAdditional Informationについて (Doc ID 2369573.1)

Last updated on MARCH 05, 2018

適用範囲:

Oracle Project Foundation - バージョン 12.1.3 以降
この文書の内容はすべてのプラットフォームに適用されます。

目的

パッチ付属のReadMeに以下記載があります。

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


 パッチ適用の際にどのような作業が必要になるのでしょうか?

解決策

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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