Oracle Transportation Management (MOSC)

MOSC Banner

Time Zone shift and Invoice Gl_Date

Hello everyone,

I try to explicitly update the shipment start time via a custom agent via a direct sql update. At the first step i get (assign) the event_date correspondaing to the start time from the ie_shipmentstatus table, and next i update the shipment start time using a direct sql update.

After that, in the invoice we define the GL_Date as the value that we have stored (via the previous custom agent) in the Shipment Start_date. To do so, we assign the shipment start time and after , via a direct sql update, we update the gl_date of the invoice.

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