Oracle Aps Technical

 Oracle Applications (Oracle E-Business Suite) use Loader Data files (LDT files) for migrating application configurations and data between instances. What are LDT Files? LDT files are plain text files used by the FNDLOAD utility in Oracle E-Business Suite to upload or download data from the database. They are commonly used for migrating setups, such as concurrent programs, value sets, and lookups, across different environments. LDT Commands: 1.        Download Data to LDT File FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct output_file.ldt FND_PROGRAM APPLICATION_SHORT_NAME="Application_Short_Name" CONCURRENT_PROGRAM_NAME="Program_Name" 2.        Upload Data from LDT File FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct input_file.ldt Key Parameters apps/apps_pwd : The username and password for the Oracle Apps database. 0 Y...

  Adding Hyperlink (URL) to XML Publisher   When working with XML output, you might encounter fields that contain URL data. In many cases, it's not enough to simply display these URLs as plain text; you need to make them active links that users can click. Below will show you process of converting a URL field into an active hyperlink within an RTF (Rich Text Format) template, specifically for the field "CF_COURIER_URL". We the column name is " CF_COURIER_URL" which contains the active url. Create a form field in RTF for CF_COURIER_URL Edit the form field and use the below command   <?if@inlines: CF_COURIER_URL!='N/A'?><fo:basic-link external-destination="{.//CF_COURIER_URL}"   color="blue" text-decoration="underline">External Url</fo:basic-link><?end if?>   Output:

On-hand quantity represents the actual quantity of an item available in inventory at a specific location and point in time. SELECT     ood.organization_id,     ood.organization_code,     msi.inventory_item_id,     msi.segment1 item_code,     msi.description,     msi.primary_uom_code,     msi.creation_date item_creation_date,     nvl(SUM(moq.primary_transaction_quantity),0) onhand_qty,     (         SELECT             item_cost         FROM             cst_item_costs cst         WHERE                 cst.cost_type_id = 2             AND msi.inventory_item_id = cst.inventory_item_id             AND ood.organization_id = cst.organization_id     )        ...

 Sample API to update supplier site liability account DECLARE    lc_return_status       varchar2 (2000);    ln_msg_count           number;    ll_msg_data            long;    ln_vendor_id           number;    ln_vendor_site_id      number;    ln_message_int         number;    ln_party_id            number;    lrec_vendor_site_rec   ap_vendor_pub_pkg.r_vendor_site_rec_type;    CURSOR c_vendorsites    IS       SELECT   xv.vendor_id,                vendor_site_id,                xv.VENDOR_NO,                xv.SITE_NO         FROM  ...

Item On-Hand Quantity For A Specific Date  SELECT   qslt.organization_id, qslt.inventory_item_id, as_of_date_on_hand   FROM   (  SELECT   organization_id,                      inventory_item_id,                      SUM (qty) AS as_of_date_on_hand               FROM   (  SELECT   organization_id,                                  inventory_item_id,                                  SUM (transaction_quantity) qty                           FROM   mtl_onhand_quantities_detail                   ...

Uninvoiced Receipts: SELECT   pha.segment1 po_number,          TO_CHAR (pha.creation_date, 'DD-MON-RRRR') po_date,          (SELECT   vendor_name             FROM   ap_suppliers ap            WHERE   ap.vendor_id = pha.vendor_id)             supplier_name,          pla.quantity,          pla.unit_price,          pla.quantity * pla.unit_price AS line_amount,          (SELECT   concatenated_segments             FROM   gl_code_combinations_kfv gcc            WHERE   gcc.code_combination_id = pda.code_combination_id)             charge_account,          rsh...

Step1: Goto AU_TOP/resource cd $AU_TOP/resource Step2: Execute the below command. frmcmp_batch module=CUSTOM.pll userid=apps/<apps password> output_file=CUSTOM.plx module_type=LIBRARY batch=yes compile_all=special