I have a requirement where i need to show Supplier Information for records coming from AP to GL in GL Detail Report. I have used the OOB functionality for drilling from GL to AP but user requested to show Supplier Name for the GL records. Need help on how to customize the ETL or RPD for this task.
I tried using W_GL_OTHER_F and W_GL_LINKAGE_INFORMATION_G and then to W_AP_XACT_F to pull supplier information but i am getting duplicates when i join W_GL_OTHER_F and W_GL_LINKAGE_INFORMATION_G using integration_id and Journal_integration_id. Need guidance on this.
What is your source instance..EBS..is it R12. If so, there is not a 1:1 mapping as transactions flow from Subledger (AP) to GL. You can have many AP transactions roll up to a different # of GL entries. If this is the case, how do you expect to have a 1:1 drill down?