Use of shell script in oracle A.Steps to Register Shell Script as a concurrent program. B.Sample Shell Script to copy the file from source to destination. C.Basic Shell Script Commands. A. Steps to Register Shell Script as a concurrent program : Step 1: ======= Place the .prog script under the bin directory for your applications top directory. For example, call the script ONEPLACE_DEMO.prog and place it under $CUSTOM_TOP/bin (*Note: $CUSTOM_TOP = name of you custom top) Go ...
Oracle FNDLOAD Scripts - Download and update LDT's 1. Lookups-- ------------- Download Command : FNDLOAD apps/password O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXSHORT_NAME" LOOKUP_TYPE="XX_LOOKUP_TYPE" Upload Command : FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE 2. Concurrent Program-- ----------------------------- Download ...
Closing PO using API
API for Closing/Finally Closing PO Using po_actions.close_po in orcale R-12
posted on , by Unknown
API for Closing/Finally Closing PO Using po_actions.close_po API for closing or finally closing the POs. In this API, there is a parameter "p_action" which we need to set as either CLOSE (if we want to close the PO) or FINALLY CLOSE (If we want to Finally Close) the PO. Another Parameter which needs to set properly is "p_auto_close". This parameter should be set to 'N'. /*oracle R12 : PO - Script to Close / Finally Close PO using PO_ACTIONS CLOSE_PO API.sql*/ DECLARE x_action constant varchar2(20) ...
Initializing the session oracle Apps R-12 FND_GLOBAL.APPS_INITIALIZE is used for initializing the session before calling any public or private API’s in Oracle EBusiness suite. Its not required for all the API’s but its recommended that you set this profile before making any calls to either private or public API. Listed below is a sample call to FND_GLOBAL.APPS_INITIALIZE function fnd_global.APPS_INITIALIZE(user_id=>l_user_id, ...
concurrent program parameter
Query to find concurrent request,requester,parameter and completion time
posted on , by Unknown
Query to find concurrent request,requester,parameter and completion time Sharing query to find all the information while running concurrent program like its parameter, who have run the program,actual start and completion time,current status and responsibility etc. SELECT REQUEST_ID, PHASE_CODE, STATUS_CODE, RESPONSIBILITY_ID, ...
Query to find Employee details,location and user Sharing query to find employee details based on its location.You can get user name,employee id etc. SELECT DISTINCT PER.FULL_NAME, PER.EMAIL_ADDRESS, FU.USER_NAME, PER.NATIONAL_IDENTIFIER, ...
Bill Of Material - Routing query in oracle -R12 A routing defines the step-by-step operations you perform to manufacture a product. Each routing can have any number of operations. For each operation you specify a department that determines the resources you may use for that operation. Here sharing query to get routing,item and its uom(unit of measure) information : SELECT distinct bor.line_code, mtlp.organization_code, ...
APARBOMcustomerdeliveryinventoryList of tablesMTLWIP
List of tables in oracle Apps R-12
posted on , by Unknown
List of tables based on module and schema in oracle Apps R-12 Tables related to order management module 1.Blanket tables BLANKET ONT.OE_BLANKET_HEADERS_ALL BLANKET ONT.OE_BLANKET_HEADERS_EXT BLANKET ONT.OE_BLANKET_LINES_ALL BLANKET ONT.OE_BLANKET_LINES_ALL BLANKET ONT.OE_BLANKET_LINES_EXT 2.BOM(Bill of Materials) tables BOM BOM.BOM_COMPONENTS_B ...
