How to download OUM 5.4 & 6.3(Oracle Unified Method) as AIM(Application Implementation Methodology) from where and how to use?

1.Clikc on the link bellow
  http://www.oracle.com/partners/en/knowledge-zone/applications/oracle-unified-method-359405.html

2.Click Implement Tab under Oracle Unified Method Knowledge Zone

" Note:
The OUM download file is an encrypted zip file, which requires a password. Please send an email opn-edu_ww@oracle.com to request the password to enable access to the encrypted OUM file.
Winzip 10.0 or higher is recommended for unzipping the OUM download file."

Click on the link bellow:-
Oracle Unified Method 5.4 

3.Download the zip file from the link
4.Send the email to opn-edu_ww@oracle.com from your corporate email
5.Unzip the zip file with password received via email.
6. Install the application.

Now It is ready for use(Navigate from Window Start menu>Programs> Oracle Methods>Oracle OUM_E(Oracle Unified Method )5.4.0

------------------------------------------------------------------------------------------------------

For Download OUM(AIM) 6.3.0 version

1. Go to the OPN Portal at partner.oracle.com.
2. Select "Sign In / Register for Account".
3. Sign In.
4. From the Product Resources section, select "Applications".
5. From the Applications page, locate and select the "Oracle Unified Method" link.
6. From the Oracle Unified Method Knowledge Zone, locate the "I want to:" section.
7. From the I want to: section, locate and select "Implement Solutions".
8. From the Implement Solution page, locate the "Best Practices" section.
9. From the Best Practices section, locate and select the "Download Oracle Unified Method (OUM)" link.

How to change APPS login page logo(Oracle Logo) in R12.1.3

Navigate to  $OA_MEDIA top (Ex:- /u01/appl/apps_st/comn/java/classes/oracle/apps/media)

Replace the gif file(FNDSSCORP.gif) with your company logo in $OA_MEDIA folder.

Bounce the Apache
Clear all cookies in client machin
Test the senario.

APPS OPM(Oracle Process Manufacturing) Recipe Header Uploading through Script using API

Recipe Header Uploading can be done using the following steps:

1. First Create a staging table say "MJIL_RCP_HDR_UPL_TBL" as shown below.

CREATE TABLE MJIL_RCP_HDR_UPL_TBL
(
RECIPE_ID NUMBER(15),
RECIPE_DESCRIPTION VARCHAR2(70 BYTE),
RECIPE_NO VARCHAR2(32 BYTE),
RECIPE_VERSION NUMBER(5),
USER_ID NUMBER(15),
USER_NAME VARCHAR2(70 BYTE),
OWNER_ORGN_CODE VARCHAR2(4 BYTE),
CREATION_ORGN_CODE VARCHAR2(4 BYTE),
OWNER_ORGANIZATION_ID NUMBER,
CREATION_ORGANIZATION_ID NUMBER,
FORMULA_ID NUMBER(15),
FORMULA_NO VARCHAR2(32 BYTE),
FORMULA_VERS NUMBER,
ROUTING_ID NUMBER,
ROUTING_NO VARCHAR2(32 BYTE),
ROUTING_VERS NUMBER(5),
PROJECT_ID NUMBER(15),
RECIPE_STATUS VARCHAR2(30 BYTE),
PLANNED_PROCESS_LOSS NUMBER,
TEXT_CODE NUMBER(10),
DELETE_MARK NUMBER(5),
CONTIGUOUS_IND NUMBER,
ENHANCED_PI_IND VARCHAR2(1 BYTE),
RECIPE_TYPE NUMBER,
CREATION_DATE DATE,
CREATED_BY NUMBER(15),
LAST_UPDATED_BY NUMBER(15),
LAST_UPDATE_DATE DATE,
LAST_UPDATE_LOGIN NUMBER(15),
OWNER_ID NUMBER(15),
OWNER_LAB_TYPE VARCHAR2(4 BYTE),
CALCULATE_STEP_QUANTITY NUMBER(5),
FIXED_PROCESS_LOSS NUMBER,
FIXED_PROCESS_LOSS_UOM VARCHAR2(3 BYTE),
ATTRIBUTE_CATEGORY VARCHAR2(30 BYTE),
ATTRIBUTE1 VARCHAR2(240 BYTE),
ATTRIBUTE2 VARCHAR2(240 BYTE),
ATTRIBUTE3 VARCHAR2(240 BYTE),
ATTRIBUTE4 VARCHAR2(240 BYTE),
ATTRIBUTE5 VARCHAR2(240 BYTE),
ATTRIBUTE6 VARCHAR2(240 BYTE),
ATTRIBUTE7 VARCHAR2(240 BYTE),
ATTRIBUTE8 VARCHAR2(240 BYTE),
ATTRIBUTE9 VARCHAR2(240 BYTE),
ATTRIBUTE10 VARCHAR2(240 BYTE),
ATTRIBUTE11 VARCHAR2(240 BYTE),
ATTRIBUTE12 VARCHAR2(240 BYTE),
ATTRIBUTE13 VARCHAR2(240 BYTE),
ATTRIBUTE14 VARCHAR2(240 BYTE),
ATTRIBUTE15 VARCHAR2(240 BYTE),
ATTRIBUTE16 VARCHAR2(240 BYTE),
ATTRIBUTE17 VARCHAR2(240 BYTE),
ATTRIBUTE18 VARCHAR2(240 BYTE),
ATTRIBUTE19 VARCHAR2(240 BYTE),
ATTRIBUTE20 VARCHAR2(240 BYTE),
ATTRIBUTE21 VARCHAR2(240 BYTE),
ATTRIBUTE22 VARCHAR2(240 BYTE),
ATTRIBUTE23 VARCHAR2(240 BYTE),
ATTRIBUTE24 VARCHAR2(240 BYTE),
ATTRIBUTE25 VARCHAR2(240 BYTE),
ATTRIBUTE26 VARCHAR2(240 BYTE),
ATTRIBUTE27 VARCHAR2(240 BYTE),
ATTRIBUTE28 VARCHAR2(240 BYTE),
ATTRIBUTE29 VARCHAR2(240 BYTE),
ATTRIBUTE30 VARCHAR2(240 BYTE)
)


2. Next create a procedure using the script as shown below.

CREATE OR REPLACE PROCEDURE CONA_RECIPE_UPLOAD_PD (ERRBUF OUT VARCHAR2,RETCODE OUT NUMBER)
is
/******************************************************************************
NAME: APPS.CONA_RECIPE_UPLOAD_PD
PURPOSE: Recipe Header Uploading

REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 5/16/2011 1. Puspendu Das Created this procedure.

NOTES:

Automatically available Auto Replace Keywords:
Object Name: APPS.CONA_RECIPE_UPLOAD_PD
Sysdate: 5/16/2011
Date and Time: 5/16/2011, 1:22:42 PM, and 5/16/2011 1:22:42 PM

******************************************************************************/

mjil_rcp_hdr_tbl gmd_recipe_header.recipe_tbl;
mjil_rcp_hdr_flex_tbl gmd_recipe_header.recipe_flex;
X_status VARCHAR2(1);
X_msg_cnt NUMBER;
X_msg_dat VARCHAR2(1000);
X_row NUMBER := 1;
l_user_id number:= 1114;
l_responsibility_id number :=22883;
l_out_index NUMBER ;
l_responsibility_app_id number;
cursor c1 is
select * from mjil_rcp_hdr_upl_tbl;

BEGIN
FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_responsibility_id,l_responsibility_app_id);
for i in c1
loop
mjil_rcp_hdr_tbl(X_row).recipe_no := i.recipe_no;
mjil_rcp_hdr_tbl(X_row).recipe_version := i.recipe_version;
mjil_rcp_hdr_tbl(X_row).recipe_description := i.recipe_description;
mjil_rcp_hdr_tbl(X_row).RECIPE_STATUS := i.RECIPE_STATUS;
mjil_rcp_hdr_tbl(X_row).RECIPE_TYPE := i.RECIPE_TYPE;
mjil_rcp_hdr_tbl(X_row).formula_no := i.formula_no;
mjil_rcp_hdr_tbl(X_row).formula_vers := i.formula_vers;
mjil_rcp_hdr_tbl(X_row).routing_no := i.routing_no;
mjil_rcp_hdr_tbl(X_row).routing_vers := i.routing_vers;

