Symptoms
Worker log shows below
Current system time is Wed Apr 12 23:30:22 2023
CURRENT SESSION_ID is : 670185973
CURRENT EDITION_NAME is : ORA$BASE
Uploading from the data file /dodiapps/prod/prodapps/fs1/EBSapps/appl/hxc/12.0.0/patch/115/import/US/hxczzffrmula0014.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Uploading FF_FORMULAS_F 01/01/2001 31/12/4712 HXC_PTO_TIMECARD_VALIDATION
Error occured for FF_FORMULAS_F key name FORMULA_TYPE_NAME with value OTL Time Entry Rules
A database error occurred:
ORA-20160: Encountered an error while getting the ORACLE user account for your concurrent request.
Contact your system administrator.
ORA-06512: at “APPS.ALR_FF_FORMULAS_F_IAR”, line 1
ORA-04088: error during execution of trigger ‘APPS.ALR_FF_FORMULAS_F_IAR’
ORA-06512: at line 177
The error occurred while executing the following statement:
Solution
- Disable below trigger
SQL> alter trigger ALR_FF_FORMULAS_F_IAR disable;
Trigger altered.
SQL>
2. Restart the failed worker using adctrl Option 2
Oracle Reference:
SR 3-32749852381 : Patch 31856789 fails at hxczzffrmula0014.ldt
Orama.blog 