MUST read -- Page 1

COPYRIGHT NOTE

This blog is written by a consultant working with the  Oracle Business Intelligence Suite. The primary goal of the blog is to help beginners with Oracle BI Apps .I am planning to add learnings ,experiences and scenarios .


1. Paid – To- Blog Disclosure – I am NOT paid to write this blog. This is a personal blog.

2. Responsibility
The opinions on this are personal &  represent my personal views only. I do not represent or write on behalf of any agency, company or employer. I don’t represent views of my employer(s) or client(s). I’m not affiliated with Oracle, nor do I have any claim to their intellectual property.


3. Libel & Do No Harm
My intention is to “do no harm” and my posts are not counsel they are just my opinions and advice. What I write on my blog is not to be taken as fact nor absolute. I can not guarantee accuracy.  If people use my advice, tips, techniques, and recommendations, and are injured or damaged, I am  not to be held responsible.
 

4.Comments
I am not responsible, nor will be held liable, for anything anyone says on my blog in the blog comments, nor the laws which they may break in my country or theirs through their comments’ content, implication, and intent. I have to approve comments first and have the right to refuse them.

5. Copyright
I don’t claim copyright to the works that I quote using fair use principle. If you find copyrighted material that you own on this site – please let me know and I’ll remove it or credit you for it whatever that works for you.


**********************************************************************************
Note: Would like to thank (http://obiee-blog.info/about/)  for this post and credit this post to the mentioned blog.I just picked the copyright clauses and I hope you wont mind this.
**********************************************************************************

Oracle Apps : AP AR Financials module

Dt:25July 2012

If someone asks you to customize the AP,AR mappings in the financials subject areas, then you may consider yourself to be very unlucky.

The AP,AR prebuilt modules utilize some of the most complex mappings.You may take a week or two just to understand the flow of data into the W_AP_XACT_FS table and then finally into W_AP_XACT_F table.

Once you take efforts and understand that logic ,modify ETL & ask for a full load of the target, you   assume that your job is done.But chances are that you will be told that the data has not been loaded properly and that there is a bug in the ETL customizations.

Problem with the AP,AR maps are that there are many restricting conditions and even the most experienced ETL resources in your team cannot say for sure whether a particular record in the EBS table should actually make its way to W_AP_XACT_F .

So even we are faced with one such issue and are currently in a deadlock with the BI and ETL developers blaming each other.Eventually this will be resolved. Will post back the findings once we  deliver this code to the client.

************************************************************************
Dt:26July 2012

Pre built Mappings were modified in custom to get project ids from distribution table .Though Business was expecting multiple projects there are only single projects connected to an invoice as Lookup transformations were used(Informatica 8.6.1) to populate the project Ids. 

So eventually it comes back to the ETL developer as a bug.

Category 1 customizations to SCD2 dimensions-W_PARTY_ORG_D

Dt:24 July 2012

I extended the W_PARTY_ORG_D dimension to add few new columns to this table.I modified the SIL mappings to accommodate the change.

To my surprise I found out that the new records were inserted with proper data in the extended columns but the updates to the newly added  columns were not working.

A little digging in and I realised that W_PARTY_ORG_D is a SCD2 dimension and will require a few settings to the update flag to get the updates working properly.

If anyone of you out there are facing a similar problem or have a solution to this then please right in .In the mean time I wll go about trying to find an ideal solution to this problem.

*******************************************************************************

 Solution:

Well it had nothing to do with SCD2 .It was just that I added extended columns from a secondary source which was not originally taken care of by the update logic .The output port which checks for the SCD1 change is SYSTEM_COLS_DIFF.This port checks for CHANGED_ON_DT ,AUX_CHANGE_ON_DT columns to  find if there is an update on any of the source tables.

AUX_CHANGED_ON_DT columns were provided by ORACLE specifically to handle these type of scenarios.But this is rarely used by Informatica developers doing customizations on prebuilt ETL.