Flat Files Reference For Price Segment Dimension For E-Business Suite
The file_pri_segment_ds.csv
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.
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 row of this file will supplement existing E-Business Suite Customer Class that are extracted using the following SQL:
SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'CUSTOMER CLASS' AND VIEW_APPLICATION_ID = 220 AND LANGUAGE = '<Base Language>'
The granularity of this file is each Customer Class Lookup code that has been created in the E-Business Suite Application.