Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

OBIA
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 3 / 5

Star ActiveStar ActiveStar ActiveStar InactiveStar Inactive
 

Post-Installation Steps

 

Source Files

The first step in post installation is to copy the source files from the etl directory.

Why do we need to do copy the files?

These source files are also a source of data along with your source instance. For example  to load group accounts from your instance you would be modifying the file  file_group_acct_codes_ora.csv to reflect your organizations group accounts. So all the files that would be used to extract data along with the source system have to be modified .

For this navigate to

BI_Oracle_Home/biapps/etl/data_files

Here you will notice the different directories.

2015-03-14 7-36-30

 

One of them is the source file (src_files). The source file in turn has several directories with the different source instance names and also has some.csv files as in the screen shot below.

file1

 

In my example since the source instance is EBS12_2 I will be copying only the EBS_12_2 to my new folder chg_files. I will also be copying the .csv files that are as shown above (eg::file_mcal_cal_d.csv)since the path I specify will be referring to chg_files and no longer to the src_files. If you do not copy the generic .csv files ,while  doing domain load /data loads  you will get errors stating file_dual.csv and file_unspsc.csv files as missing.

 

file2

So as you can see in the screen shot above I have copied all the source files belonging to EBS_12_2 to the chg_files location along with the other .csv files.

In the next article I will cover configuring the source system in BIACM.


Srimathi Badri

Add comment


Security code
Refresh

About the Author

Srimathi Badri

Srimathi Badri has over fifteen years of experience as an Applications Developer, and has worked in different technologies and E-business Applications during this time. 
Her specific focus and expertise is in RICE, OAF pages, XML publisher, Java and BI stack of technologies including OBIEE/OBIA with functional domain expertise in Financials, HR, Order Management, and Supply Chain & Warehouse Management. She has a strong desire to keep pace with new technologies which has helped her implement numerous cost saving projects. 
She was a speaker at Oracle Open World -2014 to discuss the implementation phases of OBIA 11.1.1.7.1 with ODI. The topic was "Improve profitability and Cash Flow with Oracle Financia Analytics"

She can be reached at srimathi.badri@yahoo.com

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jun 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
   1  2  3  4  5  6
  7  8  910111213
14151617181920
21222324252627
282930    

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner