Monday, October 23, 2017

Oracle Forms - Interview Questions

What is a display item?
Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

How many maximum number of radio buttons can you assign to a radio group?
Unlimited number of Radio buttons can be assigned to a radio group.

Can you change the default value of the radio button group at run time?
No.

What triggers are associated with the radio group?
Only when-radio-changed trigger associated with radio group.

What are the various states of a form?
CHANGED:- Indicates that the form contains at least one block with a Changed record.
NEW:-  Indicates that the form contains only New records.
QUERY:- Indicates that a query is open.

What are the different modals of a window?

  1. Modeless windows
  2. Modal Windows
What are the different window events activated at runtime?
When_window_activated
When_window_closed
When_window_deactivated
When_window_resized

When a form call a pl/sql routine if there is an error in the pl/sql routine how do you place custom message in the form?
FND_MESSAGE.SHOW displays an informational message in a forms modal window.
fnd_message.set_string(‘Message Text’);
fnd_message.show;
FND_MESSAGE.HINT to display a message in the forms status line and FND_MESSAGE.ERASE to clear the forms status line. FND_MESSAGE.HINT takes its message from the stack, displays the message, and then clears that message from the message stack.

List the built-in routines for controlling a window during run-time?
FIND_WINDOW
GET_WINDOW_PROPERTY
HIDE_WINDOW
MOVE_WINDOW
RESIZE_WINDOW
SET_WINDOW_PROPERTY
SHOW_VIEW

What built-in is used for changing the properties of a window dynamically?
SET_WINDOW_PROPERTY

What built-in is used for showing an alert during run-time?
SHOW_ALERT

Can you change alert messages at run-time?
Yes. By using SET_ALERT_PROPERTY.

What is the built-in function used for finding the alert?
FIND_ALERT

What is the difference between COPY and NAME_IN ?
Copy is package procedure that writes values into a field. Name_in is a package function that returns the contents of the variable to which you apply.

Can you attach an lov to a field at run-time?
Yes. By using SET_ITEM_PROPERTY

What is the built-in used to get and set lov properties during run-time?
 GET_LOV_PROPERTY
 SET_LOV_PROPERTY


How many number of columns a record group can have?
A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.

What is the Maximum allowed length of Record group Column?
Record group column names cannot exceed 30 characters.

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)