HDL tables in oracle fusion
HDL is the HCM data loader, which do help to upload or
import the Employee related information’s from External source into the Oracle
Fusion. We do import the HDL files through HDL dashboard. In HDL dashboard, we
do get the information’s about my uploaded HDL file e.g. File name, No of
Objects in the File, No of Records Uploaded, No of Records Failed, No, of
Records Migrated and many other information’s too. This all information’s
stored in the HDL tables in oracle fusion. If we want to create some alert or
to create some custom reports, then we can use these hdl tables in oracle
fusion. I will try to share the some of the Important hdl tables in oracle
fusion which do store most relevant information from HDL dashboard.
8 Important hdl tables in oracle fusion
1. HRC_LOADER_ERROR_LINES
2. HRC_LOADER_JOB
3. HRC_LOADER_LOGICAL_OBJECTS
4. HRC_LOADER_METADATA_REGISTRY
6. HRC_LOADER_METADATA_REGISTRY
7. HRC_LOADER_PARAMETERS
8. HRC_LOADER_STATS
Detail Explanations of HDL tables in oracle fusion
HRC_LOADER_ERROR_LINES :-
In this table we do get the error information’s of the HDL
rejected records. If we have to find out the rejected records and what’s the
error reason for that then we can refer this table. This table will contain the
errors for any data that is encountered during a data load.
HRC_LOADER_STATS :-
This table contains statistics about Fusion data objects
used during a data load. For Example, if we are uploading the employees through
Worker HDL file , then this table helps to know , how many employees data this
worker file have.
HRC_LOADER_JOB :-
This table contains information about individual jobs within
a batch.
HRC_LOADER_LOGICAL_OBJECTS
Logical and Business Object metadata for the File Based
Loader.
HRC_LOADER_METADATA_REGISTRY
This table contains metadata about Fusion data objects used
during a data load.
HRC_LOADER_PARAMETERS
The table is used for defining configuration parameters for
the ESS processing of HR2HR ESS Jobs.
0 comments:
Post a Comment