How to create APPS readonly user in Oracle Applications

Step 1:

Connect as SYS user to create Tablespace and APPS_RO user

CREATE TABLESPACE APPS_RO DATAFILE '/u02/oracle/db/apps_st/data/apps_ro1.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 2G;

create user apps_ro identified by appsro default tablespace APPS_RO;

grant connect, resource to apps_ro;

grant create synonym to apps_ro;

exit;


Step 2:

Connect as APPS user and run the SQL commands:

bash $ sqlplus apps/apps

SQL>set head off

SQL> set newpage none

SQL> set pagesize 9999

SQL> spool create_synonyms.sql

SQL> select ‘create synonym ‘ || object_name || ‘ for ‘ || owner ||’.’ ||object_name || ‘;’ from all_objects where OWNER not in (‘SYS’,’SYSTEM’) and OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘TABLE’,’VIEW’,’SYNONYM’,’PACKAGE’,’PACKAGE BODY’,’PROCEDURE’,’FUNCTION’);

SQL> spool off


SQL> spool grant_select.sql

SQL> select ‘grant select on ‘|| owner ||’.’ ||object_name || ‘ to apps_ro;’ from all_objects where OWNER not in (‘SYS’,’SYSTEM’) and OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘TABLE’,’VIEW’,’SYNONYM’);

SQL> spool off

SQL> spool grant_execute.sql

SQL> select ‘grant execute on ‘|| owner ||’.’ ||object_name || ‘ to apps_ro;’ from all_objects where OWNER not in (‘SYS’,’SYSTEM’) and OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘PACKAGE’,’PROCEDURE’,’FUNCTION’);

SQL> spool off

SQL> exit;



Step 3:


Connect as sysdba :

bash $ sqlplus '/as sysdba'

SQL>@grant_select.sql  -- To grant select privileges on TABLES,VIEWS and SYNONYMS.

SQL>@grant_execute.sql -- To grant execute privileges on PACKAGES, FUNCTIONS and PROCEDURES.

SQL> exit;


Step 4:


Connect as apps_ro

bash $ sqlplus apps_ro/apps_ro

SQL> @create_synonyms.sql  -- To create synonyms on apps_ro schema.

SQL> exit;

ORA-20001 FND_CANT_INSERT_USER_ROLE (USERNAME=SYSADMIN) (ROLENAME=FND_RESP|FND|FND_FUNC_ADMIN|STANDRARD) (ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

ISSUE:

Getting below error message while trying to add Functional Administrator responsibility to sysadmin user.

ORA-20001 FND_CANT_INSERT_USER_ROLE (USERNAME=SYSADMIN)
(ROLENAME=FND_RESP|FND|FND_FUNC_ADMIN|STANDRARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment)
has been detected in
FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

CAUSE:

The ORA-20001 error is often caused by the responsibility that is already assigned.

Issue exists in R12 installation,upgradation and migration.


SOLUTION:

Please run the below concurrent programs in the order given, with the respective values of the parameters, and then retest the issue.

1. Run concurrent program "Workflow Directory services user/role validation" with argument values as 10000:Yes:Yes:No:NULL.

2. If Responsibility not showing in list, do below step

3. Bounce opmn services.

Now you can able to see responsibility. 

FRM-92050 failed to connect to Server /forms/servlet -1 coming after R12.1.3 installation or upgrade from 11i to R12.1.3

ISSUE:

While opening forms in IE8, its getting below error.

CAUSE:

Issue comes in Internet Explorer IE8.

SOLUTION:

Do below steps:

Disable the XSS filter as below.

1. Open Internet Explorer 

Go to Tools -> Internet Options -> Click on Security Tab

Select Internet -> Click on Custom Level

Scroll down to entry "Enable XSS Filter" > Select Disable XSS Filter button and Apply

Reopen the forms , it should work.

R12 Rapidwiz Postinstall Steps Http, Login page, Virtual directory, JSP, Help Page Fails in Linux 5 64-bit

ISSUE:

R12 Rapidwiz Postinstall Steps Http, Login page, Virtual directory, JSP, Help Page Fails in Linux 5 64-bit

Rapidwiz log:

HTTP 
----- 
checking URL = http://<hostname>:<port> 

RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 

Help Page: 
---------- 
checking URL = http://<hostname>:<port>/OA_HTML/help 

RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 

Virtual Directory: 
------------------ 
RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 

JSP: 
---- 
checking URL = http://<hostname>:<port>/OA_HTML/jtfTestCookie.jsp 

RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 

Login Page: 
----------- 

RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing. 

While checking opmn services not running, try start services its getting below error.

You are running adopmnctl.sh version 120.6

opmnctl: starting opmn and all managed processes...
getaddrinfo(localhost, NULL, 1) failed (Name or service not known): No such file or directory
getaddrinfo(localhost, NULL, 1) failed (Name or service not known): No such file or directory
getaddrinfo(localhost, NULL, 1) failed (Name or service not known): No such file or directory
opmnctl: opmn start failed.

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /d02/applmgr/PROD/inst/apps/PROD_apps/logs/appl/admin/log/adopmnctl.txt for more information ... 

CAUSE:

The hosts file does not contain the localhost entry or commented in /etc/hosts file.

127.0.0.1 localhost.localdomain


SOLUTION.


To implement the solution, please execute the following steps:

1. Modify /etc/hosts file like add localhost entry or uncomment

127.0.0.1 localhost.localdomain localhost

2. Start opmn services and go back to rapidwiz postinstall page click retry button

3. If Still Login page check fails , do below steps

4. Stop all applications

   cd $ADMIN_SCRIPTS_HOME
   
   sh adautocfg.sh
   
5. Start applications and go back to rapidwiz postinstall page click retry button

   All postinstall checks should complete successfully.