mjil_rcp_hdr_tbl(X_row).delete_mark := i.delete_mark;
mjil_rcp_hdr_tbl(X_row).creation_date := SYSDATE;
mjil_rcp_hdr_tbl(X_row).created_by := i.created_by;
mjil_rcp_hdr_tbl(X_row).last_updated_by := i.last_updated_by;
mjil_rcp_hdr_tbl(X_row).last_update_date := SYSDATE;
mjil_rcp_hdr_tbl(X_row).last_update_login := 1114;

mjil_rcp_hdr_tbl(X_row).user_name := i.user_name;
mjil_rcp_hdr_tbl(X_row).owner_orgn_code := i.owner_orgn_code;
mjil_rcp_hdr_tbl(X_row).OWNER_ORGANIZATION_ID := i.owner_organization_id;
mjil_rcp_hdr_tbl(X_row).creation_orgn_code := i.creation_orgn_code;
mjil_rcp_hdr_tbl(X_row).owner_id := i.owner_id;

mjil_rcp_hdr_flex_tbl(X_row).attribute1 := 'FLEX1';

X_row := X_row+1;

end loop;
gmd_recipe_header.create_recipe_header(p_api_version => 1,
p_init_msg_list => FND_API.G_TRUE ,
p_commit => FND_API.G_TRUE,
p_called_from_forms => 'NO',
x_return_status => X_status,
x_msg_count => X_msg_cnt,
x_msg_data => X_msg_dat,
p_recipe_header_tbl => mjil_rcp_hdr_tbl,
p_recipe_header_flex => mjil_rcp_hdr_flex_tbl);

