1.Change the GUEST user statement to the following in $CONFIG_FILE
<oa_user type=”GUEST”>
<username oa_var=”s_guest_user”>GUEST</username>
<password oa_var=”s_guest_pass”>GUEST</password>
Use upper case letters.
3. Run AP Tier Autoconfig.
4. Verify the $FND_TOP/secure/<host>.dbc file the entry for GUEST_USER_PWD is
set in the same letter case.
Virtual Private Database (VPD) with Oracle Apps Virtual Private Database (VPD) with Oracle Apps Virtual Private Database (VPD) is an Oracle database security technology, enabling row level access control. With VPD we are able to control users access to data related to them only and preventing from them to access data they are not authorized…
1. Attributes of the login page It is possible to control the display of some attributes of the login page, for instance user name or password hints, language switchers, forgot password link, corporate policy message, etc. For this, you need to set the profile option ‘Local Login Mask’ (FND_SSO_LOCAL_LOGIN_MASK) with a number being the sum…
The Following error had occured while running the xml report “concurrent manager has timed out waiting for the Output Post-processor to finish this request” Cause: Once the Output Post Processor picks up the request, the XML Publisher engine is invoked to generate the final output file. The time that this takes will depends on various…
You may remove Oracle Portal 3.0.9 only if you are not using Oracle Portal with E-Business Suite 11i or if you have migrated existing Oracle Portal 3.0.9 functionality to Oracle Portal 10g . It is recommended that the removal of Oracle Portal 3.0.9 be done only after the migration to Oracle Portal 10g. To remove…
/* Query to find out if any patch except localisation patch is applied or not, if applied, that what all drivers it contain and time of it’s application*/ select A.APPLIED_PATCH_ID, A.PATCH_NAME, A.PATCH_TYPE, B.PATCH_DRVIER_ID, B.DRIVER_FILE_NAME, B.ORIG_PATCH_NAME, B.CREATION_DATE, B.PLATFORM, B.SOURCE_CODE, B.CREATIONG_DATE, B.FILE_SIZE, B.MERGED_DRIVER_FLAG, B.MERGE_DATE from AD_APPLIED_PATCHES A, AD_PATCH_DRIVERS B where A.APPLIED_PATCH_ID = B.APPLIED_PATCH_ID and A.PATCH_NAME = ‘<patch…
Create a Physical Standby 1. Perform a hot backup of the primary database. This can be done in several ways depending on what your current configuration is and where the logical standby database will be placed. 2. Turn this backup of the primary database into a physical standby following a. Restore the backup to the…