Skip to main content
Solved

Data Load Issue with DIM_ORGANIZATION_CODE

E
Sidekick (Partner)
Forum|alt.badge.img+5

Hi ,

We crated Data load run definition for IFS_EMPLOYEE_ANALYSIS Tabular model and getting below error.

SSIS LOG

We noticed that the ID defined in the DIM is created with Company^Structure ID^Code^Valid To.But IFS oracle database can have multiple records  for above combination and this caused the error in Data load run.

Can we add parent_org_code into the below ID to make this a unique record?

Tried to add Parent_ORG_CODE using below window and it is not available to add  as the 5th Dimension ID

 

Many thanks for your inputs on this issue.

Best regards,

Uvini

Best answer by subashfestus

Hi ​@EntUviniG,

This should be something investigated from the relevant RnD Product team (HCM) as this is on the dimension model level. Please create a support ticket.

Could be a data setup issue or a bug with the ID definition.

The ID can’t be modified from the application as a configuration. It has to be a model level change.

Best regards,

Subash 

View original
Did this topic help you find an answer to your question?

2 replies

S
Hero (Employee)
Forum|alt.badge.img+7
  • subashfestus
  • Hero (Employee)
  • 47 replies
  • Answer
  • February 5, 2025

Hi ​@EntUviniG,

This should be something investigated from the relevant RnD Product team (HCM) as this is on the dimension model level. Please create a support ticket.

Could be a data setup issue or a bug with the ID definition.

The ID can’t be modified from the application as a configuration. It has to be a model level change.

Best regards,

Subash 

E
Sidekick (Partner)
Forum|alt.badge.img+5
  • EntUviniG
  • Author
  • Sidekick (Partner)
  • 15 replies
  • February 5, 2025

​@subashfestus  Thank you for the response .

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings