How to fill the file_group_acct_codes_ora.csv ??

Question

Hi team,

I am working on OBIA 11g first time using ODI 11g. Can some1 please help me understand how to fill the "file_group_acct_codes_ora.csv" file properly. I have taken the Natural Accounts file  from my client but it has so many descriptions. Can some1 explain me ho to fill the 4th column Description ? Is is the same which Client has given me or should i give it a short name as per Oracle Standards. Does any Financial table consist of these mapping like AP = Account Payables, COGS = Cost of good sold  etc

Please suggest.

User_G7UO4 · Answer

Hi Gianni,

Thanks for your useful reply. I read the document and still have few doubts.I am uisng obia11g with ODI 11g.  I have received the "Natural Account.xls" file from my finance consultant. Now he is not aware of what Group Acct Num (description) i should maintain in csv for reports to work fine.In xls file, we have to_acct, from_acct and description. Now my confusion starts at:

1) Description given in file is very long, so should i change it to any short forms like Description says "Cost-Plant and Machinery-Material at site". Should i insert the same in csv file or rename it to something meaningful? If yes then how to identify the meaningful name ?

2) does any table in my db will have gl_acct_num mapped to some finance statment  codes?

Gianni Ceresa · Answer

Had a look at https://blogs.oracle.com/biapps/tips-and-usage-of-group-account-number-configuration  ?