We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Import Common Lookup - ERROR: Invalid Date Value

Received Response
10
Views
4
Comments
edited Jul 21, 2020 8:19PM in HCM Integrations 4 comments

Summary

Import Common Lookup - ERROR: Invalid Date Value

Content

Hello forum:

I see Date values in FND_LOOKUP_TYPES and FND_LOOKUP_VALUES_B as "2020-07-21T00:00:00.000+00:00"

And keep getting Invade Date Record no matter if i use YYYY-MM-DD or YYYY/MM/DD or D/MM/YYYY or D/MM/YY  (see below)

Can someone spot or help why this occuring with a date using "-" or "/" as i'm out of ideas?     Do i need to include HH:MM:SS etc.?

Thank  you

John

LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag
OCS_DEMO_BAC_LOOKUP|BBBB||Y|2020-07-21||BBBB|BBBB|TagB

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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