OracleAppsBlog
A day in the life of an Oracle Applications Consultant

Tuesday, September 28, 2004

Jobs and positions in a multi-language implementation

The definition of jobs and positions in Oracle HRMS happen through the setup of a key flexfield. When one of the segments needs translation, you can accomplish this via translatable value sets. Remember though that updating the values and translations of the value set do not update automatically the name of the job and the position.

The translations are stored in the corresponding (new) _TL tables.

Wednesday, September 22, 2004

Oracle E-Business Suite 11.5.10 (11i10) release date

In a previous post I speculated when Oracle Apps R11.5.10 might be coming out, this post provides further clarity on the expected release date.

My previous post on an expected release date for Oracle 11i10 stated that it would be out in November 2004. It seems that this date was correct as an article I read in the UK Computing Magazine recently reported the following: -

Oracle’s new 11i.10 e-business suite will be available in 60 days and will feature over 2,100 enhancements, the company said today at its Oracle Openworld event in London.

Improvements include new industry-specific modules, and horizontal features such as the Daily Business Intelligence module for real-time reporting.

Since Oracle OpenWorld took place two weeks ago it seems reasonable to assume that this new release will be out in November 2004.

Oracle Web Conference (OWC) replaces Oracle Direct Connect (ODC) 

A couple of weeks ago I had to use Oracle Web Conference (OWC) to resolve a Severity Level 1 Technical Assistance Request (TAR). This post discusses this new feature Oracle is offering for Collaborative Support.

My first reaction when asked by Oracle Support if we could have an OWC session to help resolve a TAR was mmm…..they must have made a spelling mistake. I’ve used ODC (Oracle Direct Connect) to resolve TAR’s for the past couple of year’s and I soon found out that it has now been replaced by Oracle Web Conference (OWC) which is run from Oracle Collaboration Suite. I have to say that I was really impressed by this product and will try in the next few sentences and pictures to give you an idea of how it works and what it looks like. The Metalink Note 274430.1 entitled How to use OWC as a customer contains instructions on how to use OWC and states: -

Oracle Web Conference (OWC) is the next generation of collaborative support that allows us to engage in a one on one system relationship with dual party control of your system using the Internet. This allows the Support Engineer to observe your issue first hand within your specific environment. OWC works on the same principles as Oracle Direct Connect(ODC) but gives us a greater range of possibilities.

Typically, to use OWC you will be given a conference ID and login information by Oracle Support. After accessing Metalink and then clicking on the Oracle Collaborative Support picture you will be presented with a screen as illustrated below which will allow you to start your conferencing session.

Resolve problems online with Oracle Web Conferencing (OWC)

The Oracle Web Conferencing (OWC) Welcome Screen

In your conference with Oracle Support they will most likely run through your problem on screen with you and via the phone. After logging out you can then access a recording of the conference via the archive as displayed in the screen shot below. I thought it was quite cool that you can download a copy of the conference session afterwards grin

The Oracle Web Conferencing (OWC) Archive Screen

Download your Oracle Support conference sessions using the archive

Tuesday, September 21, 2004

Oracle E-Business Suite 11.5.10 Documentation

This post directs you to where some good documentation can be found on the new version of Oracle E-Business Suite which is to be released shortly, namely 11i10.

I have over the last week been involved in preparing a proposal for a customer who is planning to implement the new version of Oracle E-Business Suite, namely 11.5.10. I came across some really useful documentation which can be found on Metalink. To find the documentation, log on to the Metalink site, click on the E-Business 11i button then select

Release Content Documents, ‘About’ Documents and Features Summary Matrices

and choose to download 11.5.10 Release Content Documentation (18.56MB).

