How to collect data from tables of various EBS-related businesses

1. Processing

Run rcv11i_sa. SQL with reference to Note: 402245.1. Enter the po number, and the remaining values are default.

Refer to Note: 1294177.1. If there is a problem with the above script, you can download the script from this Note to find data for each table separately.

2. Order Management

Refer to Note: 133464.1 to download the HTMomse12 script. This is used to find OM-related data.

3. Oracle EBS has dedicated tools to collect business-related data. Note: 421219.1

First, go to the Responsibility: Oracle Diagnostics Tool

Click Execute

Enter the PO number.

In this case, a request is submitted and can be viewed or downloaded after the operation is completed. this tool not only collects tracing-related data, but also collects data from various other modules, which is much more convenient than the startup script.