EBS Customizations (MOSC)

MOSC Banner

Forms Personalization - Lookup and display values from the DB

edited Apr 22, 2012 9:44PM in EBS Customizations (MOSC) 3 commentsAnswered
Hi,
I have the following requirement. Please let me know if there is a way to implement this via Forms Personalization.


1) User enters information in a form (such as Order Organizer, order number)
2) User Clicks a custom menu option(button or menu- implemented using FP, I already know how to do this)
3) The menu option invokes a database event (sql statement, database function or procedure) to look up a value in the DB based on order number)
4) A message is displayed based on the information retrieved by the db object used in step 3

(Example: User clicks a menu option to lookup a DFF in the customer master, based on the order number)

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