APPS Technical Interview

[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=”What is Summary 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 summary column performs a computation on another column’s data.
• Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total.
• You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries:  first, last, standard deviation, variance.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can u define exceptions twice in same block?” 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”]

NO

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can you have two functions with the same name in a pl/sql block?” 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

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can you have two stored functions with in the same name?” 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

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can function be overload?” 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

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is the maximum number of statements that can be specified in a trigger statement?” 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”]

ONE

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can 2 functions have same name & input parameters but differ only by return datatype?” 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”]

NO

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is FORWARD DECLARATION in Packages?” 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”]

PL/SQL allows for a special subprogram declaration called a forward declaration.It consists of the subprogram specification in the package body terminated by a semicolon.You can use forward declarations to do the following:

1. Define subprograms in logical or alphabetical order.
2. Define mutually recursive subprograms.(both calling each other).
3. Group subprograms in a package

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

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What do you mean by LOCKS?” 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”]

Locks are used to reduce concurrency

SHARE LOCK—it allows the other users for only reading not to insert or update or delete.

EXCLUSIVE LOCK— only one user can have the privileges of insert or update and delete of particular object others can only read.

UPDATE LOCK—-multiple user can read, update delete

Lock levels :

1) TABLE LEVEL

2) TABLE SPACE

3) DATABASE LEVEL.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is template?” 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 TEMPLATE form is the required starting point for all development of new Forms. It includes platform–independent attachments of several Libraries.

• APPSCORE :- It contains package and procedures that are required of all forms to support  the MENUS ,TOOLBARS.
• APPSDAYPK :- It contains packages that control the oracle applications CALENDER FEATURES.
• FNDSQF  :- it contains packages and procedures for MESSAGE DICTONARY, FLEX FIELDS, PROFILES AND CONCURRENT PROCESSING.
• CUSTOM :- it allows extension of oracle applications forms with out modification of oracle application code, you can use the custom library for customization such as zoom    ( such as moving to another form and querying up specific records)

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

It is a collection of menus, request security groups and data groups

1. Menus: collection of forms is nothing but menus
2. Request security groups: collection of programs.
3. Data groups: is a group of modules to be made accessible by the user through Responsibility.

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

None:   validation is minimal.

Independent ——input must exist on previously defined list of values

Dependent    ——input is checked against a subset of values based on a prior value.

Table             —– input is checked against values in an application table

Special          ——values set uses a flex field itself.

Pair              —— two flex fields together specify a range of valid values.

Translatable independent —– input must exist on previously defined list of values; translated values can be used.

Translatable dependent ——- input is checked against a subset of values based on a prior values; translated value can be used.

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

[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=”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]

[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=”What are ad-hoc 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”]

• Ad-hoc Report is made to meet one-time reporting needs.
• Concerned with or formed for a particular purpose.
• Example: ad hoc tax codes or an ad hoc database query

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is FSG and what is 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”]

• FSG is a powerful and flexible tool you can use to build your own custom  reports without programming.
• FSG is only available with General Ledger (GL) Module.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Differentiate Apps schema from other schemas?” 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”]

• Apps schema is the one that comprises of only synonyms and there is no possibility of creating tables in it.
• Other schema comprises of tables and objects in it and allows the creation of tables as well as for providing grants to tables.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Define custom top and its purpose?” 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”]

• Custom top can be defined as the customer top which is created exclusively for customers.
• According to the requirement of the client many number of customer tops can be made.
• Custom top is made to used for the purpose of storing components, which are developed as well as customized.
• At the time when the applying patches, every module other than custom top are overridden.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is the method of calling standard – interface program from pl/sql or sql code?” 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_REQUEST.SUBMIT_REQUEST(PO, EXECUTABLE NAME,,,,,PARAMETERS)

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Define Application Top?” 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”]

• Application Top is found when we are connecting to server.
• There are two types of application tops available product top and custom top.
• Product top is the kind of top that is built in default by manufacturer.
• Custom top can be chosen by the client, and any number of custom tops can be created as per the requirement of the client.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Explain about the procedures that are compulsory in the case of procedures?” 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 number of parameters which are mandatory in the case of procedures and each of these parameters has a specific job associated with it.

• Errorbuf: This is the parameter used for returning error messages and for sending that to log file.
• Retcode: This is the parameter capable of showing the status associated with a procedure. 0, 1 and 2 are the status displayed by this parameter. 0 is used for indicating completed normal status, 1 defines completed warning status and 2 is the one denoting completed with error.

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

• Token is used for transferring values towards report builder.
• Tokens are usually not case sensitive.

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

• Menu can be defined as a hierarchical arrangement associated with functions of the system.

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

• Function is the smaller part of the application and that is defined inside Menu.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Define about Profile Option?” 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”]

• Profile Option comprises of set of options that are helpful in defining the appearance as well as behavior of the application.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is the usage of the spawned object?” 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 object is used for process associated with executable field.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Tell me what is the procedure to develop an interface?” 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. First we will get the Requirement document.
2. We will create control file based on that plot file.
3. Then the control files which loads the data into staging tables.
4. Through pl/sql programs we will mapping and validate the data and then dump into the interface tables.
5. Through the standard programs we will push the data from interface tables to Base tables.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”How can you call a standard interface program from sql or pl/sql code?” 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. FND_REQUEST.SUBMIT_REQUEST (‘PO’,’EXECUTABLE NAME’,,,,PARAMETERS)

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Tell me couple of API’s FOR CUSTOMER INTERFACE?” 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”]

• HZ_CUST_A/C_VZPUB.UPDATE_CUST_A/C
• HZ_CUST_A/C_VZPUB.CREATE_CUST_A/C

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

[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 :

1. Design your report in Oracle Report Developer
2. Generate the executable file of the report as .rdf.
3. Move the executable as well as source file to the appropriate product’s folder.
4. Register the report as concurrent executable.
5. Define the concurrent program for the executable registered.
6. 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”]

[/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]