Procurement - EBS (MOSC)

MOSC Banner

PO_DOCUMENT_UPDATE_GRP does not update need_by_date to NULL

edited Feb 3, 2020 4:02AM in Procurement - EBS (MOSC) 5 commentsAnswered

Good Day!

I am attempting to use the API PO_DOCUMENT_UPDATE_GRP.UPDATE_DOCUMENT to update a PO shipment (PO_LINE_LOCATIONS_ALL.NEED_BY_DATE) to NULL.

In other APIs, this was accomplished by assigning the date field to fnd_api.g_null_date.

Unfortunately PO_DOCUMENT_UPDATE_GRP.UPDATE_DOCUMENT assigns the NEED_BY_DATE to 1/1/4712 when I do this.

Any help is appreciated.

Thank you.

-Tom

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center