AVINASH's Oracle ERP blog

 Steps to enable Diagnostics menu in Oracle APPS Form Step1: Set FND: Diagnostics profile option Yes Step2: Set "Hide Diagnostics menu entry" profile option value to No Logout of the application and login again

When using SQL Developer we will sometime get following error if our computer default language is settings don't go well with Oracle SQL Developer. While connecting to database from the SQL Developer fails with the following error: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified How to fix this? Find sqldeveloper.conf file: under SQLDeveloper Home / Bin directory.  Edit config file to add below options and save.  AddVMOption -Duser.language=en AddVMOption -Duser.country=US Restart SQL Developer and try connection again.

 FNDLOAD Commands: 1) Concurrent Program Download: FNDLOAD apps/<<AppsPassword>> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct <<XX_LDT_FILE_NAME>>.ldt PROGRAM APPLICATION_SHORT_NAME="<<XXCUSTAPP>>" CONCURRENT_PROGRAM_NAME="<<CONC_PROG_SHORT_NAME>>" 2) Concurrent Program Upload: FNDLOAD apps/<<apps password>> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct <<XX_LDT_FILE_NAME>>.ldt -WARNING=YES UPLOAD_MODE=REPLACE -CUSTOM_MODE=FORCE  3) Request SET Download FNDLOAD apps/<<AppsPassword>> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <<XX_LDT_FILE_NAME>>.ldt REQ_SET REQUEST_SET_NAME='<<REQSET_INTERNAL_NAME>>' 3) Request Set Links Download: FNDLOAD apps/<<AppsPassword>> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <<XX_LDT_FILE_NAME>>.ldt REQ_SET_LINKS REQUEST_SET_NAME='<<REQSET_INTERNAL_NAME>>...

Steps to generate trace file for concurrent job and  locate it on server: 1. Login applications user with System Administrator responsibility 2. Go to -> System Administrator -> Concurrent : Program -> Define and Press F11 3. Enter the Concurrent Program Name (Eg. Journal Import) -> Press Ctrl + F11 4. Enable the check box "Enable Trace" above "Copy To" button. Click on Save and close the window. 5. Select Requests -> Run->Submit the concurrent request for which you enabled trace 6. The trace file will be created in the Database Server under the location of "udump" sql>select value from v$parameter where name like '%user_dump_dest%';

  Oracle Order Entry and Oracle Purchasing integrate to provide drop shipments. Drop shipments are orders for items that your supplier ships directly to the customer either because you don't stock or currently have the items in inventory, or because it's more cost-effective for the supplier to ship the item to the customer directly SETUP A) Associate drop shipments with a receiving location. B) Drop shipments support a Destination Type of Expense or Inventory only. C) We can handle returns of drop shipments using standard Order Entry/Shipping or Purchasing functionality. There are different ways you may want to handle returns depending on whether the customer returned the item to you or directly to the supplier. We have to consider the following setup: 1- Inventory Setup  Inventory Setup : (Define and Maintain The Item) The drop ship inventory organization, item and subinventory must be setup prior to creating any drop ship orders. All drop ship ...

Very useful query to retreive the Request Group and other information for Concurrent program from its name :   SELECT cpt.user_concurrent_program_name     "Concurrent Program Name",        DECODE(rgu.request_unit_type,               'P', 'Program',               'S', 'Set',               rgu.request_unit_type)        "Unit Type",        cp.concurrent_program_name           "Concurrent Program Short Name",        rg.application_id                    "Application ID",        ...