Problem: when we try to cancel a concurrent request using frontend “Cancel Request” button from the Administer > Concurrent > Manager form. We are getting the following message: “Request xxxxxx…
Read MoreProblem: [ERROR] Failed to execute SQL statement: select AD_ZD_ADOP.GET_INVALID_NODES() from dual [ERROR] Error Message: [ERROR] ORA-04063: package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute) Cause: Package “APPS.AD_ZD_ADOP” is not valid…
Read MoreProblem: <[Security:090295]caught unexpected exception, No such object> <[Security:090303]Authentication Failed: User weblogic weblogic.security.providers.authentication.LDAPAtnDelegateException: [Security:090295]caught unexpected exception, No such object> java.security.PrivilegedActionException: javax.security.auth.login.FailedLoginException: [Security:090938]Authentication failure: The specified user failed to log in. weblogic.security.providers.authentication.LDAPAtnDelegateException:…
Read MoreBy default in Oracle Applications R12, users are not able to access Forms directly via the following url: http://hostname:port/forms/frmservlet The following error would pop out: APP-FND-01542: This Applications Server is…
Read MoreTo uninstall Oracle Enterprise Command Center Framework components, perform the following steps. Stop all the Oracle Enterprise Command Center Framework components by running the $ECC_BASE/Oracle/quickInstall/bin/stopAllEcc.sh script. Select option 1, All.…
Read MoreInstalling Oracle Enterprise Command Center Framework, Release 12.2.8 Oracle Database version: 12.2.0.2 Oracle EBS version : 12.2.8 Oracle Enterprise Command Center Framework: 6.0 Oracle WebLogic Server: 12.2.1.4 1.1 Download the…
Read MoreThere are around 1000 plus invalid objects, while looking further observed that this object do not exist in current run edition and there are duplicate/multiple entries observed for RUN and…
Read MoreOracle allows columns to be hidden from application. Columns can be made invisible in the CREATE TABLE statement or using an ALTER TABLE statement.By default columns are visible. Invisible columns…
Read MoreBelow script to find Oracle Application Modules are Licensed or Not. Script: SELECT fat.application_name ,fa.application_id ,fpi.patch_level ,decode(fpi.STATUS,’I’,’Licensed’, ‘N’,’Not Licensed’,’S’,’Shared’,’Undetermined’) STATUS ,fpi.* FROM fnd_product_installations fpi ,fnd_application fa ,fnd_application_tl fat WHERE fpi.application_id…
Read MoreBelow script to find the OPP log file location in oracle E-Business Suite. Script: SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp WHERE fcpp.processor_id = fcp.concurrent_process_id AND fcpp.action_type…
Read More