You can execute Data Load Rule by clicking on Execute button.
It will display the process ID.
Go to Process Details.
If you click on Show you can see the record count in the log.
Go to SQL Plus and run following query.
SELECT * FROM ERPI.TDATASEG
ERPI is my ERPI Schema name. If you have different name use that.
You can see the data into the table.
TDATASEG.LOADID is your process ID.
VALID_FLAG = Y indicates data is valid.
It will display the process ID.
Go to Process Details.
If you click on Show you can see the record count in the log.
Go to SQL Plus and run following query.
SELECT * FROM ERPI.TDATASEG
ERPI is my ERPI Schema name. If you have different name use that.
You can see the data into the table.
TDATASEG.LOADID is your process ID.
VALID_FLAG = Y indicates data is valid.
2 comments:
Thanks for sharing your knowledge.
Please can you tell me how i can Fix values in ERPI?
Example:
I want to load data from Oracle EBS to Hyperion Planning.
But one of my Dimension in Hyperion is 'View' i want to pass value for View as 'Input View' along other Dimensions..
Use ERPI Integrator --> Data Load --> Data Data Mapping
See if you can default some value there.
Take a look at Data Load Workbench.
See if you can define some data Rule there.
Post a Comment