Added Pivot , Unpivot ,Table functions and sub query objects in new ODI 12.1.2 patch number 17053768

Finally we got PIVOT and other three objects UNPIVOT , TABLE Function & Subquery Filter in Mapping after applying the Opatch 17053768

Copy your opatch file into C:\TEMP  directory (odi_1212_opatch\17053768)

C:\Java\jdk1.7.0_55\bin>set PATH=D:\Oracle\Middleware\Oracle_Home\OPatch;%PATH%

C:\Java\jdk1.7.0_55\bin>cd C:\TEMP\odi_1212_opatch

C:\TEMP\odi_1212_opatch>where opatch
D:\Oracle\Middleware\Oracle_Home\OPatch\opatch
D:\Oracle\Middleware\Oracle_Home\OPatch\opatch.bat

C:\TEMP\odi_1212_opatch>where unzi[
INFO: Could not find files for the given pattern(s).

C:\TEMP\odi_1212_opatch>where unzip
D:\ORACLEXE\app\oracle\product\11.2.0\server\bin\unzip.exe

C:\TEMP\odi_1212_opatch>opatch napply 17053768
Oracle Interim Patch Installer version 13.1.0.0.0
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : D:\Oracle\MIDDLE~1\ORACLE~1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 13.1.0.0.0
OUI version       : 13.1.0.0.0
Log file location : D:\Oracle\MIDDLE~1\ORACLE~1\cfgtoollogs\opatch\opatch2014-06
-06_23-11-38PM_1.log


OPatch detects the Middleware Home as "D:\Oracle\Middleware\Oracle_Home"

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   17053768

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy
stem.
(Oracle Home = 'D:\Oracle\MIDDLE~1\ORACLE~1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '17053768' to OH 'D:\Oracle\MIDDLE~1\ORACLE~1'

Patching component oracle.odi.sdk, 12.1.2.0.0...

Patching component oracle.odi.studio, 12.1.2.0.0...

Verifying the update...
Patch 17053768 successfully applied.
Log file location: D:\Oracle\MIDDLE~1\ORACLE~1\cfgtoollogs\opatch\opatch2014-06-
06_23-11-38PM_1.log

OPatch succeeded.

C:\TEMP\odi_1212_opatch>

Before Starting ODI12c Studio Client first Delete   odi_1212_opatch  directory from

C:\TEMP\odi_1212_opatch

If you are not deleted above folder then you can't find new Pivot and other objects

Next Start your ODI12c Studio Client then we can new objects in Mapping.

Added Pivot , Unpivot ,Table functions and sub query objects in new ODI 12.1.2 patch number 17053768

Added Pivot , Un pivot ,Table functions and sub query objects in new ODI 12.1.2 patch number 17053768

After ODI 12c Installation Applying the patches odi_1212_opatch.zip

• Unzip the file odi_1212_opatch.zip in a root directory (no space in the path)

• Add opatch in the PATH

  C:\> set PATH=c:\OdiHome\OPatch;%PATH%

• Verify that you can reach the utilities “opatch” and “unzip” from the directory where the patches are.
• I have copied odi_1212_opatch zip into C:\temp  directory

C:\temp\odi_1212_opatch>where unzip

C:\temp\odi_1212_opatch>where opatch

Set Oracle_Home ( ODI Installation home

set ORACLE_HOME=D:\Oracle\Middleware\Oracle_Home

Apply all the patches under the subdirectory odi_1212_opatch

c:\temp\odi_1212_opatch>opatch napply odi_1212_opatch

C:\Java\jdk1.7.0_55\bin>set PATH=D:\Oracle\Middleware\Oracle_Home\OPatch;%PATH%

C:\Java\jdk1.7.0_55\bin>cd C:\TEMP\odi_1212_opatch

C:\TEMP\odi_1212_opatch>where opatch

D:\Oracle\Middleware\Oracle_Home\OPatch\opatch

D:\Oracle\Middleware\Oracle_Home\OPatch\opatch.bat

C:\TEMP\odi_1212_opatch>where unzip

E:\app\lucky\product\11.2.0\dbhome_1\BIN\unzip.exe

C:\TEMP\odi_1212_opatch>set ORACLE_HOME=D:\Oracle\Middleware\Oracle_Home

C:\TEMP\odi_1212_opatch>opatch napply odi_1212_opatch

Oracle Interim Patch Installer version 13.1.0.0.0

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : D:\Oracle\Middleware\Oracle_Home

Central Inventory : C:\Program Files\Oracle\Inventory

   from           : n/a

OPatch version    : 13.1.0.0.0

OUI version       : 13.1.0.0.0

Log file location : D:\Oracle\Middleware\Oracle_Home\cfgtoollogs\opatch\opatch20

14-05-30_12-58-13PM_1.log

OPatch detects the Middleware Home as "D:\Oracle\Middleware\Oracle_Home"

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   16926420  17170540  17469061

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy

stem.

(Oracle Home = 'D:\Oracle\Middleware\Oracle_Home')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '16926420' to OH 'D:\Oracle\Middleware\Oracle_Home'

Patching component oracle.xdk.jrf.xmlparserv2, 12.1.2.0.0...

Patching component oracle.xdk.jrf.jaxp, 12.1.2.0.0...

Verifying the update...

Applying interim patch '17170540' to OH 'D:\Oracle\Middleware\Oracle_Home'

Patching component oracle.as.common.clone, 12.1.2.0.0...

Verifying the update...

Applying interim patch '17469061' to OH 'D:\Oracle\Middleware\Oracle_Home'

Patching component oracle.fmw.upgrade, 12.1.2.0.0...

Verifying the update...

Patches 16926420,17170540,17469061 successfully applied.

Log file location: D:\Oracle\Middleware\Oracle_Home\cfgtoollogs\opatch\opatch201

4-05-30_12-58-13PM_1.log

OPatch succeeded.