ORAERP.COM - The Knowledge Center for Oracle ERP Professionals - Looking Beyond the Possibilities - Oracle Documents (Tutorials)

Steps to Configure a Virtual Machine for Apps Installation

Sat, 08 Jun 2013 05:53:07 -0500

Dear All

All new learners try to start with their vision installation and Apps on Virtual Machine is best option.

For this installation, One tricky part is to configure network between host and guest operating systems. I have prepared a document that will address the setting for virtual machine so that you guyz could learn how to configure network between host and guest operating system.

If any body feels any area of improvement, please let me know because I believe to Learn Share and Grow.

Regards
Syed Farhan Ashraf

Steps to Configure Virtual Machine.pdf (Size: 1.75 MB / Downloads: 4)

:: Steps to Produce SLA for Payroll in R12 ::

Sat, 30 Mar 2013 04:20:10 -0500

Issue: Unable to drill down payroll transactions from GL to Payroll module

Solution:

Items:-
(1) Formula:
AMB = JLD (= JLT + ADR + JED) + AAD + SLAM + Mapping Sets

Notes:
AMB = Accounting Methods Builder
AAD = Assign JLD to each event classes
SLAM = Sub-Ledger Accounting Method
JLD = Journal Line Definition; Assign ADR to each JLT
JLT = Journal Line Type; Creation of Debit and Credit information for each Event
Classes
ADR = Accounting Definition Rules; To establish rule for CCID @ transaction level
JED = Journal Entry Description; Define Journal Header/Line Description

(2) Events Classes:
o Payroll Cost
o Payment Cost
o Estimated Cost
o Reversal Estimated Cost

a) JLD (Journal Line Definition):
Step # 1: Create JLT for each of the above Event Classes i.e Debit and
Credit Side
Step # 2: Create ADR for Dr/Cr of each Event Classes (Choose
Assignment Payroll Name in Source)
Step # 3: Assign ADR to each JLT in JLD

b) AAD (Application Accounting Definition):
Step # 4: Assign JLD to Event Classes

c) SLAM (Sub-Ledger Accounting Method):
Step # 5: Create SLAM and assign AAD to this SLAM

d) General Ledger:
Step # 6: Create Ledger from Accounting Setups in ASM (Accounting
Setup Manager) and assign to SLAM

Processes to run Payroll SLA:

Step # 1: Payroll Run
Step # 2 : Prepayment
Step # 3: Costing
Step # 4: Transfer to SLA from HRMS Responsibility
Step # 5: Run Create Accounting program from Global/Payroll Responsibility
Step # 6: Review or Post Payroll Batch in GL

Steps to Produce SLA for Payroll in R12.pdf (Size: 291.45 KB / Downloads: 26)

Functionality/Features difference between R12 and 11i

Tue, 05 Mar 2013 10:30:44 -0600

One of the 1st process of upgrade project to do a review of funtionality between two versions.
Functionality/Features difference between Oracle eBusiness Suite R12 and R11i
Oracle Financials - GL, FA, AP, AR, CM
Oracle SCM - PO
Oracle HRMS

  Fin_Functional_Analysis_11ivsR12_v1 0.xlsx (Size: 74.29 KB / Downloads: 126)

  PO_Functional_Analysis_11ivsR12_v1 0.xls (Size: 23.5 KB / Downloads: 62)

  HRMS_Functionality Diff R12-11i V1.0.xls (Size: 35 KB / Downloads: 67)

Installation of Oracle Fusion Applications

Sat, 26 Jan 2013 09:06:38 -0600

Few days back I thought, let’s try to install Oracle fusion applications and started glancing different docs available and finally reach to a question number 1, what hardware required? Do I have that infrastructure to support me for this thrust? All these questions played vital role to write my earlier post on hardware sizing for Oracle Fusion Applications. In the last whatever hardware was available with me, just started to try out as an experimental basis and we will see later on.

Downloading fusion applications media from http://edelivery.oracle.com took few days based on my internet speed and meanwhile I was just exploring installation guide Oracle Fusion Applications Installation Guide 11g Release 5 (11.1.5) E16600-07

Another thing what I have done is just captured all the steps which I have followed during this installation drive and just going to share through this post. These all steps based on my own research and maybe there is error or wrong so I would suggest all of you to just follow Oracle’s standard guide to install Oracle Fusion Applications. However do let me know if you find any point erroneous or require modifications.
What will be covered in this?
• Basic Concepts/Architecture of Oracle Fusion Applications
• Where to start? How to start?
• Oracle Fusion Applications Media download from edelivery
• Download and Installation of Oracle Linux from edelivery
• Installation of Virtual Box
• Installation of Operating System – Oracle Linux
• Stage the Oracle Fusion Applications software
• Install provisioning framework
• Install a transaction database
• Install and configure Oracle Identity Management components
• Configure Oracle Identity and Access Management components
• Integrate Oracle Identity Manager and Oracle Access Manager
• Create a provisioning plan for the new environment
• Provision a new environment
• Complete required post-installation tasks

Installation of Oracle Fusion Applications Part-1.pdf (Size: 4.82 MB / Downloads: 108)

Oracle Procure To Pay cycle

Wed, 09 Jan 2013 23:44:50 -0600

The Procure To Pay cycle is vital to an organization as in this process the organization buys and received goods or services from its vendors and makes necessary payments.

The P2P cycle comprises of the following steps,
1. Create requisition
2. Approve requisition
3. Create purchase order
4. Approve purchase order
5. Receive goods
6. Create Payables invoice
7. Pay the invoice
8. Return to Vendor (optional)
9. Transfer to General Ledger
10. Import Journal into General Ledger

Download attached doc

Oracle Procure To Pay cycle v1.pdf (Size: 1.5 MB / Downloads: 131)

Email From Oracle PL/SQL

Sun, 06 Jan 2013 01:32:21 -0600

The UTL_SMTP package can be used to send emails from PL/SQL.

Emails:

In it’s simplest form a single string or variable can be sent as the message body using the following procedure. In this case we have not included any header information or subject line in the message, so it is not very useful, but it is small.

CREATE OR REPLACE PROCEDURE send_mail (p_to IN VARCHAR2,

p_from IN VARCHAR2,
p_message IN VARCHAR2,
p_smtp_host IN VARCHAR2,
p_smtp_port IN NUMBER DEFAULT 25)
AS
l_mail_conn UTL_SMTP.connection;

BEGIN

l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);

UTL_SMTP.helo(l_mail_conn, p_smtp_host);

UTL_SMTP.mail(l_mail_conn, p_from);

UTL_SMTP.rcpt(l_mail_conn, p_to);

UTL_SMTP.data(l_mail_conn, p_message || UTL_TCP.crlf || UTL_TCP.crlf);

UTL_SMTP.quit(l_mail_conn);

END;

/

The code below shows how the procedure is called.

BEGIN

send_mail(p_to => ‘me@mycompany.com’,

p_from => ‘admin@mycompany.com’,

p_message => ‘This is a test message.’,

p_smtp_host => ‘smtp.mycompany.com’);

END;

/

Multi-Line Emails

Multi-line messages can be written by expanding the UTL_SMTP.DATA command using the UTL_SMTP.WRITE_DATA command as follows. This is a better method to use as the total message size is no longer constrained by the 32K limit on a VARCHAR2 variable. In the following example the header information has been included in the message also.

CREATE OR REPLACE PROCEDURE send_mail (p_to IN VARCHAR2,

p_from IN VARCHAR2,

p_subject IN VARCHAR2,

p_message IN VARCHAR2,

p_smtp_host IN VARCHAR2,

p_smtp_port IN NUMBER DEFAULT 25)

