I am trying to load data from Oracle EBS to Hyperion Planning.
When i push data Zero rows are inserted in Target.
When i look at Table " SELECT * FROM TDATASEG "
It is showing me data but it is not comminting data in Target application.
The reason is Data difference in Source (EBS) and Target.
In my source Year is 2013 but in Target 'FY14' so for Entity Source is '21' but Target is '2143213'
Can you please let me know how to solve this issue?
can i place a Lookup table for this in EPRI.
i am using EPRI and ODI to push data.
Have you setup the data load mapping correctly to map the source value to the proper target value? Based on what you are describing it seems that the system generated * to * map is being used, if you are mapping a source to a different target, this needs to be added to the data load mapping.