Intercompany AR invoice is not properly generating for the ATO model item when ATO model consists option item in different UOM than the transaction UOM of model item. (Doc ID 1663320.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Intercompany Invoicing

 Problem Summary
---------------------------------------------------
Create Intercompany AR Invoice won't process specific ATO Txn

Problem Description
---------------------------------------------------
We have a few items that seem to get tuck in the process to calculate the transfer price. Based on the log uploaded to the SR the price is being returned from the QP call to the price list, but when extending that price by the order qty we get something like the following (tfrPrice is -.000001500015000150001500015000150001500015) I cannot find how the system is getting to this value.


Error Codes
---------------------------------------------------


Problem Category/Subcategory
---------------------------------------------------
Other Inventory Issues/ Intercompany Invoices

Uploaded Files
---------------------------------------------------
File: Create_Intercompany_AR_Invoice_261113.txt


Template Question Responses
---------------------------------------------------
1) Please provide the details, including the navigation path, on how to consistently reproduce the issue.
We take Sales Order in one OU and ship from a different one. The item is a configured item and the end item is not invoicable, but the items selected in levels below are. There are 2 items that seem to be causing the issue. The items have a UOM of either FT (Feet) or BG (Bag). These UOM's are setup on the price list now, but were not at the time the txn were created. After adding the UOM to the price list we get the correct price as seen in the log file, but the transfer price becomes a very very small negative number. It seems like some kind of conversion issue possible with UOM or something else. I am struggling to find any details as to how it getting calculated.

2) Provide the information for Intercompany Invoices Service Request Template
working on this will upload later if the log already provided is not enough to help resolve the issue.

3) ### Impact on Business ###
these transactions seem to be causing a bigger issue in our UAT testing for R12 Upgrade Go Live. We also need to correct this process as we expect to use more Configured products shipping this way.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms