Skip navigation.

APPS Blogs

Supporting OracleApps : Debuging Oracle Alerts

OracleApps Epicenter - Mon, 2015-06-08 23:45
Alerts in EBS allows you to Monitor your Business information's to keep Be informed of database exceptions as and when they happen Sending Notifications to business user Performing routine database tasks automatically Calling Concurrent Programs, Shell Scripts and Operating System Scripts Types of Alerts in EBS Basically they are two types: Periodic Alerts :These alerts […]
Categories: APPS Blogs

Oracle Fusion Apps 11.1.9 : Error showing tasklist : SOA server connection information is not available

Online Apps DBA - Mon, 2015-06-08 16:07

 

fa_soa_tasklist

 

We implement and host Fusion Applications for our customers (both on our servers or at customer’s servers) and today’s post cover issue encountered in Oracle Fusion Applications when accessing HomePage http://host:10623/homePage  user receives message : Error reported on Worklist: Notification and Approvals

____

Error showing tasklist. Possible reasons could be : 1. SOA server connection information is not available. 2. If it is run in federated mode, the default server may be down

_____

Fusion Application contains multiple Oracle Weblogic Domain, configuration and log file for these domains are usually under/u01/ app/ fa/ instance/domains/[hostname]/  (where /u01/apps/fa is Oracle Fusion Applications base )

As this error is coming on homePage and HomePage is WebLogic Managed Server, under Domain CommonDomain so check logs at

/u01/ app/ fa/ instance/domains/ [hostname]/ CommonDomain/ servers/ HomePageServer_1/ logs/ HomePageServer_1.out

 

In my case error reported in out file

 

_____

<Jun 7, 2015 4:45:44 AM EDT> <Error> <oracle.webservices.jaxws> <BEA-000000> <Error while invoking endpoint “http://hostName:10617/integration/services/TaskQueryService/TaskQueryService” from client; Security Subject: CN_INCENTIVE_COMPENSATION_ADMINISTRATOR_JOB>
<Jun 7, 2015 4:45:44 AM EDT> <Error> <oracle.soa.services.workflow.task> <BEA-000000> <<.> Error in workflow service Web service operation invocation.
Error in workflow service Web service operation invocation. The error is .
Verify that the SOAP connection information for the server is correct.

ORABPEL-30044

Error in workflow service Web service operation invocation.
Error in workflow service Web service operation invocation. The error is .
Verify that the SOAP connection information for the server is correct.

<Jun 7, 2015 4:45:55 AM EDT> <Error> <oracle.soa.services.workflow.worklist> <BEA-000000> <Submission[id=380], Service[FederetedWorklistService], Resource[Financials]: AuthenticationHandler.call() failed for server=Financials because exception was thrown, exception: javax.xml.ws.WebServiceException: Could not determine wsdl ports. , caused by Could not determine wsdl ports. , caused by WSDLException: faultCode=OTHER_ERROR: Failed to read WSDL from http://hostName:10613/integration/services/TaskQueryService/TaskQueryService?WSDL: HTTP connection error code is 503>

<Jun 7, 2015 4:45:55 AM EDT> <Error> <oracle.soa.services.workflow.worklist> <BEA-000000> <Submission[id=379], Service[FederetedWorklistService], Resource[Supply Chain Management]: AuthenticationHandler.call() failed for server=Supply Chain Management because exception was thrown, exception: javax.xml.ws.WebServiceException: Could not determine wsdl ports. , caused by Could not determine wsdl ports. , caused by WSDLException: faultCode=OTHER_ERROR: Failed to read WSDL from http://hostname:10627/integration/ services/TaskQueryService/TaskQueryService?WSDL: HTTP connection error code is 503>

_______

 

Port 10627 is OHS port pointing to Supply Chain Domain (SCMDomain) so look in to log file of SCM Domain at

/u01/ app/ fa/ instance/ domains/ [hostName]/ SCMDomain/ servers/ soa_server1/ logs/ soa_server1.out

Error reported in SOA server log was

_____

<May 28, 2015 10:52:20 PM EDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING><May 28, 2015 10:53:03 PM EDT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool “SOALocalTxDataSource”: IO Error: The Network Adapter could not establish the connection.><May 28, 2015 10:53:04 PM EDT> <Error> <Store> <BEA-280072> <JDBC store “AGJMSJDBCStore_auto_1″ failed to open table “SCM_FUSION_SOAINFRA.AGJMS_ auto_1_WLStore”.weblogic.jdbc. extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common. ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection at weblogic.jdbc.common.internal. JDBCUtil.wrapAndThrow ResourceException (JDBCUtil.java:250)
at weblogic.jdbc.common. internal.RmiDataSource. getPoolConnection(RmiDataSource.java:471)
at weblogic.jdbc.common. internal.RmiDataSource. getConnectionInternal (RmiDataSource.java:553)
at weblogic.jdbc.common. internal.RmiDataSource. getConnection(RmiDataSource.java:513)
at weblogic.jdbc. common.internal. RmiDataSource. getConnection(RmiDataSource.java:506)
Truncated. see log file for complete stacktrace

<May 28, 2015 10:54:35 PM EDT> <Warning> <Management> <BEA-141198> <The undeployment of AGJMSJDBCStore _auto_1 failed.
weblogic.management. UndeploymentException: Deployment weblogic. management. configuration.JDBCStoreMBeanImpl @3fbfbc1([SCMDomain]/ JDBCStores[AGJMSJDBCStore_auto_1]) was never prepared
at 
Truncated. see log file for complete stacktrace
>

