My Oracle Support Banner

AIA: How To Generate E-Business Suite DB Trace for PL/SQL API Invocations from AIA (Doc ID 1327445.1)

Last updated on DECEMBER 14, 2018

Applies to:

Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite - Version 2.2 to 11.3 [Release 2 to 11.3]
Oracle Project Portfolio Management Integration Pack for Primavera P6 and Oracle E-Business Suite - Version 2.5 to 3.1 [Release 2.5 to 3.1]
Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite - Version 1.1 to 3.1.1 [Release 1 to 3.1]
Information in this document applies to any platform.

Goal

Explain how to generate the Raw Database Trace File for E-Business Suite API invocations made/submitted from AIA.

Example: In Agile PLM PIP, BPEL Process CreateEngineeringChangeOrderListEbizProvABCSImpl  invokes E-Business Suite PL/SQL API  INV_EBI_CHANGE_ORDER_PUB.PROCESS_CHANGE_ORDER_LIST

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
 Identify Integration User
 Enable trace for integration user
 Generate and collect Database trace
References

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