E1: UBE: Update DateLastChanged (VRVCD) Column In F983051 When A UBE Version Is Modified From A Web Client
Last updated on MAY 30, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
Customer wants to find any functionality in EnterpriseOne that would allow them to verify both 1) when data selection or sequencing for a UBE has been modified from a web client and 2) which user made the change.
They had a previous task opened with Oracle Development, exploring the F983051 table's VRVCD column (DateLastChanged) field but found out that this column is never updated from a web client, because there is no check-out/check-in process, which is the only activity that actually updates the time stamp in the VRVCD column (not changing data selection).
So that column name (DateLastChanged) is somewhat misleadingly named, since it can be updated (misleadingly) when someone does a check-out/check-in of a report version from a fat client without changing anything, and it is also NOT updated when a user actually makes a change to a UBE's data selection from a web client.
On web client, data selection is saved into central objects-rdaspecs. There is no OMW check-in process. Since central object specs have been modified, the customer reasons, table F983051, columns VRUSR0 VRVCD should get updated.
The customer needs to track reliably when and by whom UBE data selection or sequencing is changed by its web client users.
Customer wants the DateLastChanged (VRVCD) column in F983051 to reflect when data selection or sequencing has been changed on a UBE from the web client.
If modifying how and when that DateLastChanged (VRVCD) column is updated from web clients is not the preferable option from Oracle Development, then the customer just wants some reliable way in E1 to determine when data selection/sequencing has been modified for a report version, and by whom.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms