Approved requisitions not generating PO's — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Approved requisitions not generating PO's

edited Jul 26, 2019 12:19PM in Purchasing 9 comments

Content

We are finding that some of our requisitions are still in process status because it requires a negotiation to turn into a PO. Oracle support supplied a sql query to create a BI report, however I can't seem to make it work. Has anyone created an analysis to help with this that they would be willing to share? The query that was supplied looked like this:

SELECT prh.requisition_number
,prl.line_number
,prl.line_status
,prl.req_po_instance_id
,prl.reqs_in_pool_flag
,ph.segment1 AS po_number
,prh.emergency_po_number
,prl.reqtopo_automation_failed

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!