Month: July 2017

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