Wednesday 18 April 2012

Oracle EBS: Repairing the "XXX is not a valid responsibility for the current user" error in Oracle

Content-type: text/html; charset=WINDOWS-1256 Location: /oracle.apps.fnd.sso.AppsLogin?errText=Please%20contact%20the%20Web%20Master%20or% 01403%3A%

After applying HRMS family pack K (11i.HR_PF.K and 11i.HR_PF.K.DELTA.5) HRMS functional consultant updated that he is not able to access Approvals Management Responsibility. There are certain changes with this family pack. To overcome this issue please follow below steps as described.

Error message while accessing responsibility:

Content-type: text/html; charset=WINDOWS-1256 Location: http://orasolerp.orasol.com:8011/oa_servlets/oracle.apps.fnd.sso.AppsLogin?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Forasolerp.orasol.com%3A8011%2Foa_servlets%2Foracle.apps.fnd.sso.AppsLogin&errText=Please%20contact%20the%20Web%20Master%20or%20System%20Administrator.%20ORA-01403%3A%20no%20data%20found%0AORA-06512%3A%20at%20%22APPS.AME_UI%22%2C%20line%20496%0AORA-06512%3A%20at%20%22APPS.AME_RULES_UI%22%2C%20line%206055%0AORA-01403%3A%20no%20data%20found%0A

1) AME responsibility cannot be accessed.


Problem:
This issue is described in Metalink Note 336901.1 Ext/Pub Oracle Approvals Management
Implementation Guide (Minipack B)
The note also explains that the issue is caused by a setup similar to what you have.
Chapter 2 Implementing Oracle Approvals Management , section : AME Roles and Responsibilities

Action Plan:

From the Note:
This section gives a step-by-step illustration of adding the two AME responsibilities to the user.
1. Login as SYSADMIN user.
2. Create a New user account and give an appropriate effective date. Do NOT add any responsibility.
3. Save the record.
4. Switch the responsibility to User Management and Navigate to the Users function.
5. Query for the newly created user.
6. Click on the update action from the result table.
7. In the Update User page, click on the Assign Roles button
8. In the search window, query for Approval%
9. Following five roles will be displayed.
10. Select all five roles.
11. After selecting the Roles, provide the Justification for the role and the effective date.
12. After completing the action, you can query back the same user and can verify the list of roles
being attached to the user.
13. Now switch the responsibility to Functional Administrator.
14. Click on create grants under the grants sub-tab.
15. Enter a Grant Name and provide an effective date.
16. Navigate to the Security Context region and select the Grantee Type as `Specific User¿
17. In the Grantee field select the newly created User
18. In the Data Security region select `AME Transaction Types¿ as the Object
19. Clicking Next will take you to the `Select Object Data Context¿ page.
20. You have a default value of `All Rows¿ in the Data Context Type, leave it as it is, and
navigate further.
21. In the `Define Object Parameter
and Select Set¿ page, enter `AME Calling Applications¿
as the value in the Set field.
22. Clicking Next will take you to the Review page.
23. Verify the information and submit the transaction.
24. Now switch the responsibility to System Administrator and navigate to System Profiles.
25. Query for the profile AME:Installed at the required level and set the value to Yes.
26. Save the data.
27. Now you can login as the newly created user.
28. You should be able to see the following responsibilities:
a. Approvals Management Administrator
b. Approvals Management Business Analyst


Solution:

First Run report "Approvals management post upgrade process". This report exists in HR user group. Run this report from SYSADMIN responsibility, as this report doesn't belongs to SYSADMIN group hence we need to attach this report to Sysadmin request group.

- Attach report to sysadmin responsibility
- Run with specified paramaters



- Create AME User



- Switch to user management responsibility





- Search for created user



- click update action on resulted value



- click on assign roles





- search for term Approval



- select for term Approval and select all roles



- Specify effective date and write justification for users



- search again for AME user you can roles attached to it



- Now switch the responsibility to Functional Administrator







- click on create grants tab





- In Security Context Select specific user from drop down list and add grantee name as AME and in Data Security context – select AME transaction Type




- selection screens





- Click next on object Data context page:
- Keep default value as “All Rows”



- Select AME calling application in "Set"







- click Next will take you to review page




- click finish



- Now navigate to System administrator responsibility and and set profile AME:Installed Value to Yes at Application level for Application "Approvals Management"






- Now login to AME user, it will list two responsibilities.

Wednesday 11 April 2012

Oracle Export hangs with: "exporting cluster definitions"

1. Stop the database and the listener.

2. Set LD_LIBRARY_PATH so the first directory referenced is $ORACLE_HOME/lib
Example (replace $ORACLE_HOME with the full path of the Oracle home directory):

csh:

