Oracle Payables

In: Computers and Technology

Submitted By mahendra79
Words 3253
Pages 14
Critical Details about EBS R12 Upgrades
Presented By

Susan Behn VP, Oracle Practice

Objectives/Agenda
 Provide a high level view of topics to consider when upgrading to R12  When is a “technical” upgrade possible  What do I need to research more  When is the right time for training  What do I include in my budget/timeline  Functional Topics  Technical Topics

2

Overview
 Are you aware that…  There are over 1500 new features in R12
 



A responsibility can now access data in multiple organizations R12.1 was released in April 2009
 


How does this impact custom Responsibilities How will all these new features be “discovered”

Quicker data entry for shared services organizations





The user interface to the Oracle Diagnostics scripts was rewritten in OA Framework in R12.0.6
 

12.0 focused on Financials 12.1 focused on everything else including HR

Utilizes role-based access control requiring role grants from the user management responsibility Setup reports in diagnostics can help you find missing setups

3

FINANCIALS - GL

4

Financials - GL
 Legal Entities have significant functionality in R12  Should reflect legal corporate structure  Utilized by Accounting Functions, E-Business Tax, Intercompany, and Bank Account  Balancing segment is associated with legal entity – not ledger  Bank account is owned by legal entity  Align your Ledger structure with your business plan  Operating units are associated with ledgers in R12 – not LE  Position your business to accommodate growth  Design ledgers to satisfy non-GAAP accounting requirements  Secondary Ledgers can be utilized for statutory, management, and/or consolidation reporting  Mapping from Primary to Secondary Ledger(s) is defined in General Ledger and is assigned in the Accounting Setup Manager

5

Financials - GL
 Consider…...

Similar Documents

Oracle

...gv$session s, sys.gv$lock c, sys.gv$locked_object l, dba_objects o, sys.gv$lock k, gv$lock v WHERE o.object_id = l.object_id AND l.session_id = s.sid AND k.sid = s.sid AND s.saddr = c.saddr AND k.kaddr = c.kaddr AND k.kaddr = v.kaddr AND v.saddr = s.saddr AND k.lmode = l.locked_mode AND k.lmode = c.lmode AND k.request = c.request ORDER BY object; ***************** 11G TO 10G (XE) 1. expdp ETAG_CHTBW/etag@vw FULL=N VERSION=10.2 DIRECTORY=data_pump_dir DUMPFILE=ETAG_CHTBW.dmp LOGFILE=ETAG_CHTBW.log dump generated in : D:\app\Administrator\admin\vw\dpdump in 10g (XE for eg) put the dump generated above in this location (where 10g is installed) before running the below command: c:\oraclexe\app\oracle\admin\XE\dpdump 1.1 GRANT read, write on directory data_pump_dir to ETAG_CHTBW 2. impdp etag_chtbw/etag_chtbw FULL=Y DIRECTORY=data_pump_dir DUMPFILE=ETAG_CHTBW.DMP LOGFILE=ETAG_CHTBW.DMP_imp.log ***** TABLESPACE (MINEXTENTS) ERROR RESOLUTION (IN CASE U GET IT): ALTER TABLESPACE ETAG_DAT01 ADD DATAFILE 'C:\oraclexe\oradata\XE\MY_TS2.DBF' SIZE 90M AUTOEXTEND ON NEXT 200K MAXSIZE 200M; **************************** REF CURSOR **************************** Passing REF CURSOR as parameters to sub-programs In the previous section, we already started working with sub-programs (or sub-routines). In this section, I shall extend the same with the concept of "parameters" (or arguments). Every sub-program......

Words: 1277 - Pages: 6

Oracle

...spy may interrupt the speaker and say:-"People suffering from anarchy as illustrated by the proverbial tendency of a large fish swallowing a small one (mátsyanyáyábhibhútah prajáh), first elected Manu, the Vaivasvata, to be their king; and allotted one-sixth of the grains grown and one-tenth of merchandise as sovereign dues. Fed by this payment, kings took upon themselves the responsibility of maintaining the safety and security of their subjects 31 Kautilya's Arthashastra (yogakshemavaháh), and of being answerable for the sins of their subjects when the principle of levying just punishments and taxes has been violated. Hence hermits, too, provide the king with one-sixth of the grains gleaned by them, thinking that „it is a tax payable to him who protects us.‟ It is the king in whom the duties of both Indra (the rewarder) and Yama (the punisher) are blended, and he is a visible dispenser of punishments and rewards (hedaprasáda); whoever disregards kings will be visited with divine punishments, too. Hence kings shall never be despised." Thus treacherous opponents of sovereignty shall be silenced. Spies shall also know the rumours prevalent in the state. Spies with shaved heads or braided hair shall ascertain whether there prevails content or discontent among those who live upon the grains, cattle, and gold of the king, among those who supply the same (to the king) in weal or woe, those who keep under restraint a disaffected relative of the king or a rebellious district...

