foalabs

WSDL Generation Fails With The Error 'Service Provider Access resulted in exception 'oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server' Error: On R12.1.3, wsdl generation fails with the following error: Service Provider Access resulted in exception 'oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server. http://myhost.domain:<port>/webservices/SOAProvider/EbizAuth?Generate=1426&soa_ticket=Yjdhksgksdboq235zZr-NBQ..' when attempting to perform 'GENERATE'. Please view Service Provider logs for more details Reason:  The environment variable s_soaprovider_user was not set to ASADMIN. Solution: 1. Login to (R) System Administration > OAM > AutoConfig, and select to edit the application context file. 2. Search for the environment variable s_soaprovider_user, and set it to ASADMIN. 3. Run Autoconfig. 4. Bounce the application services, and retest the issue. If you like please ...

Validating the Setup for ASADMIN User for ISG and XML Gateway JDBC Connections in EBS Oracle Apps If we want to validate the ASADMIN setup is correct after the Integrated SOA gateway or after cloning the EBS environment we can use below steps. 1. Enable "ASADMIN" user. a) Log in using sysadmin/<sysadmin_pw> b) Choose responsibility 'User Management' c) Find user ASADMIN d) Reset Password e) Remove Active To date if set. f) Apply 2. Test that ASADMIN user exist in the Database as an EBS user: This will confirm that the ASADMIN user's password is "welcome".  Substitute it for your ASADMIN user password. select fnd_web_sec.validate_login('ASADMIN','welcome') from dual; 3. Confirm that ASADMIN has the required role 'UMX|APPS_SCHEMA_CONNECT' to be authorized to connect to EBS. col name for a30 head "Name" col role for a30 head "Role" select substr(user_name, 1, 30) name, substr(role_name, 1, 30) role from wf_l...

SOA Gateway Setup after Cloning EBS 12.1.3 Instance After cloning EBS Application, we will need to setup Integrated SOA GateWay again 1. Reset the ASADMIN password Mandatory A. Reset the password in the Application Navigation path: a. System Administrator Responsibility b. Security c. User d. Define e. Query the ASADMIN user and change the password B. Reset the "ASADMIN" password in the file system after "ASADMIN" user is enabled from inside EBS by updating the file: a. vi $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml <user> <name>ASADMIN</name> <display-name>Default Apps SOA User</display-name> <description>Used by SOAProvider for DB connection</description> <credentials>!<NEW PASSWORD></credentials> </user> NOTE: The password should be preceded by a '!' (Exclamation) so that when OAFM is started, it gets encrypted. For example, if the password is "welcome", then you...

Mentoring an IT Team: Cultivating Excellence and Growth In the dynamic world of Information Technology (IT), a highly skilled and motivated team is essential for success. As an IT leader or experienced professional, mentoring your IT team can be a powerful approach to foster growth, improve productivity, and create a positive work environment. In this article, we will explore the benefits of mentoring, key principles of effective mentoring, and practical tips for mentoring an IT team. The Benefits of Mentoring Mentoring is a valuable practice that offers numerous advantages, both for mentees and mentors: Skill Development: Mentoring provides an opportunity for team members to develop their technical and soft skills. Through regular feedback and guidance, mentees can enhance their expertise and become more proficient in their roles. Knowledge Transfer: Seasoned IT professionals can share their knowledge and experience with junior team members, promoting knowledge transfer within the or...

Enhancing IT Consulting Services: The Art of Process Review and Scope of Improvement In the fast-evolving landscape of IT consulting, ensuring the efficiency and effectiveness of processes is paramount. Regularly reviewing and identifying opportunities for improvement in processes is crucial to delivering high-quality services to clients. In this article, we will delve into the process review approach within IT consulting and explore real-world examples of how it can lead to tangible improvements and better outcomes for both consultants and clients. Understanding the Process Review Approach: Process review in IT consulting involves a systematic examination of the existing processes used to deliver services to clients. It aims to evaluate the alignment of processes with business goals, identify inefficiencies, and discover opportunities for enhancement. The review process typically includes the following steps: a. Process Mapping:  Start by mapping out the current processes. Visuali...

Effective Communication Within IT Teams: Fostering Collaboration and Success In the fast-paced and complex world of Information Technology (IT), effective communication is the cornerstone of success for any IT team. Clear and open communication enhances collaboration, prevents misunderstandings, and ensures the smooth execution of projects. In this article, we will explore the importance of effective communication within IT teams, along with practical examples to illustrate how it can drive better outcomes. Clear and Concise Messaging: Effective communication starts with clarity. IT professionals deal with intricate technical concepts, and conveying them in simple terms is crucial for seamless collaboration. For instance, when discussing a software bug with the development team, the tester should provide a clear description of the issue, including steps to reproduce it and expected results. Active Listening: Listening is as vital as speaking. Active listening ensures that team members ...