<May 28, 2015 10:54:49 PM> <FINEST> <NodeManager> <Waiting for the process to die: 2897>
<May 28, 2015 10:54:49 PM> <INFO> <NodeManager> <Server failed during startup so will not be restarted>
<May 28, 2015 10:54:53 PM> <FINEST> <NodeManager> <runMonitor returned, setting finished=true and notifying waiters>

_____

 

Looking at Admin Console of SCM Domain (Admin port 7811 and user faadmin)

soa_scm_fusionapps

 

 

Note : I restarted SOA managed server from SCM Domain WebLogic Console

Note: I also had to start few other managed servers on following domains that were down.

  • Common Domain : Admin Server Listen Port 7011
  • Financials Domain : Admin Server Listen Port 7411
  • SCM Domain : Admin Server Listen Port 7811
  • Procurement Domain : Admin Server Listen port 8211
  • Projects Domain : Admin Server Listen port 8611
  • CRM Domain : Admin Server Listen port 9011
  • HCM Domain : Admin Server Listen Port 9411

 

HTTP Listener for all the domains in Oracle Fusion Applications

fusion_apps_ports

 

After starting failed managed servers in all Fusion Applications WebLogic Domains, I was able to access HomePage with no errors

 

oracle_fusion_apps_tasklist_fixed

 

 

References

  • Error showing tasklist. Possible reasons could be : 1. SOA server connection information is not available. 2. If it is run in federated mode, the default server may be down. (Doc ID 1563474.1)
  • Starting and Stopping Fusion Applications (Doc ID 1499525.1)
  • Oracle Fusion App Start / Stop Syntax

 

 

Looking for partner to host your Oracle Fusion Application Environment – Request for Demo

Previous in series Related Posts for Fusion Apps
  1. Oracle Fusion Applications Overview
  2. Oracle Fusion Application for Apps DBAs – Concepts
  3. Install Oracle Fusion Applications in 10 Steps
  4. Oracle Fusion Applications : Provisioning Framework Overview
  5. Oracle Fusion Applications : Provisioning Framework Installation
  6. Provision Transaction Database for Oracle Fusion Applications
  7. Create Fusion Applications Schema using RCU : fusion & otbi
  8. Fusion Application 11.1.1.5.1 is now available
  9. Fusion Apps Installation : Database Provisioning Failed during listener start
  10. Fusion Applications : 128 GB memory and 500 GB Disk space : Are you ready
  11. Fusion Applications 11.1.1.5.1 Part I – Install Identity and Access Management (OID/OAM/OIM) 11g
  12. Fusion Applications 11.1.1.5.1 Installation Part II – Configure Oracle Internet Directory
  13. Fusion Applications 11.1.1.5.1 Installation Part III – Configure Policy and Identity Store
  14. Fusion Applications 11.1.1.5.1 Installation Part IV – Extend WebLogic Domain to include OIM/OAM and configure OIM
  15. Fusion Applications 11.1.1.5.1 Installation Part V – Integrate OIM with OAM
  16. Oracle Fusion Application 11.1.3 is now available
  17. Oracle Fusion Applications 11.1.3 Installation Experience
  18. FA Installation Error : runProvisioning-preverify FAPROV-00298 make sure password FUSION_RUNTIME schema password is valid
  19. FA Installation Error 2 – List of failed Validation in OIM OAM_Validation: Cannot perform OAM Validation as null
  20. Identity & Access Management configuration for Oracle Fusion Applications – Part I
  21. Oracle FA Installation Error 3: private-preverify-free-space The file system only has 190113 MB, but 204800 MB is needed
  22. Oracle Fusion Applications (FA) 11g R1 PS3 (11.1.4) is now available
  23. Oracle Fusion Applications (11g Release 7) 11.1.7 is now available to Download & Install
  24. Oracle Fusion Applications 11.1.8 is now available
  25. Oracle Fusion Applications 11.1.9 is now available : Contact Us if you need help
  26. Free Video : Troubleshoot Fusion Application : FAAdmin User is unable to create new users
  27. Oracle Fusion Apps 11.1.9 : Error showing tasklist : SOA server connection information is not available

The post Oracle Fusion Apps 11.1.9 : Error showing tasklist : SOA server connection information is not available appeared first on Oracle : Design, Implement & Maintain.

Categories: APPS Blogs

Oracle Fusion Middleware (FMW) Training is now closed

Online Apps DBA - Fri, 2015-06-05 13:48

We announced Oracle Fusion Middleware Training on 2nd June and I am excited to say with in 2 days we fully booked (in actual over booked) the training (To maintain quality we limit number of trainees in each batch).

Congratulation if you managed to register and those who couldn’t then We’ll announce here in few months time. Click below (image at end of this post) to register your interest in next batch.

Topic we are going to cover on Day1 

  • Overview & Architecture of Oracle Fusion Middleware
  • Key Concepts : Java VS System Components
  • Various Home in FMW (MW, WLS, ORACLE, DOMAIN, INSTANCE, ORACLE_COMMON)
  • Repository Creation Utility (RCU)
  • Administration & Management
  • High Availability (HA) Overview
  • Disaster Recovery Overview
  • WebLogic Server Domain
  • Administration Server
  • Managed Server
  • WebLogic Console
  • Node Manager
  • Data Sources in WebLogic
  • Installing WebLogic Server (Hands-On)
  • Creating WebLogic Domain (Hands-On)
  • Start/Stop WebLogic Server (Hands-On)
  • File System and Log File (Hands-On)
  • Creating Managed Server from Console (Hands-On)

 

