Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Selecting the latest Order revision — Cloud Customer Connect
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

Selecting the latest Order revision

12
Views
8
Comments
edited Feb 4, 2020 9:18PM in General Transactional Reporting (OTBI) 8 comments

Summary

Need to retrieve the latest Orders revisions

Content

Hi,

  While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision of the Order and ignore the old ones.

Is there a function to be used or filter logic to achieve that?

Below a sample of the analysis created and we need to show only the records for Revision 4.0

 

The Subject Areas used are:
Order Management - Order Headers Real Time
Order Management - Order Lines Real Time

BR
Hany

 

Version

19d

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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