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 amount”, aca.currency_code “Currency”, aca.check_date “Payment…
Read More/*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 MoreIn 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 MoreIn 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 MoreIn 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 MoreIn 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 MoreThis 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, papf.employee_number, papf.person_id, cur.effective_start_date new_assignment_effective_date, papf.attribute30…
Read MoreThis 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 ph.segment1 po_number ai.invoice_num,…
Read MoreThis 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 information…
Read MoreThe 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…
Read More