dbms_output.put_line('Return status - '||X_status);
dbms_output.put_line('Message count - '||X_msg_cnt);
for i IN 1 .. X_msg_cnt
LOOP
FND_MSG_PUB.get(p_msg_index => i,
p_encoded => 'F',
p_data => X_msg_dat,
P_MSG_INDEX_OUT => l_out_index);
DBMS_OUTPUT.PUT_LINE('Message Text '||X_msg_dat);
END LOOP;

exception
when others then
dbms_output.put_line('Return status - '||X_status);
dbms_output.put_line('Message count - '||X_msg_cnt);

for i IN 1 .. X_msg_cnt
LOOP
FND_MSG_PUB.get(p_msg_index => i,
p_encoded => 'F',
p_data => X_msg_dat,
P_MSG_INDEX_OUT => l_out_index);
DBMS_OUTPUT.PUT_LINE('Message Text '||X_msg_dat);
END LOOP;

END;
/

3. Finally register the procedure and run it.

APPS OPM(Oracle Process Manufacturing) Formula Uploading through Script using API

Formula Upload can be done using the following steps:

1. Create a staging table say "MJIL_FORMULA_UPLOAD" whose structure is given below.

CREATE TABLE MJIL_FORMULA_UPLOAD
(
RECORD_TYPE VARCHAR2(1 BYTE),
FORMULA_NO VARCHAR2(32 BYTE),
FORMULA_VERS NUMBER,
FORMULA_TYPE NUMBER,
FORMULA_DESC1 VARCHAR2(70 BYTE),
FORMULA_DESC2 VARCHAR2(70 BYTE),
FORMULA_CLASS VARCHAR2(32 BYTE),
FMCONTROL_CLASS VARCHAR2(32 BYTE),
INACTIVE_IND NUMBER,
OWNER_ORGANIZATION_ID NUMBER,
TOTAL_INPUT_QTY NUMBER,
TOTAL_OUTPUT_QTY NUMBER,
YIELD_UOM VARCHAR2(3 BYTE),
FORMULA_STATUS VARCHAR2(30 BYTE),
OWNER_ID NUMBER(15),
FORMULA_ID NUMBER,
FORMULALINE_ID NUMBER,
LINE_TYPE NUMBER,
LINE_NO NUMBER,
ITEM_NO VARCHAR2(2000 BYTE),
INVENTORY_ITEM_ID NUMBER,
REVISION VARCHAR2(3 BYTE),
QTY NUMBER,
DETAIL_UOM VARCHAR2(3 BYTE),
MASTER_FORMULA_ID NUMBER,
RELEASE_TYPE NUMBER,
SCRAP_FACTOR NUMBER,
SCALE_TYPE_HDR NUMBER,
SCALE_TYPE_DTL NUMBER,
COST_ALLOC NUMBER,
PHANTOM_TYPE NUMBER,
REWORK_TYPE NUMBER,
BUFFER_IND NUMBER,
BY_PRODUCT_TYPE VARCHAR2(1 BYTE),
INGREDIENT_END_DATE DATE,
ATTRIBUTE1 VARCHAR2(240 BYTE),
ATTRIBUTE2 VARCHAR2(240 BYTE),
ATTRIBUTE3 VARCHAR2(240 BYTE),
ATTRIBUTE4 VARCHAR2(240 BYTE),
ATTRIBUTE5 VARCHAR2(240 BYTE),
ATTRIBUTE6 VARCHAR2(240 BYTE),
ATTRIBUTE7 VARCHAR2(240 BYTE),
ATTRIBUTE8 VARCHAR2(240 BYTE),
ATTRIBUTE9 VARCHAR2(240 BYTE),
ATTRIBUTE10 VARCHAR2(240 BYTE),
ATTRIBUTE11 VARCHAR2(240 BYTE),
ATTRIBUTE12 VARCHAR2(240 BYTE),
ATTRIBUTE13 VARCHAR2(240 BYTE),
ATTRIBUTE14 VARCHAR2(240 BYTE),
ATTRIBUTE15 VARCHAR2(240 BYTE),
ATTRIBUTE16 VARCHAR2(240 BYTE),
ATTRIBUTE17 VARCHAR2(240 BYTE),
ATTRIBUTE18 VARCHAR2(240 BYTE),
ATTRIBUTE19 VARCHAR2(240 BYTE),
ATTRIBUTE20 VARCHAR2(240 BYTE),
ATTRIBUTE21 VARCHAR2(240 BYTE),
ATTRIBUTE22 VARCHAR2(240 BYTE),
ATTRIBUTE23 VARCHAR2(240 BYTE),
ATTRIBUTE24 VARCHAR2(240 BYTE),
ATTRIBUTE25 VARCHAR2(240 BYTE),
ATTRIBUTE26 VARCHAR2(240 BYTE),
ATTRIBUTE27 VARCHAR2(240 BYTE),
ATTRIBUTE28 VARCHAR2(240 BYTE),
ATTRIBUTE29 VARCHAR2(240 BYTE),
ATTRIBUTE30 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE1 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE2 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE3 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE4 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE5 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE6 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE7 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE8 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE9 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE10 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE11 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE12 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE13 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE14 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE15 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE16 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE17 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE18 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE19 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE20 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE21 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE22 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE23 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE24 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE25 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE26 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE27 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE28 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE29 VARCHAR2(240 BYTE),
DTL_ATTRIBUTE30 VARCHAR2(240 BYTE),
ATTRIBUTE_CATEGORY VARCHAR2(30 BYTE),
DTL_ATTRIBUTE_CATEGORY VARCHAR2(30 BYTE),
TPFORMULA_ID NUMBER,
IAFORMULA_ID NUMBER,
SCALE_MULTIPLE NUMBER,
CONTRIBUTE_YIELD_IND VARCHAR2(1 BYTE),
SCALE_UOM VARCHAR2(4 BYTE),
CONTRIBUTE_STEP_QTY_IND VARCHAR2(1 BYTE),
SCALE_ROUNDING_VARIANCE NUMBER,
ROUNDING_DIRECTION NUMBER,
TEXT_CODE_HDR NUMBER,
TEXT_CODE_DTL NUMBER,
USER_ID NUMBER,
CREATION_DATE DATE,
CREATED_BY NUMBER(15),
LAST_UPDATED_BY NUMBER(15),
LAST_UPDATE_DATE DATE,
LAST_UPDATE_LOGIN NUMBER(15),
USER_NAME VARCHAR2(100 BYTE),
DELETE_MARK NUMBER,
AUTO_PRODUCT_CALC VARCHAR2(1 BYTE),
PROD_PERCENT NUMBER
)

