Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Column returning no value when combining Payables Invoices and Payment History subject areas — 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

Column returning no value when combining Payables Invoices and Payment History subject areas

Accepted answer
22
Views
13
Comments
edited Jul 9, 2020 7:03AM in Reporting and Analytics for ERP 13 comments

Content

Hi all,

I have created a summary analysis for AP with a pivot table view that users can drill through to a detailed analysis and then drill down into the manage invoice screen. The drill through to the detailed analysis is handled with prompts.

The most relevant information for our accountants is the invoice approval status, invoice paid status and payment status. This requires the subject areas Payables Invoices - Transactions Real Time and Payables Payments - Payment History Real Time

When they drill on a value where a payment does not exist, the summary analysis will pass the filter 'is null' to the detail analysis. This is where the problem occurs, because it will not return any values. Somehow the values are not matched with null, although in my understanding this is the definition of 'non-existing'. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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