Note: I’ll be conducting Free Session on 12th July 2015 for 1 hour that anyone can join, Register your interest  by clicking below image (Leave comment for topic that you want to see in Free Session)

 

Any queries leave them as comments or Contact-Us

Previous in series Related Posts for FusionM
  1. Oracle Fusion Middleware Part II
  2. Oracle Fusion Middleware Overview
  3. Oracle Fusion Middleware : BEA WebLogic or Oracle Application Server
  4. Oracle Fusion Middleware 11g is coming … 1 July 2009
  5. Oracle Fusion Middleware 11g launched today
  6. Oracle Fusion Middleware 11g concepts for Apps DBA’s
  7. Fusion Middleware 11g – How to register Oracle Instance with Webogic Server (opmnctl) ?
  8. Reader’s Question : How to change hostname, domainname, IP of Fusion Middleware 11g (SOA, WebCenter, WebLogic) ?
  9. Oracle Fusion Middleware 11g R1 patchset 2 (11.1.1.3.0) – SOA, WebCenter, RCU, WebLogic (10.3.3)
  10. Oracle Fusion Middleware Challenge : Can you answer Why different domain home for Admin & Managed Server ?
  11. Beware !!! Oracle Fusion Middleware 11g R1 patchset 2 (11.1.1.3.0) is patch set only
  12. Oracle Fusion Middleware 11g R1 PS 3 (11.1.1.4) available now
  13. Oracle Fusion Middleware 11g R1 PS4 (11.1.1.5) is available now
  14. Cloning Oracle Fusion Middleware 11g (SOA, WebCenter, UCM) – copyBinary, copyConfig, extractMovePlan, pasteBinary, pasteConfig, cloningclient.jar
  15. Fusion Middleware 11g startup issue : OPMN RCV No such file or directory
  16. Oracle Fusion Middleware Start-up Issue : jps-config.xml No such file or directory : startScriptEnabled
  17. #OFMW 11.1.1.6 (SOA, WebCenter, IdM, OBIEE, OHS, ADF, CEP…) is now available
  18. ODL-52049 DMS-Startup oracle.core. ojdl.logging. LogUtil log cannot create instance of class ‘oracle. dfw. incident.Incident DetectionLog Filter’
  19. Oracle Fusion Middleware (FMW) 12.1.2 is available now : WebLogic, Coherence, OWSM, OHS, ADF etc
  20. Oracle Fusion Middleware Installation : java.lang.UnsatisfiedLinkError libmawt.so libXtst.so.6: cannot open shared object file
  21. Oracle Fusion Middleware Training – Win FREE Lesson : Suggest topic to our client
  22. YouTube Sunday : Troubleshoot Fusion Middleware Pre-Requisite Failure : Kernel Setting
  23. Oracle Fusion Middleware (FMW) 11.1.1.9 now available : Documentation & Download
  24. Oracle Fusion Middleware (FMW) Training by Atul Kumar starting on 6th June
  25. Oracle Fusion Middleware (FMW) Training is now closed

The post Oracle Fusion Middleware (FMW) Training is now closed appeared first on Oracle : Design, Implement & Maintain.

Categories: APPS Blogs

Oracle Fusion Middleware (FMW) Training by Atul Kumar starting on 6th June

Online Apps DBA - Tue, 2015-06-02 16:15

oracle_fmw_admin_450

I am starting a new batch of Oracle Fusion Middleware training for Architects/Administrator from 6th June 2015. To maintain quality, We’ve restricted number of trainees in this batch, We’ve now left with last 2 seats.

Course/Training Name : Oracle Fusion Middleware Administration (WLS, SOA, OBIEE, WCS, OHS, SSL, etc )

Course/Training Dates : 6, 7, 13, 14, 20, 21, 27, 28 June (9 -11 AM PST) followed by 4 hours of lab exercise (We provide dedicated machine on cloud and step by step lab exercises).

fmw_450

100% Money Back Guarantee : We’re ready to prove everything we claim. Buy The Course right now, and see it for yourself with-in the first 2 Sessions. If the course is not right for you just inform us after 2 sessions, We’ll refund full Money back to you in next 72 hours with no questions asked.

Still worried for you Money ?
Call Us: US +1 408 627 8021 |  INDIA +91 85 880 97686 (9 AM-5PM GMT only)

Mail Us: support [at] k21technologies.com

Claim your seat by registering for Oracle Fusion Middleware Course from last 2 available seats.

