Oracle APPS DBA

ERROR APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your system administrator.

Can Oracle Label Security be Used with EBS 12.2? By: Steven Chan | Senior Director Yes, Oracle Label Security (OLS) can be used with EBS 12.2.  It can also be used for earlier EBS releases …

Compiling Objects Manually Through SQL Commands First find the Invalid Objects in the Database by below given query. SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = ‘INVALID’; For a more detailed …

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. …