My Oracle Support Banner

Invoice Mismatch Due To The Number Of 9 Decimals Used In Receiving (Doc ID 2909703.1)

Last updated on SEPTEMBER 25, 2024

Applies to:

Oracle Inventory Management - Version 12.2.9 and later
Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

When using the iProcurement for splitting the bill to line accounting flexfield, from the entire quantity the customer allocates expenses to multiple percentages and the quantities are auto-splitting using 15 decimals. When creating the purchase order in forms, the shipping distribution form collects the same quantities - imported from iProcurement. The user approves the PO and when he checks the Invoices form (Invoices – entry – Invoices) he notices that the quantities invoiced are truncated/rounded to 9 decimals.

EXPECTED BEHAVIOR

The quantities invoiced should not be truncated/rounded to 9 decimals and keep the original 15 decimals

STEPS

The issue can be reproduced at will with the following steps:

1. iProcurement responsibility - Create requisition
2. Billing - Split the line bill to line accounting flexfield - Quantities are shown using 15 decimals
3. Approve requisition
4. Purchasing responsibility
5. Auto-create Purchase order
6. Press Shipments button - Press Distributions button => Quantities are shown using 15 decimals
6. Approve PO
7. AP responsibility
8. Invoices – entry – Invoices
9. Find invoice - Press Match button => The Qty Invoiced field shows quantities using only 9 decimals

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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