Description: Following steps are used to upload the application objects using FNDLOAD. FNDLOAD Syntax These are the extensive list which can be done through FNDLOAD — Concurrent Programs, Executables —…
Read MoreDescription: Following steps are used to compile the forms in EBS R.12. Steps: Step 1: Login to application user in application server through winscp and go to $AU_TOP/forms/US step 2:…
Read MoreDescription: Following sql script is used to find the Application Express users , who all are logged in previous days or specific period (months , years) . Steps: 1.Login as…
Read MoreDescription: The oracle OS user does not have the appropriate privileges on the OS directory, or if the path specified in the database does not match to an actual path,…
Read MoreDescription: Scheduler jobs are the automated process handled by the database scheduler in oracle. It will run the scheduler jobs in a specific server time intervals like daily , weekly…
Read More1.CREATE TABLE FOR THE FILES create global temporary table FILE_NAME ( filename varchar2(255) ) 2.CREATE JAVA SOURCE. This java is used to read the file from directory and insert the…
Read More1.Find which programs are stucked in OPP using below query. set lines 200; set pages 300; SELECT a.request_id, substr(e.user_concurrent_program_name,1,80) Program,d.sid, d.serial# ,d.status,to_char(d.logon_time,’DD-MON-YY HH24:MI:SS’)logon, round(d.last_call_et/60) LCT FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_processes b,…
Read MorePYTHON: If you’re using Oracle Linux 7, you can use yum to install the CLI. sudo yum install python36-oci-cli The CLI will be installed to the Python site packages: /usr/lib/python3.6/site-packages/oci_cli…
Read MoreBelow the steps for enable DIAGNOSTICS option to a specific user in R.12. 1.Login as a sysadmin user in front end. 2.In the EBS dashboard , choose SYSTEM ADMINISTRATOR Responsibility…
Read MoreThis following query is used to fetch the status of the workflow service components. login as APPS user, SQL> desc apps.fnd_svc_components; Name Null? Type —————————————– ——– —————————- COMPONENT_ID NOT NULL…
Read More