Crediting ORA-20404: ORA-00054: Resource Busy And Acquire With NOWAIT Specified Or Time (Doc ID 2195500.1)

Last updated on OCTOBER 20, 2016

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run crediting process, the following error occurs.

ERROR
-20404 : ORA-20404: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
-20404 : ORA-20404: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
-20404 : ORA-20404: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
CN_TP_DIRECT_CREDITS.generate_direct_credits.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
CN_TP_CREDIT_TXNS.generate_credits.g_exc_error
-20404 : ORA-20404: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
SQLCODE : 1
SQLERRM : User-Defined Exception
End of cn_tp_credit_txns.generate_credits

STEPS
1. Submit Run Crediting and it errors then process change to Wait status
2. User submit another crediting job and it errors right away with error message

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms