Requisitions Are Stuck at 'Unable To Reserve Document' With Enough Funds Available (Doc ID 567913.1)

Last updated on AUGUST 21, 2016

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.
POXVDCKB.pls


Symptoms


When attempting to approve a requisition the workflow gets stuck at activity
'Unable To Reserve Document'
However, there is 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

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