Buyer Setup

1) In HRMS  'People > Enter and maintain',Create New Employee  whose Last name must be same as User name Which we are logged in. Go to Assignment, Enter Org,Position and Job.Save the record.

2) In Sysadmin 'Security > User > Define', Query for the user & enter 'person' field with employee name created in HRMS. Save the record.

3) In PO 'Setup >Personal > Buyers', Create new buyer for our user. Now we can create a PO

4)  In PO  'Setup >Approvals > Approval groups', Create an approval group.

5)  Go to 'Setup >Approvals > Approval Assignments' , Select the position ( as given in HRMS) and assign approval group for different document types. Now we can approve Documents

DataLoad Commands

DataLoad Command	Application Action(s)
TAB	Press the Tab key
ENT	Press the Enter key
*UP	Press the up arrow key
*DN	Press the down arrow key
*LT	Press the left arrow key
*RT	Press the right arrow key
*SAVE	Save the current record
*SP	Save & proceed
*FE	Open the field editor
*PB	Navigate to the previous block
*NB	Navigate to the next block
*PF	Navigate to the previous field
*NF	Navigate to the next field
*PR	Navigate to the previous record
*NR	Navigate to the next field
*IR	Insert a new record
*CL	Clears the form field but does not delete any data
*ER	Clears a record from the form fields but does not delete it
*DR	Delete the current record
*FR	Navigate to the first record
*LR	Navigate to the last record
*SB	Press the Spacebar. This is useful for toggling the setting of radio buttons and check boxes instead of using the mouse.
*ST	Select the entire field
*FI	Open the find window
*FA	Find all records
*QE	Put the form in to the query enter mode
*QR	Run a query when the form is in query enter mode
*BM	Open the block menu. This is used in Oracle E-Business to select the block or tab to which to navigate.
*AX	Sends the Alt + X keystroke where X is a single letter (A-Z). See Note 1

Note 1 In most applications the menus, buttons and other controls can usually be activated by using the Alt key combined with one other key. DataLoad provides *AX so that all possible Alt key combinations are available as a DataLoad command.

Built-in Commands

The following commands are built-in to DataLoad to provide additional functionality beyond sending data and keystrokes to applications. These commands cannot be edited or replaced in the commands window. The built-in commands are listed in the following table. Where available, please click the link on the command name for more information about using each command.

Command	Application Action(s)
*SLN or *SL(N)	Pause the load for N seconds
*CW(window)	Change to window window
*ML(coordinates)	Position the mouse at coordinates and press the left button
*MR(coordinates)	Position the mouse at coordinates and press the right button
*DL(coordinates)	Position the mouse at coordinates and double click the left button
PROMPT(message)	Prompt the user with message and wait for a response
PHP(function)	Calls a PHP function when Scripting used with a Macro load

User Exits

We can integrate Oracle reports with Oracle Application Object Library, and run them as concurrent programs from your forms or through standard request submission.

User Exits : The Program which makes USER to ExiT from ongoing environment to perform certain action is call USER EXIT.

1. We use the User Exits in the Report triggers like before report, after report, before parameter form, after parameter form.
2. We have to create a mandatory parameter called P_CONC_REQUEST_ID when we work with FND SRWINIT, FND SRWEXIT.
3. The user exits are case sensitive we have to write them in capital letters only otherwise they will raise an error.

SRW Package : SQL Report Writer, SRW is package used while creating a report using .rdf  it helps to perform action at runtime


These are the user exits available in Oracle Reports that makes AOL integration.

Five Types of User Exits:

FND SRWINIT
FND SRWEXIT
FND FORMAT_CURRENCY
FND FLEXIDVAL
FND FLEXSQL

FND SRWINIT

This is a User Exit which sets your profile option values and allows Oracle AOL user exits to detect that they have been called by oracle repots.
It must be included if one is using any ORACLE APPLICATION OBJECT LIBRARY features in his report (such as concurrent processing).

FND SRWINIT also allows your report to use the correct organization automatically.
Can be used in BEFORE-REPORT Trigger.
Syntax is : SRW.USER_EXIT(‘FND SRWINIT’);

FND SRWEXIT
This user exit ensures that all the memory allocated for AOL user exits has been freed up properly.
Can be used in AFTER- REPORT Trigger.
Syntax is : SRW.USER_EXIT(‘FND SRWEXIT’);

FND FORMAT_CURRENCY
To format the currency amount dynamically depending upon the precision of the actual currency value, standard precision, users profile values and location (country) of the site.
You obtain the currency value from the database into an Oracle Reports column.
Define another Oracle Reports column, a formula column of type CHAR, which executes the FORMAT_CURRENCY user exit to format the currency value.
A displayed field has this formula column as its source so that the formatted value is automatically copied into the field for display.

Syntax:
FND FORMAT_CURRENCY
CODE=:column containing currency
DISPLAY_WIDTH=field width for display
AMOUNT=:source column name
DISPLAY=:display column name
[MINIMUM_PRECISION=:P_MIN_PRECISION]
[PRECISION={STANDARD|EXTENDED}]
[DISPLAY_SCALING_FACTOR=:P_SCALING_FACTOR]

FND FLEXSQL
Call this user exit to create a SQL fragment usable by your report to tailor your SELECT statement that retrieves flexfield values. This fragment allows you to SELECT flexfield values or to create a WHERE, ORDER BY, GROUP BY, or HAVING clause to limit or sort the flexfield values returned by your SELECT statement. You call this user exit once for each fragment you need for your select statement. You define all flexfield columns in your report as type CHARACTER even though your table may use NUMBER or DATE or some other datatype.
Syntax:

