Trying to Query Requisitions and Manage Buyer Workload Using PO_REQUISITION_LINES_ALL.ASSIGNMENT_START_DATE Field As an Indicator Of Assignment
Last updated on AUGUST 24, 2017
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.
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