Welcome to my blog

· I have extensively worked on the following technologies/Implementation projects

· Oracle EBS R12, 11.5.10.2, 11.5.9

o Oracle Applications DBA (AD)

o Oracle Financials

o Order Management

· Oracle Retail Suite V12, V13

o Retail Merchandizing system RMS

o Invoice matching ReIM

o Retail Integration Bus RIB

o Retail price manager RPM

o Store Inventory Manager SIM

o Retail Demand Forecasting RDF

o Retail data warehousing RDW

o Oracle Internet Directory OID

· Oracle SOA Suite

o BPEL process manager

o Enterprise Service Bus

· Oracle Hyperion Suite

o Shared services OSS

o Workspace

o Planning

o Essbase

o Enterprise performance management EPM

o Financial reporting, Web analysis

· Enterprise Batch Scheduler Uc4 Appworx

· Oracle Business intelligence Suite

o Answers

o Interactive dashboards

o BI publisher


· I am responsible for several Implementations that use the following Oracle middleware products

· Oracle Weblogic Fusion Middleware web application

· Oracle Weblogic Forms and Reports Server

· Oracle Weblogic SOA Suite

o BPEL process manager

o Oracle Service Bus

o Oracle B2B server

· Oracle Business intelligence Suite

o BI publisher

o Oracle Discoverer 10g

· Enterprise Batch Scheduler Active Batch

· Oracle Internet Directory OID

· Oracle Connection Manager

· Several Custom applications deployed in Oracle 10g Application servers



My interest is to make this an arena to share my experiences.

Saturday, June 21, 2008

How can Licensed products be de-licensed

How can Licensed products be de-licensed? What if HR needs to be de-licensed?

Licensed products can not be de-licenced oger the OAM interface.

They need to be updated at the table level. The switch on the FND_PRODUCT_INSTALLATIONS table to 'S'. This should de-license

If HR should really be shared rather than fully installed it may be possible to change it as long as no data has been populated in the database. Run this script to determine that HR is now installed fully:

select status from fnd_product_installations where application_id = 800

(I = Installed s = Shared)

Next determine whether hrglobal.drv was run using this script:

select application_short_name, Legislation_code, status, action, pi_steps_exist, LAST_UPDATE_DATE from hr_legislation_installations where application_short_name in ('PER','PAY')


The hrglobal.drv file should not be run in a shared installation as it installs legislations. If hrglobal.drv has not been run, change the switch on the FND_PRODUCT_INSTALLATIONS table to 'S'.

If the legislations have been installed the only way to go back to a shared install is to start over and reinstall the application.

No comments: