Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

i am working on OTBI report Payables Invoices - Transaction real time Subject area

Received Response
9
Views
1
Comments
User_8O8W5
User_8O8W5 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

i am working on OTBI report Payables Invoices - Transaction real time Subject area . where i am pulling the details of Account Debit and Account Credit , accounting date ,Supplier name .i want to pull the details of only the active supplier . how to do that in Payables Invoice -Transaction real time subject area .

Answers

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead

    Hi User_8O8W5 ,

    Try the below options:

    Option 1: Use “Supplier Status” from Supplier Profile
    If available in your environment, look for:

    "Supplier"."Supplier Status" Filter:

    Supplier Status is equal to 'Active'
    However, this field may not be exposed in all Fusion environments or may be hidden due to role-based access.

    Option 2: Filter by Supplier Site Status
    If Supplier Status isn’t available, use:
    "Supplier Site"."Supplier Site Status" Filter:

    Supplier Site Status is equal to 'Active'

    Option 3: Filter by Invoice Activity
    If neither status field is exposed, use invoice-level logic:

    Filter by suppliers who have invoices with:
    "Invoice Status" = Validated or Approved
    "Invoice Cancelled Flag" = No
    "Invoice Amount" > 0

    You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance.

    Thanks,
    Riyaz Ali