Example of Loading Data for Extensible Flexfields
This topic shows how the METADATA line is constructed for a Job business object component with the configured JobLegislative extensible flexfield. The METADATA line appears automatically in the generated job template.
Constructing the METADATA Line for the JobLegislative Extensible Flexfield
The PER_JOBS_LEG_EFF extensible flexfield is configured in Oracle HCM Cloud with the context and attribute values shown in this table. The Hint column shows the resulting hint for each attribute.
Context |
Attribute |
Hint |
---|---|---|
CA |
_EE0G |
(PER_JOBS_LEG_EFF=CA) |
CA |
_NOC_CODE |
(PER_JOBS_LEG_EFF=CA) |
CH |
_POSITION_TYPE |
(PER_JOBS_LEG_EFF=CH) |
FR |
_ECAP_JOB |
(PER_JOBS_LEG_EFF=FR) |
FR |
_INSEE_PCS_EXT_CODE |
(PER_JOBS_LEG_EFF=FR) |
In the generated Job.dat template file, the JobLegislative METADATA line includes these attribute definitions for the flexfield attributes:
METADATA|JobLegislative|...|EFF_CATEGORY_CODE|FLEX:PER_JOBS_LEG_EFF|_EEOG(PER_JOBS_LEG_DFF=CA)|_NOC_CODE(PER_JOBS_LEG_DFF=CA)|_POSITION_TYPE(PER_JOBS_LEG_DFF=CH)|_ECAP_JOB(PER_JOBS_LEG_DFF=FR)|_INSEE_PCS_EXT_CODE(PER_JOBS_LEG_DFF=FR)