2. Next create a procedure similar to the one given below.

CREATE OR REPLACE PROCEDURE APPS.CONA_FML_UPLOAD_PD (ERRBUF OUT VARCHAR2,RETCODE OUT NUMBER)
is
/******************************************************************************
NAME: CONA_FML_UPLOAD_PD
PURPOSE: Formula Uploading

REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 5/16/2011 1. Puspendu Das Created this procedure.

NOTES:

Automatically available Auto Replace Keywords:
Object Name: CONA_FML_UPLOAD_PD
Sysdate: 5/16/2011
Date and Time: 5/16/2011, 1:22:42 PM, and 5/16/2011 1:22:42 PM

******************************************************************************/
mjil_fml_tabtype apps.gmd_formula_pub.formula_insert_hdr_tbl_type;
cursor c1 is
select * from MJIL_FORMULA_UPLOAD where formula_no not in(select formula_no from fm_form_mst);
cnt number;
l_return_status varchar2(1);
l_msg_count number;
l_msg_data varchar2(1000);
l_out_index NUMBER :=0;
l_user_id number:= 1114;
l_responsibility_id number :=22883;
l_responsibility_app_id number;
begin
FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_responsibility_id,l_responsibility_app_id);
cnt := 0;
for i in c1
loop
cnt := cnt+1;
mjil_fml_tabtype(cnt).record_type := i.record_type;
mjil_fml_tabtype(cnt).FORMULA_NO := trim(i.FORMULA_NO);
mjil_fml_tabtype(cnt).FORMULA_VERS := i.formula_vers;
mjil_fml_tabtype(cnt).formula_type := i.formula_type;
mjil_fml_tabtype(cnt).formula_desc1 := i.formula_desc1;
mjil_fml_tabtype(cnt).formula_desc2 := i.formula_desc2;
mjil_fml_tabtype(cnt).inactive_ind := i.inactive_ind;
mjil_fml_tabtype(cnt).OWNER_ORGANIZATION_ID := i.owner_organization_id;
mjil_fml_tabtype(cnt).total_input_qty := i.total_input_qty;
mjil_fml_tabtype(cnt).total_output_qty := i.total_output_qty;
mjil_fml_tabtype(cnt).formula_status := i.formula_status;
mjil_fml_tabtype(cnt).line_no := i.line_no;
mjil_fml_tabtype(cnt).line_type := i.line_type;
mjil_fml_tabtype(cnt).item_no := i.item_no;
mjil_fml_tabtype(cnt).qty := i.qty;
mjil_fml_tabtype(cnt).detail_uom := i.detail_uom;
mjil_fml_tabtype(cnt).release_type := i.release_Type;
mjil_fml_tabtype(cnt).scrap_factor := i.scrap_factor;
mjil_fml_tabtype(cnt).scale_type_hdr := i.scale_type_hdr;
mjil_fml_tabtype(cnt).scale_type_dtl := i.scale_type_dtl;
mjil_fml_tabtype(cnt).cost_alloc := i.cost_alloc ;
mjil_fml_tabtype(cnt).phantom_type := i.phantom_type;
mjil_fml_tabtype(cnt).rework_type := i.rework_type ;
mjil_fml_tabtype(cnt).buffer_ind := i.buffer_ind ;
mjil_fml_tabtype(cnt).contribute_yield_ind := i.contribute_yield_ind ;
mjil_fml_tabtype(cnt).contribute_step_qty_ind := i.contribute_step_qty_ind ;
mjil_fml_tabtype(cnt).delete_mark := i.delete_mark;
end loop;
GMD_FORMULA_PUB.Insert_Formula
( p_api_version => 1
, p_init_msg_list => FND_API.G_TRUE
, p_commit => FND_API.G_TRUE
, p_called_from_forms => 'NO'
, x_return_status => l_return_status
, x_msg_count =>l_msg_count
, x_msg_data =>l_msg_data
, p_formula_header_tbl => mjil_fml_tabtype);
dbms_output.put_line('Return status - '||l_return_status);
dbms_output.put_line('Message count - '||l_msg_count);
for i IN 1 .. l_msg_count
LOOP
FND_MSG_PUB.get(p_msg_index => i,
p_encoded => 'F',
p_data => l_msg_data,
P_MSG_INDEX_OUT => l_out_index);
DBMS_OUTPUT.PUT_LINE('Message Text '||l_msg_data);
END LOOP;
exception
when others then
dbms_output.put_line('Return status - '||l_return_status);
dbms_output.put_line('Message count - '||l_msg_count);

