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.