EBS Customizations (MOSC)

MOSC Banner

How to create a condition properly in a forms personalization

I want to personalize the AP Invoice Workbench to put a message to the screen when the user enters the same invoice number in one supplier site that already exists in another supplier site. I am doing when_new_record_instance on the inv_sum_folder. I am having trouble with the condition. I have tried a number of things, I created a pl/sql function that returns 1 if I want my message to fire.

I have the following condition entered (select dup_invoice(INV_SUM_FOLDER.INVOICE_NUM,INV_SUM_FOLDER.VENDOR_ID) from dual) = 1 but when trying to validate I get the following error: ORA-00904 INV_SUM_FOLDER.INVOICE_NUM invalid identifier.

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