In this blog, you will find the SQL query to extract the Employee expense payments in Oracle apps R12.1.3 Query: select aps.vendor_name “Supplier”, aca.AMOUNT “Payment [...]

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

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

This sql query will be useful to extract the approval limits that are changed for any employee’s job/assignments supervisor change SQL Query SELECT pbg.name business_group_name, [...]

This sql query will help to get the payment status of the requisition , PO , Invoice and its payment status SELECT DISTINCT prh.segment1 req_number, prh.authorization_status req_status [...]

This post will help you to understand, how effectively you can amend the “Colombian Withholding Tax type certificate footer information” There is a standard setup to setup the footer [...]

The requirement is to update/attach a new Bill To Location to existing supplier sites. The below script can be used to update the Bill To Location for the existing supplier sites and this script [...]