APPS DBA

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

General Ledger Interface Tables GL_BUDGET_INTERFACE GL_DAILY_RATES_INTERFACE GL_DRM_HIERARCHY_INTERFACE  GL_DRM_SEGVALUES_INTERFACE GL_IMP_COA_ERR_INTERFACE GL_IMP_COA_NORM_HIER_INTERFACE GL_IMP_COA_SEG_VAL_INTERFACE GL_IEA_INTERFACE GL_INTERFACE GL_INTERFACE_CONTROL GL_INTERFACE_HISTORY GL_REPORT_INTERFACE GL_XFR_INTERFACE   Account Payables (AP) Interface Tables AP_INTERFACE_CONTROLS AP_INTERFACE_REJECTIONS AP_INVOICE_INTERFACE AP_INVOICE_LINES_INTERFACE OIE_POL_RATES_INTERFACE   Account …

ERROR  Completed database cleanup for previous session. Error: Unable to execute statement < Begin ad_jar.get_jripasswords(:l_storepass, :l_keypass); End; > len = 63 AD Administration error: ORA-01031: insufficient privileges ORA-06512: at “SYS.DBMS_SESSION”, …