Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

How does Requisition Import determine the grouping method for incoming pieces of data?

This function groups requisitions. It first assigns values to REQUISITION_LINE_ID and REQ_DISTRIBUTION_ID; the function then groups Requisitions based on the REQ_NUMBER_SEGMENT1 column. All requisitions with the same NOT NULL REQ_NUMBER_SEGMENT1 are assigned the same REQUISITION_HEADER_ID. The function then groups Requisitions based on the GROUP_CODE column. All requisitions with the same value in the GROUP_CODE column are assigned the same REQUISITION_HEADER_ID. It then groups based on the GROUP_BY parameter, which takes on the value of DEFAULT_GROUP_BY if not provided. GROUP_BY could be one of the following: BUYER, CATEGORY, ITEM, VENDOR, LOCATION or ALL.

Related Posts

• Adding a Buyer
• Sql queries to validate the data that is part of the approval processing
• Sql queries to get organization id from requisition, purchase order and purchase order release?
• What is the Basic Purchasing Setup for Requisition Import?
• Oracle Purchasing Interview Questions