How to Create a Read-Only APPS Schema?

We are going to create a schema similar to the APPS schema having only read-only privileges.

Step 1. Create the user for the required schema:

• SQL> connect system/manager
• SQL> create user <your_user> identified by <your_user_password> default tablespace;
• SQL><tablespace_to_assign_to_user> temporary tablespace temp;

Step 2. Grant connect and resource privileges to your user:

• SQL> connect system/manager
• SQL> grant connect, resource to <your_user>;

Step 3. Use the following select statement to generate a script that will grant privileges on APPS objects to your User.

This select statement would generate a script that will grant almost all required permissions to a user called READONLY.

SELECT 'GRANT ' 
       || Decode(O.object_type, 'TABLE', 'SELECT', 
                                'VIEW', 'SELECT', 
                                'EXECUTE') 
       || ' ON ' 
       || Decode(O.owner, 'PUBLIC', '', 
                          O.owner 
                          || '.') 
       || '"' 
       || O.object_name 
       || '"' 
       || ' TO MYUSER;' COMMAND 
FROM   all_objects O 
WHERE  O.object_type IN ( 'TABLE', 'PACKAGE', 'PACKAGE BODY', 'PROCEDURE', 
                          'VIEW', 'FUNCTION' ) 
UNION 
SELECT 'GRANT ' 
       || Decode(O2.object_type, 'TABLE', 'SELECT', 
                                 'VIEW', 'SELECT', 
                                 'EXECUTE') 
       || ' ON ' 
       || Decode(O.owner, 'PUBLIC', '', 
                          O.owner 
                          || '.') 
       || '"' 
       || O.object_name 
       || '"' 
       || ' TO READONLY;' COMMAND 
FROM   all_objects O, 
       all_objects O2, 
       dba_synonyms S 
WHERE  O.object_type = 'SYNONYM' 
       AND O.object_name = S.synonym_name 
       AND O2.object_name = S.table_name 
       AND O2.object_type IN ( 'TABLE', 'PACKAGE', 'PACKAGE BODY', 'PROCEDURE', 
                               'VIEW', 'FUNCTION' )

Now, Use the following select statement to generate a script that will create synonyms in <your_user> schema for all objects owned by APPS.

SELECT ‘CREATE SYNONYM MYUSER.’ || O.OBJECT_NAME || ‘ FOR APPS.’ || O.OBJECT_NAME || ‘;’ COMMAND FROM DBA_OBJECTS O WHERE O.Owner = ‘APPS’

Run the above two scripts as SYS user.

How to get table information? How to get About this Page link in OA page in R12

How to find supplier related view / table information in web page environment?

Step 1. Navigate to the Supplier Page

Step 2. Click on the About this page link

Step 3. Click Expand All

Step 4. You will be seeing SuppSrchVO, SupplierVO and SitesVO

Step 5. If you click on that view it will show you the query used.

How to get the About this Page link in OA page?

To get the About this Page Link, Please ensure the below Profile option is set to Yes at site level:

• FND: Diagnostics
• System Administrator > Profile > System

The FND: Diagnostics profile option controls whether the Diagnostics button is rendered.

It also controls the display of the About this Page link.

You may also set below

• Personalize Self-Service Defn : Yes
• FND: Personalization Region Link Enabled : Yes 
• FND: Diagnostics : Yes

Add the below responsibilities to the user:

System Administrator > Security > User > Define

• FND Html Forms
• Functional Administrator
• Functional Developer

1. Once done bounce the apache

2. Retest the issue

3. Migrate the solution to other environments as appropriate.