Apps Technical Interview Questions Part 2
[et_pb_section bb_built=”1″ _builder_version=”3.0.52″ background_image=”http://dev.oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg” parallax=”on” parallax_method=”off” inner_shadow=”on”][et_pb_row _builder_version=”3.0.52″ parallax=”on” parallax_method=”off” background_position_1=”top_left” background_repeat_1=”no-repeat” make_fullwidth=”on” use_custom_width=”on” custom_width_percent=”100%” custom_width_px=”1702px” use_custom_gutter=”on” width_unit=”off” make_equal=”on”][et_pb_column type=”4_4″][et_pb_toggle _builder_version=”3.0.52″ title=”Which is the most commonly used package in apps that uses Autonomous Transaction?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
- FND_LOG, this is used for debugging.
- This has a procedure named string, which does a commit.
- Hence your debug messages are not lost in the event of rollback during unhandled exception.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is one of the limitations of Forms Personalization?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
· You can not display interactive messages as you can using fnd_message.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”How to use Flexfields in reports ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
- Most common way is to use FND user exits provided by oracle applications.
- Other way is to directly use the DB views (TableName || ‘_KFV’ or ’_DFV’) created by apps, and use the concatenated_segments column which holds the concatenated segments of the key or descriptive flexfields.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What are Autonomous transactions ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
- An autonomous transaction is an independent transaction started by another transaction.
- Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is record group ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
- Record group are used with LOVs to hold sql query for your list of values.
- The record group can contain static data as well it can access data from database tables through SQL queries.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is a FlexField ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
- An Oracle Applications field made up of segments.
- Each segment has an assigned name and a set of valid values.
- Oracle Applications uses flexfields to capture information about your organization.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What are different report triggers and what is their firing sequence ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
There are five report trigger :
- Before Report
- After Report
- Before Parameter Form
- After Parameter Form
- Between Pages
The Firing sequence for report triggers is
Before Parameter Form > After Parameter Form > Before Report > Between Pages > After Report
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”How to attach reports in Oracle Applications ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
The steps are as follows :
- Design your report in Oracle Report Developer
- Generate the executable file of the report as .rdf.
- Move the executable as well as source file to the appropriate product’s folder.
- Register the report as concurrent executable.
- Define the concurrent program for the executable registered.
- Add the concurrent program to the request group of the responsibility.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is the use of triggers in Forms ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
Triggers are used in forms for event handling.
You can write PL/SQL code in triggers to respond to a particular event occurred in your forms like when user presses a button or when he commits the form.
The different type of triggers available in forms are :
- Key-triggers
- Navigational-triggers
- Transaction-triggers
- Message-triggers
- Error-triggers
- Query based-triggers
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is the use of Temp tables in Interface programs ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
- Temporary tables are used in Interface programs to hold the intermediate data.
- The data is loaded into temporary tables first and then, after validating through the PL/SQL programs, the data is loaded into the interface tables.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”How to pass parameters to a report ? do you have to register them with AOL ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
- You can define parameters in the define concurrent program form.
- There is no need to register the parameters with AOL. But you may have to register the value sets for those parameters.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Do you have to register feeder programs of interface to AOL ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
Yes ! you have to register the feeder programs as concurrent programs to Apps.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What are forms customization steps ?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
The steps are as follows :
- Copy the template.fmb and Appstand.fmb from AU_TOP/forms/us.
- Put it in custom directory.
- The libraries (FNDSQF, APPCORE, APPDAYPK, GLOBE, CUSTOM, JE, JA, JL, VERT) are automatically attached .
- CREATE OR OPEN NEW FORMS.
- Now, Customize.
- Save this Form in Corresponding Modules.
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Difference between Key and Descriptive Flexfield?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
KEY FLEXFIELD |
DESCRIPTIVE FLEFIELD |
Unique Identifier | To capture extra information |
Key Flexfield are stored in segment | Stored in attributes |
For key flexfield there are flexfield Qualifier and segment Qualifier | Context-sensitive flexfield is a feature
of DFF. (descriptive flexfield) |
[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is MRC and what are it’s use?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]
- The Multi Reporting Currency Feature allows you to report and maintain records at the transaction level in more than one functional currency.
- You can do by defining one or more set of books in addition to primary set of books.
[/et_pb_toggle][/et_pb_column][/et_pb_row][/et_pb_section]