Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Voucher Number is not getting populated for Invoices in OTBI Subject area

Received Response
253
Views
5
Comments
User_D7SS5
User_D7SS5 Rank 1 - Community Starter

Hi Team,

We tried to create OTBI report using Payables Invoice- transaction real time subject area. And, we are noticing that the data for Voucher number is not populating as expected even though the data is there. Let us know the workaround for this to derive the Voucher number.

Thanks

Tagged:

Answers

  • Noelle Bartlam-Oracle
    Noelle Bartlam-Oracle Rank 5 - Community Champion

    Can you clarify what you mean by 'not populating as expected'? Is there data there, but it isn't the data you expected or is there no data at all?

  • User_D7SS5
    User_D7SS5 Rank 1 - Community Starter

    There is data in the front end and not getting populated in the report, No data at all in the Voucher number column in subject area.

  • Noelle Bartlam-Oracle
    Noelle Bartlam-Oracle Rank 5 - Community Champion

    Can you post the nqquery log for this analysis?

  • User_D7SS5
    User_D7SS5 Rank 1 - Community Starter

    Hi,

    Voucher number was populating in Doc-sequence column as the document sequence was enabled and the voucher number field was populating where the document sequencing was disabled.

    Thanks

  • Shakkir K.K
    Shakkir K.K Rank 1 - Community Starter

    Dear User_D7SS5,

    Thanks for your advice.
    We are also searched for that and able to find the Voucher Number data as below.

    Payables Invoices - Transactions Real Time > Invoice Detail > Reference Information > Document Sequence

    Regards,