The documentation pack that you will download contains the information on the following modules: -

  • Healthcare
  • Advanced Planning
    •  
    • Contracts
    • Procurement
    • Projects
    • Sales
    • Service
  • Discrete Manufacturing
    • Complex Maintenance, Repair and Overhaul
    • Configure to Order
    • Cost Management
    • Enterprise Asset Management
    • Flow Manufacturing
    • Item Master and Manufacturing BOM management
    • Project Manufacturing
    • Quality
    • Shop Floor Management
    • Work in Process
  • Financials
  • HRMS
  • Intelligence
    • Balance Scorecard
    • Business Intelligence System (BIS) Purchasing
    • Business Intelligence System (BIS) Service
    • Business Intelligence System (BIS) Service Contracts
    • Enterprise Data Warehousing (EDW) Financials
    • Enterprise Data Warehousing (EDW) Purchasing
    • Intelligence
    • Daily Business Intelligence (DBI) 6.0
    • Daily Business Intelligence (DBI) 7.0
  • Interaction
  • Logistics
    • Inventory
    • Mobile Supply Chain Applications
    • Transportation Execution
    • Transportation Planning
    • Warehouse Management
  • Marketing and Sales
    • iStore
    • Marketing
    • Sales Contracts
    • Sales
  • Order Management
    • Advanced Pricing
    • Configurator
    • iStore
    • Order Management
    • Release Management
    • Shipping Execution
  • Process Manufacturing
    • e-records
    • Cost Management
    • Execution
    • Inventory Control
    • Logistics
    • Planning
    • Product Development
    • Quality Management
    • System Administration
    • Regulatory Management
  • Procurement
    • iProcurement
    • iSupplier Portal
    • Contracts
    • Purchasing
    • Services
    • Sourcing
  • Product Lifecycle Management
  • Projects
    • Grants Accounting
    • Project Contracts
    • Projects
  • Service
    • Advanced Scheduler
    • Depot Repair
    • Field Service
    • Install Base, Enterprise Install Base, Counters
    • Mobile Field Service
    • Mobile Field Service: Wireless and Voice
    • Service Contracts
    • Service
    • Spares Management
  • Student System
  • Technical
    • Applications DBA
    • Oracle Applications Technology

Monday, September 20, 2004

Oracle OpenWorld DEMOgrounds visit – Internal Controls Manager

On Tuesday 7th September 2004 I paid a visit to DemoGrounds at Oracle OpenWorld and took a look at Oracle Internal Controls Manager, here’s a summary of my findings.

I have to say I quite like this product as well as the idea and concept behind it. Internal Controls Manager (ICM) has been developed so that it can assist organisations that are trying to ensure they comply with the new requirements of the Sarbanes-Oxley Act of 2002 as well as increased adoption of International Accounting Standards (IAS). Internal Controls Manager comes standard with 11i10 but not 11i9 (you have to patch up a standard 11.5.9 install to get ICM working).

According to the demonstrator there are only about 160 people implementing it and most of those customers are in the USA. The various brochures, fact sheets and documentation I was given to read indicated that Oracle was one of the first ERP Vendors to come out with a product like this. A product flash leaflet I was given at the DEMOgrounds entitled An Ounce of Prevention - Oracle Internal Controls Manager by Scott Tiazkun of IDC had the following to say: -

The product of work with customers and design partners PricewaterhouseCoopers and Deloitte and Touche to give it that user-tested and partner-approved feel, the Oracle application is aimed specifically at facilitating compliance with Sections 302 and 404 of Sarbanes-Oxley. Section 302 requires particular employees to state that their internal controls are effective. Section 404 requires them to attest that a company attains standards similar to those set by The Committee of Sponsoring Organizations of the Treadway Commission (COSO), a Congressional commission subcommittee on internal controls. This is in addition to the external auditors certification and review of the same issues.

Oracle ICM is used in conjunction with Oracle Workflow, a modelling tool already in the E-Business Suite that allows users to design internal business processes and store them in a repository. Oracle ICM monitors these processes to ensure they are performed as designed. If deviations occur, automatic alerts are sent to designated personnel. Oracle ICM allows users to catalog and track risk factors that might impact financial statements and includes Oracle Tutor to document policies and procedures. The product also uses iSurvey as a mechanism to conduct questionairre-based assessments and also to support anonymous feedback to provide "whistleblower" support. The application provides users with an auditing portal-type work screen, where users can submit audit findings and issue audit reports, manage process documentation, document business process variations, and review compliance status of financial statements, reconciliation status and overall enterprise compliance status.

The Oracle Internal Controls Manager Home Page

The Oracle Internal Controls Manager Home Page

In a nutshell the Controls Manager allows you to take a look at the processes within your organisation, determine the risks at each point within a process and specify controls which should mitigate the risks. Oracle has integrated ICM very well into the E-Business Suite and this is the beauty of the product. Firstly ICM links with Oracle Projects so that if you are going to conduct an audit you can treat it as a project which is appropriately costed and allocated the right resources. Secondly it integrates with Tutor in a manner that allows you to import your Oracle Tutor process documentation into the module. Lastly, where you don’t have any process documentation prepared in Tutor, an interface is available with Web ADI that provides you with templates where you can capture process, risk and control information for subsequent import into ICM.

I’m hoping to have a chance to implement this product in the future and would certainly be interested in receiving contributions from readers or implementor’s relating to this module.

Page 1 of 2 pages  1 2 >