Words: 166183 - Pages: 665

Oracle

...Morningstar ® Document Research ℠ FORM 10-K ORACLE CORP - ORCL Filed: June 28, 2011 (period: May 31, 2011) Annual report with a comprehensive overview of the company The information contained herein may not be copied, adapted or distributed and is not warranted to be accurate, complete or timely. The user assumes all risks for any damages or losses arising from any use of this information, except to the extent such damages or losses cannot be limited or excluded by applicable law. Past financial performance is no guarantee of future results. Table of Contents UNITED STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549 FORM 10-K x ANNUAL REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934 For the fiscal year ended May 31, 2011 OR ¨ TRANSITION REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934 For the transition period from to Commission file number: 000-51788 Oracle Corporation (Exact name of registrant as specified in its charter) Delaware (State or other jurisdiction of incorporation or organization) 54-2185193 (I.R.S. Employer Identification No.) 500 Oracle Parkway Redwood City, California (Address of principal executive offices) 94065 (Zip Code) (650) 506-7000 (Registrant’s telephone number, including area code) Securities registered pursuant to Section 12(b) of the Act: Title of each class Common Stock, par value $0.01 per share The NASDAQ......

Words: 95668 - Pages: 383

Oracle

...The History of Oracle | Founded in August 1977 by Larry Ellison, Bob Miner, Ed Oates and Bruce Scott, Oracle was initially named after "Project Oracle" a project for one of their clients, the C.I.A, and the company that developed Oracle was dubbed "Systems Development Labs", or SDL.   Although they may not have realized it at the time, these four men would change the history of database management forever. In 1978 SDL was renamed Relational Software Inc (RSI) to market their new database.  1979 - Oracle release 2 The first commercial RDBMS was built using PDP-11 assembler language. Although they created a commercial version of RDBMS in 1977, it wasn't available for sale until 1979 with the launch of Oracle version 2. The company decided against starting with version 1 because they were afraid that the term "version 1" might be viewed negatively in the marketplace.  USA Air Force and then CIA were the first customers to use Oracle 2. In 1982 there was another change of the company’s name, from RSI to Oracle Systems Corporation so as to match its popular database name.  The current company name comes from a CIA project that Larry Ellison had previously worked on code named Oracle. 1983 - Oracle release 3 The Oracle version 3 was developed in 1983. This version was assembled using C programming language and could run in mainframes, minicomputers, and PCs or any hardware with a C compiler. It supported the execution of SQL statements and transactions. This version also......

Words: 1424 - Pages: 6

Oracle

...COMPANY PROFILE Oracle Corporation REFERENCE CODE: C0CB6D9E-4EFE-4621-B998-73B241B46317 PUBLICATION DATE: 23 May 2014 www.marketline.com COPYRIGHT MARKETLINE. THIS CONTENT IS A LICENSED PRODUCT AND IS NOT TO BE PHOTOCOPIED OR DISTRIBUTED. Oracle Corporation TABLE OF CONTENTS TABLE OF CONTENTS Company Overview..............................................................................................3 Key Facts...............................................................................................................3 SWOT Analysis.....................................................................................................4 Oracle Corporation © MarketLine Page 2 Oracle Corporation Company Overview COMPANY OVERVIEW Oracle Corporation (Oracle or “the company”) is a provider of enterprise software, computer hardware products and services. The company operates in more than 145 countries across the world. Oracle is headquartered in Redwood Shores, California and employed 120,000 people as of May 31, 2013. The company recorded revenues of $37,180 million during the financial year ended May 2013 (FY2013), an increase of 0.2% over FY2012. The increase in revenues was due to an increase in Oracle’s software business revenues. The operating profit of the company was $14,684 million in FY2013, an increase of 7.1% over FY2012. The net profit was $10,925 million in FY2013, an increase of 9.5% over FY2012. KEY FACTS Head Office Oracle......

