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

Unique Records via BIP for tables with Object Version Number

Received Response
9
Views
1
Comments
edited Sep 21, 2020 8:12AM in Reporting and Analytics for ERP 1 comment

Summary

I'm looking for a way to obtain the latest information for a given record via a BIP job, for tables with an Object_Version_Number column

Content

Hi, 

As per the subject, I'm looking to try and find a way to return unique records from a table with Object Version Number.

For example, a unique list of roles available in the application.

Both per_roles_dn_tl, and per_roles_dn hold the column "OBJECT_VERSION_NUMBER". My understanding is that this is related to API calls, and that the number increments as the records are updated.

However, this means that there are duplicate records held on the table for each role. I don't want to use a distinct function, as this will effectively give me a random row each time, rather than the latest record for each role.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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