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

Behavior in PO_ATTRIBUTE_VALUES table

in Purchasing 2 comments

Summary:

Behavior in PO_ATTRIBUTE_VALUES table

Content (please ensure you mask any confidential information):

My question is regarding the PO_ATTRIBUTE_VALUES table. This table contains the MANUFACTURER_PART_NUM, and if this value is updated on even a single line of a PO then the other lines of that same PO are also updated (vs. new rows being inserted). What I'm seeing is that the LAST_UPDATE_DATE column gets updated on every single line of a PO, even if only a single line actually had the Mfg. Part Number changed.

This is causing an issue as I want to use the LAST_UPDATE_DATE column as a way to track if any Line level attributes changed for syncing back to PIM, however with this behavior it's updating the LAST_UPDATE_DATE on every line, regardless of whether it was in fact updated or not otherwise.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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