Words: 3160 - Pages: 13

Oracle Ebs

...to Oracle EBS 1.1 About EBS 1.2 EBS Application Products 2. The EBS architecture 2.1 Desktop Tier 2.2 Application Tier 2.3 Database Tier 3. Oracle EBS database features 3.1 Monitoring Features 3.2 Performance Features 3.3 Scalability Features 3.4 Business Intelligence Features 3.5 Security Features 4. Oracle EBS user list 5. Oracle EBS success stories 5.1 Home Box Office (HBO) 5.2 Mallcom limited 5.3 AT&T INC. 5.4 Facebook 5.5 HCL 1.1 ORACLE EBS Oracle's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management(CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. The software utilizes Oracle's core Oracle relational database management system technology. The E-Business Suite contains several product lines often known by short acronyms. Significant technologies incorporated into the applications include the Oracle database technologies, (engines for RDBMS, PL/SQL, Java, .NET, HTML and XML), the "technology stack" (Oracle Forms Server, Oracle Reports Server, Apache Web Server, Oracle Discoverer, Jinitiator and Sun's Java). Oracle Corporation brands the on-line technical documentation of E-Business Suite as eTRM — "E-Business Suite Technical Reference Manuals". The applications found in the Oracle EBS include: * Oracle......

Words: 7162 - Pages: 29

Oracle

...Israel Garcia Professor Neil Librock Finance 3300 21 October 2014 Oracle Corporation Most widely known for their Java software, the #1 development platform, Oracle is the so called leader in database software. Their business expands, however, from software to hardware with products such as storage equipment, servers, operating systems, virtualization software, middleware, and many more. It was founded in 1977 and today it is headquartered in our very own Golden state in Redwood City. We look first at measures of financial leverage, which is important because debt can increase or decrease returns to shareholders. Financial leverage is usually measured by the ratio of long-term debt to total long-term capital. Oracles long-term debt ratio for 2014 is 33%, an increase from 29% in 2013. This number tells us that for every dollar in the form of long-term capital, 33 cents is in the form of debt. This measure, however, ignores Oracle’s short-term debt. To take short-term debt into account we measure its total debt ratio, in this case Oracle’s total debt ratio is 47%. Ultimately, these numbers tell us that Oracle is financed 47% with long-term and short-term debt and 53% with equity. We want equity here to be higher than debt since the less money the company borrows, the less interest it pays. Next, we take a look at Oracle’s liquidity ratios. Liquid assets can be converted into cash quickly, which is why it is important to measure to see how quickly a company can bring......

Words: 652 - Pages: 3

Oracle and Microsoft

...Financial Statement Analysis: Oracle Corporation and Microsoft Corporation ACCT-504-10236: Acct Fin: Managerial Use,Anlys Professor: Leonard Hope Oracle Corporation is a US based company that headquarter in Redwood city, CA. It is a multinational computer technology company that develops and markets computer hardware systems. Oracle is second only to Microsoft as the largest software maker by revenue. The company was founded in 1977 under the name of Software Development Laboratories. It went through many name changes only to land the name Oracle Corporation in 1995. They offer many products and services such as software, hardware, middleware, Oracle Beehive, and many applications. Like Oracle Microsoft is a US based computer technology company. It is headquarter out of Redwood, WA. It was founded in 1975 in Albuquerque, NM by Bill Gates and Paul Allen. It is multinational company that serves as the largest software maker by revenue. In 1985 Microsoft partnered with IBM to write the operating systems. However, by the 90s Microsoft own operating system, Microsoft Windows, took 90% of the worlds personal computers. As of 2013 Microsoft has a global annual revenue of $77.85 billion dollars. They employ 110,000 people in 105 different companies. They develop, license, support, and manufacture a large range of software products. Use this Excel spreadsheet to compute ratios; show your computations for all ratios on this tab and also include your commentary. The......

Words: 1088 - Pages: 5

Accounts Payable

...Financial Benefits of an Automated Accounts Payable System for Business While businesses have become bigger and more complex over time, there has been a lag in the harmonisation of financial systems over time especially the Accounts Payable. The complexity of business has been as a result of various factors such as mergers and acquisitions as well as cross-border trade which is affected by factors that include but not limited to different tax regulations, currency and the languages of instruction. This affects the Accounts Payable as it requires real time data especially with regard to a business’ suppliers and buyers for it to be effective. Lack of an automated Accounts Payable system leads to inherent problems such as delayed payments to an organisation’s suppliers, while delaying payments to suppliers may in the short run appear beneficial to an organisation’s cash flows, it actually may lead to the organisation losing some early payment discounts from suppliers which would otherwise represent huge savings on the organisation’s part. Delayed payments also affect long-term relationships with the suppliers as cash flow issues on the part of the suppliers may lead to a cessation of important supplies to the organisation. This ultimately hurts the organisation’s performance. Despite the disadvantages stated above, adoption of automated Accounts Payable has been slow even though recent trends suggest the prospects are changing, a majority of the organisations surveyed......

Words: 565 - Pages: 3

Oracle

...Oracle Systems Corporation is a database management software company that found success in the 1980’s from being an innovator in multiplatform software development. Oracle’s business strategy focused on building its technical expertise and customer service to provide performance standards that could not be matched by competitors. Oracle adopted a first mover competitive advantage when it was the first company to deliver multiple-interface software along with a range of accounting applications - all at record-setting speeds. An incentive-driven sales force was established in order to market to large corporations that would benefit the most from its software. In return, Oracle saw growth rates as sales increased by nearly 700 million dollars from 1988 to 1990. Oracle’s key successes and risk factors can both be traced to their marketing and R&D costs, as well as expanding licensing agreements with hardware manufacturers and value-added resellers (VARs). The first mover advantage that Oracle established with its software allowed the company to venture into a wide arrange of services such as maintenance, consulting, and systems integration before its competitors. These services created a company that could specialize in both product quality and customer service. This instant expansion also came with its own set of problems. Customer satisfaction dropped due to an inability of the sales force to adapt to new territories and new software was being criticized for a number of...

Words: 580 - Pages: 3

Oracle

...Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6 This article describes the installation of Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with both SELinux and the firewall disabled. The following package groups were included for this installation. * Base System * Base * Debugging Tools * Directory Client * Hardware monitoring Client * Large Systems Performance * Network file system client * Performance Tools * Perl Support * Servers * Server Platform * System administration tools * Desktops * Desktop * Desktop Platform * Fonts * General Purpose Desktop * Graphical Administration Tools * X Windows System * Applications * Internet Browser * Development * Development Tools An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below. Note. At the time of writing Oracle have not certified any of their database products on OL6 or RHEL6, so you shouldn't use these operating systems for anything important until the certification is complete. * Download Software * Unpack Files * Hosts File * Set Kernel Parameters * Setup * Installation * Post Installation Download Software Download......

Words: 1320 - Pages: 6

Oracle

...Oracle 11g PL/SQL New Features PL/SQL "continue" keyword - This will allow a "C-Like" continue in a loop, skipping an iteration to bypass any "else" Boolean conditions. A nasty PL/SQL GOTO statement is no longer required to exit a Boolean within a loop. Oracle professional Jurgen Kemmelings has an excellent PL/SQL example of the PL/SQL continue clause in-action: begin for i in 1..3 loop dbms_output.put_line(’i=’||to_char(i)); if ( i = 2 ) then continue; end if; dbms_output.put_line(’Only if i is not equal to 2′); end loop; end; Disabled state for PL/SQL - Another 11g new feature is a "disabled" state for PL/SQL (as opposed to "enabled" and "invalid" in dba_objects). Easy PL/SQL compiling - Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library. Source: Lewis Cunningham Improved PL/SQL stored procedure invalidation mechanism - A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL. Scalable PL/SQL - The next scalable execution feature is automatic creation of "native" PL/SQL (and Java code), with just one parameter for each type with an "on/off" value. This apparently provides a 100% performance boost for pure PL/SQL code, and a 10%-30% performance boost for code containing SQL. Mark Rittman Enhanced PL/SQL warnings - The 11g PL/SQL compiler will issue a......

Words: 269 - Pages: 2

Hp Oracle

...penulis memberikan suatu pemberian solusi akan data warehouse dari Oracle. HP Oracle Database Machine memberikan performa ekstrim untuk data skala besar gudang pertanyaan mengenai pra-konfigurasi sistem, berdasarkan Oracle yang mana memimpin pasar database dan server standar industri, penyimpanan dan komponen jaringan dari HP. Dengan kecepatan, handal, aman sistem yang dapat dengan mudah memberi skala untuk memenuhi integrasi data yang kompleks, pelaporan, analisis dan penggalian data untuk aplikasi yang paling menuntut organisasi hari ini. Kertas memperkenalkan Anda kepada seorang baru keluarga produk Oracle, Oracle Exadata keluarga dan menjelaskan secara rinci bagaimana produk ini akan membahas isu-isu skalabilitas yang berkaitan dengan volume data yang pernah berkembang. Salah satu anggota keluarga Exadata, HP Oracle Database Machine, adalah bandwidth tinggi pra-konfigurasi hardware dan software solusi ekstrim memberikan skalabilitas untuk data pergudangan. Anggota lain dari keluarga, Oracle Exadata HP Storage Server digunakan dalam mesin database sebagai smart solusi penyimpanan dirancang untuk menangani penyimpanan database. Ketika digunakan untuk menambah sebuah sistem saat ini, server penyimpanan pintar ini mempercepat kinerja permintaan saat ini. Dengan memperkenalkan HP Oracle Database Machine dan Oracle Exadata HP Storage Server, Oracle telah membawa suatu industri gudang data terkemuka solusi dan Oracle komitmen kepada pelanggan, untuk masalah domain yang......

Words: 1793 - Pages: 8

Oracle and Mirosoft

...Course Project Financial Statement Analysis Project -- A Comparative Analysis of Oracle Corporation and Microsoft Corporation Here is the link for the financial statements for Oracle Corporation for the fiscal year ending 2011. First, select 2011 using the drop-down arrow labeled for Year on the right-hand side of the page, and then select Annual Reports using the drop-down arrow labeled Filing Type on the left-hand side of the page. You should select the 10k dated 6/28/2011 and choose to download in PDF, Word, or Excel format. http://www.oracle.com/us/corporate/investor-relations/sec/index.html Here is the link for the financial statements for Microsoft Corporation for the fiscal year ending 2011. You should select the 10k dated 7/28/2011 and choose to download in Word or Excel format. http://www.microsoft.com/investor/SEC/default.aspx?year=2011&filing=annual A sample Project template is available for download in Doc Sharing. The sample project compares the ratio performance of Tootsie Roll and Hershey using the 2009 financial statements of Tootsie Roll and Hershey provided in Appendix A and Appendix B of your textbook.   |   | Description | |   |   | This course contains a course project where you will be required to submit one draft of the Project at the end of Week 5 and the final completed Project at the end of Week 7. Using the financial statements for Oracle Corporation and Microsoft Corporation, respectively, you will calculate......

Words: 1188 - Pages: 5

Balance Sheet Oracle and Saps

...Balance Sheet as at 31st june, 2012 Oracle Corporation SAPS Corporation Assets 2012 2011 2010 2012 2011 2010 Current Asset $ $ $ $ $ $ Cash & Short Term Investments 30.68B 28.85B 18.47B 6.915B 4.672B 3.185B Receivables 6.377B 6.628B 5.585B 4.866B 4.118B 3.413B Inventory 158.00M 303.00M 259.00M Prepaid Expenses 1.935B 2.206B 1.532B Other Current Assets 1.720B 695.87M 1.131B Total Current Assets 40.02B 39.17B 27.00B 13.50B 9.486B 7.729B Fixed Assets Gross Property, Plant & Equipment 5.419B 5.095B 4.648B Accumulated Depreciation 2.398B 2.238B 1.885B Net Property, Plant & Equipment 3.021B 2.857B 2.763B 2.160B 1.926B 1.912B Long Term Investments 147.82M Goodwill & Intangibles 33.02B 29.41B 29.75B 14.95B 14.28B 8.253B Other Long Term Assets 1.67B 1.015B 798.00M 1.124B 844.60M 1.033B Total Long Term Assets 38.30B 34.36B 34.57B 18.88B 18.03B 11.60B Total Assets 78.33B 73.54B 61.58B 32.38B 27.51B 19.33B Liabilities 2012 2011 2010 2012 2011 2010 Current Liabilities Current Portion of Long Term Debt Accounts Payable 438.00M 494.00M 775.00M 1.364B 1.206B 714.03M Accrued Expenses 2.002B 2.32B 1.895B 527.87M 212.48M Deferred Revenues 7.035B 6.802B 5.90B Other Current Liabilities 2.963B 3.426B 2.976B 6.851B 5.398B 3.714B Total Current Liabilities 15.39B 14.19B 14.69B 8.743B 6.817B 4.909B Long-Term......

Words: 439 - Pages: 2