R12.1: Purchase Orders Fail to Reserve Intermittently While There are Sufficient Funds (Doc ID 2189254.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
BudgetaryControlResultsAMImpl.java
BudgetaryControlResultsCO.java

Symptoms

Autocreated POs fail to approve and reserve, when there are sufficient funds available.
These PO will reserve successfully manually using Workflow notification retry.

Steps to reproduce:

1. Auto create PO
2. PO fails to approve and reserve intermittently

- Intermittent issue, occurs on 4-6 POs per day

Compare Workflow status of 2 identical POs for the same item, sourcing document, accounting etc, observe the following:

Process/Activity RESERVE_BEFORE_APPROVE/DOC_RESERVE_PROCESS shows status=COMPLETE, result=N for the failed PO.

Workflow Activity Statuses - for failed PO:

EXECUTION_TIME BEGIN_DATE PROCESS Process Display Name ACTIVITY Activity Display Name STATUS RESULT ASSIGNED_USER NOTIFICATION_ID Notification Status
61 10-AUG-16 03:23:05 MAIN_POAPPRV_PROCESS PO Approval Process RESERVE_BEFORE_APPROVE Reserve Before Approve COMPLETE Y
62 10-AUG-16 03:23:05 RESERVE_BEFORE_APPROVE Reserve Before Approve START Start COMPLETE #NULL
64 10-AUG-16 03:23:05 RESERVE_BEFORE_APPROVE Reserve Before Approve IS_ENCUMB_ON_DOC_UNRESERVED Is Encumbrance On and Is Document Not Reserved? COMPLETE Y
66 10-AUG-16 03:23:05 RESERVE_BEFORE_APPROVE Reserve Before Approve DOC_RESERVE_PROCESS Document Reserve Subprocess COMPLETE N

Workflow Activity Statuses - for success PO:

EXECUTION_TIME BEGIN_DATE PROCESS Process Display Name ACTIVITY Activity Display Name STATUS RESULT ASSIGNED_USER NOTIFICATION_ID Notification Status

61 12-SEP-16 09:38:32 MAIN_POAPPRV_PROCESS PO Approval Process RESERVE_BEFORE_APPROVE Reserve Before Approve COMPLETE Y
62 12-SEP-16 09:38:32 RESERVE_BEFORE_APPROVE Reserve Before Approve START Start COMPLETE #NULL
64 12-SEP-16 09:38:32 RESERVE_BEFORE_APPROVE Reserve Before Approve IS_ENCUMB_ON_DOC_UNRESERVED Is Encumbrance On and Is Document Not Reserved? COMPLETE Y
66 12-SEP-16 09:38:32 RESERVE_BEFORE_APPROVE Reserve Before Approve DOC_RESERVE_PROCESS Document Reserve Subprocess COMPLETE Y

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