My Oracle Support Banner

Movement Statistics Intrastat Showing Wrong Movement Amount When Receipt Uom Is Different From PO Uom (Doc ID 2543728.1)

Last updated on JULY 25, 2019

Applies to:

Oracle Supply Chain Globalization - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Inventory Transactions

This is an issue with the Intrastat, for Purchase Orders. The purchase orders are created in UOM of Each and receipts are created in UOM of CTN.
The invoices are created in Each and showing the correct unit price but for the intrastat transactions, the UOM used is CTN from receipts and the unit price being used is Each (which is from invoice).
This is causing an issue while reporting the movements statistics with incorrect Movement amounts. System is not converting unit price to CTN price in the intrastat transactions.

Steps to Reproduce
1. Create PO in one uom
2. Receive the PO in a different uom.
3. Invoice the received material.
4. Run Movement Statistics Processor.
5. Incorrect movement amount is reported.

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
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.