Unable To Import Some Fields For Costing when VLookup formula to used to calculate the cost. (Doc ID 2125206.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Agile Product Governance and Compliance - Version 9.3.4.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.3.4.0 version, Import(PGC)

ACTUAL BEHAVIOR
---------------
Create a sourcing project, add an Agile BOM in the project & then create an RFQ for the project. Export the RFQ from Agile to update the component cost, then import it back to RFQ & submit the RFQ before rolling up the product cost. The issue happens after importing the RFQ, there are some costs that did not get imported, it appear as zero cost in Agile
This happens to the costs which uses VLookup formula to calculate the cost.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Sourcing project with BOMs.
2) Create RFQ
3) Log in as supplier and export the RFQ to excel, do the necessary changes in excel. Ensure few cells get values from the vLookup formulas
4) Import the RFQ


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