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, [...]

Description: 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: copy [...]

Description: 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 system or sys schema [...]

Description: 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, the program will hurl the [...]

Description: 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 and any [...]

1.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 file name [...]

1.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# [...]

PYTHON: 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: [...]

Below 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 under Main [...]

This 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 [...]