The NNNN function is not available in YYYY Responsibility

[rafaellfo]

I created a new query function by taking as an existing basis. I did this in the System Administrator> Application> Function.

In this new function all fields and their values ??are equal to those of the original function, single difference was on the Form tab in the Parameters field where I insert 'query_only = "".

In the approval environment works perfectly, but in production by clicking the Web link opens a page with the following information:

"The NNNN function is not available In YYYYY liability "

but accessed directly by Forms works without error.


Someone could help me, how to delete the error that appears by clicking the Web link. Server bounce did not solve the problem, it's EBS 12.

[victorhugomuniz]

liability in the environment that presents the error

[rafaellfo]

No, this already checked, the responsibility is in the environment. So much so that I have entered that when you access it via Forms it works normally.

[paulochagas]

Can you post the registration screen of this form please?

[rafaellfo]

Paulo, I set up a brief step-by-step:

[IMG http://www.postimage.org/image.php?v=aVrJzp9]
[IMG http://s4.postimage.org/rJzp9-327c19cfb ... 465469.png[/img]

[paulochagas]

I'm sorry for the delay because here in a suffocation only lately
I still researching on the net some solutions to your problem:
follows the possibilities:
http://knoworacle.wordpress.com/2009/11 ... nsibility/ http://oracleapplicationguru.blogspot.c ... -this.html]]
I found this the most coherent extracted from Metalink:

Select all

R12 Error 'Function not available to this responsibility' When Trying to Access Custom Form. [ID 553014.1]  	  
  	Modified 26-MAY-2010     Type PROBLEM     Status PUBLISHED 	  
 
In this Document 
  Symptoms 
  Changes 
  Cause 
  Solution 
 
Applies to: 
Oracle Application Object Library - Version: 12.0.3 to 12.0.3 - Release: 12 to 12 
Information in this document applies to any platform. 
Symptoms 
 
PROBLEM STATEMENT: 
 
On 12.0.3 instance, 
When attempting to access custom forms, 
the following error occurs. 
 
ERROR 
 
"Function not available to this responsibility. Change Responsibilities or contact your System 
Administrator". 
 
STEPS 
 
The issue can be reproduced at will with the following steps: 
 
1. Register custom application. 
2. Register custom form under this application. 
3. Add it to the menu 
4. Add the new product_top variable to the .env file. 
5. Bounce the forms server. 
6. Place the .fmx file in PROD_TOP/forms/US. 
7. Log in to Oracle applications and try opening the form. 
8. Encounter the above error. 
 
 
BUSINESS IMPACT 
 
The issue has the following business impact: 
Due to this issue, users cannot access the form in R12 which was working fine in 11.5.10.2. 
 
. 
Changes 
Upgrade from 11i to R12. 
Cause 
 
The issue is caused by the following setup: 
 
Missing entry for CUSTOM_TOP under default.env file 
 
Ideally in such cases,CUSTOM_TOP should be defined under default.env in $INST_TOP/ora/10.1.2/forms/server directory to have your custom form work with R12. 
Solution 
 
To implement the solution, please execute the following steps: 
 
1. Login to server with APPLMGR manager user access. 
 
2. Go to $INST_TOP/ora/10.1.2/forms/server directory. 
 
3. Ensure that your CUSTOM_TOP's are registered in the default.env file. 
 
This means that, you should create an entry for environment variable CUSTOM_TOP (which contains physical path to your custom directory) like below in default.env file present under location $INST_TOP/ora/10.1.2/forms/server directory. 
 
For Example: 
 
..... 
 
APPL_TOP=/home/applmgr/PROD/apps/apps_st/appl  
CUSTOM_TOP=/home/applmgr/PROD/apps/apps_st/custom 
------ 
 
4. Restart the middle tier services. 
 
5. Retest the issue. 
 
6. Migrate the solution as appropriate to other environments.

[rafaellfo]

I obtained success with the solution of the first link:

Select all

1) Manually run the ‘Compile Security’ concurrent program, set the parameter to YES. 
2) Shut down Middle Tier (Apache) 
3) Delete the contents of $OA_HTML/_pages directory (11.5.10 only). 
4) Restart Middle tier 
5) Test the menu item

Thanks for the help, apologies for the delay.