for i IN 1 .. l_msg_count
LOOP
FND_MSG_PUB.get(p_msg_index => i,
p_encoded => 'F',
p_data => l_msg_data,
P_MSG_INDEX_OUT => l_out_index);
DBMS_OUTPUT.PUT_LINE('Message Text '||l_msg_data);
END LOOP;

END;

3. Register and run the procedure in Oracle Apps.

Oracle APPS Miscellaneous receipt Transaction / openning stock upload through interface sample script

   We need to create a customer table :-

CREATE TABLE XX_STOCK
     (  sl_no                       number,
        organization_name   varchar2(30),
        organization_id        number,
        item                         varchar2(20),
        item_id                    number,
        uom                         varchar2(3),
        subinventory            varchar2(10),
        quantity                   number,
        lot                           varchar2(30),
        txn_date                  date,
        ucost                       number
     );

We need to populate customer table with proper data. Then we need to insert all the data in interface tables. If items are lot enabled we need also to populate lot interface data.

INSERT INTO MTL_TRANSACTIONS_INTERFACE 
   ( process_flag                   ,
     validation_required         ,  
     transaction_mode           , 
     lock_flag                        ,     
     last_update_date            ,     
     last_updated_by             ,  
     creation_date                 ,        
     created_by                     ,
     inventory_item_id           ,    
     organization_id               ,  
     transaction_quantity        , 
     primary_quantity             ,           
     transaction_uom             , 
     transaction_date             ,     
     subinventory_code         ,
     transaction_action_id      ,
     transaction_type_id        ,  
     transaction_interface_id  ,
     source_code                  ,
     source_line_id                ,
     source_header_id           ,
     distribution_account_id   ,
     transaction_cost      )
   select
     1                          ,
     1                          ,
     3                          ,
     2                          ,
     txn_date               ,
     1114                    ,
     txn_date               ,
     1114                    ,
     item_id                 ,
     organization_id     ,
     quantity                ,
     quantity                ,
     UOM                   ,
     txn_date               ,
     subinventory         ,
     27                        ,
     42                        ,
     sl_no                    ,
     'Stock_upload'     ,
     sl_no                    ,
     -1                         ,
     3723                    ,
     ucost
   FROM XX_STOCK;

   INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE           ( TRANSACTION_INTERFACE_ID                   ,
      LAST_UPDATE_DATE                                  ,
      LAST_UPDATED_BY                                    ,
      CREATION_DATE                                         ,
      CREATED_BY                                                ,
      LOT_NUMBER                                               ,
      TRANSACTION_QUANTITY                       ,
      PROCESS_FLAG                                            ,
      SOURCE_CODE                                            ,
      SOURCE_LINE_ID                          
    )
   SELECT
      sl_no                                  ,
      txn_date                             ,
      1114                                  ,
      txn_date                             ,
      1114                                  ,
      lot                                      ,
      quantity                              ,
      1                                        , 
      'Stock_upload'                   ,
      sl_no                                  
    FROM XX_STOCK;

