You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Error Loading UDT using HDL

    edited Sep 5, 2020 12:33AM in Payroll and Global Payroll Interface (GPI) 4 comments

    Summary

    Getting "A logical end date is required." error when loading effective dated records in User-Defined Table using HDL.

    Content

    Hi All,

    Getting "A logical end date is required." error when loading effective dated records in User-Defined Table using HDL.  User Column Instance already exists so trying to enter an effective dated record to that User Column Instance ID.  Has anyone else encountered this error?

    Thanks!

    Kelly

    Version

    19D

    Code Snippet

    METADATA|UserDefinedTableColumnInstance|EffectiveStartDate|Value|LegislativeDataGroupName|UserColumnCode|UserRowId|UserTableCode|UserColumnId|RowLowRangeOrName|UserColumnInstanceId
MERGE|UserDefinedTableColumnInstance|2020/01/01|2020-01-01*2020-05-25*2020-07-04*2020-09-07*2020-11-26*2020-12-25|US Legislative Data Group|Observed_Holiday|300001392407821|KP_AM_TL_HOLIDAY_DATES_TBL|300001392355618|KP IT*NUE-IT-01*CO|300001391380257
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!