My Oracle Support Banner

CLM Buyer Work Center Pricing Details Via Import Standard PO Import API Causes Decimal Issue (Doc ID 2480601.1)

Last updated on JULY 09, 2020

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.6 and later
Information in this document applies to any platform.


Problem Summary
CLM Buyer Work Center Pricing Details via Import Standard PO Import API Decimal Issue

Problem Description
When creating a Purchase Order through the API Import Standard Purchase Orders (Import CLM Awards), when certain combinations, of Price and Quantity provided in the Pricing details are provided, the Line/Shipment/Distribution level amount is left with Decimals. i.e Quantity = .99869053008 and Price = 2898188.00 leaves the line with an extended price of 2894392.90999149. Expecting 2894392.91.

When created manually, the calculate button does perform the calculation on these values accordingly. This is not occurring and the line amount can have many decimals. This results in the Distribution Amount not being equal to the Funded Amount passed via the import process.

1. Login to the E-Business Suite and choose the CLM Purchasing Module.
2. Run Import CLM Awards with Pricing Details results in journal with >2 decimals as the amount.

Expectation is that amount would only be 2 decimals, not multiple, based on precision




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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