Payables and Cash Management - EBS (MOSC)

MOSC Banner

SQL condition in Invoice Workbench personalization is not working

Hi gurus,

I need to create a personalization for our company in eBS (12.2.4) to prevent users from entering invoices in a previous GL date than the max used

But there's a condition which is not currently working, this is the personalization:

WHEN-VALIDATE-RECORD

INV_SUM_FOLDER

Condition

:INV_SUM_FOLDER.GL_DATE < (select max (aia.gl_date) from ap_invoices_all aia where aia.org_id=245 and aia.cancelled_amount is null and aia.invoice_type_lookup_code != 'EXPENSE REPORT' and aia.invoice_date > to_date('01/06/2018', 'MM/DD/YYYY') and aia.pay_group_lookup_code != 'DEVOLUCIONES')

Actions - Error message

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