Oracle GL Transaction Register Report
Header : Outbound details from oracle general ledger Usage of Heading : Useful to get General ledger transaction details information data Description of post : This query is very useful…
Read MoreForm Personalization on Purchasing Receipt Standard Form
Header : How to apply Form Personalization on Purchasing Receipt Standard Form Usage of Heading : Useful in the purchasing module in receipt of goods Description of post : Form…
Read MoreHow to Enable DFF in Bank Account Transfer Page
Header : How to Enable DFF in Bank Account Transfer Page Usage of Heading : Useful in the cash management module in banking page Description of post : DFF means…
Read MoreSQL Query to Extract the Corporate Card Inter-Company Accounting Details in Oracle APPS R12
SQL Query to Extract the Corporate Card Inter-Company Accounting Details in Oracle APPS R12 Introduction This script will help to extract the complete Corporate Card Inter-Company Accounting Details in Oracle…
Read MoreUnderstanding XML Bursting in BI Reports
XML Bursting is used to split a single XML file in to multiple XML blocks as the per the defined XML Element. Below are the Steps involved. Generate the XML…
Read MoreAlternate 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 More