vngappsdba

 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.

 Error: while launching vncserver [appr12uat@ebsuatapp1:R12UAT:~] > vncserver :1 /usr/bin/perl: symbol lookup error: /appltop/oracle/R12UAT/fs2/FMW_Home/webtier/perl/lib/5.10.0/x86_64-linux-thread-multi/auto/Socket/Socket.so: undefined symbol: Perl_Istack_sp_ptr Fix : unset the PERL5LIB [ap12uat@ebsuasssa1:UAT:~] > unset PERL5LIB [ap12uat@ebsuasssa1:UAT:~] > ps -ef|grep vnc app12u+ 17563 16579  0 14:39 pts/1    00:00:00 grep --color=auto vnc [ap12uat@ebsuasssa1:R12UAT:~] >  vncserver :1 New 'ebsuasssa1:1 (ap12uat)' desktop is ebsuasssa1:1 Starting applications specified in /home/ap12uat/.vnc/xstartup Log file is /home/ap12uat/.vnc/ebsuasssa1:1.log

 Validate Javamail Version If things are not working - Generate the jar files Class verification cd /applprd/software/OAuth/ $AF_JRE_TOP/../bin/javac -classpath .:$AF_CLASSPATH getjarofclass.java     $AFJVAPRG -classpath .:$AF_CLASSPATH getjarofclass   Location => file:/appltop/oracle/RDEV/fs2/FMW_Home/modules/javax.mail_1.6.2.jar   Java Mail Api Version is => 1.6.2   API version => 1.6.2   API_ver version => 1.6.2

 Oracle Note:  Configuring Oracle Workflow for OAuth 2.0 in Oracle E-Business Suite Release 12.2 and Release 12.1.3 (Doc ID 2884072.1) Java api patch - 31042881 cd $FMW_HOME/utils/bsu/cache_dir/ cp -rp /applprd/software/OAuth/p31042881_1036_Generic.zip . unzip -o p31042881_1036_Generic.zip . Archive:   p31042881_1036_Generic.zip   inflating: README.txt   inflating: patch-catalog_27104.xml   inflating: 7BIA.jar cd $FMW_HOME/utils/bsu ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir/ -patchlist=7BIA -prod_dir=$FMW_HOME/wlserver_10.3 -verbose OAuth2.0 - 34423621 time adop phase=apply patches=34423621 wait_on_failed_job=yes patchtop=/applprd/software/OAuth apply_mode=downtime OAuth2.0 - 34565205 time adop phase=apply patches=34565205 wait_on_failed_job=yes p...

  Caused by: org.xml.sax.SAXException: Error Parsing at line #6: 1. org.xml.sax.SAXParseException; lineNumber: 6; columnNumber: 1; <Line 6, Column 1>: XML-20100: (Fatal Error) Expected 'EOF'.          at oracle.ods.virtualization.engine.config.parsers.ConfigErrorHandler.fatalError(ConfigErrorHandler.java:103) Fix: ) Take a backup of $DOMAIN_HOME/config/fmwconfig/ovd/default/adapters.os_xml 2) Delete corrupted adapters.os_xml 3) Copy adapters.os_xml from $MW_HOME/oracle_common/modules/oracle.ovd/templates/ to $DOMAIN_HOME/config/fmwconfig/ovd/default/ 4) Restart the server.

 MANUALLY GET LIST OF PARAMETERS: You  can Manually check the parameters in your database by the parameter “v$parameter”. And the query is 1. Immediate : List of dynamic parameters. select name from v$parameter where ISSYS_MODIFIABLE=’IMMEDIATE’; 2. DEFERRED : Semi-Dynamic Parameters. select name from v$parameter where ISSYS_MODIFIABLE=’DEFERRED’; 3. False : Static parameters list.\ select name from v$parameter where ISSYS_MODIFIABLE=’FALSE’;

 managed server status showing as FORCE shutting down go to following path , select "bam_server2.state" $DOMAIN_HOME/servers/bam_server2/data/nodemanager  ls bam_server2.prg  bam_server2.state   bam_server2.url  boot.properties  startup.properties  vi bam_server2.state change value from " FORCE_SHUT_DOWN " to " SHUTDOWN "

 sqlplus apps/apps4dev SQL*Plus: Release 10.1.0.5.0 - Production on Thu Dec 8 04:22:00 2022 Copyright (c) 1982, 2005, Oracle.  All rights reserved. ERROR: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. Cause: Achive log location is full Fix: connect to rman RMAN target / execute following command delete noprompt force archivelog until time 'sysdate -1';

 C:\Users\xstoreadm>sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 6 07:19:43 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. ERROR: ORA-12557: TNS:protocol adapter not loadable Fix:  set the  correct environment

 error: C:\Users\xstoreadm>lsnrctl start LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 06-DEC-2022 07:44:51 Copyright (c) 1991, 2019, Oracle.    All rights reserved. Starting tnslsnr: please wait... Unable to OpenSCManager: err=5 TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error Cause: Oracle_home is pointing to 12c and path is poining to 19c Fix: updated oracle home as 19c

 ERROR DESCRIPTION: (ORA-44303: service name exists ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 21 ORA-06512: at "SYS.DBMS_SERVICE", line 316 ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) at /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/bin/txkCreateEBSPDBService.pl line 408. ) ERRORCODE = 1 ERRORCODE_END .end std out. Fix: SQL> EXEC dbms_service.delete_service('ebs_R12PRD'); PL/SQL procedure successfully completed. SQL> select service_id, name, pdb, deletion_date from service$ where  name='ebs_R12PRD'; SERVICE_ID NAME ---------- ---------------------------------------------------------------- PDB -------------------------------------------------------------------------------- DELETION_ ---------          7 ebs_R12PRD CDB$ROOT 02-DEC-22

1)  To see queue in Printer  lpstat -o "Printername" eg: lpstat -o QVAPCHKP3 QVPCHKP3-136209        appnprd          22528   Tue 11 Sep 2018 08:40:38 AM MST job  QVPCHKP3-136209 2) To cancel the job cancel job eg: cancel   QVPCHKP3-136209   3) To get printer ip address lpoptions  -p "Printername" | awk '{for (i=1; i<=NF; i++) {if ($i ~ /device-uri/) {print $i}}}' eg: lpoptions  -p QVAPCHKP3 | awk '{for (i=1; i<=NF; i++) {if ($i ~ /device-uri/) {print $i}}}' device-uri=socket://10.45.45.212:9100 4) Send a test print from server lp -d QVPCHKP3 test QVPCHKP3.txt

 lp: Too many active jobs. Pasta: Error: Print failed. Command=lp -c -dWVOAPCHKP3  /prd/app/nprd/shared/apps/apps_st/comn/admin/conc/out/o87724679.out Pasta: Error: Check printCommand/ntPrintCommand in pasta.cfg Pasta: Error: Preprocess or Print command failed!!! APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN. Program exited with status 1 Cause: AFPPRN received a return code of failure from the OSD routine FDUPRN. Program exited with status 1. Action: Review your concurrent request log file for more detailed information. Dunning (ARDLGP) Process Ends in Error - APP-FND-00500: AFPPRN Received a Return Code of Failure from Routine FDUPRN (Doc ID 1124476.1) Please change the profile value for concurrent copies for operation user from 5 to 0 and retest the issue. Cause: spool has file count around 1000 Fix: lp: Too many active jobs Log in through root user. Delete files form "/var/spool/cups"  cd /var/spool/cups.  # rm -rf * Restart CUPS se...