Thursday, March 31, 2016
Wednesday, March 30, 2016
The oraoledb.oracle provider is not registered (Doc ID 1567025.1)
The oraoledb.oracle provider is not registered (Doc ID 1567025.1)
APPLIES TO:
Oracle Enterprise Single Sign-On Suite Plus - Version 11.1.2.1.0 and later
Information in this document applies to any platform.
SYMPTOMS
On a Password Reset server using an Oracle database repository, the following error is seen in the management console;
"the oraoledb.oracle provider is not registered"
CAUSE
Since the Self Service Password Reset application is running in 32 bit mode, the 32 bit oracle client must be installed, despite this being a 64 bit server. This error is seen when the 64 bit oracle client is installed and not the 32 bit.
SOLUTION
Installing the 32 bit oracle client resolves this issue.
Setting Up an ODBC Data Source for Oracle
https://msdn.microsoft.com/en-us/library/ms709329(v=vs.85).aspx
http://www.interfaceware.com/manual/odbc_oracle.html
You can control performance of the ODBC Driver for Oracle by knowing the data environment and correctly setting the parameters of the data source connection through the ODBC Data Source Administrator dialog box or through connect string parameters. The dialog box provides the following controls for connecting to a data source using the dialog box or using connect strings:
User DSN tab Lists the Data Source Names that are local to the computer.
System DSN tab Enables you to add or remove a system data source. System data sources can be accessed by all users on the local computer.
File DSN tab Enables you to add or remove a file data source from the local computer. File data sources can be shared by all users who have the same driver installed.
Drivers tab Lists the installed ODBC drivers.
Tracing tab Enables you to specify how the ODBC Driver Manager traces calls to ODBC functions. You can configure tracing separately for each installed ODBC application.
Connection Pooling tab Enables you to select connection options for each installed driver.
Oracle Enterprise Single Sign On Templates for Microsoft Outlook , Oracle Sites and OAM
How to publish application templates to multiple ESSO-LM clients in standalone mode (Doc ID 1357320.1)
eSSO: Sample Template To Logon To Oracles Public Sites, Including My Oracle Support (Doc ID 1185134.1)
eSSO Integration With Oracle Access Manager (Doc ID 757519.1)
eSSO: Creating An Application Template For MS Outlook (Doc ID 605486.1)
Esso: Logon Manager Agent Does Not Respond To Oracle eBusiness 12 Login Page (Doc ID 982866.1)
Master Note: Oracle Identity Manager Integration With eSSO Provisioning Gateway (Doc ID 1092733.1)
Configuring eSSO-LM For The Cisco Any Connect VPN Client Application (Doc ID 1338057.1)
eSSO Sample Application Template Repository (Doc ID 758717.1)
Integrating eSSO with other Oracle applications
Note 757519.1 eSSO Integration With Oracle Access Manager
Note 757518.1 eSSO Integration With Oracle SSO
Note 758708.1 eSSO Defining Templates For Oracle Identity Manager
Note 1185134.1 eSSO Sample Template To Logon To Oracles Public Sites, Including My Oracle Support
Note 759613.1 eSSO Integrating With PeopleSoft Web Client
Note 740025.1 eSSO Will Not Auto Login To Peoplesoft HR
Note 798425.1 eSSO Cannot Detect Oracle Files Confirmation Page
External common applications
Note 412967.1 eSSO Putty autologin to Unix server
Note 605486.1 eSSO Creating An Application Template For MS Outlook
Note 603247.1 eSSO Integrating With Terminal Services Client
Note 1280941.1eSSO: Sample Template To Logon To Lotus Notes On A Windows 7 Client
Generic integration scenarios
Note 470492.1 eSSO How To Integrate an Application Having Windows Based Login and Web Based Password Change
Note 549756.1 eSSO Detection Matching For Web Applications Where URL Remains Unchanged
Note 1187745.1eSSO: How To Create an Application Template For a Page Displayed In an Iframe?
REFERENCES
NOTE:1185134.1 - eSSO: Sample Template To Logon To Oracles Public Sites, Including My Oracle Support
NOTE:1187745.1 - How To Create an Application Template For a Page Displayed In an Iframe?
NOTE:1280941.1 - Sample Template To Logon To Lotus Notes On A Windows 7 Client
NOTE:412967.1 - ESSO - Putty autologin to Unix server
NOTE:470492.1 - How To Integrate an Application Having Windows Based Login and Web Based Password Change
NOTE:549756.1 - Detection Matching For Web Applications.
NOTE:603247.1 - eSSO: Integrating With Terminal Services Client
NOTE:605486.1 - eSSO: Creating An Application Template For MS Outlook
NOTE:740025.1 - Esso Will Not Auto Login To Peoplesoft HR
NOTE:757519.1 - eSSO Integration With Oracle Access Manager
NOTE:798425.1 - ESSO CANNOT DETECT ORACLE FILES CONFIRMATION PAGE
isscript1150.msi
Today I was trying to install and configure Oracle Enterprise Single Sign On .
One of the pre-requsiste was to install isscript1150.msi file .
I tried to download the software ..but this version is not available .
Finally I found this in the same ESSO Logon Manager 11.1.1.5.1 ,utility folder .
Sharing this ,to save your time if you are also trying to get this isscript1150.msi :-)
Tuesday, March 29, 2016
ORACLE CRM SOLUTIONS
Please refer this link for more information
http://www.enterpriseappstoday.com/crm/oracle-crm-buying-guide.html
Oracle offers four customer relationship management (CRM) products within its enterprise applications portfolio – which one is right for you?
It's not quite the 57 varieties of Heinz or the 31 flavors of Baskin Robbins, but Oracle provides a hearty number of customer relationship management (CRM) products within its enterprise applications portfolio – four to be exact.
• Oracle CRM On Demand
• Oracle E-Business Suite (EBS) CRM
• Oracle PeopleSoft Enterprise CRM
Five Steps to Manage the Customer Journey for B2B Success Download Now
• Oracle Siebel CRM
A couple of these came to it through acquisitions – most notably Siebel and PeopleSoft.
Related Articles
8 Must-Have Two-Tier ERP Features
Clari Intros Sales Analytics Tool to Enhance Pipeline Visibility
Startup Spotlight: Evergage's Personalization Platform
7 Marketing Automation Leaders
Marketing Automation's Star Is Rising
So when it comes time to choosing CRM products, which Oracle flavor is the right one to consider?
William Band of Forrester agrees with this simplistic overview:
Deploy Oracle EBS CRM and Oracle Peoplesoft CRM if you already have the EBS or Peoplesoft Enterprise Resource Product (ERP) products running.
Otherwise, choose Oracle On Demand CRM if you want Software as a Service (SaaS), or Oracle Siebel CRM if you want enterprise-class CRM.
"Oracle EBS CRM and Oracle PeopleSoft CRM are fading into the background and not getting much investment and development for the future," said Band. "Oracle Siebel CRM remains Oracle's flagship product and receives the bulk of Oracle's investment and attention."
Other analysts concur with this assessment. Gartner, for example, placed Oracle Siebel CRM and Oracle CRM On Demand in the leader's segment of its recent Magic Quadrant.
Let's take a look at each of the four products.
Oracle Siebel CRM
Oracle describes Siebel CRM as the world's most complete CRM solution. It is available as on premises and on demand, as well as in specific tailored versions for government and other verticals. It includes modules for such areas as sales force automation, quote & order capture, marketing, contact center, e-Billing and partner relationships.
"Oracle Siebel CRM's notable recent changes include significant success with the Siebel Loyalty Management solution," said Band. "Oracle Siebel CRM is still the most full-featured CRM solution, with a breadth and depth of functionality for many industry verticals."
He added that the company had been doing a lot of work to lower total cost of ownership (TCO) by introducing more pre-integration with other solutions and offering "rapid implementation" methodologies and tools to reduce upgrade costs.
Oracle CRM On Demand
Oracle CRM On Demand offers most of the features of Siebel CRM, but is a hosted solution. It's most recent iteration, Oracle CRM On Demand Release 19, introduces new cloud and mobility features such as iPad tablet, iPhone, BlackBerry and Microsoft Outlook support. Updates happen automatically across the system so that sales people accessing data won't be fed out of date information. The interface has been adapted to give the same look as Microsoft Outlook, which makes it easier to learn and use.
"Oracle CRM On Demand continues to be the focus of Oracle's play in the CRM SaaS solution segment with steadily enhanced capabilities and a sound future road map, including industry vertical functional enhancement," said Band. "A significant new development was Oracle's acquisition of Market2Lead, a lead management solution that includes tools for landing pages and microsites, digital prospect tracking, progressive profiling, lead scoring, email marketing, nurture campaigns, automated distribution of sales-ready leads to the sales team and marketing analytics. This fills a gap in the Oracle CRM On Demand solution footprint that Salesforce.com does not have."
He gives Oracle CRM On Demand high marks for ease of use and relatively fast deployment time.
Oracle PeopleSoft CRM
Oracle PeopleSoft Enterprise CRM is a family of applications in Oracle's PeopleSoft Enterprise product suite. This includes analytics, marketing, sales, service, partner relations and versions for specific industries. Band recommends it for people who already have PeopleSoft in operation for ERP.
"Oracle EBS CRM and Oracle PeopleSoft Enterprise CRM are good options for ERP customers," said Band. "ERP integration is a strength of PeopleSoft Enterprise CRM, which has unique functionality to meet the relationship management needs of the higher-education sector and offers new solutions to support human resources professionals."
Oracle E-Business Suite CRM
From measuring marketing campaigns to automatically dispatching field technicians to remote locations, Oracle has more than 50 CRM-specific applications as part of EBS CRM.
"Oracle EBS CRM attracts customers by providing ease of integration into the rest of the Oracle EBS suite and offering strengths in field service and sales compensation management," according to Band.
Fusion CRM: Coming Soon
Interestingly, the Oracle CRM landscape is scheduled for a major change in the near future. It is likely, of course, that EBS and PeopleSoft CRM will fade gradually from view. This will be accelerated by the release of Oracle's new line of Fusion applications, which are being developed right now and are in the early stages of deployment.
CEO Larry Ellison announced the release of Fusion at Oracle World last year. He said that in time it will replace all Oracle, PeopleSoft, JDEdwards and Siebel middleware as well as all as all the applications that run on them. This will have a fundamental impact on Oracle's CRM product lines.
"Fusion has a modern familiar interface with collaboration and social networking built in," said Ellison.
It will be available on premise, in a public cloud, private cloud or in a hybrid arrangement. A key design principal is for the new version of Fusion to be business intelligence-driven, as opposed to just having BI functionality built in.
"Information age ERP, CRM and HRMS provides insight as to who you should buy from," said Ellison. "Instead of having to ask developers to make changes, Fusion applications will be accessible by business managers who can adjust them to suit their needs."
As Fusion rolls out, then, look for it to become the dominant flavor of Oracle CRM.
For more on CRM, see our small business, midmarket and enterprise CRM buying guides. And for the latest on Oracle's CRM offerings, see An In-Depth Look at Oracle Fusion Applications.
Thursday, March 17, 2016
SQL Script to check the status of Concurrent Managers in Oracle EBS
We check the status of Concurrent Managers from the console like below .
System Administrator >> Concurrent : Manager >> Administer
We get the Actual and Target processes for a concurrent manager and if they are nonzero or same , we conclude that the CM is working fine.
We can also check the status of CM from the backend using the below SQL Script .
select decode(CONCURRENT_QUEUE_NAME,'FNDICM','Internal Manager','FNDCRM','Conflict Resolution Manager','AMSDMIN','Marketing Data Mining Manager','C_AQCT_SVC','C AQCART Service','FFTM','FastFormula Transaction Manager','FNDCPOPP','Output Post Processor','FNDSCH','Scheduler/Prereleaser Manager','FNDSM_AQHERP','Service Manager: AQHERP','FTE_TXN_MANAGER','Transportation Manager','IEU_SH_CS','Session History Cleanup','IEU_WL_CS','UWQ Worklist Items Release for Crashed session','INVMGR','Inventory Manager','INVTMRPM','INV Remote Procedure Manager','OAMCOLMGR','OAM Metrics Collection Manager','PASMGR','PA Streamline Manager','PODAMGR','PO Document Approval Manager','RCVOLTM','Receiving Transaction Manager','STANDARD','Standard Manager','WFALSNRSVC','Workflow Agent Listener Service','WFMLRSVC','Workflow Mailer Service','WFWSSVC','Workflow Document Web Services Service','WMSTAMGR','WMS Task Archiving Manager','XDP_APPL_SVC','SFM Application Monitoring Service','XDP_CTRL_SVC','SFM Controller Service','XDP_Q_EVENT_SVC','SFM Event Manager Queue Service','XDP_Q_FA_SVC','SFM Fulfillment Actions Queue Service','XDP_Q_FE_READY_SVC','SFM Fulfillment Element Ready Queue Service','XDP_Q_IN_MSG_SVC','SFM Inbound Messages Queue Service','XDP_Q_ORDER_SVC','SFM Order Queue Service','XDP_Q_TIMER_SVC','SFM Timer Queue Service','XDP_Q_WI_SVC','SFM Work Item Queue Service','XDP_SMIT_SVC','SFM SM Interface Test Service') as "Concurrent Manager's Name", max_processes as "TARGET Processes", running_processes as "ACTUAL Processes" from apps.fnd_concurrent_queues where CONCURRENT_QUEUE_NAME in ('FNDICM','FNDCRM','AMSDMIN','C_AQCT_SVC','FFTM','FNDCPOPP','FNDSCH','FNDSM_AQHERP','FTE_TXN_MANAGER','IEU_SH_CS','IEU_WL_CS','INVMGR','INVTMRPM','OAMCOLMGR','PASMGR','PODAMGR','RCVOLTM','STANDARD','WFALSNRSVC','WFMLRSVC','WFWSSVC','WMSTAMGR','XDP_APPL_SVC','XDP_CTRL_SVC','XDP_Q_EVENT_SVC','XDP_Q_FA_SVC','XDP_Q_FE_READY_SVC','XDP_Q_IN_MSG_SVC','XDP_Q_ORDER_SVC','XDP_Q_TIMER_SVC','XDP_Q_WI_SVC','XDP_SMIT_SVC');
Save this as CheckCMStatus.sql
Connect as apps and run the above script.
sqlplus apps/******
SQL> set pagesize 9999
SQL> @CheckCMStatus.sql
Concurrent Manager's Name TARGET Processes ACTUAL Processes
---------------------------------------------- ---------------- ----------------
Service Manager: AQHERP 1 1
Output Post Processor 1 1
Workflow Document Web Services Service 1 1
WMS Task Archiving Manager 2 2
Marketing Data Mining Manager 5 5
Conflict Resolution Manager 1 1
Internal Manager 1 1
Scheduler/Prereleaser Manager 1 1
Standard Manager 10 10
PO Document Approval Manager 3 3
Receiving Transaction Manager 3 3
FastFormula Transaction Manager 1 1
PA Streamline Manager 1 1
Inventory Manager 5 5
INV Remote Procedure Manager 5 5
Workflow Agent Listener Service 1 1
Workflow Mailer Service 1 1
Transportation Manager 10 10
C AQCART Service 1 1
Session History Cleanup 1 1
UWQ Worklist Items Release for Crashed session 1 1
SFM Controller Service 1 1
SFM Order Queue Service 1 1
SFM Work Item Queue Service 1 1
SFM Fulfillment Actions Queue Service 1 1
SFM Fulfillment Element Ready Queue Service 1 1
SFM Event Manager Queue Service 1 1
SFM Inbound Messages Queue Service 1 1
SFM Timer Queue Service 1 1
SFM Application Monitoring Service 1 1
SFM SM Interface Test Service 1 1
OAM Metrics Collection Manager 1 1
32 rows selected.
I got this information from the below link .follow his blog for more..
https://muneer2908.wordpress.com/2011/01/02/checking-the-status-of-all-concurent-managers-from-backend/?blogsub=confirming#blog_subscription-3
Wednesday, March 16, 2016
Arabic Font Issue in Printing Oracle EBS 12.1.3
Issue : Arabic Font Issue in Oracle EBS 12.1.3
This is a fresh installation and trying to print Report in Arabic Font for the first time
NLS Patch for Arabic has already applied.
Arabic font is coming properly while viewing in the browser and also while giving print from the browser.
But When trying to print the report from the EBS Application Arabic font is coming in junk/reverse order( That is from Left to Right ) .
Solution: Follow this document and change/add the parameters in the config file mentioned in the DOC ID
“Pasta For Arabic? (Doc ID 816879.1)
Subscribe to:
Posts (Atom)