My Oracle Support Banner

R12.2 : Purchase Order Stuck in "PreApproved" Status after Changed Promised date and re approve with Document Manager Failed With Error Number 3 Error for Back to Back flow (Doc ID 2261949.1)

Last updated on JUNE 19, 2019

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Purchase Order Stuck in "Pre-approved" Status after Changed Promised date and re approve with below error for Back to Back flow.

Error
-----

Document Manager Failed With Error Number 3 Error

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

1. Create Back to back Sale Order.
2. Create Purchase order from internal requisition
3. Receive and Deliver the purchase order.
3. Create ASN
4. Partially receive and deliver
5. Then change "Promise date" in the PO and try to re approve it.
6. Purchase Order get stuck in "Preapproved" status

The inventory debug log file shows

INV_MAINTAIN_RESERVATION_PUB.Check_Reqd_Param: In reduce_reservation, p_mtl_maintain_rsv_rec.from_primary_uom_code is required parameter, value is g_miss_char
[29-SEP-16 14:00:21] INV_MAINTAIN_RESERVATION_PUB.reduce_reservation: when expected exception raised for procedure :
[29-SEP-16 14:00:21] INV_MAINTAIN_RESERVATION_PUB.Maintain_Reservation: When unexpected exception raised for procedure :
[29-SEP-16 14:00:21] INV_MAINTAIN_RESERVATION_PUB.Maintain_Reservation: INV_API_NO_RSV_EXIST
[29-SEP-16 14:00:21] INV_MAINTAIN_RESERVATION_PUB.Maintain_Reservation: INV_API_MISSING_PARAM (API_NAME=reduce_reservation) (MISSING_PARAM=p_mtl_maintain_rsv_rec.from_primary_uom_code)
[29-SEP-16 14:00:21] INV_MAINTAIN_RESERVATION_PUB.Maintain_Reservation: Unrecognized character : f in Package FND_API Procedure TO_BOOLEAN

[29-SEP-16 14:00:21] INV_RESERVATION_PVT: inventory_item_id: 254946
[29-SEP-16 14:00:21] INV_RESERVATION_PVT: organization_id: 96
[29-SEP-16 14:00:21] INV_RESERVATION_PVT: supply source header id: 528722
[29-SEP-16 14:00:21] INV_RESERVATION_PVT: supply source line id: 6699789

 

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.