AS

l_mail_conn UTL_SMTP.connection;

BEGIN

l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);

UTL_SMTP.helo(l_mail_conn, p_smtp_host);

UTL_SMTP.mail(l_mail_conn, p_from);

UTL_SMTP.rcpt(l_mail_conn, p_to);

UTL_SMTP.open_data(l_mail_conn);

UTL_SMTP.write_data(l_mail_conn, ‘Date: ‘ || TO_CHAR(SYSDATE, ‘DD-MON-YYYY HH24:MIS’) || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘To: ‘ || p_to || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘From: ‘ || p_from || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Subject: ‘ || p_subject || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Reply-To: ‘ || p_from || UTL_TCP.crlf || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, p_message || UTL_TCP.crlf || UTL_TCP.crlf);

UTL_SMTP.close_data(l_mail_conn);

UTL_SMTP.quit(l_mail_conn);

END;

/

The code below shows how the procedure is called.

BEGIN

send_mail(p_to => ‘me@mycompany.com’,

p_from => ‘admin@mycompany.com’,

p_subject => ‘Test Message’,

p_message => ‘This is a test message.’,

p_smtp_host => ‘smtp.mycompany.com’);

END;

/

HTML Emails

The following procedure builds on the previous version, allowing it include plain text and/or HTML versions of the email. The format of the message is explained here.

CREATE OR REPLACE PROCEDURE send_mail (p_to IN VARCHAR2,

p_from IN VARCHAR2,

p_subject IN VARCHAR2,

p_text_msg IN VARCHAR2 DEFAULT NULL,

p_html_msg IN VARCHAR2 DEFAULT NULL,

p_smtp_host IN VARCHAR2,

p_smtp_port IN NUMBER DEFAULT 25)

AS

l_mail_conn UTL_SMTP.connection;

l_boundary VARCHAR2(50) := ‘—-=*#abc1234321cba#*=’;

BEGIN

l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);

UTL_SMTP.helo(l_mail_conn, p_smtp_host);

UTL_SMTP.mail(l_mail_conn, p_from);

UTL_SMTP.rcpt(l_mail_conn, p_to);

UTL_SMTP.open_data(l_mail_conn);

UTL_SMTP.write_data(l_mail_conn, ‘Date: ‘ || TO_CHAR(SYSDATE, ‘DD-MON-YYYY HH24:MIS’) || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘To: ‘ || p_to || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘From: ‘ || p_from || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Subject: ‘ || p_subject || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Reply-To: ‘ || p_from || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘MIME-Version: 1.0′ || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Type: multipart/alternative; boundary=”‘ || l_boundary || ‘”‘ || UTL_TCP.crlf || UTL_TCP.crlf);

IF p_text_msg IS NOT NULL THEN

UTL_SMTP.write_data(l_mail_conn, ‘–’ || l_boundary || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Type: text/plain; charset=”iso-8859-1″‘ || UTL_TCP.crlf || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, p_text_msg);

UTL_SMTP.write_data(l_mail_conn, UTL_TCP.crlf || UTL_TCP.crlf);

END IF;

IF p_html_msg IS NOT NULL THEN

UTL_SMTP.write_data(l_mail_conn, ‘–’ || l_boundary || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Type: text/html; charset=”iso-8859-1″‘ || UTL_TCP.crlf || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, p_html_msg);

UTL_SMTP.write_data(l_mail_conn, UTL_TCP.crlf || UTL_TCP.crlf);

END IF;

UTL_SMTP.write_data(l_mail_conn, ‘–’ || l_boundary || ‘–’ || UTL_TCP.crlf);

UTL_SMTP.close_data(l_mail_conn);

UTL_SMTP.quit(l_mail_conn);

END;

/

The code below shows how the procedure is called.

DECLARE

l_html VARCHAR2(32767);

BEGIN

l_html := ‘

Test HTML message

This is a HTML version of the test message.

’;

send_mail(p_to => ‘me@mycompany.com’,

p_from => ‘admin@mycompany.com’,

p_subject => ‘Test Message’,

p_text_msg => ‘This is a test message.’,

p_html_msg => l_html,

p_smtp_host => ‘smtp.mycompany.com’);

END;

/

Emails with Attachments

Sending an email with an attachment is similar to the previous example as the message and the attachment must be separated by a boundary and identified by a name and mime type.

BLOB Attachment

Attaching a BLOB requires the binary data to be encoded and converted to text so it can be sent using SMTP.

CREATE OR REPLACE PROCEDURE send_mail (p_to IN VARCHAR2,

p_from IN VARCHAR2,

p_subject IN VARCHAR2,

p_text_msg IN VARCHAR2 DEFAULT NULL,

p_attach_name IN VARCHAR2 DEFAULT NULL,

p_attach_mime IN VARCHAR2 DEFAULT NULL,

p_attach_blob IN BLOB DEFAULT NULL,

p_smtp_host IN VARCHAR2,

p_smtp_port IN NUMBER DEFAULT 25)

AS

l_mail_conn UTL_SMTP.connection;

l_boundary VARCHAR2(50) := ‘—-=*#abc1234321cba#*=’;

l_step PLS_INTEGER := 24573;

BEGIN

l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);

UTL_SMTP.helo(l_mail_conn, p_smtp_host);

UTL_SMTP.mail(l_mail_conn, p_from);

UTL_SMTP.rcpt(l_mail_conn, p_to);

UTL_SMTP.open_data(l_mail_conn);

UTL_SMTP.write_data(l_mail_conn, ‘Date: ‘ || TO_CHAR(SYSDATE, ‘DD-MON-YYYY HH24:MIS’) || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘To: ‘ || p_to || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘From: ‘ || p_from || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Subject: ‘ || p_subject || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Reply-To: ‘ || p_from || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘MIME-Version: 1.0′ || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Type: multipart/mixed; boundary=”‘ || l_boundary || ‘”‘ || UTL_TCP.crlf || UTL_TCP.crlf);

IF p_text_msg IS NOT NULL THEN

UTL_SMTP.write_data(l_mail_conn, ‘–’ || l_boundary || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Type: text/plain; charset=”iso-8859-1″‘ || UTL_TCP.crlf || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, p_text_msg);

UTL_SMTP.write_data(l_mail_conn, UTL_TCP.crlf || UTL_TCP.crlf);

END IF;

IF p_attach_name IS NOT NULL THEN

UTL_SMTP.write_data(l_mail_conn, ‘–’ || l_boundary || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Type: ‘ || p_attach_mime || ‘; name=”‘ || p_attach_name || ‘”‘ || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Transfer-Encoding: base64′ || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Disposition: attachment; filename=”‘ || p_attach_name || ‘”‘ || UTL_TCP.crlf || UTL_TCP.crlf);

FOR i IN 0 .. TRUNC((DBMS_LOB.getlength(p_attach_blob) – 1 )/l_step) LOOP

UTL_SMTP.write_data(l_mail_conn, UTL_RAW.cast_to_varchar2(UTL_ENCODE.base64_encode(DBMS_LOB.substr(p_attach_blob, l_step, i * l_step + 1))));

END LOOP;

UTL_SMTP.write_data(l_mail_conn, UTL_TCP.crlf || UTL_TCP.crlf);

END IF;

UTL_SMTP.write_data(l_mail_conn, ‘–’ || l_boundary || ‘–’ || UTL_TCP.crlf);

UTL_SMTP.close_data(l_mail_conn);

UTL_SMTP.quit(l_mail_conn);

END;

/

The code below shows how the procedure is called.

