Monday, October 26, 2020

The Applications System names per the APPL_TOP and the database are different

 Adpatch Fails : 'The Applications System names per the APPL_TOP and the database are different.' (Doc ID 213339.1)

Unable to Patch a Cloned Environment Because of Wrong Applications System Names (Doc ID 202483.1)


Error:-


We recently faced an issue after development instance cloned from production.

adadmin Failed with the below errors.


The Applications System names per the APPL_TOP and the database

are different.

    Applications System name per the APPL_TOP: uaterp

    Applications System name per the database: THRMS


If you continue, the Applications System name per the APPL_TOP will

be ignored.

Do you wish to continue [No] ?


Solution:-


SQL> desc FND_PRODUCT_GROUPS
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
PRODUCT_GROUP_ID                          NOT NULL NUMBER(15)
LAST_UPDATE_DATE                          NOT NULL DATE
LAST_UPDATED_BY                           NOT NULL NUMBER(15)
CREATION_DATE                             NOT NULL DATE
CREATED_BY                                NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN                         NOT NULL NUMBER(15)
PRODUCT_GROUP_NAME                        NOT NULL VARCHAR2(60)
RELEASE_NAME                              NOT NULL VARCHAR2(50)
PRODUCT_GROUP_TYPE                        NOT NULL VARCHAR2(30)
ARGUMENT1                                          VARCHAR2(30)
MULTI_ORG_FLAG                                     VARCHAR2(1)
MULTI_LINGUAL_FLAG                                 VARCHAR2(1)
MULTI_CURRENCY_FLAG                                VARCHAR2(1)
APPLICATIONS_SYSTEM_NAME                  NOT NULL VARCHAR2(30)
IS_NEW_TS_MODE                                     VARCHAR2(1)
ARU_RELEASE_NAME                                   VARCHAR2(50)

SQL> select APPLICATIONS_SYSTEM_NAME from FND_PRODUCT_GROUPS;
APPLICATIONS_SYSTEM_NAME
------------------------------
THRMS

SQL> update FND_PRODUCT_GROUPS
  2  set APPLICATIONS_SYSTEM_NAME='uaterp'
  3  ;
1 row updated.

SQL> commit;

Commit complete.

SQL> select APPLICATIONS_SYSTEM_NAME from FND_PRODUCT_GROUPS;
APPLICATIONS_SYSTEM_NAME
------------------------------
uaterp
SQL>



No comments:

Post a Comment

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts