Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post :…
Read MoreHeader : 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 MoreHeader : 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 MoreHeader : 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 Introduction This script will help to extract the complete Corporate Card Inter-Company Accounting Details in Oracle…
Read MoreXML 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 MoreIf 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 MoreIntroduction: 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 MoreIntroduction: 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 MoreObjective: 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 More