DECLARE

l_name images.name%TYPE := ‘site_logo.gif’;

l_blob images.image%TYPE;

BEGIN

SELECT image

INTO l_blob

FROM images

WHERE name = l_name;

send_mail(p_to => ‘me@mycompany.com’,

p_from => ‘admin@mycompany.com’,

p_subject => ‘Test Message’,

p_text_msg => ‘This is a test message.’,

p_attach_name => ‘site_logo.gif’,

p_attach_mime => ‘image/gif’,

p_attach_blob => l_blob,

p_smtp_host => ‘smtp.mycompany.com’);

END;

/

CLOB Attachment

Attaching a CLOB is similar to attaching a BLOB, but we don’t have to worry about encoding the data because it is already plain text.

CREATE OR REPLACE PROCEDURE send_mail (p_to IN VARCHAR2,

p_from IN VARCHAR2,

p_subject IN VARCHAR2,

p_text_msg IN VARCHAR2 DEFAULT NULL,

p_attach_name IN VARCHAR2 DEFAULT NULL,

p_attach_mime IN VARCHAR2 DEFAULT NULL,

p_attach_clob IN CLOB DEFAULT NULL,

p_smtp_host IN VARCHAR2,

p_smtp_port IN NUMBER DEFAULT 25)

AS

l_mail_conn UTL_SMTP.connection;

l_boundary VARCHAR2(50) := ‘—-=*#abc1234321cba#*=’;

l_step PLS_INTEGER := 24573;

BEGIN

l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);

UTL_SMTP.helo(l_mail_conn, p_smtp_host);

UTL_SMTP.mail(l_mail_conn, p_from);

UTL_SMTP.rcpt(l_mail_conn, p_to);

UTL_SMTP.open_data(l_mail_conn);

UTL_SMTP.write_data(l_mail_conn, ‘Date: ‘ || TO_CHAR(SYSDATE, ‘DD-MON-YYYY HH24:MIS’) || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘To: ‘ || p_to || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘From: ‘ || p_from || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Subject: ‘ || p_subject || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Reply-To: ‘ || p_from || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘MIME-Version: 1.0′ || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Type: multipart/mixed; boundary=”‘ || l_boundary || ‘”‘ || UTL_TCP.crlf || UTL_TCP.crlf);

IF p_text_msg IS NOT NULL THEN

UTL_SMTP.write_data(l_mail_conn, ‘–’ || l_boundary || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Type: text/plain; charset=”iso-8859-1″‘ || UTL_TCP.crlf || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, p_text_msg);

UTL_SMTP.write_data(l_mail_conn, UTL_TCP.crlf || UTL_TCP.crlf);

END IF;

IF p_attach_name IS NOT NULL THEN

UTL_SMTP.write_data(l_mail_conn, ‘–’ || l_boundary || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Type: ‘ || p_attach_mime || ‘; name=”‘ || p_attach_name || ‘”‘ || UTL_TCP.crlf);

UTL_SMTP.write_data(l_mail_conn, ‘Content-Disposition: attachment; filename=”‘ || p_attach_name || ‘”‘ || UTL_TCP.crlf || UTL_TCP.crlf);

FOR i IN 0 .. TRUNC((DBMS_LOB.getlength(p_attach_clob) – 1 )/l_step) LOOP

UTL_SMTP.write_data(l_mail_conn, DBMS_LOB.substr(p_attach_clob, l_step, i * l_step + 1));

END LOOP;

UTL_SMTP.write_data(l_mail_conn, UTL_TCP.crlf || UTL_TCP.crlf);

END IF;

UTL_SMTP.write_data(l_mail_conn, ‘–’ || l_boundary || ‘–’ || UTL_TCP.crlf);

UTL_SMTP.close_data(l_mail_conn);

UTL_SMTP.quit(l_mail_conn);

END;

/

The code below shows how the procedure is called.

DECLARE

l_clob CLOB := ‘This is a very small CLOB!’;

BEGIN

send_mail(p_to => ‘me@mycompany.com’,

p_from => ‘admin@mycompany.com’,

p_subject => ‘Test Message’,

p_text_msg => ‘This is a test message.’,

p_attach_name => ‘test.txt’,

p_attach_mime => ‘text/plain’,

p_attach_clob => l_clob,

p_smtp_host => ‘smtp.mycompany.com’);

END;

/

Miscellaneous

For emails with multiple recipients, simply call the RCPT procedure once for each separate email address.

The UTL_SMTP package requires Jserver which can be installed by running the following scripts as SYS.

SQL> @$ORACLE_HOME/javavm/install/initjvm.sql

SQL> @$ORACLE_HOME/rdbms/admin/initplsj.sql

API - Assign Item to an another Organization in Oracle Inventory

Tue, 25 Dec 2012 22:37:25 -0600

Release R12+
Assign Item to an another Organization in Oracle Inventory by using API EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG

API EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG provides functionality for maintaining items, item revisions, and etc. let’s use ASSIGN_ITEM_TO_ORG procedure to assign one item to an organization.
The procedure definition is:

PROCEDURE Assign_Item_To_Org(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
,p_commit IN VARCHAR2 DEFAULT G_FALSE
,p_Inventory_Item_Id IN NUMBER DEFAULT G_MISS_NUM
,p_Item_Number IN VARCHAR2 DEFAULT G_MISS_CHAR
,p_Organization_Id IN NUMBER DEFAULT G_MISS_NUM
,p_Organization_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
,p_Primary_Uom_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER);

The parameters are:
 P_API_VERSION – A decimal number indicating major and minor revisions to the API. Pass 1.0 unless otherwise indicated in the API parameter list.
 P_INIT_MSG_LIST – A one-character flag indicating whether to initialize the FND_MSG_PUB package’s message stack at the beginning of API processing (and thus remove any messages that may exist on the stack from prior processing in the same session). Valid values are FND_API.G_TRUE and FND_API.G_FALSE.
 P_COMMIT – A one-character flag indicating whether to commit work at the end of API processing. Valid values are FND_API.G_TRUE and FND_API.G_FALSE.
 P_INVENTORY_ITEM_ID – Inventory Item Id of the Item
 P_ITEM_NUMBER – Segment1 of the Item
 P_ORGANIZATION_ID – Organization Id of the Organization to whom Item must be assigned
 P_ORGANIZATION_CODE – 3 character Organization Code of the Organization to whom Item must be assigned
 P_PRIMARY_UOM_CODE – Primary Unit of Measure of the item.
 X_RETURN_STATUS – A one-character code indicating whether any errors occurred during processing (in which case error messages will be present on the FND_MSG_PUB package’s message stack). Valid values are FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.
 X_MSG_COUNT – An integer indicating the number of messages on the FND_MSG_PUB package’s message stack at the end of API processing.
Sample Code: (Tested in R12.1.3)
DECLARE
g_user_id fnd_user.user_id%TYPE :=NULL;
l_appl_id fnd_application.application_id%TYPE;
l_resp_id fnd_responsibility_tl.responsibility_id%TYPE;
l_api_version NUMBER := 1.0;
l_init_msg_list VARCHAR2(2) := fnd_api.g_false;
l_commit VARCHAR2(2) := FND_API.G_FALSE;
x_message_list error_handler.error_tbl_type;
x_return_status VARCHAR2(2);
x_msg_count NUMBER := 0;
BEGIN
SELECT fa.application_id
INTO l_appl_id
FROM fnd_application fa
WHERE fa.application_short_name = 'INV';

