Hi Gianni, Thank you!! This is what I was looking for. Thanks to Nega as well for providing an alternative direction. Thank you gents.

Hi, I have noticed that the execution code for SDE_ORAR1213_ADAPTOR_SDE_ORA_LEDGERDIMENSION - 5 > Load data has not included the filter LEDGER_ID. select SQ_GL_LEDGERS.NAME C1_LEDGER_NAME, SQ_GL_LEDGERS.SHORT_NAME C2_LEDGER_SHORT_NAME, SQ_GL_LEDGERS.DESCRIPTION C3_LEDGER_DESC, TO_CHAR(SQ_GL_LEDGERS.CHART_OF_ACCOUNTS_ID)…

Hi, I have made changes to these two mappings (SDE_ORA_DomainGeneral_SQ_GL_LEDGER and SDE_ORA_LedgerDimension) and run a fresh load. However the W_LEDGER_D dimension has all the records I am not too sure whether Im missing a step here? Attached are the steps followed to attempt the customization. Then re-generated the load…

Hi Charles, Thank you for a reply and suggestions. My source is Oracle E-Business Suite R12.1.3.x. I have done the functional configuration part and yes I do have My Oracle Support account. I will go through your suggestions and update here. Thank you