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 AUGUST 24, 2017

Applies to:

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

Goal

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.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms