Skip to content

Archive for

Sep 18

Deploying JRE for Windows Clients in Oracle E-Business Suite Release 12

Deploying JRE for windows clients in Oracle E-Business suite release 12.1.3 Follow the document

  1. Follow the document
Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1) . 

 

Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

 

2. Steps

Upgrade latest OUI 6640838 and then applying below patches use by opatch 6880880 with 10.1.0.0.0

Upgrade Patch :

Apply patch  14825718

Apply overlay patch 26825525

and follow post installation steps on 437878.1

Sep 18

DDL Extract for tables

DDL Extract for tables

 

ALL Tables from user

set heading off;
set echo off;
Set pages 999;
set long 90000;

spool export_tables_ddl.sql

select dbms_metadata.get_ddl(‘TABLE’,table_name,’TESTUSER’) from user_tables;

 

spool off

 

*table_name — Don’t mention anything

 

 

A table

select dbms_metadata.get_ddl(‘TABLE’,’EMPLOYEE’) from dual

 

*EMPLOYEE – table name