My Oracle Support Banner

R12: AP: MAX TOTAL AMOUNT Hold Cannot be Released. (Doc ID 956856.1)

Last updated on SEPTEMBER 01, 2021

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When attempting to release the hold 'MAX TOTAL AMOUNT', the following error occurs.

ERROR
System raised an incorrect hold and now it can't be released.
See the different following errors:

FRM-40735: MULTI RETURN ACTION trigger raised unhandled exception ORA-20002.

An Unexpected Error -20002 has occurred. An alert has been sent to the system administrator.
ORA-20002: 3100: Item '<item>' does not exist.
ORA-06512: at "APPS.WF_ENGINE", LINE xxxx
ORA-06512: at "APPS.AP_WORKFLOW_PKG" , line yyyy

APP-SQLAP-10000: ORA-20002: 3100: Item '<item>' does not exist. occurred in
AP_HOLDS_PKG.UPDATE_ROW<-APXINWKB
with parameters (ROWID = AABD8UAAYAADeZ+AAL, INVOICE_ID = <Invoice_ID>
 , LINE_LOCATION_ID = <line location id> , HOLD_LOOKUP_CODE = MAX TOTAL
AMOUNT)
while performing the following operation:



STEPS
The issue can be reproduced at will with the following steps:

1. Search for problem invoice

2. Click onto ‘Holds’ tab

3. Click onto release holds button

4. Select the only option in LOV -list of values (Quick release)

5. Click OK -> first error message seen

FRM-40735: MULTI RETURN ACTION trigger raised unhandled exception ORA-20002.

6. Click OK again -> see second error message (this is a new error message from when I first
logged the SR)

An Unexpected Error -20002 has occurred. An alert has been sent to the system administrator.
ORA-20002: 3100: Item 'APINVHDN/152116' does not exist.
ORA-06512: at "APPS.WF_ENGINE", LINE xxxx
ORA-06512: at "APPS.AP_WORKFLOW_PKG" , line yyyy

7. Click OK again -> third error message

APP-SQLAP-10000: ORA-20002: 3100: Item '<Item>' does not exist. occurred in
AP_HOLDS_PKG.UPDATE_ROW<-APXINWKB
with parameters (ROWID = AABD8UAAYAADeZ+AAL, INVOICE_ID =<invoice id>
 , LINE_LOCATION_ID = <line location id> , HOLD_LOOKUP_CODE = MAX TOTAL
AMOUNT)
while performing the following operation:

8. Click OK again -> asked to save changes.

9. Click Yes -> back to error message from step 7

APP-SQLAP-10000: ORA-20002: 3100: Item '<Item>' does not exist. occurred in
AP_HOLDS_PKG.UPDATE_ROW<-APXINWKB
with parameters (ROWID = AABD8UAAYAADeZ+AAL, INVOICE_ID = <invoice id>
, LINE_LOCATION_ID = <line location id> , HOLD_LOOKUP_CODE = MAX TOTAL
AMOUNT)
while performing the following operation:

10. Press OK -> Returned to invoice workbench

11. When Closing the invoice workbench it asks to save again -> clicking ok results in same
error message as steps 7 and 9.
To close the workbench you have to click ‘No’ to the save question.

12. Re-open invoice workbench and re-query invoice and nothing has changed.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.