Why Fusion and OTBI report gives different Validation Status — 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

Why Fusion and OTBI report gives different Validation Status

edited Jun 4, 2025 7:11AM in Payables, Payments & Cash Management 1 comment

In OTBI I use the MATCH_STATUS_FLAG from AP_INVOICE_DISTRIBUTIONS_ALL to get the validation status.


A - Validated

Null - Never / Not Validated

T - Needs Revalidation

Is these correct?

Going to my question, in Fusion, I can see some Invoices which has a Validation Status of Needs Revalidation, but when I extract the same Invoice in OTBI, it gives either A or Null which is supposed to be T.

Is there any reason for that? or any underlying sub status or any other fields to consider?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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