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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center