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 with Redwood: Oracle Cloud SCM and Purchasing

What PO line updates trigger updt to last_update_date on po_distributions_all/po_line_locations_all?

edited Jul 25, 2023 5:29PM in Purchasing 9 comments

Summary:

When a PO Line is updated for a specific PO and line via a change order in the UI, the last_update_date is updated with the current date in the po_lines_all table for the modified line only. However, the last_update_date is updated on all active PO lines in the po_line_locations_all table. In po_distributions_all, the last_update_date is updated on all PO lines (including cancelled).

Content (required):

Our interface logic checks last_update_date on po_lines_all, po_line_locations_all, and po_distributions_all to identify PO lines updated via a

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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