Category: Apps DBA

  • How To License A New Product in Oracle Applications

    How To License A New Product in Oracle Applications 1. After purchasing a license for an Application Product/Module, the first thing is to use license manager to record that the product/module is now licensed. License manager can be run 2 ways: a. log in through Oracle Application Manager (OAM) and select Site Map -> Administration…

  • Oracle Metalink Notes for Oracle Apps DBAs.

    Here are the list of Oracle Metalink Notes, I do refer regularly. Moreover, these are very informative. So, I thought of sharing those note ids here with you. Note: You have to have an account in Oracle Metalink to access notes. Installation Note: 452120.1 – How to locate the log files and troubleshoot RapidWiz for…

  • how to cleanup FND_NODES table to clear corrupted setup

    ## ## before cleanup ## 13:42:56 APPS@XTPR:host01> r 1 select node_name, node_mode, support_cp, 2 support_web, support_admin, support_forms 3* from FND_NODES NODE_NAME N S S S S —————————— – – – – – HOST01 O Y N Y N MIDTIER01 O N Y N Y APPSERVER21 N Y N Y <– bogust host APPSERVER22 N Y…

  • Oracle Apps Patch info Scripts

    /* 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…

  • 11i Forms compilation errors

    Forms compilation errors parameter Recently all custom forms compilation failed with errors like these: FRM-18108: Failed to load the following objects. Source Module:APPSTAND Source Object: STANDARD_PC_AND_VA Source Module:APPSTAND Source Object: STANDARD_TOOLBAR Source Module:APPSTAND Source Object: STANDARD_CALENDAR Compiling package specification APP_CUSTOM… No compilation errors. or Compiling KEY-NXTBLK trigger on QUERY_FIND data block… Compilation error on KEY-NXTBLK…

  • Remove Portal Schema from 11i

    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…

  • Perosnalize Login in EBS

    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…

  • concurrent manager has timed out waiting for the Output Post-processor to finish this request

    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…

  • Logical Standby Creation

    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…

  • APP-FND-01630: Cannot open file D:\oracle\prodcomn\temp\OF4981.tmp

    My Friend call me and told me he is getting following errors when he runs the report. Cause: The program terminated, returning status code 3. Action: Check your installation manual for the meaning of this code on this operating system. APP-FND-01630: Cannot open file D:\oracle\prodcomn\temp\OF4981.tmp for reading Cause: USDINS encountered an error when attempting to…