Launch Material Transaction from Inventory Interface Manager.
N:- Inventory>Setup>Transaction>Interface Managers
It will launch 'Process transaction interface' and 'Process transaction interface' will call 'Inventory transaction worker'

How to find how many and what DFF(Descriptive Flex Field) are enabled in the Oracle APPS R12.1 instance

Execute following script :

SELECT TITLE FROM  FND_DESCRIPTIVE_FLEXS_VL
WHERE FREEZE_FLEX_DEFINITION_FLAG='Y' AND LAST_UPDATED_BY NOT IN (-1,1,2,0,120,121);

How to find all Form Personalization through script in Oracle APPS / How to get Form Personalization thorugh script

SELECT FORM_ID, FORM_NAME, USER_FORM_NAME, DESCRIPTION
FROM
FND_FORM_VL
WHERE FORM_NAME IN
(SELECT FORM_NAME FROM FND_FORM_CUSTOM_RULES GROUP BY FORM_NAME)

Oracle APPS R12.1.3 Rapid Clone Application and Database

Pre clone Activity

Database Tier

$ su – <dbuser>

$ cd <db script home> (ex:/u01/orcln/crp/db/tech_st/11.1.0/appsutil/scripts/)
$ sh adautocfg.sh
Pwd: apps

$ perl adpreclonr.pl dbTier

