How To Get SLA Data Dumps Such As AAD Dump, GT Table Dump, Header and Line Cursor Data Dump (Doc ID 1906900.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Cost Management - Version 12.0.0 and later
Oracle Receivables - Version 12.0.0 and later
Oracle Subledger Accounting - Version 12.0.0 and later
Oracle Assets - Version 12.0.0 and later
Information in this document applies to any platform.

Goal

How to display the accounting events, product header extract and line extract data passed during the accounting based on the Application Accounting Definition Setup?

This is achieved based on the input of ledgerId, ApplicationId, EventClass, Create Accounting End Date and, optionally, the EntityID and EventType.  (If not provided, all the events of the given Event Class are selected).
This script can also be used to get the dump of the AAD package if input need_aad_package_dump is set to Y.  In that case, input the AMB_CONTEXT_CODE, PRODUCT_RULE_TYPE_CODE, PRODUCT_RULE_CODE and AAD dump file name.

Solution

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 hundreds of Community platforms