Hello Mina,

you can follow the below Steps:

Method :1

[code]

SQL> CREATE USER APPSREAD IDENTIFIED BY APPSREAD;
User created.

SQL> GRANT CONNECT, RESOURCE,CREATE SYNONYM TO APPSREAD;
Grant succeeded.
[/code]

Generate a Script for creating database objects of Application User ‘APPS’.

[code]
set echo off set
pagesize 0
set linesize 300
spool cr8synonyms.sql
select ‘create synonym ‘ || OBJECT_NAME || ‘ for ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘;’ from all_objects where OWNER in (‘APPS’) and
OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘TABLE’,’VIEW’,’SYNONYM’);
spool off

[/code]

Generate a script for selecting database objects of Application User ‘APPS’.

[code]
spool GrantSelect.sql
select ‘grant select on ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘ to APPSREAD;’ from all_objects where OWNER not in (‘SYS’,’SYSTEM’) and OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘TABLE’,’VIEW’,’SYNONYM’);
spool off

[/code]

Connect to sqlplus as sysdaba and execute the following script

[code]
SQL> @GrantSelect.sql
SQL> @cr8synonyms.sql
[/code]

Connect to Read only schema User and check the objects.

[code]
SQL> conn APPSREAD/APPSREAD Connected.
SQL> select count(*) from tab;
COUNT(*) ———- 15515
[/code]

Regards.

Hi , To compile the form manually, do the following.

frmcmp_batchmodule=/prod/apps/oraapp/apps_st/appl/au/12.0.0/forms/US/********.fmb userid=APPS/***** output_file=/prod/apps/oraapp/apps_st/appl/ap/12.0.0/forms/US/********.fmx module_type=form batch=yes compile_all=special

To compile the pl sql library

frmcmp_batch module=/prod/apps/oraapp/apps_st/appl/au/12.0.0/resource/********.pll userid=APPS/****output_file=/prod/apps/oraapp/apps_st/appl/au/12.0.0/resource/********.plx module_type=library batch=yes compile_all=special

Mahmoud Morsy

Hello ,

you can follow the below steps:

1. Stop all Application services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any dead process is running.
2. Stop the database.
3. Start the database.
4. Go to cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDFS”
$ adrelink.sh force=y link_debug=y “fnd FNDCRM”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”
5. Run the CMCLEAN.SQL then Commit 6.Start All Application services

thanks ,

Mahmoud Morsy