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)