The file_quoteitem_fs.csv file is generic and therefore does not support any source quote system specific features, such as recurring quote lines, and so on.
Note:
The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:
Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.
Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.
Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.
Note:
If you are deploying OTBI-Enterprise, then you must download the CSV files from Configuration Manager, as follows: 1. From the Tasks bar, click Define Business Intelligence Applications. 2. Click Actions, then Manage Source Configuration Data Files. 3. Click the Export Source Configuration Data Files option on the tool bar. 4. Move the required files to the right hand list, then click Export.Each line in this file will supplement existing EBS Quote Lines with data to populate the following prices:
Quote Item Approved Invoice Price
Quote Item Approved Pocket Margin
Quote Item Approved Pocket Price
Quote Item Guideline Invoice Price
Quote Item Guideline Pocket Margin
Quote Item Guideline Pocket Price
Quote Item Requested Invoice Price
Quote Item Requested Pocket Margin
Quote Item Requested Pocket Price
The granularity of this file is each Quote Line ID which should be the root Quote Line ID in the case of configured products.
Each price above should be the rolled-up price in case of a configured product.
| Column Name | Data Type | Sample Data | Description |
|---|---|---|---|
|
INTEGRATION_ID |
VARCHAR2(80) |
344946 |
The INTEGRATION_ID for this file will be the Quote Line ID. This should be the root Quote Line ID in the case of configured products. |
|
GLN_INV_PRI |
NUMBER(28,10) |
101.55 |
The sales guideline (price policy) invoice price that was applied to the quote. If there was no price exception, this is the same as the actual invoice price. |
|
GLN_PKT_PRI |
NUMBER(28,10) |
91.534 |
The sales guideline (price policy) pocket price that was applied to the quote, or the derived guideline pocket price based on the guideline invoice price. If there was no price exception, this is the same as the actual pocket price. |
|
GLN_PKT_MARGIN |
NUMBER(28,10) |
30 |
What the pocket margin would have been for the quote based on its quantity and the guideline pocket price. If there was no price exception, this is the same as the actual pocket margin. |
|
REQ_INV_PRI |
NUMBER(28,10) |
1345.12 |
The invoice price that was requested (usually by sales) on the price exception request. If there was no price exception, this is the same as the actual invoice price. |
|
REQ_PKT_PRI |
NUMBER(28,10) |
122.2 |
The pocket price based on the requested invoice price (usually by sales) on the price exception request. If there was no price exception, this is the same as the actual pocket price. |
|
REQ_PKT_MARGIN |
NUMBER(28,10) |
1.3 |
What the pocket margin would have been for the quote based on its quantity and the requested pocket price. If there was no price exception, this is the same as the actual pocket margin. |
|
APPR_INV_PRI |
NUMBER(28,10) |
44.44 |
The invoice price that was last approved for the quote. If there was no price exception, this is the same as the actual invoice price. |
|
APPR_PKT_PRI |
NUMBER(28,10) |
22222.2 |
The pocket price that was last approved for the quote. If there was no price exception, this is the same as the actual pocket price. |
|
APPR_PKT_MARGIN |
NUMBER(28,10) |
172222.2 |
What the pocket margin amount would have been on the quote the quote based on its quantity and the invoice price that was last approved for the quote. If there was no price exception, this is the same as the actual pocket margin. |