Error "Getting Decimal Division By Zero Occurred" When Creating Purchase Order Sourced From Contract Having Different SETID than Item SETID. (Doc ID 2985268.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Symptoms

When a PO is created by copying a requisition with contract linked and contract has non default UOM selected for the item, below error shows up. Issue occurs due to Contract SETID being different than the Item SETID.

Steps:
1. Setup an Item with two UOMs.
     Item > Define Items and Attributes > Define Item
2. Setup Purchasing Item Attributes with a Vendor/Supplier having two locations and different UOMs in both locations.
3. Create a Procurement Contract with a different SETID than Item SETID. Select the same vendor as above.
     Procurement Contracts > Add/Update Contracts
4. Enter the Item ID setup above and see default UOM is shown on contract line. Now click on Details icon.
5. Go to Pricing Information and select location with non default UOM.
6. Ensure Tableset control for Contract SETID and update 'FS_24'(Administer Contract) record group to same SETID as Contract SETID.
     PeopleTools > Utilities > Administration > Maintain TableSet Controls
7. Create a requisition, with BU as per Contract SETID, for the same item and enter contract details. Ensure that the supplier has the location with non default UOM.
     Purchasing >  Requisitions > Add/Update Requisitions
8. Create a PO by copying the requisition and save the PO.
     Purchasing > Purchase Orders > Add/Update POs
9. See the above error.

Cause

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