Requisitions Are Stuck at 'Unable To Reserve Document' With Enough Funds Available
(Doc ID 567913.1)
Last updated on AUGUST 20, 2023
Applies to:
Oracle iProcurement - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]Information in this document applies to any platform.
Symptoms
When attempting to approve a requisition the workflow gets stuck at activity
'Unable To Reserve Document'
However, there are sufficient funds available.
There are no errors in the workflow.
When running the script wfstatus.sql it shows that there is a discrepancy in the workflow attributes authorization_status and authorization_status_disp:
AUTHORIZATION_STATUS = PRE-APPROVED
AUTHORIZATION_STATUS_DISP = In Process
Furthermore, the attribute ONLINE_REPORT_TEXT shows the following error:
"The requested action is not allowed for current document status"
The attribute 'JUSTIFICATION' contains more than 240 characters in a multibyte language.
FND debugging displays the following error:
ORA-12899: value too large for column "PO"."PO_REQ_HEADERS_GT"."NOTE_TO_AUTHORIZER" (actual: 492, maximum: 480) in Package PO_DOCUMENT_CHECKS_PVT Procedure POPULATE_REQ_HEADERS_GT
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 |
Cause |
Solution |
References |