Apps Technical Interview Questions Part 4

[et_pb_section bb_built=”1″ _builder_version=”3.0.52″ background_image=”https://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=”Write down the Form development process?” 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”]

1. Open template form.
2. Save as <your form>.fmb
3. Change the form module name as form name.
4. Delete the default blocks, window, and canvas
5. Create a window.
6. Assign the window property class to window
7. Create a canvas(subclass info)
8. Assign canvas property class to the canvas
9. Assign the window to the canvas and canvas to the window
10. Create a data block
11. Modify the form level properties.
12. Modify the app_cusom package in the program unit.
13. Modify the pre-form trigger (form level)
14. Modify the module level properties 
15. Save and compile the form.
16. Place the .fmx in the server directory.
17. Register in the Application Object Library (AOL).

APPLICATION > FORM

APPLICATION >FUNCTION

APPLICATION > MENU

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is OPEN-DEBIT MEMO REPORT? And tell me it parameters?” 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”]

This report shows all the open-debit memo transactions, based on customer number and dates.

Columns  :- type, customer_no, trx_no, amt_due, remaining.

Parameter :- type, customer, from_date, to_date.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is GENERATING POSITIVE PAY FILE FOR BANK REPORT?” 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”]

Basically this report generates a flat file of all the payments in order to send in to the bank.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is UPDATE POSITIVE PAY CHECKS REPORT?” 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”]

This report which updates the data into the Account Payables (AP) system from the plot file, the file which is sent by bank.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is UPDATE POSITIVE PAY OUT STANDING CHECKS?” 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”]

This report which shows the out standing checks. 

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is CUSTOMER PAYMENT DETAILS REPORT?” 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”]

This report shows each customer original amount, amount pay and due amount based on transaction type.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What are the requests groups?” 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”]

Single request: -this allows you to submit an individual request.

Request set : – this allows you to submit a pre-defined set of requests.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is the usage of SysAdmin Module?” 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”]

1. Define Custom Users
2. Define Login Users
3. Register oracle DB users,
4. Define Concurrent Programs
5. Register Concurrent Executables
6. Setting Profile Option Values
7. Define Request Types

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is the usage of Application Object Library (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”]

1. Registering tables. 
2. Registering views 
3. Registering db sequences
4. Registering profile options 
5. Registering lookups and lookup codes
6. Registering forms 
7. Registering Form and Non-Form functions 
8. registering Menus and sub-menus.  
9. Registering DFF and KFF. 
10. Libraries

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What are the type Models in the system parameters of the report?” 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”]

·         Bit map

·         Character mode

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is Sql Report Writer (SRW) Package? ” 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”]

• This is the Report builder Built in package know as SRW Package.
• This package extends reports, Control report execution, output message at runtime, Initialize layout fields, Perform  DDL statements used to create or Drop temporary table,  Call User Exist, to format width of the columns, to page break the column, to set the colors

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Difference between Bind and Lexical parameters?” 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”]

BIND VARIABLE

• Bind Variable are used to replace a single value in sql, pl/sql
• Bind variable may be used to replace expressions in select, where, group, order by, having, connect by, start with cause of queries.
• Bind reference may not be referenced in FROM clause (or) in place of reserved words or clauses.

LEXICAL REFERENCE

• You can use lexical reference to replace the clauses appearing AFTER select, from, group by, having, connect by, start with.
• You can’t make lexical reference in a pl/sql statements.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is Flex mode and Confine mode?” 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”]

Flex mode:

On:  parent borders “stretch” when child objects are moved against them.

Off:  parent borders remain fixed when child objects are moved against them.

Confine mode:

On:  child objects cannot be moved outside their enclosing parent objects.

Off:  child objects can be moved outside their enclosing parent objects.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is Place holder Columns?” 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”]

• A placeholder is a column is an empty container at design time.
• The placeholder can hold a value at run time has been calculated and placed into it by pl/sql code from anther object.
• You can set the value of a placeholder column is in a Before Report trigger.
• Store a Temporary value for future reference.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is Formula Column?” 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”]

A formula column performs a user-defined computation on another column data, including placeholder columns.

[/et_pb_toggle][/et_pb_column][/et_pb_row][/et_pb_section]