OracleAppsBlog
A day in the life of an Oracle Applications Consultant

Tuesday, August 03, 2004

The Oracle Financial Information Systems (FIS) Project at University College London (UCT)

This post contains a link to the Oracle Financial Information Systems (FIS) website at University College London (UCT) and also mentions the key features of the site.

The Financials Systems Project site at the University College London (UCT) provides readers with a comprehensive understanding of what it takes to implement an Oracle Applications System. The site gives readers a holistic view of all the aspects of Enterprise Systems Implementations. UCT initially implemented the following modules of Oracle Application 11.0.3 and later upgraded to 11i : -

  • General Ledger
  • Accounts Payable
  • Purchase Ordering
  • Accounts Receivable
  • Grants ( including Project Costing and Project Billing)
  • Fixed Assets
  • Inventory

Following is a review of the key areas of the site:

FIS Project

This section of the site provides an overview of what the FIS project and has related information categorised as follows: -

  • Information on the use of the site
  • What is the FIS Project?
  • FIS Team Members
  • Useful Contact Information
  • Migration Plan
  • FIS Service Times
  • FIS Users Group
  • 11.0.3 Enhancement Stage Plan
  • FIS Technical and Business Consultancy 2003
  • Upgrade to Version 11i
  • FIS Newsletters
  • FIS Training Dates

Procedures, User Guides and General Reference

This particular section of the site is probably one of the most useful areas as it contains project documentation which has been categorised in to the following areas: -

  • General Reference and Procedural Notes
  • User Guides for the following modules: -
    • Accounts Payable
    • Accounts Receivable
    • Fixed Assets
    • General Ledger
    • Grants
    • Inventory
    • Purchase Ordering
  • Other User Guides
  • Technical Guidance
  • How To…?

Monday, August 02, 2004

Oracle E-Business Suite Electronic Technical Reference Manuals (eTRM)

This post contains a link to the site where Oracle E-Business Suite Electronic Technical Reference Manuals (eTRM) can be found and also has a write up on the site.

In a previous post I highlighted where the Oracle E-Business Suite Documentation CD could be downloaded. If you’ve taken a look at this documentation CD you will have noticed that the Technical Reference Manuals (TRM’s) are not there. This is because Oracle is now maintaining the technical reference manuals online. Presently you can access the Oracle E-Business Suite at this site: http://etrm.oracle.com. Once accessing this site you will be redirected to Metalink where you will need to specify a user name and password.

According to the site: -

eTRM is a pl/sql utility that reads design information in an Oracle database and displays its output in html format. It shows database design and dependency information for the Oracle eBusiness Suite.

The present version of eTRM is 3.0 and according to Oracle: -

Version 3.0 is a complete re-write of the eTRM code. Prior versions ran against an Oracle Designer repository. Version 3 runs in an Oracle Applications instance. This allows it to provide a more complete and accurate picture of the Applications data model. New features include a search engine, improved navigator functionality, pl/sql dependencies and static reports for offline working.

The site allows you to search the Oracle Databases from 11.5.4 to 11.5.9 to examine the FND Model or Oracle Data Dictionary. The information you obtain can then be downloaded in HTML or PDF format. I’m sure the information on the site will be very useful to anyone who would like to understand the technical architecture of Enterprise Resource Planning (ERP) Systems.

Page 6 of 6 pages ‹ First  < 4 5 6