vngappsdba

error: Validating system setup.     Node registry is valid.     [UNEXPECTED]Unable to find appltop_id for host ebsapp2 in database     [UNEXPECTED]Unable to find appltop_id for host ebsapp2 in database cause: on node2  s_atName parameter value having wrong entryu on node1 grep -i s_atname $CONTEXT_FILE          <APPL_TOP_NAME oa_var="s_atName">AT_ebsapp1</APPL_TOP_NAME> [appr12prd@esbapp1:R12PRD:scripts] [appr12prd@ebsapp2:R12PRD:~] > grep -i s_atname $CONTEXT_FILE          <APPL_TOP_NAME oa_var="s_atName">ebsapp1</APPL_TOP_NAME>  === wrong entry on node2 , it should be AT_ebsapp1 reference: ADOP Phase=prepare Fails With the Error "[UNEXPECTED]Unable To Find Appltop_id For Host In Database" (Doc ID 2794402.1) Fix:  s_atName parameter value in node1 and node2 should be same as  AT_ebsapp1 as node2 is having wrong entry ,  updated it with correct value and...

Error: While running   Checking for existing adop sessions.     No pending session exists.     Starting new adop session.     [UNEXPECTED]Unable to find appltop_id for host ebsappprd2 in database  Statement Handler Error Code: 20010  Statement Handler Error Message: ORA-20010: No admin node found. Review and correct your configuration,                                contacting Oracle Support as needed. ORA-06512: at "APPS.AD_ZD_ADOP", line 3028 ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute)  Reference of statement-handler is valid, not attempting database reconnect.  Failed to execute SQL statement:       begin          ad_zd_adop.INSERT_ADD_NODE_RECORDS;         end;  Error Message: ORA-20010: No admin node found. Review and correct your configuration,         ...

 Error: AutoPatch - aidafoGetFileDbVersion: INFO:  ORA-01403: no data found AutoPatch error: Unable to get APPS_DDL package version from db <XXPIC> <APPS_DDL> <PACKAGE> AutoPatch error: adpmrp: Error while installing apps_ddl packages. Fix: oracle note: Adop Phase=cutover Failing With AutoPatch - AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found (Doc ID 2790694.1) SQL> select  ORACLE_USERNAME, READ_ONLY_FLAG, ENABLED_FLAG, ORACLE_ID, INSTALL_GROUP_NUM, last_update_date from FND_ORACLE_USERID where ORACLE_USERNAME in ('XXPIC'); ORACLE_USERNAME                R E  ORACLE_ID INSTALL_GROUP_NUM ------------------------------ - - ---------- ----------------- LAST_UPDATE_DATE ------------------ XXPIC                          D        20063                 0 21-DEC-22 SQL> select...

 while creating WebADI documents, getting following error org.apache.poi.POIXMLException:+org.apache.poi.openxml4j.exceptions.InvalidFormatException Oracle Note: "org.apache.poi.POIXMLException:+org.apache.poi.openxml4j.exceptions.InvalidFormatException" Error When Creating WebADI Documents (Doc ID 2495167.1) Cause:  WebADI_Template.xlsm template file got corrupted Fix: Copy the  WebADI_Template.xlsm template file from working environment.   strings -a $BNE_TOP/patch/115/bneobjects/WebADI_Template.xlsm|grep Header ls -lrt $BNE_TOP/patch/115/bneobjects/WebADI_Template.xlsm cd $BNE_TOP/patch/115/bneobjects/ cp -rp WebADI_Template.xlsm WebADI_Template.xlsm_orig mv WebADI_Template.xlsm WebADI_Template.xlsm_BKP cp -rp /applprd/software/OAuth/UIapps_steps/WebADI_Template.xlsm .   ls -lrt WebADI_Template.xlsm chmod 755 WebADI_Template.xlsm ls -lrt WebADI_Template.xlsm

  Subledger Accounting: Version : 12.2   Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.   XLAACCUP: Accounting Program Current system time is 22-DEC-2022 13:44:37 An internal error occurred.  Please inform your system administrator or support representative that:   An internal error has occurred in the program xla_je_validation_pkg.balance_by_intercompany.  ORA-01555: snapshot too old: rollback segment number 3 with name "$TEMPUNDOSEG" too small. An internal error occurred.  Please inform your system administrator or support representative that:   An internal error has occurred in the program xla_je_validation_pkg.balance_by_intercompany.  ORA-01555: snapshot too old: rollback segment number 3 with +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------...

Workflow mailer able to send notifications to Users.  When users acknowledges the email, they are stuck in their inbox only. Unable to process . Fix: Applications System:R12PRD   > Workflow   > Service Components   >Advanced > Details check the value of  Inbound Thread Count , it should be 1.