Friday, July 23, 2010

Now Available: Oracle E-Business Suite Release 12.1.2 [ID 977706.1]

Now Available: Oracle E-Business Suite Release 12.1.2 [ID 977706.1]
Modified 25-MAY-2010 Type ANNOUNCEMENT Status PUBLISHED

In this Document
What is being announced?
What do you need to do?

What is being announced?
E-Business Suite Development is pleased to announce the availability of Oracle E-Business Suite Release 12.1.2. This release update pack (RUP) combines error corrections, statutory/regulatory updates, and functionality enhancements into a consolidated, suite-wide patchset. Release 12.1.2 is cumulative and includes new updates as well as updates made available in one-off patches after the base 12.1 release.
What do you need to do?

Oracle E-Business Suite Release 12.1.2 is currently available on My Oracle Support as Patch 7303033. This patch needs to be applied on top of Oracle E-Business Suite Release 12.1.1. Please refer to the following documents for additional information:

* Instructions for downloading and applying the patch can be found in Document 949406.1 Oracle E-Business Suite Readme, Release 12.1.2.
* Information about the new products and features included in this release can be found in Document 561580.1 Oracle E-Business Suite Release 12.1 Release Content Documents.
* Documentation, Transfer of Information (TOI) online training, and additional information can be found in Document 806593.1 Release 12.1 Information Center.

How To License A New Product in Oracle Applications

How To License A New Product in Oracle Applications

1. After purchasing a license for an Application Product/Module, the first thing is to use license manager to record that the product/module is now licensed. License manager can be run 2 ways:

a. log in through Oracle Application Manager (OAM) and select Site Map -> Administration tab -> License Manager

b. run adlicmgr.sh from AD_TOP/bin

Using both methods you can license by Module or by individual Product. Select the check box for the Module/Product to be licensed and Save/Next

2. The Products are now licensed but not ready to be used as none of the Forms/Packages etc would have been compiled and loaded into the Database for these new Products. Use adadmin to generate the files for the new Product/s

a. run adadmin

b. Select Generate Application Files menu

c. Select all of the following Menu options:
- Generate message files
- Generate forms files
- Generate report files
- Generate graphic files
- Generate product JAR files

d. Back to Main Menu

e. Select Compile/Reload Applications Database Entities menu

f. Select all of the following Menu options:
- Compile APPS schema
- Compile menu information
- Compile flexfields

3. Once complete, check that the Forms/JSPs for the new Products licensed now work. The Products are now ready to be configured.

4. Run autoconfig.
Ads by Google
Oracle Apps ERP Training
Oracle Fin, Hrms,Crm,Scm, Apps dba Oracle Approved Center in Gurgaon
www.saviance.com



April 5, 2010 - Posted by Shreyas Desai | AD Utilities | adadmin, adlicmgr, AD_TOP, AutoConfig, License, OAM
2 Comments »

1.

I guess running Autoconfig is also required along with the above steps.. Not sure, but last when I tried to add a module, I was advised to run autoconfig after the above steps also

Comment by Vishwast | April 7, 2010 | Reply
*

Yes i missed. thanx for comment.

Comment by Shreyas Desai | April 8, 2010 | Reply

Saturday, July 17, 2010

HRGLOBAL.DRV for R12.1.1 with issue and resolutions

HRGLOBAL.DRV


140511.1
ID 414434.1
java oracle.apps.per.DataInstall apps apps thin dhadev2:1540:JADE

At one point HR Global will fail on the worker 1 with the error ORA-20001, then we need to resolve it by following the below note and restart the worker.
HRGLOBAL Driver Fails on benxansi.ldt with 'Criteria value not found' Error [ID 579714.1]
________________________________________
Modified 30-JUN-2008 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References
________________________________________
Applies to:
Oracle Advanced Benefits - Version: 12.0.4
This problem can occur on any platform.
Symptoms
Problem Statement:
On 12.0.4 in Production:
When applying the hrglobal patch, the patch driver fails with the following error:

ERROR
"Error loading seed data for CRITERIA_VAL: FILE_NAME = ANSI-834 Change Event, PROFILE_NAME = ANSI-834 Change Event, PROFILE_NAME = ANSI-834 Change Event, TYPE_CODE = CCE, PROFILE_NAME = ANSI-834 Change Event, TYPE_CODE = CCE, VAL = Update Participant Monthly Premium, ORA-20001: Criteria value not found : Person Extract Change Event : Update Participant Monthly Premium"

Steps To Reproduce:
1. Apply the hrglobal patches Patch 6836355 and Patch 6610000 (all pre-reqs are met).
2. Run Data Installer.
3. Run the hrglobal driver and the error can be seen in the log file.
Cause
The benxansi.ldt has failed because there is no lookup with meaning 'Update Participant Monthly Premium' for the lookup type 'BEN_EXT_CHG_EVT'.
This is a know data issue and has been fixed in the future releases of the application.

Confirmed on the above from the error message uploaded by the user in the log file, and from the feedback from development on the following bug
Internal BUG 6873970 - HRGLOBAL FAILED ON HR2RW210
Solution
To implement the solution, please execute the following steps:

1. Run the following command:
FNDLOAD user/pwd@instance 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/aflvmlu.lct $PER_TOP/patch/115/import/US/perzzlookup00151.ldt - CUSTOM_MODE=FORCE

2. Execute the following SQL statement to confirm that the LDT got uploaded correctly:
select lookup_code, meaning, start_date_active, end_date_active,language
from fnd_lookup_values
where lookup_code in ('COPMPRM','CCOPMPRM') and language = 'US'

3. Confirm that the results of the above query are as follows:
Code Meaning Start End lang
------- ----------------------------- ------------- ----------- ----
COPMPRM Update Participant Monthly Premium(obsolete,Use CCOPMPRM) 01-JAN-51 01-JAN-51 US
CCOPMPRM Update Participant Monthly Premium 01-JAN-51 US

4. Once confirmed, re-run the hrglobal driver and re-check the issue.

5. Migrate the solution as appropriate to other environments.
References
________________________________________

Related
________________________________________
Products
________________________________________
• Oracle E-Business Suite > Human Capital Management > Benefits > Oracle Advanced Benefits
Errors
________________________________________ORA-20001




*******************************************************************************

java oracle.apps.per.DataInstall apps apps thin dhadev:1524:PROD
java oracle.apps.ad.licensemgr.LicenseMgr apps apps thin oracle:1521:prod


**************************************************************************************************************************************************************************


select lookup_code, meaning, start_date_active, end_date_active,language
from fnd_lookup_values
where lookup_code in ('COPMPRM','CCOPMPRM') and language = 'US' ;

FNDLOAD apps/apps@CRP2 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/aflvmlu.lct $PER_TOP/patch/115/import/US/perzzlookup00151.ldt - CUSTOM_MODE=FORCE