SELECT fr.responsibility_id
INTO l_resp_id
FROM fnd_application fa, fnd_responsibility_tl fr
WHERE fa.application_short_name = 'INV'
AND fa.application_id = fr.application_id
AND UPPER (fr.responsibility_name) = 'INVENTORY';

fnd_global.apps_initialize (g_user_id, l_resp_id, l_appl_id);

EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG(
P_API_VERSION => l_api_version
, P_INIT_MSG_LIST => l_init_msg_list
, P_COMMIT => l_commit
, P_INVENTORY_ITEM_ID => 1003
, p_item_number => 000000000001035
, p_organization_id => 11047
, P_ORGANIZATION_CODE => 'DXN'
, P_PRIMARY_UOM_CODE => 'EA'
, X_RETURN_STATUS => x_return_status
, X_MSG_COUNT => x_msg_count
);
DBMS_OUTPUT.PUT_LINE('Status: '||x_return_status);
IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
DBMS_OUTPUT.PUT_LINE('Error Messages :');
Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
FOR j IN 1..x_message_list.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(x_message_list(j).message_text);
END LOOP;
END IF;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('Exception Occured :');
DBMS_OUTPUT.PUT_LINE(SQLCODE ||':'||SQLERRM);
END;

Item Category Creation APIs
There are few APIs in INV_ITEM_CATEGORY_PUB package related to item category. This article will follow a category flexfield structure. Please refer the below post for more detail.
INV_ITEM_CATEGORY_PUB.Create_Category:
DECLARE
l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;
l_return_status VARCHAR2(80);
l_error_code NUMBER;
l_msg_count NUMBER;
l_msg_data VARCHAR2(80);
l_out_category_id NUMBER;
BEGIN
l_category_rec.segment1 := 'RED';

SELECT f.ID_FLEX_NUM
INTO l_category_rec.structure_id
FROM FND_ID_FLEX_STRUCTURES f
WHERE f.ID_FLEX_STRUCTURE_CODE = 'INV_COLORS';

l_category_rec.description := 'Red';

INV_ITEM_CATEGORY_PUB.Create_Category
(
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_TRUE,
x_return_status => l_return_status,
x_errorcode => l_error_code,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_category_rec => l_category_rec,
x_category_id => l_out_category_id
);
IF l_return_status = fnd_api.g_ret_sts_success THEN
COMMIT;
DBMS_OUTPUT.put_line ('Creation of Item Category is Successful : '||l_out_category_id);
ELSE
DBMS_OUTPUT.put_line ('Creation of Item Category Failed with the error :'||l_error_code);
ROLLBACK;
END IF;
END ;

INV_ITEM_CATEGORY_PUB. Delete_Category:

DECLARE
l_return_status VARCHAR2(80);
l_error_code NUMBER;
l_msg_count NUMBER;
l_msg_data VARCHAR2(80);
l_category_id NUMBER;
BEGIN
SELECT mcb.CATEGORY_ID
INTO l_category_id
FROM mtl_categories_b mcb
WHERE mcb.SEGMENT1='RED'
AND mcb.STRUCTURE_ID =
(SELECT mcs_b.STRUCTURE_ID
FROM mtl_category_sets_b mcs_b
WHERE mcs_b.CATEGORY_SET_ID =
(SELECT mcs_tl.CATEGORY_SET_ID
FROM mtl_category_sets_tl mcs_tl
WHERE CATEGORY_SET_NAME ='INV_COLORS_SET'
)
);

INV_ITEM_CATEGORY_PUB.Delete_Category
(
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_TRUE,
x_return_status => l_return_status,
x_errorcode => l_error_code,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_category_id => l_category_id);

IF l_return_status = fnd_api.g_ret_sts_success THEN
COMMIT;
DBMS_OUTPUT.put_line ('Deletion of Item Category is Successful : '||l_category_id);
ELSE
DBMS_OUTPUT.put_line ('Deletion of Item Category Failed with the error :'||l_error_code);
ROLLBACK;
END IF;
END ;

INV_ITEM_CATEGORY_PUB.Update_Category_Description
Updates the category description.

DECLARE
l_return_status VARCHAR2(80);
l_error_code NUMBER;
l_msg_count NUMBER;
l_msg_data VARCHAR2(80);
l_category_id NUMBER;
l_description VARCHAR2(80);
BEGIN
select mcb.CATEGORY_ID into l_category_id
from mtl_categories_b mcb
where mcb.SEGMENT1='BLACK'
and mcb.STRUCTURE_ID = (select mcs_b.STRUCTURE_ID
from mtl_category_sets_b mcs_b
where mcs_b.CATEGORY_SET_ID = (select mcs_tl.CATEGORY_SET_ID
from mtl_category_sets_tl mcs_tl
where CATEGORY_SET_NAME ='INV_COLORS_SET'));

l_description := 'new black color';

INV_ITEM_CATEGORY_PUB.Update_Category_Description (
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_TRUE,
x_return_status => l_return_status,
x_errorcode => l_error_code,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_category_id => l_category_id,
p_description => l_description);

IF l_return_status = fnd_api.g_ret_sts_success THEN
COMMIT;
DBMS_OUTPUT.put_line ('Update of Item Category Description is Successful : '||l_category_id);
ELSE
DBMS_OUTPUT.put_line ('Update of Item Category Description Failed with the error :'||l_error_code);
ROLLBACK;
END IF;
END ;

Use following API for assigning a category to a category set. A category will be available in the list of valid categoies for a category set only if it is assigned to the category set. This is a required step if for categories enforce list is checked on.

INV_ITEM_CATEGORY_PUB.Create_Valid_Category

Create a record in mtl_category_set_valid_cats.

DECLARE
l_return_status VARCHAR2(80);
l_error_code NUMBER;
l_msg_count NUMBER;
l_msg_data VARCHAR2(80);
l_category_set_id NUMBER;
l_category_id NUMBER;
BEGIN
select mcs_tl.CATEGORY_SET_ID into l_category_set_id
from mtl_category_sets_tl mcs_tl
where mcs_tl.CATEGORY_SET_NAME ='INV_COLORS_SET';

select mcb.CATEGORY_ID into l_category_id
from mtl_categories_b mcb
where mcb.SEGMENT1='RED'
and mcb.STRUCTURE_ID = (select mcs_b.STRUCTURE_ID
from mtl_category_sets_b mcs_b
where mcs_b.CATEGORY_SET_ID = (select mcs_tl.CATEGORY_SET_ID
from mtl_category_sets_tl mcs_tl
where CATEGORY_SET_NAME ='INV_COLORS_SET'));

INV_ITEM_CATEGORY_PUB.Create_Valid_Category (
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_TRUE,
x_return_status => l_return_status,
x_errorcode => l_error_code,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_category_set_id => l_category_set_id,
p_category_id => l_category_id,
p_parent_category_id => NULL );

IF l_return_status = fnd_api.g_ret_sts_success THEN
COMMIT;
DBMS_OUTPUT.put_line ('Create Valid Category is Successful : '||l_category_id);
ELSE
DBMS_OUTPUT.put_line ('Create Valid Category Failed with the error :'||l_error_code);
ROLLBACK;
END IF;
END ;

INV_ITEM_CATEGORY_PUB.Delete_Valid_Category

Delete the record from mtl_category_set_valid_cats.

DECLARE
l_return_status VARCHAR2(80);
l_error_code NUMBER;
l_msg_count NUMBER;
l_msg_data VARCHAR2(80);
l_category_set_id NUMBER;
l_category_id NUMBER;
BEGIN
select mcs_tl.CATEGORY_SET_ID into l_category_set_id
from mtl_category_sets_tl mcs_tl
where mcs_tl.CATEGORY_SET_NAME ='INV_COLORS_SET';

