FCS : The Efficiency Catalyst
home | about us | news & events | contact us | login | fcs corporate site   
Product Support 24/7 Heading
Link to Domain Expertise Section Link to Technologies Section Link to Process Section Link to differentiator Section Link to Delivery Section










Technologies Heading
technologies heading



Oracle 8i/8.0.4/8.0.6, Oracle Applications 10.7 SC, 10.7 NCA, 11.0.3 and 11i, Sun Solaris 2.6, Win NT, Shell Scripts, SVRMGR, Adadmin, SQL*Plus, PL/SQL, Oracle Internal Tools Used: SUNDBLINK, RTRENF, ADPATCH, ADRELINK

Kemaman Supply Base

Project Details:
Applications Database Administrator Oracle Automotive Solution improves communication between trading partners while reducing costs and lead time across the automotive supply chain using Electronic Data Interchange (EDI) communications and integration of Oracle CARAS, Oracle Financial, Oracle Manufacturing and Distribution applications.

In the project, we were involved in:

  • Installation and configuring Oracle Applications (10.7 SC), 10.7(NCA) On Solaris, Citrix (SC), NT (SC).
  • Installation and setting up of Oracle Applications 11.0.3 on NT (NCA).
  • Installation and setting up of Oracle Applications 11i on NT.
  • Supporting the Oracle 11i application Modules.
  • Applying Oracle application and the database patches on certification databases using the ADPATCH utility.
  • Applying the RDBMS and the Server Patches whenever required.
  • Installation of the Oracle Developer 2000 and Oracle Web Servers.
  • Creating and maintaining the Oracle Application Users.
  • Re-linking Application Libraries and compiling the Oracle Application Invalid Database Objects.
  • Creating and maintaining Backup Scripts and Database Maintenance Scripts.
  • Upgrading the databases from to, and 8.0.4 to 8.0.5.
  • Maintaining and troubleshooting of databases, application tops and concurrent managers.
  • Replicating the development and test database from certification database.
  • Applying the CARAS third party patches to the Automotive Databases.
  • Automating the entire Backup and the regular maintenance scripts using the CRON Facility.
  • Creating and implementing the regular tuning scripts for the databases such as recreating the Indexes, analyzing the structures etc.
  • Managing all types of failures and recoveries.
  • Performing the daily health check of all the databases.

Oracle Applications 10sc, General Ledger, Accounts Payable, Accounts Receivable, Developer 2000 (Forms 4.5, Reports 2.5, Graphics 2.5), Oracle 7.1, PL/SQL, UNIX.

Project Details:

In the project, we were involved in:

  • Analysis, set ups, customizations and implementation of Oracle Financials modules like General Ledger, Accounts Payable and Accounts Receivable.
  • Building interfaces for vendors, vendor invoice, purchase order, customer invoice, customer order, customer account, set of books, journals etc.
  • Implementation of interface payable transactions to the general ledger from payable side.
  • Implementation of interface invoice and payment information to the general ledger from receivable side.



Oracle Corporation