This Query Calculate the Datafile Growth on a Yearly Basis

  SELECT   ood.organization_code Warehouse_code,   ood.organization_name Warehouse,   ood.operating_unit OU_ID,   hou.name OU_Name,   hle.name Legal_entity,   hle.set_of_books_id,   gsob.name SOB FROM   org_organization_definitions ood,   hr_operating_units hou,   hr_legal_entities hle,   gl_sets_of_books gsob WHERE …

Syntax: fnd_user_pkg.addresp(username => v_user_name ,resp_app => ‘SYSADMIN’ ,resp_key => ‘SYSTEM_ADMINISTRATOR’ ,security_group => ‘STANDARD’ ,description => ‘Auto Assignment’ ,start_date => SYSDATE – 10 ,end_date => SYSDATE + 1000);   Usage: BEGIN …

Step 1. Setup the profile value at user level with the following value Profile name: “Initialization SQL Statement – Custom” User: [%User Name from which Concurrent program Runs%] Profile value: …

ERROR Oracle EBS 12.2.4 application tier autoconfig fails with following error.

ERROR When clearing all cache in Functional Administrator or Using OA framework, it errors With Error 404–Not Found : EBS 12.2.3

ERROR Starting OPMN managed OAFM OC4J instance … adoafmctl.sh: exiting with status 152

HOW to Verify and Change oc4jadmin Password   Step 1. Run the below command as applmgr user to verify oc4jadmin Password: $ java -jar $IAS_ORACLE_HOME/j2ee/home/jazn.jar -checkpasswd jazn.com oc4jadmin -pw ***** …

  ERROR ARC3: Error 19809 Creating archive log file to ‘+DISKS’ Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_6598.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 42687547752 bytes is 100.00% used, and has 0 remaining bytes available. …