Prompt Pwd: apps

$ exit

Application Tier

$ su– <application user>testcrp

$ cd <application script home> (ex: /u01/orcln/crp/apps/inst/apps/TEST10_vis/admin/scripts)
$ sh adautocfg.sh
Pwd: apps

$ perl adpreclone.pl appsTier

$ exit

Stop Instance

and ensure all process are stop

Login as root

copy all folder(apps,db,inst) to destination

$ cp –R <source>(/u01/orcln/crp/*) <destination>( /b01/UAT/)

After completion of copy change permission and ownership:-

$ chown – R orauat:dba db
$ chown – R appluat:dba apps
$ chown – R appluat:dba inst

$ chmod –R 777 db

$chmod –R 777 apps

$chmod –R 777 inst

Post Clone Activity database

$ su – <new db user> orauat
$ cd <clone/bin> (ex:/b01/UAT/db/tech_st/11.1.0/appsutil/clone/bin)
$ perl adcfgclone.pl dbTier
Prompt Pwd: apps

Target system host name : <host name> (test)

RAC(Y/N): N
Target system Database SID: <SID> (UAT)
Target system: /b01/UAT/db/tech_st/11.1.0
Target system utl_file_dir Directody list : /usr/tmp
DATA_TOP: 1
DATA_TOP_Directory: /b01/UAT/db/apps_st/data
ORACLE_HOME Directory: /b01/UAT/db/tech_st/11.1.0
Do you want to preserve display : y
Target system port pool : 6
$ exit

Checking for database connection (database up or not)

Post Clone Activity Application

$ su – <new application user>(appluat)
$ cd /b01/UAT/apps/apps_st/comn/clone/bin
$ perl adcfgclone.pl appsTier
Prompt Pwd: apps
Host name : test
SID : <sid> (UAT)
Database server node : vis
System database domain name : kross.com
System base directory : - /b01/UAT/apps/apps_st/appl
System tool oracle_home: - /b01/UAT/apps/tech_st/10.1.2
System web oracle_home :- /b01/UAT/apps/tech_st/10.1.3
System appl_top:- /b01/UAT/apps/apps_st/appl
System common_top:- /b01/UAT/apps/apps_st/comn
System instance home:- /b01/UAT/apps/inst
<accept other default value by pressing enter>

Preserve display: y

Port pool : 6
Appltmp : - 1( /usr/tmp)
Do you want to startup application services: y

Stop and start new instance

Run Autoconfig on Database

Run Autoconfig on Application

Stop and start New instance

Oracle APPS ISO Internal Location details and deletion from backend.

SELECT * FROM PO_LOCATION_ASSOCIATIONS_ALL

WHERE LOCATION_ID = &location_id AND ORG_ID = &enter org_id;

 If it returns any row, it means that, indeed, an Internal location is Already assigned to another Ship-to Address 

For deletion of internal location association

Please run following datafix:

Take a backup of table :- FROM PO_LOCATION_ASSOCIATIONS_ALL

 DELETE FROM PO_LOCATION_ASSOCIATIONS_ALL

WHERE LOCATION_ID = &location_id AND ORG_ID = &enter org_id;

Oracle APPS PO Output for Communication Completed with Error

ERROR:
m_Languages :en
m_Territories :US
genDoc() : Exceptionjava.lang.Exception: Error while generating PDF :null
java.lang.Exception: Error while generating PDF :null
rolling back the complete program

Solution :- . Query profile "XDO: Numeric Characters"
Set at site level one of the possible values for this profile: - 10.000,00