The file_pwf_element_ds.csv
file is generic and therefore does not support any source Pricing system-specific features.
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.
Each row of this file will supplement existing E-Business Suite Modifier Line IDs that are extracted using the following SQL:
SELECT QP_LIST_LINES.LIST_LINE_ID MODIFIER_LINE_ID FROM APPS.QP_LIST_LINES INNER JOIN APPS.QP_LIST_HEADERS_B ON QP_LIST_LINES.LIST_HEADER_ID = QP_LIST_HEADERS_B.LIST_HEADER_ID INNER JOIN APPS.QP_LIST_HEADERS_TL ON QP_LIST_HEADERS_B.LIST_HEADER_ID = QP_LIST_HEADERS_TL.LIST_HEADER_ID WHERE (QP_LIST_HEADERS_TL.LANGUAGE = 'US') AND QP_LIST_LINES.LIST_LINE_TYPE_CODE IN ('DIS','SUR','PBH','FREIGHT_CHARGE') AND EXISTS (SELECT 1 FROM ASO_PRICE_ADJUSTMENTS WHERE QP_LIST_LINES.LIST_LINE_ID = ASO_PRICE_ADJUSTMENTS.MODIFIER_LINE_ID AND ASO_PRICE_ADJUSTMENTS.APPLIED_FLAG = 'Y' UNION ALL SELECT 1 FROM OE_PRICE_ADJUSTMENTS WHERE QP_LIST_LINES.LIST_LINE_ID = OE_PRICE_ADJUSTMENTS.LIST_LINE_ID AND OE_PRICE_ADJUSTMENTS.APPLIED_FLAG = 'Y' )
The granularity of this file is each Modifier Line ID of the Modifier Line Type – Discount, Surcharge, Price Break Header or Freight Charge which has caused an adjustment for an Order (or) Quote line.
Column Name | Data Type | Sample Data | Description |
---|---|---|---|
INTEGRATION_ID |
VARCHAR2(80) |
15678 |
The INTEGRATION_ID for this file will be the Modifier Line Id that is, QP_LIST_LINES.LIST_LINE_ID. |
ELEMENT_TYPE_CODE |
VARCHAR2(80) |
Revenue Adjustment |
Price Element Type Code. Code-Name pair values are supplemented using the file: |
BASIS_SEGMENT |
VARCHAR2(50) |
Ceiling Revenue |
Not available. |
TOKEN |
VARCHAR2(50) |
OFF_CEILING |
Not available. |
REVN_COST_IND |
NUMBER(10) |
1 |
Not available. |
DISP_ON_ZERO_FLG |
VARCHAR2(1) |
N |
Not available. |