In Oracle : Maintain Database Entities in Oracle Apps 11i

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Maintain Database Entities in Oracle Apps 11i

 

 Maintain Database Entities in Oracle Apps 11i

 

 

1. Access "Maintain Applications Database Entities" menu

2. "Maintain Applications Database Entities" menu options

3. Validate APPS schema

4. Re-create grants and synonyms for APPS schema

5. Maintain multi-lingual tables

6. Check DUAL table

7. Maintain Multiple Reporting Currencies

8. Convert to Multi-Org

 

 

1. Access "Maintain Applications Database Entities" menu

 

Run adadmin and choose the option "4. Maintain Applications Database Entities menu"

2. "Maintain Applications Database Entities" menu options

 

Enter your choice [6] : 4

Maintain Applications Database Entities
---------------------------------------------------

1. Validate APPS schema

2. Re-create grants and synonyms for APPS schema

3. Maintain multi-lingual tables

4. Check DUAL table

5. Maintain Multiple Reporting Currencies schema

6. Return to Main Menu

 

 

3. Validate APPS schema

 

This task creates a report called <APPS schema name>.lst in $APPL_TOP/admin/<SID>/out directory.

 

This report shows:

  • invalid objects in APPS schema

  • missing objects in APPS schema

This task must be run:

  • when there are customizations in APPS schema;

  • after upgrade, applying a maintenance pack;

  • before convertion to Multi Org or Multi Reporting Currencies (MRC);

  • after an import/ export;

  • if an error is coming from AD_DDL package.

This task could be run also from the sqlplus (connected as system):

SQL> @$AD_TOP/admin/sql/advrfapp.sql <APPS schema name> <AOL schema name>

 

 

4. Re-create grants and synonyms for APPS schema

 

The APPS schema keeps the database code but, the tables are situated in each product schema. To access these tables, the code must have the right grants. So, this task re-grants the privileges,  recreates the synonyms for APPS schema (and also for APPLSYSPUB public schema).  

 

This task must be run:

  • After a custom development 

  • Failed Patches

  • Incomplete import/ export

 

5. Maintain multi-lingual tables

 

This task maintains multi-lingual tables by adding any missing, untranslated rows. 

 

 

6. Check DUAL table

 

This task verifies if the SYS.DUAL exists and has ONLY one row. If the SYS.DUAL doesn't exist or has more than 1 row, Oracle Applications will not run correctly. 

 

 

7. Maintain Multiple Reporting Currencies

 

If the Oracle Applications are NOT using the MRC,  instead "Maintain Multiple Reporting Currencies" we will have in the menu "Convert to Multiple Reporting Currencies".

 

When MRC is implemented, for each currency will be a conversion rate and the reports can be created in any currency supported by the Oracle Applications. 

 

 

8. Convert to Multi-Org   (this option appears only if the Oracle Applications don't support Multi-Org )

 

The improved Convert to Multi-Org process is available for download from Metalink. Patch Number 2412194 (or 2616304, which is included in Applications DBA 11i.AD.H).

 

NOTE: To avoid data corruption, please shut down all concurrent managers and ensure all users are logged off the system. 

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Maintain Database Entities in Oracle Apps 11i

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.