Syed Saad Ali
Syed Saad Ali
Month: September 2017
September 16, 2017
What’s New in EBS 12.2.7?
NEWS AND UPDATES
What’s New in EBS 12.2.7?
EBS 12.2.7 is the latest update to E-Business Suite 12.2. It includes functionality enhancements, error corrections, and statutory and regulatory updates in a consolidated suite-wide patch set.
Release 12.2.7 is cumulative and includes updates released previously for earlier EBS releases including 12.1.3, 12.0, and 11.5.10. It includes bug fixes for the following major product areas:
- Applications Technology
- Asset Lifecycle Management
- Channel Revenue Management
- Financials
- Human Capital Management
- Lease and Finance Management
- Logistics
- Manufacturing
- Master Data Management
- Order Management & Contracts
- Procurement
- Contract Lifecycle Management for Public Sector
- Projects
- Sales, Marketing, and eCommerce
- Service Management
- Value Chain Planning
EBS 12.2.7 includes new functionality for the following major product families:
- Iprocurement
- Procurement
- Project Procurement
- Projects
- Order Management
- Logistics
- Manufacturing
- Value Chain Planning
- Asset Management
For a complete list of new features, refer to:
- Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)
September 15, 2017
What is Oracle E-Business Suite on Oracle Cloud?
NEWS AND UPDATES
What is Oracle E-Business Suite on Oracle Cloud?
You can think of running Oracle E-Business Suite on Oracle Cloud as running exactly the same Oracle E-Business Suite applications that you run on-premises in your datacenter today – the same E-Business Suite applications you may have customized – on a combination of Oracle’s Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) offerings.
The main choices are:
- Infrastructure: The Oracle Compute Cloud Service part of IaaS provides a highly scalable, competitively-priced compute capacity that can be used to host your application tier and (optionally) your database tier.
- Infrastructure + Database: The Database Cloud Service part of PaaS can be used to run your database tier, allowing you to provision your chosen database configuration quickly and easily.
- Infrastructure + Database + Application Management: Optionally, you can get assistance with Oracle E-Business Suite applications and database management by deploying managed services on top of the infrastructure and platform services:
- Oracle Managed Cloud Services (OMCS) manages your Oracle E-Business Suite environment on Oracle Cloud. The complete lifecycle management provided by this service includes patching, cloning, and regular technical/functional updates, along with an industry-leading application availability SLA. [OMCS will also keep you up-to-date with the most recent security patches and latest product releases, so that you can both remain secure and benefit from the newest innovations.]
- Alternatively, you can choose a partner to run your applications and perform applications DBA tasks such as patching and cloning, as well as upgrades and technology updates.
For more information, visit the Oracle E-Business Suite on Oracle Cloud Landing Page.
Source: https://blogs.oracle.com/ebsandoraclecloud/what-is-oracle-e-business-suite-on-oracle-cloud
September 6, 2017
Oracle’s Booming Cloud Business Could Rip And Replace SAP As #1 In Apps
NEWS AND UPDATES
Oracle’s Booming Cloud Business Could Rip And Replace SAP As #1 In Apps
Oracle founder and chairman Larry Ellison believes cloud computing gives Oracle the chance to overtake archrival SAP in enterprise apps. (Photo by Ezra Shaw/Getty Images)
(Note: After an award-winning career in the media business covering the tech industry, Bob Evans was VP of Strategic Communications at SAP in 2011, and Chief Communications Officer at Oracle from 2012 to 2016. He now runs his own firm, Evans Strategic Communications LLC.)
CLOUD WARS – Cloud computing, which has already triggered massive disruptions across industries in business models and traditional pecking-orders, is giving Oracle Corp. a once-in-a-generation chance to displace arch-enemy SAP as the world leader in enterprise applications.
For decades, SAP has been the world leader in enterprise applications and Oracle has been the frontrunner in enterprise databases, with both companies retaining their leadership positions in spite of the seismic shifts in the industry caused by the moves from mainframes to minicomputers to client-server to the Internet.
Oracle’s recent surge in cloud-applications revenue—it sold $1 billion in SaaS apps during the quarter ended May 31 and $3.4 billion for the year—give it a legitimate chance to overtake SAP as the world’s #1 provider of enterprise applications, particularly in the massive cloud ERP market.
In the combined category of on-premise apps plus cloud apps, it’s still not very close as SAP’s revenue for that category doubles that of Oracle for the corresponding set of products and services:
- Oracle: For the 3 months ending May 31, it reported combined applications revenue of $2.86 billion: $964 million for SaaS apps and $1.9 billion for on-premise (see full details on page 10 of the Oracle press release).
- SAP: For the 3 months ending June 30, it reported combined applications revenue for cloud plus on-premise of $5.61 billion (see full details on page 7 of the SAP press release).
But in that same Q4, Oracle’s SaaS revenue (non-GAAP) of $1.0 billion was up 76% over the year-earlier period—and during its June 21 earnings call with analysts, Oracle executives emphasized that every financial KPI they monitor for SaaS points to even bigger and better numbers for the coming quarter, which will end Aug. 31.
And standing out prominently among all that growth was Oracle’s Cloud ERP business, which CEO Mark Hurd said is now on an annualized run rate of $1.2 billion after Q4 revenue soared 156% over the year-earlier period.
Triggering that steep growth, said Hurd, were 868 new Cloud ERP customers in Q4, plus 200 more “expansions” from customers that were added more of the Oracle Cloud ERP services to ones they’d purchased previously.
As businesses jump to the cloud to accelerate innovation and engage more intimately with customers, my Cloud Wars series analyze the major cloud vendors from the perspective of business customers.
September 1, 2017
How To Trace Concurrent Programs
APPS DBAErrors/Workarounds-ApplicationsInstallations/Configurations-Applications
How To Trace Concurrent Programs
CASE 1 : Concurrent Program Tracing without bind variables
1) Follow the following navigation to enable logging for Concurrent Program
- Goto Sysadmin > Concurrent > Program > Define
- Query the concurrent program
- Check the trace box to enable trace
2) Execute the concurrent program and note down the request id
CASE 2: Concurrent Program Tracing with bind variables and waits
1) Note down the following values
- SQL>SELECT value FROM v$parameter WHERE name = “max_dump_file_size”;
- SQL>SELECT value FROM v$parameter WHERE name = “timed_statistics”;
2) Execute the following commands as sysdba
- SQL>ALTER SYSTEM SET max_dump_file_size = unlimited;
- SQL>ALTER SYSTEM SET timed_statistics = true;
- SQL>ALTER SYSTEM SET EVENTS ‘10046 trace name context forever, level 12’;
3) Execute the concurrent program and note down the request id
4)Turn off tracing the reset the values.
- SQL>ALTER SYSTEM SET EVENTS ‘10046 trace name context off’;
- SQL>ALTER SYSTEM SET max_dump_file_size = <value from step 1>;
- SQL>ALTER SYSTEM SET timed_statistics = <value from step 1>;
CASE 3: Enabling the trace for a concurrent request for which you donot have privileges to run the concurrent Request.
1) Now, Run the concurrent program and get the request id .
2) Get the oracle_process_id for that concurrent request.
SELECT request_id,
oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id IN (“xxxxxxx”);
3) Now get the session details ( SID and Serial ) using value obtained from step 2
col “SID/SERIAL” format a10 col username format a15
col osuser format a15 col program format a40
SELECT s.sid
|| “,”
|| s.serial# “SID/SERIAL”,
s.username,
s.osuser,
s.status,
p.spid “OS PID”,
s.inst_id,
s.MODULE
FROM sys.gv_$session s,
sys.gv_$process p
WHERE s.paddr = p.addr
AND s.inst_id = p.inst_id
AND p.spid = &value_from_step2
ORDER BY To_number(p.spid);
4) Execute the following command to enable the trace :
EXECUTE dbms_support.start_trace_in_session (&sid, &serial, binds=>true, waits=>
true);
5) Collect the trace from udump location and investigate the issue.
Reference Metalink Note: 296559.1 to know more about tracing.