Navigating Escalation Meetings with Clients: A Service Delivery Manager's Guide Introduction: As a Service Delivery Manager in an IT company, you are no stranger to the occasional escalation meeting with clients. These meetings occur when issues or concerns have escalated to a point where higher-level intervention is required. While escalation meetings can be tense, they also present an opportunity to strengthen client relationships and demonstrate your team's commitment to resolving challenges promptly. In this scenario-based article, I will explore how to handle an escalation meeting with a client, ensuring a positive and successful outcome. Scenario: Imagine you are the Service Delivery Manager responsible for managing IT services for a prestigious client. Recently, the client's finance team experienced delays in their financial reporting due to a IT technical glitch in the newly implemented financial software. Frustrated, the client raised the issue to your attention, a...

 What is Assertive Communication Assertive communication is a communication style characterized by expressing one's thoughts, feelings, and needs directly, honestly, and respectfully, while also respecting the rights and feelings of others. It involves standing up for oneself in a confident and positive manner without being aggressive, passive, or manipulative. Assertive communication is an essential skill in building healthy relationships, resolving conflicts, and maintaining self-esteem. Here are some key characteristics of assertive communication: Clear and Direct:  Assertive communication involves expressing thoughts and needs clearly and directly. It avoids vague or ambiguous language and gets straight to the point. Respectful and Polite:  While being direct, assertive communication is also respectful and considerate of others' feelings and perspectives. It avoids demeaning or insulting language. Open and Honest:  Assertive communicators are honest about th...

Dealing with Difficult People I will share valuable strategies to deal with challenging personalities and maintain positive interactions. Let's get started! 1) Stay Calm and Composed Take a deep breath and remain composed when encountering difficult individuals. Keep your emotions in check to prevent escalating the situation. Avoid responding impulsively or defensively. 2) Listen Actively Give the person your undivided attention and listen actively to their concerns. Demonstrate empathy and understanding to validate their feelings. Avoid interrupting or dismissing their perspective. 3) Empathize and Put Yourself in Their Shoes Try to see the situation from their point of view to better understand their emotions. Show empathy and acknowledge their feelings, even if you disagree with their actions. Avoid judging or criticizing their behavior. 4) Set Boundaries Establish clear boundaries for acceptable behavior and communicate them respectfully. Be firm in enforcing these boundaries t...

Building a High-Performing IT Team: Strategies for Success In today's fast-paced and technology-driven world, building a high-performing IT team is crucial for organizations to stay competitive and achieve their business objectives. A high-performing IT team is not just a group of talented individuals but a cohesive unit that collaborates, innovates, and delivers exceptional results. In this article, we will explore key strategies to build and nurture a high-performing IT team that drives success for the organization. Define Clear Roles and Responsibilities: Establishing clear roles and responsibilities is the foundation of a high-performing IT team. Each team member should understand their specific tasks and contributions to the team's overall goals. Clarity minimizes duplication of efforts, enhances accountability, and fosters a sense of ownership among team members. Recruit Top Talent and Foster Diversity: Recruiting top talent is essential for building a high-performing IT ...

While Running Autoconfig txkCfgUtlfileDir.sh directory does not exist When running adconfig.sh in database, getting below error Error: WARNING: [CVM Error Report] The following report lists errors encountered during CVM Phase /u01/app/oracle/product/19c/db_home1/appsutil/bin/txkCfgUtlfileDir.sh 1 No. of scripts failed in CVM phase: 1 Solution : 1) Check adconfig.log file ERROR DESCRIPTION: (FATAL ERROR PROGRAM : (/u01/app/oracle/product/19c/db_home1/appsutil/bin/txkCfgUtlfileDir.pl) TIME : Sat Jul 22 10:00:39 2023 FUNCTION: main::checkUtlFileDir [ Level 1 ] ERRORMSG: Directory /u01/TEST/temp/EBSTEST does not exist. ) ERRORCODE = 1 ERRORCODE_END .end std out. .end err out. 2) Create directory /u01/TEST/temp/EBSTEST run below script to add this directory in utl_file_dir perl /u01/app/oracle/product/19c/db_home1/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/oracle/product/19c/db_home1/appsutil/EBSTEST_funebs122.xml -oraclehome=/u01/app/oracle/product/19c/db_home1 -outdir=/u01/app...

