FND Load

By -
FNDLOAD
========
  • FNDLOAD is used to transfer various AOL Objects between instances.
  • FNDLOAD executable can be located at $FND_TOP/bin- config files.

Syntax
=====
FNDLOAD [username/password] 0 Y [mode] [configuration file] [target data file] [object type key] [object Identifier]
  • 0 Y - concurrent program flags. 
  • [mode] -for download or upload .
  • [configuration file] - The .lct file like afcpprog.lct  which varies based on the object to transfer.
  • [target data file] - The .ldt file to be created for download or used for upload. 
  • [object type key] -The object type.
  • [object Identifier] - The object name, for ex: short name for CONCURRENT_PROGRAM_NAME='XXACMEPRT'.

FORM Personalization
================
 Download
     FNDLOAD <userid>/<pass> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt>  FND_FORM_CUSTOM_RULES function_name=<function name>

 Upload
     FNDLOAD <userid>/<pass> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt>

Concurrent program
=================
 Download
    FNDLOAD <userid>/<pass> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct $XX_TOP/admin/import/<LDT file name>.ldt PROGRAM CONCURRENT_PROGRAM_NAME="<Conc Program Short Name>" APPLICATION_SHORT_NAME="<application top>"

 Upload
    FNDLOAD <userid>/<pass> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $XX_TOP/admin/import/<FILENAME.ldt> - CUSTOM_MODE=FORCE

Request set
================
Download
RQS File
      FNDLOAD <userid>/<pass> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct $XX_TOP/admin/export/<RQS_NAME>.rqs REQ_SET APPLICATION_SHORT_NAME="<application top>" REQUEST_SET_NAME="<Request set short Name>"

 Request Set - RQL File
           FNDLOAD <userid>/<pass> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct $XXPA_TOP/admin/export/<Request set short Name>.rql REQ_SET_LINKS APPLICATION_SHORT_NAME="XXSPA" REQUEST_SET_NAME="< Request set short Name>"

 Upload
     FNDLOAD <userid>/<pass> 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct $XXPA_TOP/admin/import/<Request link file>.rqs - CUSTOM_MODE=FORCE

     FNDLOAD <userid>/<pass> 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct $XXPA_TOP/admin/import/<Request link file>.rql - CUSTOM_MODE=FORCE

DFF
====
Download
       FNDLOAD <userid>/<pass> 0 Y DOWNLOAD 
$FND_TOP/patch/115/import/afffload.lct PO_REQUISITION_LINES_dff.ldt DESC_FLEX APPLICATION_SHORT_NAME=PO DESCRIPTIVE_FLEXFIELD_NAME=PO_REQUISITION_LINES

Upload
     FNDLOAD <userid>/<pass> 0 Y UPLOAD  
$FND_TOP/patch/115/import/afcpprog.lct "$PO/patch/115/import/PO_REQUISITION_LINES_dff.ldt" 
- UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;


Quality Plan
==========
FNDLOAD apps/pnapnc01 0 Y DOWNLOAD $QA_TOP/patch/115/import/qltplans.lct Q_plan.ldt QA_PLANS PLAN_ID=8943

FNDLOAD apps/<password> O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct Q_plan.ldt

Steps to create Quality plan
====================
Create collection elements
Create collection plan types
Create collection plan
Enter Quality Results
later Update Quality results - as required

Comments

Post a Comment

Popular posts from this blog

PO & Receipt Query

By -
Query to get PO & Receipt Data: select aps.segment1  "Supplier Number", poh.segment1  "Purchase Order Number", poh.AUTHORIZATION_STATUS  "Purchase Order Status", Null  "Purchase Order Release Number", poh.START_DATE  "Purchase Order Date", papf.full_name  "Buyer", msi.segment1   "Purchase Order Item Number", pll.closed_code  "Purchase Order Item Status", pol.PURCHASE_BASIS  "Purchase Order Item Type", msi.segment1  "Location Part Number", msi.description  "Location Part Description", pol.VENDOR_PRODUCT_NUM  "Supplier Part Number", POL.QUANTITY  "Item Order Quantity", pol.unit_price  "Location Item Price", poh.CURRENCY_CODE  "Location Currency Code", pol.unit_price  "Supplier Item Price", aps.PAYMENT_CURRENCY_CODE  "Supplier Currency Code", msi.PRIMARY_UNIT_OF_MEASURE  "Inventory Unit of Me
Read more

Supplier SQL query

By -
Query to get Supplier data from Oracle R12 SELECT   aps.segment1 "SupplierNum",          assa.vendor_site_code "Address Book Identifier ",          aps.vendor_name "Supplier Company Name ",          --Hou.name "Operating Unit Name",          Assa.address_line1 "Supplier Address Line1",          Assa.address_line2 "Supplier Address Line2",          assa.address_line3 "Supplier Address Line3",          assa.address_line4 "Supplier Address Line4",          assa.city "Supplier city",          assa.state || assa.PROVINCE "Supplier State/Province",          assa.country "Supp_country_Code",          assa.zip "Supp_postal_Code",          apsite_rmt.ADDRESS_LINE1 "Supp_Remit_to_Address_Line_1",          apsite_rmt.ADDRESS_LINE2 "Supp_Remit_to_Address_Line_2",          apsite_rmt.ADDRESS_LINE3 "Supp_Remit_to_Address_Line_3",    
Read more

Inventory Item Attributes, Categories, Vendor & Costs

By -
Query to get safety stock Quantity of inventory items: select msib.segment1,c.INVENTORY_ITEM_ID,SAFETY_STOCK_QUANTITY from mtl_safety_stocks c,  mtl_system_items_b msib   where c.INVENTORY_ITEM_ID = msib.INVENTORY_ITEM_ID     and c.ORGANIZATION_ID = msib.ORGANIZATION_ID     and c.SAFETY_STOCK_QUANTITY <> 0     and msib.ORGANIZATION_ID = 12     and msib.segment1 in ('98765'); Query to get the inventory item vendor and costs : select msi.inventory_item_id "Item ID", msi.segment1 "Part Number", msi.description  "Part Description - Internal", decode (msi.item_type,'XX_SUPPORT_ITEM','SUPPORT ITEM'                                        ,'XX_BULK_ITEM','BULK ITEM'                                        ,'P','PURCHASED ITEM'                                        ,'SA','SUBASSEMBLY'                                        ,'PH','PHANTOM ITEM'      
Read more