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

Question

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 .

Riyaz Ali-Oracle · Answer

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