/*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, [...]

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 can implement their [...]

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 [...]

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 [...]

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 [...]

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 [...]

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, [...]

// 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 = new [...]

roll-back-the-import-load-program-submitted-in-hcm

calling-java-script-in-integrations