select mcb.CATEGORY_ID into l_category_id
from mtl_categories_b mcb
where mcb.SEGMENT1='RED'
and mcb.STRUCTURE_ID = (select mcs_b.STRUCTURE_ID
from mtl_category_sets_b mcs_b
where mcs_b.CATEGORY_SET_ID = (select mcs_tl.CATEGORY_SET_ID
from mtl_category_sets_tl mcs_tl
where CATEGORY_SET_NAME ='INV_COLORS_SET'));

INV_ITEM_CATEGORY_PUB.Delete_Valid_Category (
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_TRUE,
x_return_status => l_return_status,
x_errorcode => l_error_code,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_category_set_id => l_category_set_id,
p_category_id => l_category_id);

IF l_return_status = fnd_api.g_ret_sts_success THEN
COMMIT;
DBMS_OUTPUT.put_line ('Delete Valid Category is Successful : '||l_category_id);
ELSE
DBMS_OUTPUT.put_line ('Delete Valid Category Failed with the error :'||l_error_code);
ROLLBACK;
END IF;
END ;

Oracle Database 11g on Enterprise Linux 5 and CentOS 5

Sat, 08 Dec 2012 13:44:48 -0600

Introduction
This articles covers the Installation of Oracle Database 11g Release 2 on Enterprise Linux 5 and Suse 11.
Oracle 11g Release 2 launched in August 2009. Now, the product is available on Linux platform. There are almost 400 aditional functionality added by Oracle 11g. After going through the Oracle webcast 11g Release 2, I feel Oracle 11g Rel. 2 more focus on High Availability(easy RAC installation and implementation),Compressing Data,Security,etc.

11g Release 2 required minimum 1gb RAM for the installation. I would recommend minimum 4gb ram will be ideally better. Swap should have double of physical ram.

I recommend the following Server Configuration:

Intel Xeon Processor W5580 3.20ghz
L3 8mb Cache
1 Quad Core
4 to 8gb Ram (an ideal configuration) .
146gb HDD (default) - This configuration can be changed, based on various factors.

The following packages is mandatory for Enterprise Linux : GNOME Desktop Environment ,Graphical Internet, X Window System ,Editors , Development Tools ,Server Configuration Tools,System Tools and Administration Tools.

You can download the software, subject to Oracle Licensing.

