CSEIPVFP: Interface Invoice Price Variance to Oracle Assets Program Interfacing Incorrect Value. (Doc ID 2250636.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Asset Tracking - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Support Codes

ACTUAL BEHAVIOR
---------------
Received an Item as PO receipt for 10 qty.This item is not serialized.The asset got created for 10 qty as asset value is 100 i.e. 10*10=100.10 is the unit price of the item.
After that created an invoice and matched this PO with that invoice in Payables.  Additionally put a vendor charged tax of 10 dollars and a Miscellaneous line for 50 USD.Allocated the Miscellaneous line to the item line.The item line value is 150 USD now.

Vertex calculated the tax as 8.25 % and put the extra tax as self assessed tax i.e. 2.38 USD.

Ran the IPV program and expected that it will only bring the Miscellaneous line cost and the tax line cost as IPV to Fixed asset.  But it is bringing 500 USD as one of the line which is 10 times the Miscellaneous line value.  Also bringing 100 as the tax value which is 10 times the value of the tax line.  The PO qty is 10.
As a result the asset is getting over costed.

EXPECTED BEHAVIOR
-----------------------
Correct amount should be brought in.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. For example, received an Item as PO receipt for 10 qty.This item is not serialized.
2. The asset got created for 10 qty as asset value is 100 i.e. 10*10=100.10 is the unit price of the item.
3. Created an invoice and matched this PO with that invoice in Payables
4. Additionally put a vendor charged tax of 10 dollars and a Miscellaneous line for 50 USD.Allocated the Miscellaneous line to the item line.The item line value is 150 USD now.
5. Vertex calculated the tax as 8.25 % and put the extra tax as self assessed tax i.e. 2.38 USD .
6. Ran the IPV program and was expecting that it will only bring the Miscellaneous line cost and the tax line cost as IPV to Fixed asset.
But for some reason it is bringing extra values.
Asset is getting over costed as part of cost adjustments.

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