Previous in series Next in seriesRelated Posts for FusionM
  1. Oracle Fusion Middleware Part II
  2. Oracle Fusion Middleware Overview
  3. Oracle Fusion Middleware : BEA WebLogic or Oracle Application Server
  4. Oracle Fusion Middleware 11g is coming … 1 July 2009
  5. Oracle Fusion Middleware 11g launched today
  6. Oracle Fusion Middleware 11g concepts for Apps DBA’s
  7. Fusion Middleware 11g – How to register Oracle Instance with Webogic Server (opmnctl) ?
  8. Reader’s Question : How to change hostname, domainname, IP of Fusion Middleware 11g (SOA, WebCenter, WebLogic) ?
  9. Oracle Fusion Middleware 11g R1 patchset 2 (11.1.1.3.0) – SOA, WebCenter, RCU, WebLogic (10.3.3)
  10. Oracle Fusion Middleware Challenge : Can you answer Why different domain home for Admin & Managed Server ?
  11. Beware !!! Oracle Fusion Middleware 11g R1 patchset 2 (11.1.1.3.0) is patch set only
  12. Oracle Fusion Middleware 11g R1 PS 3 (11.1.1.4) available now
  13. Oracle Fusion Middleware 11g R1 PS4 (11.1.1.5) is available now
  14. Cloning Oracle Fusion Middleware 11g (SOA, WebCenter, UCM) – copyBinary, copyConfig, extractMovePlan, pasteBinary, pasteConfig, cloningclient.jar
  15. Fusion Middleware 11g startup issue : OPMN RCV No such file or directory
  16. Oracle Fusion Middleware Start-up Issue : jps-config.xml No such file or directory : startScriptEnabled
  17. #OFMW 11.1.1.6 (SOA, WebCenter, IdM, OBIEE, OHS, ADF, CEP…) is now available
  18. ODL-52049 DMS-Startup oracle.core. ojdl.logging. LogUtil log cannot create instance of class ‘oracle. dfw. incident.Incident DetectionLog Filter’
  19. Oracle Fusion Middleware (FMW) 12.1.2 is available now : WebLogic, Coherence, OWSM, OHS, ADF etc
  20. Oracle Fusion Middleware Installation : java.lang.UnsatisfiedLinkError libmawt.so libXtst.so.6: cannot open shared object file
  21. Oracle Fusion Middleware Training – Win FREE Lesson : Suggest topic to our client
  22. YouTube Sunday : Troubleshoot Fusion Middleware Pre-Requisite Failure : Kernel Setting
  23. Oracle Fusion Middleware (FMW) 11.1.1.9 now available : Documentation & Download
  24. Oracle Fusion Middleware (FMW) Training by Atul Kumar starting on 6th June
  25. Oracle Fusion Middleware (FMW) Training is now closed

The post Oracle Fusion Middleware (FMW) Training by Atul Kumar starting on 6th June appeared first on Oracle : Design, Implement & Maintain.

Categories: APPS Blogs

pc

OracleApps Epicenter - Sat, 2015-05-30 19:33
From PO to PC and then to Fixed assets. Based on business process decide at what level cost are to be allocated in Projects whether it is at Top level or Task Level. Create Projects in Project Costing Create Task and Sub Task for every Project. Also create Assets that would be created for a […]
Categories: APPS Blogs

Customer Data Hub

OracleApps Epicenter - Sat, 2015-05-30 19:31
Customer Data Hub is a packaged solution which tries to integrate the customer information from a set of heterogeneous systems across the organization and strives to provide a single view across departments. Helps in maintaining clean, reliable and consistent customer data Key Components Oracle Customer Online – provides the UI for the customer data Customer […]
Categories: APPS Blogs

cdh

OracleApps Epicenter - Sat, 2015-05-30 19:30
Oracle Customer Data Hub (CDH) is not a mandate for EBS users. However, it solely depends on the Organizational needs. If an Organization decides to have SSOT (Single Source Of Truth) for it's customer data they can go with CDH solution. CDH is a complete packaged solution that allows companies to create a single, enterprise […]
Categories: APPS Blogs

Oracle Identity & Access Management (IDAM) 11gR2 PS3 – 11.1.2.3 is now available

Online Apps DBA - Thu, 2015-05-21 09:35

oracle_idm_11gr2ps3_1123

 

Oracle Identity & Access Management 11g R2 PS3 (11.1.2.3) is now available (released on 18th May 2015)

  • Documentation for Identity & Access Management 11gR2 PS3 11.1.2.3.0 is here
  • Download Oracle IdM 11gR2 PS3 (11.1.2.3) software from here

 

idm_11gr2ps3

 

Products available as part of Identity & Access Management 11gR2 Ps3 (11.1.2.3) are

  • Oracle Access Management
  • Oracle Identity Manager (Governance)
  • Oracle Entitlement Server
  • Oracle Unified Directory
  • Oracle Mobile Security Suite
  • Oracle Enterprise Single Sign-On
  • Oracle Mobile Authenticator

 

Did you register for our YouTube Channel ?

 