[font="]http://www.oracle.com/technology/software/products/database/index.html[/font]

Standard Edition One – support upto 2 cpu
Standard Edition – support upot 4 cpu
Enterprise Edition – unlimited.
(11.2.0.1.0) Linux x86 | Disk 2(2.1 GB)

Set the Linux Kernal Parameters:
Linux Kernel Parameters

What is the Shared Memory ( reference with various linux/unix sites for these parameters.):

The shared memory will hve huge impact on Oracle Performance. So very carefully to be handled.

Shared memory allows processes to access common structures and data by placing them in shared memory segments. It's the fastest form of IPC (Interprocess Communication) available since no kernel involvement occurs when data is passed
between the processes.
Oracle uses shared memory segments for the SGA (Shared Global Area) which is an area of memory that is shared by all Oracle background and foreground processes.

Setting SHMMAX Parameter

This parameter defines the maximum size in bytes for a shared memory segment.
Since the SGA is comprised of shared memory, SHMMAX can potentially limit the size of the SGA.

Setting SHMMNI Parameter
This parameter sets the maximum number of shared memory segments system wide.

Setting SHMALL Parameter
This parameter sets the total amount of shared memory in bytes that can be used at one time on the system.

The SEMMSL Parameter
This parameter defines the maximum number of semaphores per semaphore set.
Oracle recommends to set SEMMSL to the largest PROCESSES init.ora parameter of any database on the Linux system.

The SEMMNI Parameter
This parameter defines the maximum number of semaphore sets in the entire Linux system.

The SEMMNS Parameter
This parameter defines the total number of semaphores (not semaphore set) in the entire Linux system.

The SEMOPM Parameter
This parameter defines the maximum number of semaphore operations that can be performed per [font="]semop(2)[/font] system call.

Setting File Handles
The maximum number of file handles denotes the maximum number of open files that you can have on the Linux system.

Setting System Wide Limit for File Handles

The value in /proc/sys/fs/file-max sets the maximum number of file handles or open files that the Linux kernel will allocate. When you get error messages about running out of file handles, then you might want to raise this limit.
Change the parameters:

Copy sysctl.conf
cp sysctl.conf
sysctl.confold

Cd /etc

Vi sysctl.conf

Add the following:
kernel.shmmax = 2147483648
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536 # 512 * PROCESSES
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
net.ipv4.ip_local_port_range = 1024 65000

Press Esc :wq

Change the Hosts File Entry

Cd
/etc

Cp hosts hostsold

Vi hosts
IP-address Machinename.domainname Hostname

Press Esc and :wq
Go to /etc/security (cd /etc/security)
Vi limits.conf
Add or change /etc/security/limits.conf file:
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
to save Esc :wq

Go to /etc/pam.d (cd /etc/pam.d)
Vi login
Add or change line to the /etc/pam.d/login file

session required pam_limits.so
session required /lib/security/pam_limits.so
to save Esc :wq

Very important Steps:
On secure linux has to be disabled:
Go to /etc/selinux(cd /etc/selinux)
Vi config Change or add
SELINUX=disabled
to save Esc :wq

The following packages(rpm) required for Enterprise Linux 5.0 on various cd’s :
Insert the cd
and mount the same
Go to cd /media/cdrom/Server (cd /media/cdrom/Server)
(carefully use –force and –nodeps)

rpm -Uvh binutils-2.17.50.0.6
rpm -Uvh compat-libstdc++-33-3.2.3
rpm -Uvh elfutils-libelf-0.125
rpm -Uvh elfutils-libelf-devel-0.125
rpm -Uvh elfutils-libelf-devel-static-0.125
rpm -Uvh gcc-4.1.2
rpm -Uvh gcc-c++-4.1.2
rpm -Uvh glibc-2.5-24
rpm -Uvh glibc-common-2.5
rpm -Uvh glibc-devel-2.5
rpm -Uvh glibc-headers-2.5
rpm -Uvh kernel-headers-2.6.18
rpm -Uvh ksh-20060214
rpm -Uvh libaio-0.3.106
rpm -Uvh libaio-devel-0.3.106
rpm -Uvh libgcc-4.1.2
rpm -Uvh libgomp-4.1.2
rpm -Uvh libstdc++-4.1.2
rpm -Uvh libstdc++-devel-4.1.2
rpm -Uvh make-3.81
rpm -Uvh sysstat-7.0.2
rpm -Uvh unixODBC-2.2.11
rpm -Uvh unixODBC-devel-2.2.11

eject or unmount

Linux Enterprise Server 11 - SUSE:

rpm -Uvh binutils-2.19
rpm -Uvh gcc-4.3
rpm -Uvh gcc-c++-4.3
rpm -Uvh glibc-2.9
rpm -Uvh glibc-devel-2.9
rpm -Uvh ksh-93t
rpm -Uvh libstdc++33-3.3.3
rpm -Uvh libstdc++43-4.3.3_20081022
rpm -Uvh libstdc++43-devel-4.3.3_20081022
rpm -Uvh libaio-0.3.104
rpm -Uvh libaio-devel-0.3.104
rpm -Uvh libgcc43-4.3.3_20081022
rpm -Uvh libstdc++-devel-4.3
rpm -Uvh make-3.81
rpm -Uvh sysstat-8.1.5

Create user and groups
Adding Groups

groupadd oinstall
groupadd dba
groupadd asmadmin
Adding user and assign the group:
useradd -g oinstall -G dba,oper,asmadmin oracle
Add password for Oracle user
passwd oracle

I would like to light on the "asmadmin" group is used for ASM.
Make directories in which the Oracle Binary to be installed:

mkdir -p /data1/app/oracle/product/11/db_1
chown -R oracle:oinstall /data1
chmod -R 777 /data1

Shutdown or
reboot the machine

Login as Oracle
Change/add user enviroment
Go to /home/oracle
Vi .bash_profile
Add the following:
ORACLE_HOSTNAME=machinename.domainname
ORACLE_BASE=/data1/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
Press Esc key :wq

Log out

Login as Oracle user

Run Install
Steps:
Set the Display first
export DISPLAY=hostname:0.0
Or
DISPAY=HOSTNAME:0.0
export
DISPLAY
Go setup Disk directory
Cd Disk1
./runInstaller

Rest follow the GUI provided by Oracle

Installation of Oracle eBusiness Suite R12.1.1

Sat, 08 Dec 2012 07:44:59 -0600

In continuation of my previous post How to install Red Hat Enterprise Linux for Oracle eBusiness Suite R12.1.1

Following updates are done in the document v1.1

Redhat Linux Installation
Pre-requisite/Preparation for Oracle eBusiness suite R12.1.1
Readiness with Oracle EBS R12 software from Media or eDelivery
Installation of Oracle eBusiness suite R12.1.1

Redhat Linux Installation for Oracle E-Business Suite R12 v1.1.pdf (Size: 2.38 MB / Downloads: 115)

How to install Red Hat Enterprise Linux for Oracle eBusiness Suite R12.1.1

Sun, 12 Aug 2012 15:28:38 -0500

Long back I was doing Redhat Linux installation for myself on server or on Laptop with VMware and noted down all steps in my personal word docs; just thought to rearrange them and will publish here for community folks so what you will be getting in this doc is a typical RHEL 5 (Red Hat Enterprise Linux 5) installation.
It should be a good start for you, particularly who want to create his own environment for practise and learning and off course you can advance this process as per your environment and requirements.

In this document step by step installation with screenshots is covered with pre-requisite required for Oracle eBusiness suite R12.1.1 as per My Oracle Support note ID 761564.1

Redhat Linux Installation for Oracle E-Business Suite R12.pdf (Size: 4.09 MB / Downloads: 169)

Oracle E-business Suite R-12 - Oracle Payable User Manual

Thu, 26 Jul 2012 15:44:08 -0500

Oracle Payable User Manual - Oracle E-business Suite R-12This document is to facilitate the user in day to day activity of entering invoices, making payments to Suppliers, creating bank accounts and for running the standard reports for the Accounts Payable module of Oracle Financials R12.

Oracle E-Business Suite - Oracle Payables User Manual.zip (Size: 7.58 MB / Downloads: 180)

Upgrade Oracle Applications from R12.1.1 to 12.1.2

Sat, 16 Jun 2012 08:44:59 -0500

How to upgrade Oracle Applications from R12.1.1 to 12.1.2

Download step by step guide from here

Upgrade Oracle Applications from R12.1.1 to 12.1.2 by Abdul Rehman.pdf (Size: 1.18 MB / Downloads: 155)

A Journey from Oracle E-Business Suite R12.1 to R12.2

Thu, 01 Dec 2011 06:15:56 -0600

What’s coming in the next major version of Oracle E-Business Suite 12.2?
I will try to analyze architectural overview of the latest updates, installation and upgrade options, new configuration options, and new tools for hot-cloning and automated “lights out” cloning in R-12.2
Oracle E-Business Suite 12.1 Architecture

Oracle E-Business Suite 12.2 Architecture
Release 12.2 will replace Oracle Containers for Java (OC4J) 10g with WebLogic Server 11g
Release 12.2 Database tier will run RDBMS 11gR2 to support online patching

There will be number of updates coming in release R12.2, from a technology stack perspective, EBS 12.2 will be notable for two things:
1-Replacing Oracle Containers for Java (OC4J) 10g with WebLogic Server 11g
EBS 12.2 will use WebLogic Server from Fusion Middleware 11g in place of OC4J 10g as part of the release’s internal technology stack. Other additional new Fusion Middleware 11g components used will include WebLogic JSP and UIX 11g
2-Online Patching support via 11gR2 Edition-Based Redefinition
EBS 12.2 will use the 11gR2 Database’s Edition-Based Redefinition features to provide support for Online Patching. Edition-Based Redefinition is really exciting new technology. From the 11gR2 Application Developer’s Guide:
“Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.
“To upgrade an application while it is in use, you copy the database objects that comprise the application and redefine the copied objects in isolation. Your changes do not affect users of the application—they continue to run the unchanged application. When you are sure that your changes are correct, you make the upgraded application available to all users.”
It is not released yet but It will include significant changes to the Application Server architecture, It will use RDBMS Version 11gR2 or higher, It will change Patching, Cloning, the User Experience

Continue reading with the article on http://oraerp.com/blog/a-journey-from-or...-to-r12-2/

Oracle e business suite, Generic Loader - FNDLOAD

Thu, 11 Aug 2011 16:29:57 -0500

Abstract:
We will examine FNDLOAD configuration management process in Oracle E-Business Suite. We will briefly examine concepts for configuration,
customization. This note will describe how to use the FNDLOAD and java XMLImporter and XDOLoader utilities. Along with example commands and sample unix scripts, we will review how to download and upload Oracle Application data.

Data Synchronization?

Data Synchronization is a process in which some setup data would be synchronized, and this would be more important when you are working in Oracle application development/implementation project. The equally important that ATG data Migration takes place necessary to synchronize the data across databases instance during :

· Installations (New descriptive flex field creations etc)

· Upgrades (Apps upgrade etc.)

· Maintenance (Value set changes etc.
FNDLOAD -- The FNDLOAD utility is documented in Oracle Applications 11.5.7, 11.5.8, 11.5.9 System Administration Guides, Appendix C. Starting with 11.5.10, the documentation has been expanded in the System Administration Guide – Configuration manual, Appendix B. The documentation for Release 12 has 3 new pages for Folders Configuration File. Metalink notes are useful when you encounter an error or are not sure of the correct syntax or format for a specific use of FNDLOAD. Other good sources of documentation are Oracle blogs which can easily be found by entering the FNDLOAD command or error in google.

“FNDLOAD is a Generic Loader” - FNDLOAD can be used to download application data from an Oracle Application instance into editable text file(.ldt file). The data, in the FNDLOAD .ldt file can then be uploaded into another Oracle Application instance. This .ldt file contains not only the
actual data representing the object(s) being downloaded, but it also contains metadata about the structure of that data.
The following diagram illustrates how FNDLOAD downloads data from an Oracle Application database according to a configuration (lct) file, and converts the data into a data file (ldt file) for subsequent uploading to another Application database.

What can be done?

These are the extensive list which can be done through FNDLOAD
· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions/Personalizations
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Alerts
· Concurrent Manager Schedules
[/font]The FNDLOAD: Concurrent Program – FNDLOAD can be executed as a concurrent program.

FNDLOAD
operates in one of two modes:
Download or Upload
In the download mode, data is downloaded from the database to a text file.
In the upload mode, data is uploaded from a text file to the database.
In both downloading and uploading, the structure of the data involved is described by the configuration file (lct file) and also the access methods to use to copy the data into or out of the database file. The same lct file is used for both uploading and downloading. Data structures
supported by the loader include master-detail relationships and foreign key reference relationships.
The FNDLOAD executable can be found in $FND_TOP/bin and associated lct files are located in $FND_TOP/admin/import/ or $FND_TOP/patch/115/import for the most current version.

FNDLOAD can be executed as a Concurrent Program or as a UNIX command line utility with the following format and parameters, as documented in the Oracle Application System Administrator’s Guide - Configuration:
FNDLOAD apps/pwd 0 Y mode configfile datafile entity [parameter....]
Where:
Apps schema / password
< 0 Y > Concurrent Program flags mode UPLOAD
or DOWNLOAD
Configuration lct file to use.
See the FNDLOAD configuration table below for names of the lct files by seed data types.
Name of ldt data file written out
when the FNDLOAD runs. This file is then used in an FNDLOAD upload to load the downloaded data into another application instance.
Entities to upload or download.
Specify a “-” to upload all entities on uploads.
<[param]> Zero or more additional parameters used to provide bind values in the access SQL. Each parameter is in the form NAME=Value (Look at the specific .lct file being used for more details for these parameters.)

Some advantages when using FNDLOAD

1. Because downloaded data is stored in a text file, version administration is possible
2. There is nothing to worry to go to purchase because Investment = 0$
3. No learning curve. this is relief for developer and dba
4. Fully supported and recommended by Oracle
5. Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
6. Pin-point when something happened and where (database) easily
7. Your AOL data migration process is now simplified and streamlined goal attained

Some disadvantages when using FNDLOAD

1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. UPLOAD_MODE=REPLACE only for menus
3. No validation against migrating database/instance sensitive data

[font=Arial]Some sample examples:
MENU:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct menu.ldt MENU MENU_NAME=BOM_NAV

FUNCTION:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct function.ldt FUNCTION FUNCTION_NAME=INV_INVTTMTX

FORM:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct form.ldt FORM FORM_NAME=${shortname}

PERSONALIZATION:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct formpersonalization.ldt FND_FORM_CUSTOM_RULES function_name=${shortname}

PRINTER:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct printer.ldt STYLE PRINTER_STYLE_NAME=${shortname}

CONCURRENT:
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct concprog.ldt PROGRAM
CONCURRENT_PROGRAM_NAME=${shortname}

LOOKUP:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct lookup.ldt
FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND"
LOOKUP_TYPE=${shortname}

RESPONSIBILITY:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/admin/import/afscursp.lct responsible.ldt
FND_RESPONSIBILITY RESP_KEY="${respkey}"

DESCFLEX:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct ${shortname}_flex.ldt
DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME=${shortname}

KEYFLEX:
FNDLOAD apps/$PASSWD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct keyflex.ldt KEY_FLEX
P_LEVEL='COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:
CVR_ALL:SEG_ALL'
APPLICATION_SHORT_NAME=${appshortname}
ID_FLEX_CODE=MCAT
P_STRUCTURE_CODE=${shortname}

VALUE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct valset.ldt VALUE_SET
FLEX_VALUE_SET_NAME=${shortname}

PROFILE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct profile.ldt PROFILE
PROFILE_NAME=${shortname}

MESSAGE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct message.ldt
FND_NEW_MESSAGES MESSAGE_NAME=${shortname}

REQUEST GROUP:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct reqgrp.ldt
REQUEST_GROUP REQUEST_GROUP_NAME=${shortname}

REQUEST SET:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct rqstset.ldt REQ_SET
APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME=${shortname}

WEBADI:
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/admin/import/bnelay.lct XX_C_O_F_T.ldt BNE_LAYOUTS
LAYOUT_ASN="PER" LAYOUT_CODE="XX_C_O_F_T"

Blob:
With Release 12.1.1, FNDLOAD supports BLOB data (upload / download ) to better serve content-rich applications.
FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ... ]

Several different errors can occur when using FNDLOAD, so use attentiveness to review results and logs when using this utility. The FNDLOAD program can fail when the ldt file used to download and the corresponding lct file used to upload are not compatible.
Other Oracle Utilities – Similar to FNDLOAD, other Oracle Development tools, like the XML Publisher and JDeveloper, also have Oracle Application utilities that can be used to download and/or upload application data.
These tools are supported by the java XML and XDO Loader utilities, which can be used to migrate additional types of Application
entities among your instances. Finally, AD administration tasks are sometimes needed to support post-upload requirements for some entities.
Developers can use the XML Publisher to create XML reports for Oracle Applications. In the Apps, navigate to the XML Publisher
Administrator responsibility, then to Templates and Data Definition web pages. Use these web pages to register custom XML reports and upload your report's physical template file from your client, or you can use two command line utilities to automate moving XML report registration and the report’s physical files among instances. FNDLOAD will download and upload XML report data definitions and template metadata. The XDOLoader utility is a Java-based command line program to download and/or upload the physical template (RTF, PDF,
XSL-FO, XML, and XSD) files from/to the XML Publisher database tables. The following examples show the FNDLOAD and XDO Loader commands to download/upload XML report data:
Data definition and template registration:
FNDLOAD apps/apps O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct tmpl.ldt
XDO_DS_DEFINITIONS
APPLICATION_SHORT_NAME=custom application name
DATA_SOURCE_CODE=code
name
Physical template files:
java
oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -
DB_PASSWORD xxxx -JDBC_CONNECTION
'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1561))(CONNECT_DATA
=(SERVICE_NAME=SID)))'
-LOB_TYPE TEMPLATE -APPS_SHORT_NAME XXLM -LANGUAGE en
-lct_FILE
$XDO_TOP/patch/115/import/xdotmpl.lct
Developers can use JDeveloper to modify existing OA Framework pages or create new custom web pages. The web pages can then be downloaded and/or uploaded from one Oracle Application instance to another using the Java Exporter and/or Importer utility. OA Framework pages also have file system class and jar files which can be migrated by zipping your custom directories, using ftp to copy these files, and unzipping them into your other instance's $APPL_TOP before running the XML Importer.
The following is a sample Java XML Importer command to load xml pages:
XML PAGES:
java
oracle.jrad.tools.xml.importer.XMLImporter
$XXLM_TOP/oracle/apps/xxlm/${shortname}/webui/
-username apps -password
$password -rootdir
$XXLM_TOP -DBCONNECTION "hostname:dbportid"
-jdk13 -
mmddir $OA_HTML/jrad
Once uploaded and prior to being used, some entities require AD administration tasks to be executed. For example, uploading messages requires the maintenance step of ‘Generate Message Files’. Before AD administration can be used non-interactively, a defaults file must be created interactively. eg: adadmin defaultsfile=$APPL_TOP/admin/testdb1/adadmindef.txt
Once created, this defaults file is used in the non-interactive call to adadmin:
adadmin interactive=n defaultsfile=$APPL_TOP/admin/testdb1/adadmindef.txt
For details, see “Oracle Applications Maintenance Procedures.”
Utility download script – Running FNDLOAD, and other similar utilities, from a UNIX script allows you to easily integrate the use of the download/upload utilities for your Oracle Applications data, e.g., registration of forms/reports/value sets, etc., for code promotion with the configuration management and promotion of your UNIX file system objects, e.g, your forms (fmb), reports (rdf), etc.
Any execution of FNDLOAD assumes the Oracle Application environment has previously been set.
The code segment below is one example of how to call FNDLOAD within a korn shell script.
##
## assumes APPS environment is properly set
## and other shell variables previously defined
##
##
## Prompt for type and parameter value
##
echo "Enter a category
(MENU,FUNCTION,PERSONALIZATION,PRINTER,CONCURRENT,LOOKUP,RESPONSIBILITY,FORM, DESCFLEX, KEYFLEX, VALUE, PROFILE, REQGROUP, REQSET,MESSAGE,XML,XDO,IMPORTER):"
read category
if [ -z
"$category" ] ; then
exit
else
typeset -u category
echo "Using
category" $category | tee -a ${LOGFILE}
fi
##
## determine appropriate user input prompt
case $category in
'REQGROUP')
parm_prompt="Please
enter a request group."
;;
'RESPONSIBILITY')
parm_prompt="Please enter a responsibility key (include _ underscore for spaces)." ;;*)
parm_prompt="Entera short name."
esac
## Get input from user
echo $parm_prompt
read shortname
if [ -z
"$shortname" ] ; then
echo $parm_prompt
exit
fi
respkey=$shortname
## log files from
FNDLOAD execution are not ‘well named’
## this is one attempt to identify a new file
## Get initial list of
*log files
ls *log >
${WORK_FILE1} 2>/dev/null
##
## execute appropriate form of FNDLOAD
##
case $category in
'MENU')
FNDLOAD apps/$PASSWD O
Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct
${shortname}_menu.ldt
MENU MENU_NAME=${shortname}
;;
'PERSONALIZATION')
FNDLOAD apps/$PASSWD O
Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
${shortname}_formpersonalization.ldt
FND_FORM_CUSTOM_RULES
function_name=${shortname}
;;
'XML')
FNDLOAD apps/$PASSWD O
Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
${shortname}_tmpl.ldt
XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXLM
DATA_SOURCE_CODE=${shortname}
;;
'XDO')
java
oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -
DB_PASSWORD $PASSWD
-JDBC_CONNECTION
'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=$EMACH)(PORT=$EPORT))(CONNECT_DATA
=(SERVICE_NAME=$TWO_TASK)))'
-LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME XXLM
-LOB_CODE ${shortname}
-LANGUAGE en -TERRITORY US -XDO_FILE_TYPE RTF -
FILE_CONTENT_TYPE
'application/rtf' -FILE_NAME ${shortname}.rtf -NLS_LANG
ENGLISH_UNITED_STATES.WE8ISO8859P1
$XDO_TOP/patch/115/import/xdotmpl.lct
;;
##
## additional FNDLOAD command lines for each of the different
## categories of applications entities
##
*)
echo
echo You entered an incorrect category. Valid categories are:
echo MENU, FUNCTION, PRINTER, CONCURRENT, LOOKUP, RESPONSIBILITY DESCFLEX, KEYFLEX, VALUE, PROFILE, REQGROUP, REQSET, XML, XDO;;
esac
sleep 1
## Additional work to attempt to identify the most recently
## created log file
##
## get new list of log
files
ls *log >
${WORK_FILE2}
## find name of newly
created log file (from concurrent mgr process)
FND_LOG=`diff
${WORK_FILE1} ${WORK_FILE2} | grep \> | cut -c3-`
echo "Logfile
is:" ${FND_LOG} | tee -a ${LOGFILE}
## look for obvious
success or failure tokens
grep
"successfully" ${FND_LOG} | tee -a ${LOGFILE}
grep "ORA-"
${FND_LOG} | tee -a ${LOGFILE}

