Query to get the baseline for an sql id

Please use below query.   col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format 999 col child_number format 99999 ...

PO XML Views in Oracle

In Oracle Purchasing, The PO Output for Communication program is responsible for sending the PO copies to vendors with respect to the communication details captured. During the call of this ...

Recurring GL Journals extract query

In Oracle Financials, We have a provision to create a recurring journal in GL application. This blog will helping in extracting that journals. SELECT b.name batch, b.description ...

AME Rule changes audit queries

In Oracle E-Biz applications Approvals Management Engine(AME) is widely used for approvals in Purchasing,HR modules. Especially an audit enabled systems, We need to capture the changes in the ...

Start typing and press Enter to search