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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

Reset a Assignment Attribute of DATE type to BLANK using Worker.dat

edited Nov 11, 2019 11:06AM in HCM Integrations 6 comments

Summary

Reset a Assignment Attribute of DATE type to BLANK using Worker.dat

Content

Hi Experts,

I'm generating a Worker.dat file using PL/SQL packages for one of our HCM Integrations.

I need to do a 'LOCATION_CHANGE' on an existing assignment on Cloud & along with that reset a assignment attribute(a date) to a BLANK in some cases or pass a new values.

Now for a character field, we can pass '#NULL' to reset a character assignment attribute to BLANK but it doesn't work for DATES.Can someone suggest how to reset a date field (assignment attribute) with a currently existing value in HCM Cloud to BLANK?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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