Previous in series Related Posts for IdM
  1. Oracle Identity & Access Management II
  2. Upgrade Oracle Internet Directory/IdM Suite to 10.1.4.2
  3. Oracle Launches Oracle Access Management Suite
  4. Installing Oracle Fusion Middleware (FMW) 11g – Identity Management Components (OID, DIP, OVD, OIF)
  5. Oracle Identity Management Products – OID, OVD, OAM, OIM, ORM, OWSM, OIF, eSSO, OES, OAAM
  6. #OracleIdM 11g webinar : Is this for OAM (Oracle Access Manager) & OIM (Oracle Identity Manager) 11g ?
  7. Installing Oracle Identity Management (OIM & OAM) 11g R1 PS2 (11.1.1.3) : High Level Steps
  8. #OracleIdM 11g : Step by Step Installation of OAM, OIM, OAAM, OAPM, OIN (11.1.1.3.0) – Part I : Load Schema
  9. Part II – Install WebLogic 10.3.3 : #OracleIdM 11g : Step by Step Installation of OAM, OIM, OAAM, OAPM, OIN (11.1.1.3.0)
  10. Part III – Install SOA 11.1.1.2 & Upgrade to 11.1.1.3 : #OracleIdM 11g : Step by Step Installation of OAM, OIM, OAAM, OAPM, OIN (11.1.1.3.0)
  11. Part IV – Install IDAM 11.1.1.3 : #OracleIdM 11g : Step by Step Installation of OAM, OIM, OAAM, OAPM, OIN
  12. Part V : Create Domain : #OracleIdM 11g : Step by Step Installation of OAM, OIM, OAAM, OAPM, OIN
  13. Part VI : Configure Identity Manager (OIM) : #OracleIdM 11g : Step by Step Installation of OAM, OIM, OAAM, OAPM, OIN
  14. Part VII : Install & Configure OIM Design Console : #OracleIdM 11g : Step by Step Installation of OAM, OIM, OAAM, OAPM, OIN
  15. OAM 11g / OIM 11g High Availability (Active / Active) Architecture Documentation
  16. Part VIII (Optional) Configure LDAP Sync with OIM 11g (OIM 11g Integration with OVD/OID)
  17. Looking for Technical Reviewer for Oracle Identity & Access Management Book (OIM/OAM Administration)
  18. My Book “Oracle Identity & Access Manager 11g for Administrators” is now available in RAW format
  19. Install Oracle Identity Management (OIM/IDM) 11.1.1.4 – OID / OVD / OIF : High Level Steps
  20. Oracle IDentity & Access Management (OAM, OIM, OAAM & OES) 11.1.1.5 is available now : 12575064
  21. Password Policy in OAM-OIM-OID Integration : User not locked after configured value
  22. IdmConfigTool : OIM/OAM/FusionApps Integration – preConfigIDStore, prepareIDStore, configOAM, configOIM
  23. Autologin failed in OIM/OAM Integration after password reset SSOAccessKey javax.security. auth.login. LoginException
  24. OIM 11.1.1.5 BP02 (13399365) and OAM 11.1.1.5 BP02 (13115859)
  25. Confused about Oracle IAM software version & release number ?
  26. Oracle Identity Management 11g R2 #oracleidm : Webcast
  27. Oracle Identity Management 11g R2 documentation now available
  28. Oracle Identity & Access Management 11gR2 Software is now available to download
  29. Oracle Identity & Access Management 11gR2 : Installation & Configuration in 12 Steps
  30. OIM-OAM-OAAM integration using TAP – Request Flow you must understand !!
  31. Account Lock in OIM OAM OAAM, OID & WebLogic 11g because of Failed Login Attempts
  32. User not synced from OID (LDAP) to OIM (LDAPsync) : Account Locked in OAM is not locked in OIM
  33. Oracle IAM 11gR2 PS2 (11.1.2.2) is now available : Software download & Documentation
  34. Oracle IAM 11.1.2.2 Certification Matrix – Supported JDK, WebLogic, OS
  35. Oracle Identity & Access Management (IDAM) 11gR2 PS3 – 11.1.2.3 is now available

The post Oracle Identity & Access Management (IDAM) 11gR2 PS3 – 11.1.2.3 is now available appeared first on Oracle : Design, Implement & Maintain.

Categories: APPS Blogs

Free Video : Troubleshoot Fusion Application : FAAdmin User is unable to create new users

Online Apps DBA - Mon, 2015-05-18 08:44

Last week We launched our YouTube Channel covering videos related to Oracle Apps, Fusion Middleware,  Fusion Applications, and database and since then 70 new users subscribed .

Today we added new video related to Oracle Fusion Applications issue that we encountered for one of our customer (Contact Us if you need any help to install and manage Oracle Fusion Applications or want us to host your Oracle Fusion Applications)

 

 

Thanks for those who subscribed and if you have not yet then Click here to subscribe to our YouTube Channel

Leave comment on what videos you would like to see (We’ll be posting videos every Sunday), Should we post on Oracle Apps 12.2 or Fusion Middleware or Oracle Identity Management or ………

Previous in series Next in seriesRelated Posts for Fusion Apps
  1. Oracle Fusion Applications Overview
  2. Oracle Fusion Application for Apps DBAs – Concepts
  3. Install Oracle Fusion Applications in 10 Steps
  4. Oracle Fusion Applications : Provisioning Framework Overview
  5. Oracle Fusion Applications : Provisioning Framework Installation
  6. Provision Transaction Database for Oracle Fusion Applications
  7. Create Fusion Applications Schema using RCU : fusion & otbi
  8. Fusion Application 11.1.1.5.1 is now available
  9. Fusion Apps Installation : Database Provisioning Failed during listener start
  10. Fusion Applications : 128 GB memory and 500 GB Disk space : Are you ready
  11. Fusion Applications 11.1.1.5.1 Part I – Install Identity and Access Management (OID/OAM/OIM) 11g
  12. Fusion Applications 11.1.1.5.1 Installation Part II – Configure Oracle Internet Directory
  13. Fusion Applications 11.1.1.5.1 Installation Part III – Configure Policy and Identity Store
  14. Fusion Applications 11.1.1.5.1 Installation Part IV – Extend WebLogic Domain to include OIM/OAM and configure OIM
  15. Fusion Applications 11.1.1.5.1 Installation Part V – Integrate OIM with OAM
  16. Oracle Fusion Application 11.1.3 is now available
  17. Oracle Fusion Applications 11.1.3 Installation Experience
  18. FA Installation Error : runProvisioning-preverify FAPROV-00298 make sure password FUSION_RUNTIME schema password is valid
  19. FA Installation Error 2 – List of failed Validation in OIM OAM_Validation: Cannot perform OAM Validation as null
  20. Identity & Access Management configuration for Oracle Fusion Applications – Part I
  21. Oracle FA Installation Error 3: private-preverify-free-space The file system only has 190113 MB, but 204800 MB is needed
  22. Oracle Fusion Applications (FA) 11g R1 PS3 (11.1.4) is now available
  23. Oracle Fusion Applications (11g Release 7) 11.1.7 is now available to Download & Install
  24. Oracle Fusion Applications 11.1.8 is now available
  25. Oracle Fusion Applications 11.1.9 is now available : Contact Us if you need help
  26. Free Video : Troubleshoot Fusion Application : FAAdmin User is unable to create new users
  27. Oracle Fusion Apps 11.1.9 : Error showing tasklist : SOA server connection information is not available

