My Oracle Support Banner

R12:CE:Consigned Purchase Orders are Appearing in the Cash Forecast Results (Doc ID 2508779.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Cash Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms



Consigned Purchase Orders are included in the Cash Forecast. They should not be included in it.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Blanket Purchase Agreement (BPA) and approve..
(N) Purchasing Responsibility > Purchase Orders > Purchase Orders

2. Create an Advanced Supplier List (ASL) for the item used in above BPA and mark the item as `Consigned from Supplier in the ASL (in Inventory tab)
(N) Purchasing Responsibility> Supply Base > Approved Supplier List > Attribute > Inventory Tab

3. Create and approve a Supplier Purchase Order (SPO) to receive Consigned Stock
(N) Purchasing Responsibility > Purchase Orders > Purchase Orders

4. Create a Consigned Receipt for SPO created in step 4 and verify the stock on hand.
(N) Purchasing Responsibility > Receiving > Receipts

5. Transfer consigned stock to Regular stock through `Transfer to Regular in Consigned Transactions
(N) Inventory > Transactions > Consigned Transactions

6. Run Create Consumption Advice program with supplier specified as a parameter. (The SPO which is actually the
Consumption Advice is by default Closed for Receiving because the item is received and consumed)
(N) Inventory > reports > Transactions

7. Check through PO summary form that a SPO with shipment status as Closed for Receiving has been generated as a Consumption Advice, against the BPA specified in ASL
(N) Purchasing Responsibility> Purchase Orders > Purchase Order Summary

8. Create an Invoice and match aginst the consumption advice created in step 8.
(N) Payables Responsibility > Invoices > Entry> Invoices > New

9. Check through PO summary form that an Invoice has been generated.
(N) Purchasing Responsibility > Purchase Orders > Purchase Order Summary

10. Go Cash Management Responsibility
Create a Forecast Template: PO Template for source Purchase Orders.
11. Run the forecast PO Template results: Forecast Name XXX and consigned PO is included.


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.