I have problem when loading financial module, after I ran the execution plan, execution plan succeed (complete) without warning but there was no data in these table:
I have already set the data source number for the ebs version as in page 56 document e19039-Oracle® Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users. I already followed reference from metalink (ID 746902.1, ID 865215.1, ID 1256585.1) but still did not find resolution. Any idea where could I start to debug?
Have you data in the staging table ? :
If not could you view the query executed by informatica (Worflow Monitor - Folder ORA_SDE-...) and see if all parameters are correctly used.
Hope it helps,
Thanks for your quick reply. After I followed document on metalink ID 1366309.1 and did patching for Patch 9739315 and Patch 9255542 here is the result after I ran the execution plan:
No data for those tables:
Data available for those tables:
There were No table
Any idea where should I start to investigate?
the best way is to use Informatica with dependencies tools to see what mappings are used to load data in your table and see with Worklfow monitor the query used for these mappings.
For example :
- table W_AP_BALANCE_F is loaded by some mappings (PLP folder):
- PLP_APBalanceCurrentActivityLoad uses as source
- table W_AP_BALANCE_F_TMP is loaded by some mappings (PLP folder):
- PLP_APIncrActivityLoad uses as source
with inner join between these tables
So if you have data in the table W_AP_XACT_F, maybe your dimension W_GL_ACCOUNT_D has a bad configuration or maybe you have no record with a status equals to 'POSTED' or 'REVERSED'.
The only way is to see the query runs by Informatica in your environment and find your issue.
Hope it helps,
Thanks for your help. Yes it is true something bad for my configuration on file_group_acct_codes_ora.csv. I have fixed it already and data for W_AP_BALANCE_F and W_AR_BALANCE_F already show up. But for w_gl_cogs_f and w_gl_cogs_fs still did not show the result. Did you have documentation for mapping involve for each subject area such as for Financial - General Ledger, Financials - Cost of Goods Sold, Financials - General Ledger, Financials - Payable, etc. If you have any documentation for the mapping involve please send to my email email@example.com. I will award you for helpful answers.
Really appreciate for you help.
the documentation for mapping Financial module is provided in the Oracle documentation (Configuration Guide for Informatica PowerCenter Users).
You can find this documentation on the URL with your BI Apps version : http://www.oracle.com/technetwork/middleware/bi-foundation/documentation/bi-apps-098545.html
Hope it helps,
check the dependencies for the tables w_gl_cogs_f and w_gl_cogs_fs in informatica mappings and trace data/dependencies from target to source starting from SIL mapping for these tables. it is the best way to trace the issue. you can also find target to source dependencis in data lineage document provided by oracle for biapps. biapps document doesn't tell you anything at the details level for a specific mapping. plzz follow my advise.
I've got the same problem as you had previously. What kind of configurations your have done in the file_group_acct_codes_ora.csv to make the tables W_AP_BALANCE_F and W_AR_BALANCE_F load with data? Many Many Many thanks!