R12.1: Purchase Orders Fail to Reserve Intermittently While There are Sufficient Funds
(Doc ID 2189254.1)
Last updated on JANUARY 25, 2025
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
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 |
| Steps to reproduce: |
| Cause |
| Solution |
| References |