Payables and Cash Management - EBS (MOSC)

MOSC Banner

Payables Invoice woprkbench customization

edited Apr 21, 2015 10:07AM in Payables and Cash Management - EBS (MOSC) 14 commentsAnswered

Hi,

I want to customize invoice work bench so user cannot enter invoice in closed period.

But when I created customization on when-validate-record it is working but when query records it fires there also , is there any other event for this?

My code is this

:INV_SUM_FOLDER.INVOICE_DATE not between

(SELECT to_date(min(start_date),'DD-MON-RRRR')

FROM GL_PERIOD_STATUSES_V

WHERE APPLICATION_ID = '200' AND SET_OF_BOOKS_ID = 1

AND NVL(ADJUSTMENT_PERIOD_FLAG, 'N') = 'N' 

and closing_status='O')

and

(SELECT to_date(max(end_date),'DD-MON-RRRR')

FROM GL_PERIOD_STATUSES_V

WHERE APPLICATION_ID = '200' AND SET_OF_BOOKS_ID = 1

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