Fix for ORA-03113 end-of-file on communication channel while starting Oracle database While Starting database we are getting End-of-file error. Error: Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Database mounted. ORA-03113: end-of-file on communication channel Process ID: 4903 Session ID: 237 Serial number: 26032 Solution: Exit from previous SQLPLUS session and connect to new  session [oracle@zeus ~]$ sqlplus / as sysdba Connected to an idle instance. SQL> startup nomount ORACLE instance started. SQL> alter database mount; Database altered. Clean unarchived logfiles. SQL> alter database clear unarchived logfile group 1; Database altered. SQL> alter database clear unarchived logfile group 2; Database altered. SQL> alter database clear unarchived logfile group 3; Database altered. SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL...

How to check if TDE or TSE is enabled in Oracle Database If we want to find if TDE or TSE is enabled in database we can use below queries. TDE is encryption is table column level TSE us encryption in table space level To check if your table space is encrypted, run below query SQL> SELECT tablespace_name, encrypted, status FROM dba_tablespaces where tablespace_name = "<TS name>" To check if you have encrypted columns use SQL> SELECT * FROM dba_encrypted_columns; If you like please follow and comment

How to set Oracle Pluggable Database Automatic startup with Container In Oracle Database 12c and above, the Multitenant Architecture was introduced, allowing for the creation of multiple Pluggable Databases (PDBs) within a single Container Database (CDB). To ensure seamless operation and availability of the PDBs, it is essential to configure automatic startup for the PDBs during database startup. This blog article will guide you through the steps to set up automatic startup for Oracle Pluggable Databases. Steps: 1) Connect to the CDB Start by connecting to the Container Database (CDB) using SQL*Plus $sqlplus / as sysdba SQL>show con_name CON_NAME ------------ CDB$ROOT 2) Check Current Startup Mode Execute the following query to check the current startup mode of the PDBs: SELECT name, open_mode FROM v$pdbs; Or SQL>show pdbs     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ----------...

Shell Script to Delete old log files and Send mail In post I am sharing sample shell script to delete old log file from a location and send mail Script: #!/bin/bash # Directory path where log files are stored log_directory="/u01/oracle/app/diag/test" # Maximum age of log files (in days) max_age=10 # Email configuration email_recipient="support@funoracleapps.com" email_subject="Deleted Log Files Report from TesT" # Delete old log files and collect the deleted file names one by one deleted_files=$(find "$log_directory" -type f -name "*.log" -mtime +"$max_age" -exec rm {} \; -print) # Generate email body if [ -n "$deleted_files" ]; then     email_body="Deleted log files:$'\n'$deleted_files" else     email_body="No log files were deleted." fi # Send email to recipient echo "$email_body" | mail -s "$email_subject" "$email_recipient" If you like please follow and co...

How to Run DDL Command on Remote Database With Database Link The DDL command cannot be executed directly with the database link on the remote database. If it is run, it will cause the error as follows. ORA-02021: DDL operations are not allowed on a remote database. The dbms_utility.exec_ddl_statement procedure must be used for this. With this procedure, any DDL command can be executed in the remote database.  In this way, all operations can be done from a single point. Example: SQL> exec dbms_utility.exec_ddl_statement@DB_LINK('TRUNCATE TABLE USER.TABLE_NAME'); DB_LINK specifies the database link. After that, the command is executed in parenthesis and single quotes. Create a table as follows. SQL> exec dbms_utility.exec_ddl_statement@DB_LINK('create table emp (id number)'); In this way, it is possible to run DDL commands through the database link in the remote database. Please ensure that you have the necessary privileges, appropriate database link setup, and prop...

Steps for Changing Apps Password in R12.2 In this post I am going to share steps to change apps password step by step in R12.2. 1. Stop Application Tier Services $INST_TOP/admin/scripts/adstpall.sh 2. Changing APPS password from FNDCPASS FNDCPASS apps/<old_apps_password> 0 Y system/<system_password> SYSTEM APPLSYS <new_apps_password> Check the log file it should show the successful status. 3. Run autoconfig on both application nodes 1 st in Node 2 (Slave Node) Cd $ADMIN_SCRIPTS_HOME Sh adautocfg.sh 2 nd in Node 1 (Master Node) Cd $ADMIN_SCRIPTS_HOME Sh adautocfg.sh  4. Starting AdminServer $INST_TOP/admin/scripts/adadminsrvctl.sh start ** Do not start any other application tier services .  5. Changing APPS password in WLS Data source a. Log in to WLS A...