Alternate Options for Using LISTAGG Function
If we have a Requirement to Concatenate the list of values in to a Single Field than we can achieve it with LISTAGG Function. As Listagg Function having Size limitation…
Read MoreAR Tax code update API
Introduction: Requested to update the Tax code in customer Ship-to. Solution: We have update the Tax code by using the oracle API. API: DECLARE x_return_status VARCHAR2(10); l_init_msg_list VARCHAR2(1000) := FND_API.G_FALSE;…
Read MorePurchase order Detail Report
Introduction: User wants to pull the Open Purchase order details data. Solution: We provide the view to fulfill their requirement. View: CREATE OR REPLACE VIEW “APPS”.”XDMC_OPEN_PO_DETAIL_V” (“BUYER”, “VENDOR_NO”, “VENDOR”, “SITE_NO”,…
Read MoreProgram to extend the customer sites into the multiple orgs.
Objective: The below code logic is used to extend the customer sites into the different org. (eg. Suppose customer sites exist in 82 org and the requirement is to extend…
Read MoreAutoconfig fails after clone error code (adgentns.pl fails: AC-50480: Internal error occurred)
Description: Once we completed clone successfully after that we run the Autoconfig its completed with error. error code (AC-50480: Internal error occurred) Cause : The issue can occur if the…
Read MoreApproval Limit change extract for any Job/Assignment change
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, papf.employee_number, papf.person_id, cur.effective_start_date new_assignment_effective_date, papf.attribute30…
Read MoreRequisition to Invoice Payment Status extract query
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 ph.segment1 po_number ai.invoice_num,…
Read MoreHow to amend Colombian Withholding Tax type certificate footer information
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 information…
Read MoreSupplier Bill To Location Update script
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…
Read MoreOracle Ebs R12.1 Post Install Check Error
This error occurred when we install Oracle EBS R12.1 on oracle cloud. CAUSES OF ISSUE The http port number and instance public ip is blocked by the vcn network. There…
Read More