Payables and Cash Management - EBS (MOSC)

MOSC Banner

What causes the Approved_Amount field in the AP Invoices table to populate?

Oracle R12 SQL query:

SELECT *

FROM  AP.ap_invoices_all

WHERE invoice_date >= '01-JAN-20'

AND  approved_amount IS NOT NULL

GROUP BY SOURCE

UNION ALL 

SELECT source, count(1)

FROM  AP.ap_invoices_all

WHERE invoice_date >= '01-JAN-20'

AND  approved_amount IS NULL

GROUP BY SOURCE


Provides:

Where the Approved_Amount field is populated with a value for a given invoice. What is the difference between the two Manual Invoice Entry lines (as only one is in the Payables Sources lookup)?

Thank you in advance,

Lonnie

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center