The post Free Video : Troubleshoot Fusion Application : FAAdmin User is unable to create new users appeared first on Oracle : Design, Implement & Maintain.

Categories: APPS Blogs

Oracle Fusion Middleware (FMW) 11.1.1.9 now available : Documentation & Download

Online Apps DBA - Fri, 2015-05-15 13:19


Oracle_FMW_11.1.1.9

Oracle Fusion Middleware (FMW) 11.1.1.9 is now available (released on 13th May 2015).

 

Following Fusion Middleware Components are release as part of Fusion Middleware 11.1.1.9 update

  • Oracle Jdevloper & ADF
  • Oracle Business Intelligence Enterprise Edition (OBIEE)
  • Oracle SOA Suite
  • Oracle BPMS
  • Oracle Data Integrator (ODI)
  • Oracle Identity & Access Management (OID, OVD, OIM, DIP, ODSM)
  • Oracle Application Integration Architecture (AIA)
  • Oracle Web Tier (OHS)
  • Oracle Forms & reports
  • Oracle User Messaging Service (UMS)
  • Oracle Enterprise Scheduler

 

Stay tuned for new features in 11.1.1.9 Oracle Identity & Access Management

 

Did you subscribed to our YouTube Channel for any Video Tutorials on Oracle products ?

Previous in series Next in seriesRelated Posts for FusionM
  1. Oracle Fusion Middleware Part II
  2. Oracle Fusion Middleware Overview
  3. Oracle Fusion Middleware : BEA WebLogic or Oracle Application Server
  4. Oracle Fusion Middleware 11g is coming … 1 July 2009
  5. Oracle Fusion Middleware 11g launched today
  6. Oracle Fusion Middleware 11g concepts for Apps DBA’s
  7. Fusion Middleware 11g – How to register Oracle Instance with Webogic Server (opmnctl) ?
  8. Reader’s Question : How to change hostname, domainname, IP of Fusion Middleware 11g (SOA, WebCenter, WebLogic) ?
  9. Oracle Fusion Middleware 11g R1 patchset 2 (11.1.1.3.0) – SOA, WebCenter, RCU, WebLogic (10.3.3)
  10. Oracle Fusion Middleware Challenge : Can you answer Why different domain home for Admin & Managed Server ?
  11. Beware !!! Oracle Fusion Middleware 11g R1 patchset 2 (11.1.1.3.0) is patch set only
  12. Oracle Fusion Middleware 11g R1 PS 3 (11.1.1.4) available now
  13. Oracle Fusion Middleware 11g R1 PS4 (11.1.1.5) is available now
  14. Cloning Oracle Fusion Middleware 11g (SOA, WebCenter, UCM) – copyBinary, copyConfig, extractMovePlan, pasteBinary, pasteConfig, cloningclient.jar
  15. Fusion Middleware 11g startup issue : OPMN RCV No such file or directory
  16. Oracle Fusion Middleware Start-up Issue : jps-config.xml No such file or directory : startScriptEnabled
  17. #OFMW 11.1.1.6 (SOA, WebCenter, IdM, OBIEE, OHS, ADF, CEP…) is now available
  18. ODL-52049 DMS-Startup oracle.core. ojdl.logging. LogUtil log cannot create instance of class ‘oracle. dfw. incident.Incident DetectionLog Filter’
  19. Oracle Fusion Middleware (FMW) 12.1.2 is available now : WebLogic, Coherence, OWSM, OHS, ADF etc
  20. Oracle Fusion Middleware Installation : java.lang.UnsatisfiedLinkError libmawt.so libXtst.so.6: cannot open shared object file
  21. Oracle Fusion Middleware Training – Win FREE Lesson : Suggest topic to our client
  22. YouTube Sunday : Troubleshoot Fusion Middleware Pre-Requisite Failure : Kernel Setting
  23. Oracle Fusion Middleware (FMW) 11.1.1.9 now available : Documentation & Download
  24. Oracle Fusion Middleware (FMW) Training by Atul Kumar starting on 6th June
  25. Oracle Fusion Middleware (FMW) Training is now closed

The post Oracle Fusion Middleware (FMW) 11.1.1.9 now available : Documentation & Download appeared first on Oracle : Design, Implement & Maintain.

