Oracle Transactional Business Intelligence

Products Banner

Duplicates appearing - need true data

Received Response
51
Views
3
Comments

Summary

I have one field that is pulling different dates - need true data

Content

Hi Group,

I'm having an issue getting a single date to pull in correctly in OBI. The field is under Requisition Posting>Posting Date.

What I need is the date the req was posted - however, it pulls in 2 separate dates causing duplicates on my report. 9/19/16 was the actual date posted. The "different date" is shown below.

Any assistance is greatly appreciated!

   
First Fully Approved Date Posting Date
08/03/2016 09/19/2016
08/03/2016 09/20/2016

Answers

  • Hi,

    Have you tried to pull "Requisition Posting"."Posting Board Type" field too. Multiple rows could be fetched if there are different Board Types like "Internal"/"External"

    If you wish to see the recent posting Date details, you can try using a Max on Posting Date column and it will avoid duplicates.Hope this helps.

    Thanks and Regards,

    Reena Trangri

  • Hi Reena,

    Thanks for responding! I'm not sure how to add a max on Posting Date column. Would you be kind enough to explain a bit more for me?

    Thank you!

    Erin

     

  • Hi Erin,

      Edit the Formula for Posting Date column and enter the expression as Max("Requisition Posting"."Posting Date")

    Thanks and Regards,

    Reena