This code interactively prompts the user for the type and name of the entity that will be downloaded. It also uses the name (‘shortname’ parameter) to help label the created .ldt file along with its entity type. This naming convention helps to keep track of which ldt files contain which entities. An upload script for these files would look very similar. The script could be extended or used in conjunction with other scripts to implement a simple configuration process.

References:
Note: 274667.1 FNDLOAD Commands to Download Different Seed Data Types.
Note: 287417.1 Parameters Of Different Configuration Files To Download And Upload Seed Data Types.
Note: 256573.1 How To Download/Upload Descriptive Flexfield With Name $SRS$
EBS Release 11.5.10.2+ : Oracle Applications System Administrator's Guide - Configuration
EBS Release 12.0.4+ : Oracle Applications System Administrator's Guide - Configuration
EBS Release 12.1.3 : Oracle Applications System Administrator's Guide - Configuration
Customization Survival Guide: How to Use E-Business Utilities to Migrate Your Custom Code, Brad Simmons and Donna Campbell,Los Alamos
National Laboratory document
Tips About FNDLOAD [ID 735338.1]
Is It Possible To Use FNDLOAD To Migrate Configurations Or Data To Another Instance? [ID 1316916.1]
How To Use XDOLoader to Manage, Download and Upload Files? [ID 469585.1]