Categories: APPS Blogs

OAM/WebGate troubleshooting : WebGate on Apache/OHS Unable to read the configuration file

Online Apps DBA - Thu, 2015-05-14 04:15
This post is from one of customer engagement where we implemeted and now support complete Oracle Identity & Access Management ( Contact Us If you are looking for Oracle Support or Implementation Partner) .  When you protect a resource on Oracle Access Manager (OAM) you configure WebGate on WebServer (OHS, Apache or IIS) acting as Policy Enforcement Point (PEP). In OAM […] The post OAM/WebGate troubleshooting : WebGate on Apache/OHS...

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!
Categories: APPS Blogs

java.sql.SQLException: Invalid number format for port number

Vikram Das - Wed, 2015-05-13 17:11
Jim pinged me with this error today:
on ./adgendbc.sh i getCreating the DBC file...java.sql.SQLRecoverableException: No more data to read from socket raised validating GUEST_USER_PWDjava.sql.SQLRecoverableException: No more data to read from socketUpdating Server Security Authenticationjava.sql.SQLException: Invalid number format for port numberDatabase connection to jdbc:oracle:thin:@host_name:port_number:database failedto this point, this is what i've tried.clean, autoconfid on db tier, autoconfig on cm same resultsbounced db and listener.. same thing.. nothing i've done has made a difference
I noticed that when this error was coming the DB alert log was showing:
Wed May 13 18:50:51 2015Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x10A2FFBC8, joet_create_root_thread_group()+136] [flags: 0x0, count: 1]Errors in file /r12.1/admin/diag/rdbms/erp/erp/trace/erp_ora_14528.trc  (incident=1002115):ORA-07445: exception encountered: core dump [joet_create_root_thread_group()+136] [SIGSEGV] [ADDR:0x8] [PC:0x10A2FFBC8] [Address not mapped to object] []Incident details in: /r12.1/admin/diag/rdbms/erp/erp/incident/incdir_1002115/erp_ora_14528_i1002115.trc
Metalink search revealed this article:
Java Stored Procedure Fails With ORA-03113 And ORA-07445[JOET_CREATE_ROOT_THREAD_GROUP()+145] (Doc ID 1995261.1)
It seems that the post patch steps for a PSU OJVM patch were not done.  We followed the steps given in above note were note completed. We completed these and adgendbc.sh completed successfully after that.

1.set the following init parameters so that JIT and job process do not start.

If spfile is used:

SQL> alter system set java_jit_enabled = FALSE;
SQL> alter system set "_system_trig_enabled"=FALSE;
SQL> alter system set JOB_QUEUE_PROCESSES=0;

2. Startup instance in restricted mode and run postinstallation step.

SQL> startup restrict

3.Run the postinstallation steps of OJVM PSU(Step 3.3.2 from readme)PostinstallationThe following steps load modified SQL files into the database. For an Oracle RAC environment, perform these steps on only one node.
  1. Install the SQL portion of the patch by running the following command. For an Oracle RAC environment, reload the packages on one of the nodes.
2. cd $ORACLE_HOME/sqlpatch/192820153. sqlplus /nolog4. SQL> CONNECT / AS SYSDBA5. SQL> @postinstall.sql
  1. After installing the SQL portion of the patch, some packages could become INVALID. This will get recompiled upon access or you can run utlrp.sql to get them back into a VALID state.
7. cd $ORACLE_HOME/rdbms/admin8. sqlplus /nolog9. SQL> CONNECT / AS SYSDBASQL> @utlrp.sql

4. Reset modified init parameters

SQL> alter system set java_jit_enabled = true;
SQL> alter system set "_system_trig_enabled"=TRUE;
SQL> alter system set JOB_QUEUE_PROCESSES=10;
        -- or original JOB_QUEUE_PROCESSES value

5.Restart instance as normal6.Now execute the Java stored procedure.

Ran adgendbc.sh and it worked fine.
Categories: APPS Blogs

YouTube Sunday : Troubleshoot Fusion Middleware Pre-Requisite Failure : Kernel Setting

Online Apps DBA - Sat, 2015-05-09 19:13
    We’ve started our YouTube Channel covering videos related to Oracle Apps, Fusion Middleware,  Fusion Applications, and database (Subscribe to our Channel by clicking link above to get latest videos). We’ll be posting Videos every Sunday and this weeks Video is on how to fix Oracle Fusion Middleware Installation Pre-Requisite Failure related to kernel setting .     […] The post YouTube Sunday :...

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!
Categories: APPS Blogs

Oracle Fusion Middleware Training – Win FREE Lesson : Suggest topic to our client

Online Apps DBA - Tue, 2015-05-05 17:42
  We have trained hundred of corporate clients on Oracle Fusion Middleware & Oracle Apps DBA in last 8 years where either customer suggest topics to cover in training or We help them to come up with training topics based on background of team (Apps DBAs, Middleware Admins, Architects and sometime developers).   Something interesting happened this week while […] The post Oracle Fusion Middleware Training – Win FREE Lesson :...

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!
Categories: APPS Blogs

R12.2 Single file system

