Script to see all lock objects
set term on; set lines 130; column sid_ser format a12 heading 'session,|serial#'; column username format a12 heading 'os user/|db user'; column process format a9 heading 'os|process'; column spid format a7…
Read MoreEmployee Supplier Prepayment Account details extract query
/*Query to get the Prepayment Account details of the Employee Suppliers */ SELECT * FROM ( SELECT DISTINCT pbg.name business_group_name, papf.employee_number, papf.full_name employee_name, gcck.concatenated_segments prepayment_account_site_level, hou.name opperating_unit_name, apssa.vendor_site_code, fu.user_name last_updated_user…
Read MoreHow to add custom/fields PO XML generation
In this blog, We will see how can we add the custom XML segments/fields that can be extended in PO XML output. PO_CUSTOM_XMLGEN_PKG package is the place where the business…
Read MoreQuery 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…
Read MorePO 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…
Read MoreRecurring 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 batch_description, ( SELECT…
Read MoreAME 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 real-time systems.…
Read MoreHow to remove the Oracle OLAP Option from a 12c Database during 19c Upgrade
Check the OLAP option is enabled in database. select parameter, value from v$option where parameter = ‘OLAP’; PARAMETER VALUE OLAP FALSE select comp_id, comp_name, version, status, schema from dba_registry where…
Read MoreJava Script to return of no. of days between two date
// JavaScript program to illustrate // calculation of no. of days between two date <script type = “text/javascript” > // To set two dates to two variables var date1 =…
Read MoreRoll Back the Import Load Program Submitted in HCM
roll-back-the-import-load-program-submitted-in-hcm
Read More