Forms Personalization in Oracle Apps R-12 - Zoom Functionality

Wed, 15 Jun 2011 11:50:16 -0500

[font=Verdana]
Personalization form automatically queries the function, form and pre-defined personalization rules, if any exists for the specific form. For example, the form name is INVTOMAI i.e. Move Order form on which the personalization form is opened.

Rules
Rules administer the personalization needs to be implemented on the form. Each rule contains a sequence number, description and level (Rules may now be specified as acting either at the Function level (the default) or at the Form level). The rule can be activated or de-activated using the “Enabled” checkbox. The rule can be deleted when no longer needed.
Defining rules doesn’t identify, when the rule should get evaluated or applied. For each rule, there should be conditions attached, which power the execution of the rule.
Conditions
Conditions decide the event the rule to be executed. Each condition mainly contains three sections i.e. Trigger Event, Trigger Object and Condition.
Context
Context manages to whom the personalization should apply. This is similar to the concept of using profile options in Oracle Applications. The various levels are Site, Responsibility, Industry and User. During runtime, the values provided in the context are evaluated and personalization rules will be applied. Usage of context is very vital in implementing the personalization to prevent the inappropriate users accessing these customizations of the form.

Actions
Actions decide the exact operation to be performed when the event occurs and the condition evaluates to true during the runtime.
Each Action consists of one of the following:

setting a Property
displaying a Message
executing a Builtin
enabling a Menu/Special entry

Property

The action type “Property” is used to set the properties of the objects. The various objects include “Item, Window, Block, Global Variable etc”.

Property Type

Select By Text button used to select an object based on text appearing on the screen at the point in time, the Personalization form is invoked, including any changes that current rules might have performed. Target Object can be selected from the list.
Target Object, either name defined in the form or variable name should be entered depending on the object type selected.
Property Name is the property to be changed.
Value is the new desired value for the property.
The current value of the property will be displayed when clicked on the Get Value button.
SQL functions and operators can be used to assign value. Any value started with “=” operator will be evaluated at runtime otherwise the value is treated as is entered in the value field.Message

The action type “Message” is used to display custom messages during runtime. Message Type and Message Text should be entered after selecting the action type as “Message”. The available message types are “Show, Hint, Error, Debug and Warn”.

Message Type

Builtin

The action type “Builtin” is used to execute the form and AOL functions. Depending on the builtin type selected, the arguments should be entered.

Builtin Type

Add Parameter… list of Values displays currently used parameters. Applies to the builtin ‘Launch a Function’ only.Menu

The action type “Menu” is used to activate the available special menus on the Tools menu. Oracle Applications provide 45 special menus under Tools menu which can be used by customers based on their requirements. The menus are arranged in 3 sets of 15 each under the Tools, Reports and Actions pull-down menus. If you select a menu that the base form is already using, your functionality will override the form's functionality.
Select the Menu Entry which is not used by the form.
Menu Label is the prompt which appears to the users when Tools menu is invoked.
Icon name is the .ico file name.
Enabled in Block(s) specifies the blocks for which the special menu should be activated.

Menu Type

A separator can be created above the activated special menu by selecting the “Render line before menu” checkbox.
This property can be used only in WHEN-NEW-FORM-INSTANCE event.[size=10]