> setenv LD_LIBRARY_PATH=$ORACLE_HOME/lib
> setenv LIBPATH=$ORACLE_HOME/lib

ksh:

> export LD_LIBRARY_PATH=$ORACLE_HOME/lib
> export LIBPATH=$ORACLE_HOME/lib

For Oracle9i and higher on AIX: set environment variable LIBPATH and afterwards, run /usr/sbin/slibclean as root

For Oracle9i and higher on HP-UX, Linux, Solaris, and Tru64: set environment variable LD_LIBRARY_PATH

3. Re-start the database and the listener.

4. Re-run the export.

Tuesday 10 April 2012

How Do I Find the Version Of HRMS in oracle APPS


How Do I Find the Version Of Human Resources (HR) On My System? [ID 269286.1]

  Modified 06-JAN-2012     Type HOWTO     Status ARCHIVED  

In this Document
  Goal
  Solution
  References





Applies to:

Oracle Human Resources - Version: 11.5.5 to 11.5.10.2
Information in this document applies to any platform.

Goal

How do I determine the patch level of HRMS application code on our system?

Solution

1. You can run one of the general HRMS diagnostic scripts such as:
Note:462555.1 "Collecting Data Using The SSHR11i.sql Script as Requested by Support"
Note:211747.1 "HRMS11i.sql"
Note:208964.1 "PAY11i.sql"

2. Or you can run the following script from the SQL prompt:

SELECT substr(fpi.application_id,1,6) APP_ID
,substr(fat.application_name,1,40) APPLICATION
,substr(l.meaning,1,9) STATUS
,substr(decode(fpi.patch_level,null,'11i.'||
fa.application_short_name||'.?',fpi.patch_level),1,12) PATCH
FROM fnd_product_installations fpi
,fnd_application_tl fat
,fnd_application fa
,fnd_lookups l
WHERE (fpi.application_id between 800 and 850
OR fpi.application_id in (178,275,712,777))
AND fpi.application_id = fat.application_id
AND fpi.application_id = fa.application_id
and l.lookup_type = 'FND_PRODUCT_STATUS'
and l.lookup_code = fpi.status
ORDER BY fat.application_id;

3. Either of these methods requires and 11.5 instance and that AD MiniPack "G" (2344175) or greater has been applied.

Sunday 8 April 2012

How to compile Oracle Apps Forms 11i/R12

How to compile Oracle Apps 11i Forms

============================

Check whether the forms that you want to generate are not in use at the time you are generating them.

 If they are in use when you generate the fmx files, the forms client session terminates.

1) Login to the Forms server node as applmgr and run .env file to set the applications environment.

2) Change directory to $AU_TOP/forms/US.

3) Use the “f60gen” command to generate the fmx files for the fmb files.

4) Issue the following command

$ f60gen module=.fmb userid=apps/ output_file=/forms/US/.fmx

How to compile Oracle Apps R12 Forms

=============================

1) Log into the forms tier.

2) Set the applications environment

3) Ensure that the $FORMS_PATH includes $AU_TOP/resource and $AU_TOP/resource/stub, for example

echo $FORMS_PATH

/u01/oracle/DEV/apps/apps_st/appl/au/12.0.0/resource:

/u01/oracle/DEV/apps/apps_st/appl/au/12.0.0/resource/stub

4) Compile the form

a)- If you are using forms customizations (CUily: verdana,geneva;">1) Log into the forms tier.

2) Set the applications environment

3) Ensure that the $FORMS_PATH includes $AU_TOP/resource and $AU_TOP/resource/stub, for example

echo $FORMS_PATH

/u01/oracle/DEV/apps/apps_st/appl/au/12.0.0/resource:

/u01/oracle/DEV/apps/apps_st/appl/au/12.0.0/resource/stub

4) Compile the form

a)- If you are using forms customizations (CUSTOM.pll) then run the command below to compile the form.

frmcmp_batch.sh module= userid=APPS/APPS output_file=

module_type=form compile_all=special

For eg:-

frmcmp_batch.sh module=/u01/oracle/TEST/apps/apps_st/appl/au/12.0.0/forms/US/

XXX.fmb userid=APPS/APPS output_file=/u01/oracle/TEST/apps/apps_st/appl/inv/

12.0.0/forms/US/XXX.fmx module_type=form compile_all=special

b) If you are NOT using forms customizations, then run the command below to compile the form.

frmcmp_batch.sh module= userid=APPS/APPS output_file=

module_type=form

For example..

frmcmp_batch.sh module=/u01/oracle/TEST/apps/apps_st/appl/au/12.0.0/forms/US/

XXX.fmb userid=APPS/APPS  output_file=/u01/oracle/TEST/apps/apps_st/appl/inv/

12.0.0/forms/US/XXX.fmx module_type=form

Number of Visitors