FND FLEXSQL
CODE=”flexfield code”
APPL_SHORT_NAME=”application short name”
OUTPUT=”:output lexical parameter name”
MODE=”{ SELECT | WHERE | HAVING | ORDER BY}”
[DISPLAY=”{ALL | flexfield qualifier | segment number}”]
[SHOWDEPSEG=”{Y | N}”]
[NUM=”:structure defining lexical” | MULTINUM=”{Y | N}”]
[TABLEALIAS=”code combination table alias”]
[OPERATOR=”{ = | < | > | <= | >= | != | “||” | BETWEEN | QBE}”]
[OPERAND1=”:input parameter or value”]
[OPERAND2=”:input parameter or value”]
FND FLEXIDVAL

Call this user exit to populate fields for display. You pass the key flexfields data retrieved by the query into this exit from the formula column. With this exit you display values, descriptions and prompts by passing appropriate token (any one of VALUE, DESCRIPTION, APROMPT or LPROMPT).

Syntax:

FND FLEXIDVAL
CODE=”flexfield code”
APPL_SHORT_NAME=”application short name”
DATA=”:source column name”
[NUM=”:structure defining source column/lexical”]
[DISPLAY=”{ALL|flexfield qualifier|segment number}”]
[IDISPLAY=”{ALL|flexfield qualifier|segment
number}”]
[SHOWDEPSEG=”{Y | N}”]
[VALUE=”:output column name”]
[DESCRIPTION=”:output column name”]
[APROMPT=”:output column name”]
[LPROMPT=”:output column name”]
[PADDED_VALUE=”:output column name”]
[SECURITY=”:column name”]

Handling multiple layouts in XML Publisher

Steps for handling multiple layouts in XML.

1. After developing the Report definition file (.rdf) we have to add one more parameter like follows.
   
2. This parameter value should be assigned to Place holder column(CP ) like follows
   We can assign Parameter value either after parameter form or before report Triggers.
   In this we assigned in Before report Trigger like Below..
   
   
   

Note: – place holder column should be placed at Report level.

Then we can create multiple layouts in (.rtf).

Like below we have to add condition(If) Field for handling the multi layouts.

Double click on if condition which was added by ourselves. Then the following screen

Will display.

Click On Add help text Button

Then the following screen will display.

Different Types of Value Sets

Independent Value Set:

Navigation: Application Developer > Application > Validation > Sets

Enter information as below

Save it.

Create Values for the value set we defined above

Navigation: Application Developer > Application > Validation > Values

Enter information as below

Save it.

Dependent Value Set

To define a Dependent value set we also need one Independent value set.

Example: To List down States in a Country we need to have list of Countries for which states need to be defined.

First Define list of countries in a independent value set

Navigation: Application Developer > Application > Validation > Sets

Enter Values for the above value set

Navigation: Application Developer > Application > Validation > Values

Enter Values in the below screen

Now define another Value set

Navigation: Application Developer > Application > Validation > Sets

Click Edit Information Button to link this Dependent Value set with Independent Value set defined in previous step

Enter Values for each country

Navigation: Application Developer > Application > Validation > Values

Ensure to Select Country name in “Independent Value” field before click Find.

Click Find and enter states for Country India

Save it

Now repeat the above two steps to enter states of country USA

Ensure to select country as USA before clicking Find button

Save it.

Table Type Value Set

Navigation: Application Developer > Application > Validation > Sets

Select Validation type as “Table” and click Edit Information button

Enter information as below

Click Test button validate the information that is entered

Navigate to Concurrent Program Parameters screen and add fourth parameter

API Parameters

Overview

1) The Application Programming Interface or API is a PL/SQL packaged procedure which can be used as an alternative entry point into the system to the traditional online forms

2) The advantage being that the same logic used by the seeded online forms can also be used by other interfaces into the system, thus ensuring that the integrity of the data remains intact

Calling API

1) Ensure it is appropriate to allow that particular business operation

2) Validate the data passed to the API

3) Each API has a number of parameters, most of them mapped with DB column. Every parameter name starts with p_. If the parameter maps onto a database column, the remaining part of the name is usually the same as the column name

4) When calling the APIs, it is strongly recommended that you use Named Notation, instead of Positional Notation

Standard IN Parameters

1) p_api_version IN NUMBER 

This must match the version number of the API. An unexpected error is returned if the calling program version number is incompatible with the current API version number

2) p_init_msg_list IN VARCHAR2
The valid values for this parameter are:
• True = FND_API.G_TRUE
• False = FND_API.G_FALSE
• Default = FND_API.G_FALSE
If set to true, then the API makes a call to fnd_msg_pub.initialize to initialize the message stack. To set to true, use the value, "T". If set to false then the calling program must initialize the message stack. This action is required to be performed only once, even in the case where more
than one API is called. To set to false, use the value, "F".

3) p_commit IN VARCHAR2 

The valid values for this parameter are:
• True = FND_API.G_TRUE
• False = FND_API.G_FALSE
• Default = FND_API.G_FALSE
If set to true, then the API commits before returning to the calling program. To set to true, use the value, "T". If set to false, then it is the calling program’s responsibility to commit the transaction. To set to false, use the value, "F".

Standard OUT Parameters

1) x_return_status OUT NOCOPY VARCHAR2

Indicates the return status of the API. The values returned are one of the following:
• FND_API.G_RET_STS_SUCCESS
Success: Indicates the API call was successful
• FND_API.G_RET_STS_ERROR
Expected Error: There is a validation error, or missing data error.
• FND_API.G_RET_STS_UNEXP_ERROR
Unexpected Error: The calling program can not correct the error.

2) x_msg_count OUT NOCOPY NUMBER
Holds the number of messages in the message list.

3) x_msg_data OUT NOCOPY VARCHAR2
Holds the encoded message if x_msg_count is equal to one

Outbound Interface