Vikram Das - Wed, 2015-04-29 23:21
With the release of AD and TXK Delta 6, Oracle has provided the feature of single file system on development instances for R12.2. Here's what they have mentioned in support.oracle.com article: Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 (Doc ID 1983782.1)
Enhancements in AD and TXK Delta 6
4. New and Changed FeaturesOracle E-Business Suite Technology Stack and Oracle E-Business Suite Applications DBA contain the following new or changed features in R12.AD.C.Delta.6 and R12.TXK.C.Delta.6.4.1 Support for single file system development environments
  • A normal Release 12.2 online patching environment requires one application tier file system for the run edition, and another for the patch edition. This dual file system architecture is fundamental to the patching of Oracle E-Business Suite Release 12.2 and is necessary for production environments and test environments that are meant to be representative of production. This enhancement makes it possible to have a development environment with a single file system, where custom code can be built and tested. A limited set of adop phases and modes are available to support downtime patching of such a development environment. Code should then be tested in standard dual file system test environments before being applied to production.
More details are provided in Oracle E-Business Suite Maintenance Guide, Chapter: Patching Procedures):
http://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm#6169002 

Support for Single File System Development Environments
A normal Release 12.2 online patching environment requires two application tier file systems, one for the run edition and another for the patch edition. This dual file system architecture is fundamental to patching of Oracle E-Business Suite Release 12.2, and is necessary both for production environments and test environments that are intended to be representative of production. This feature makes it possible to create a development environment with a single file system, where custom code can be built and tested. The code should then always be tested in a standard dual file system test environment before being applied to production.
You can set up a single file system development environment by installing Oracle E-Business Suite Release 12.2 in the normal way, and then deleting the $PATCH_BASE directory with the command:
$ rm -rf $PATCH_BASE
A limited set of adop phases and modes are available to support patching of a single file system development environment. These are:
·         apply phase in downtime mode·         cleanup phaseSpecification of any other phase or mode will cause adop to exit with an error.
The following restrictions apply to using a single file system environment:
·         You can only use a single file system environment for development purposes.·         You cannot use online patching on a single file system environment.·         You can only convert an existing dual file system environment to a single file system: you cannot directly create a single file system environment via Rapid Install or cloning.·         There is no way to convert a single file system environment back into a dual file system.
·         You cannot clone from a single file system environment.
Categories: APPS Blogs

You Are Trying To Access a Page That Is No Longer Active.The Referring Page May Have Come From a Previous Session. Please Select Home To Proceed

Vikram Das - Wed, 2015-04-15 16:06
Shahed pinged me about this error.  It was coming after logging in.  This R12.1.3 instance had just migrated from an old server to a new one. Once you logged in this error would be displayed:

You Are Trying To Access a Page That Is No Longer Active.The Referring Page May Have Come From a Previous Session. Please Select Home To Proceed

The hits on support.oracle.com were not helpful, but a gave a clue that it may have something to do with session cookie.  So I used Firefox to check http headers.  If you press Ctrl+Shift+K, you will get a panel at the bottom of the browser. Click on Network tab, click on the AppsLocalLogin.jsp and on the right side of the pane, you'll see a cookie tab.

The domain appearing in the cookie tab was from the old server.  So I checked:

select session_cookie_domain from icx_parameters;
olddomain.justanexample.com

So I nullified it:

update icx_parameters set session_cookie_domain=null;

commit;

Restarted Apache

cd $ADMIN_SCRIPTS_HOME
adapcctl.sh stop
adapcctl.sh start

No more error.  I was able to log in and so was Shahed.
Categories: APPS Blogs

Chrome and E-Business Suite

Vikram Das - Wed, 2015-04-15 12:23
Dhananjay came to me today.  He said that his users were complaining about forms not launching after upgrading to the latest version of Chrome. On launching forms they got this error:

/dev60cgi/oracle forms engine Main was not found on this server

I recalled that Google Chrome team had announced that they would not support java going forward. Googling with keywords chrome java brought this page:

https://java.com/en/download/faq/chrome.xml#npapichrome

It states that:

NPAPI support by ChromeThe Java plug-in for web browsers relies on the cross platform plugin architecture NPAPI, which has long been, and currently is, supported by all major web browsers. Google announced in September 2013 plans to remove NPAPI support from Chrome by "the end of 2014", thus effectively dropping support for Silverlight, Java, Facebook Video and other similar NPAPI based plugins. Recently, Google has revised their plans and now state that they plan to completely remove NPAPI by late 2015. As it is unclear if these dates will be further extended or not, we strongly recommend Java users consider alternatives to Chrome as soon as possible. Instead, we recommend Firefox, Internet Explorer and Safari as longer-term options. As of April 2015, starting with Chrome Version 42, Google has added an additional step to configuring NPAPI based plugins like Java to run — see the section Enabling NPAPI in Chrome Version 42 and later below.Enabling NPAPI in Chrome Version 42 and laterAs of Chrome Version 42, an additional configuration step is required to continue using NPAPI plugins.
  1. In your URL bar, enter:
    chrome://flags/#enable-npapi 
  2. Click the Enable link for the Enable NPAPI configuration option.
  3. Click the Relaunch button that now appears at the bottom of the configuration page.
Developers and System administrators looking for alternative ways to support users of Chrome should see this blog, in particular "Running Web Start applications outside of a browser" and "Additional Deployment Options" section.Once Dhananjay did the above steps, Chrome started launching forms again.  He quickly gave these steps to all his users who had upgraded to the latest version of Chrome (version 42) and it started working form them too.Oracle doesn't certify E-Business Suite forms on Chrome.  Only self service pages of E-Business Suite are certified on Google Chrome.
Categories: APPS Blogs