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.


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

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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.