1) Create a user and grant select option to that user.
This will have to be done individually for all users that you want to have as read only.
2) Create a readonly role and assign users this role.
This will have to be done once and then assign this role to the users.
One of the most visible (and colorful!) user interface enhancements for Oracle E-Business Suite Release 12.2.4 is the new simplified home page:
When you first install or upgrade to Release 12.2.4, you will see the home page as it appeared in previous versions of Release 12.2 (configurable home page with tree-based navigator).
Read more...
While running adop phase=prepare, it fails on one node while trying to clone Run Context file to refresh Patch context file.
It fails with the following error in the ADOP Session.
ADOP prepare phase fails with [UNEXPECTED] occurred during CONFIG_CLONE Patch File System from Run File System
The log file has the following error:
ERROR: Could not clone the Run context file due to the following exception:
AC-00005: No write permissions for creating the Context file - /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
ERROR: Failed to clone Run Context file to refresh Patch context file
applpreprod@ebsapp01:~$ adop phase=prepare
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/PREPROD/fs1/inst/apps/PREPROD_ebsapp01/appl/admin/PREPROD_ebsapp01.xml
Patch edition context: /u01/PREPROD/fs2/inst/apps/PREPROD_ebsapp01/appl/admin/PREPROD_ebsapp01.xml
Patch file system free space: 83.74 GB
Validating system setup.
Read more...
After applying Exadata or Super Cluster Bundle Patch on the RDBMS HOME of an EBS R12.2 database, the APPS.AD_ZD_ADOP Package becomes invalid and all ADOP sessions fail.
Check ADOP status:
applprod@ebsapp01:~$ adop -status
Enter the APPS password:
==============================================================
ADOP (C.Delta.7)
Session Id: 55
Command: status
Output: /u01/PROD/fs_ne/EBSapps/log/status_20161115_112514/adzdshowstatus.out
===================================wo============================
File System Synchronization Type: Full
declare
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_ADOP"
ORA-06512: at line 6
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 1 (Fail)
=====================
After logging in and clicking on any form, java installation window opens up even though the correct java version is installed on client PC’s.
This issue is seen on all client machines.
Issue occurs for all EBS Users who are using Internet Explorer.
Classid is not set properly in $FORMS_WEB_CONFIG_FILE.
EBS looks for classid to launch the form.
