1)Personalize Region Line Enabled> Region Level Link Enable

2)Personalize self-service def link enable Page Level Link Enable

Sysadmin > system >profile to enable personalization

Func Administrator > Core Services > Profiles

Personalization UI Level Change> no coding

Extention > Business funct is changed the Coding; CO ,VO EO AM

To check wheather personalization done or not

Exec jdr_utils.printDocument(‘xml rn path ’);

Select * from jdr_paths where path_name like ‘summerycountainerRN’

Jdr_components, jdr_attributes

Save the region path >

TO DOWNLOAD

FND%Document%ROOT%Path> valid middle tier location > location to download the file (Winscp mein folder banana hai )

Functional Administrator > Personalization > Import/Export

There are 2 types of interfaces:

1) Inbound Interface: will be used to upload the data from legacy system (Flat files) into Oracle Applications base tables.

2) Outbound Interface: will be used to extract the data from oracle Database tables base tables into the flat files.

Inbound Interface

1) Open Interface

2) Custom interface

Open Interface >standard Programs >base tables

Custom interface >falt files into oracle base table through api’s(packages developed by oracle peoples )

Outbound Interface>base table data into > flat files

1) Sql approach

2) Pl/sql approach (is used in real life )>utl file packages used in this

Util pre defined packages

How to find out the path of util file;

Select * from V$parameter where name like ‘utl%’

It gives the path of the path col name would be VALUE 4 PATHS select any 1 path.

Xfile utl_file.file_type;

Xfile:=utl_file.fopen(‘utl path ’,’ITEMS.xls’,’W’);

FOR I in C1

LOOP

L_count := l_count +1;

Utl.file.put_line(x_file, i.item_naem||’,’||i.item_no||’,’||i.item_order);

End loop;

Utl_file.fclose(X_FILE);