Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog
July 1, 2017 Apps Technical Interview Questions Part 3
APPS Technical InterviewInterview Questions

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

July 1, 2017 Apps Technical Interview Questions Part 2
APPS Technical InterviewInterview Questions

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

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]

July 1, 2017 ORA-03113: END-OF-FILE ON COMMUNICATION CHANNEL
Errors/Workarounds10gErrors/Workarounds11gOracle Database Material

ERROR

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.

(more…)

July 1, 2017 Java Heap Space Error while running Payables Posted Invoice Register
Accounts PayablesErrors/Workarounds-APOracle Functional

ERROR

When attempting to run Payables Posted Invoice Register ,
the following error occurs.

ERROR
———————–
Status=Error
Completion Text=Java Heap Space
(more…)