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:

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

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