Requisition creation via BPA for item with multiple supplier items and prices

Summary: Automatically create a requisition from BPA for one internal item that represents multiple supplier items

Content (please ensure you mask any confidential information):

We have an internal item that maps to many supplier item numbers depending on the supplier contract pricing (supplier dictates the different supplier item numbers). EXAMPLE> Internal = XYZ, Supplier Number = 123, price $50 OR Internal item = XYZ, Supplier Number = 456, price = $75

Internally the item number cannot be different - multiple supplier items must map to one specific internal item in this scenario. Internal item is currently active on one BPA with 2 lines - one for each supplier item and the different prices. When the requisition is imported / auto created (from a 3rd party system), the incorrect BPA line / price is selected based on Oracle rules - generally the highest line number (last created) for the internal item on the BPA but sometimes the lower line number (not sure why it varies).