My Oracle Support Banner

Trying to Query Requisitions and Manage Buyer Workload Using PO_REQUISITION_LINES_ALL.ASSIGNMENT_START_DATE Field As an Indicator Of Assignment (Doc ID 2299864.1)

Last updated on APRIL 20, 2023

Applies to:

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


Currently we are using manage the buyers' workload by reviewing how many requisition lines are assigned to a particular buyer and reassigning them to distribute the workload better and to evaluate how many unassigned requisitions are urgent or are needed within a certain time limit so that we can assign them to the appropriate buyers for immediate ordering.

When the PO_REQUISITION_LINES_ALL.ASSIGNMENT_START_DATE field is checked it is NULL/EMPTY after we are assign the requisition.


Please explain when the PO_REQUISITION_LINES_ALL.ASSIGNMENT_START_DATE field is updated or what table are affected when we assign requisition to a particular buyer.


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.