As mentioned earlier project teams hire consultants of two types
1. Functional consultants/Business Analysts (B.A.’s)
2. Technical Consultants
Functional Consultants gather and analyze the requirements, design, configure & test the solution, and support the business once the project has gone live. Technical Consultants allow the project to implement customized functionality. Hybrid Consultants have attributes of a typical functional and technical consultant.
The following diagrams illustrate the common knowledge areas of each consultant type. The following diagrams detail the knowledge areas for Technical consultants.
Application data for each module is stored in the corresponding tables. For instance Receivables transaction information is stored in the ra_customer_ trx_all table, whereas the receivables line information is stored in the ra_ customer_trx_lines_all table. Knowledge of these table structures, and how to join them together, is a basic skill for an Oracle technical consultant.
An Application programming interface(API) is a stored procedure used to create & update data in the core Application tables. These very powerful tools allow update of Oracle data from customized components. A technical consultant will use these API’s when creating interfaces between Oracle and an external system, designing customized screens or Workflows.
A good technical consultant is also a thorough tester. Testing technical changes requires technical and functional knowledge, and a thorough test is the proof that the component operates according to the specification. Testing strategies should be agreed between technical and functional consultants in the early stages of development, as this will save much time when the official testing phases start.
A functional consultant designs the inputs and outputs from any customized component, but it is the technical consultant who decides if, or how best, this can be achieved. An experienced technical consultant can discuss and explain technical feasibility of a solution with the functional consultant, until a compromise is reached.
A workflow is used to direct information to various business departments according to business rules. For instance, a sales order is captured by the order desk, fulfilled and shipped by the warehouse, and is invoiced to the customer by the Receivables department. Workflow is used to control this flow. A large number of standard workflows are provided as part of the standard Oracle package. If the client has an unusual business process flow, this can be controlled by modifying the Workflow.
The Oracle toolset is growing as new technologies emerge, but a technical consultant would have some exposure to Oracle Reports, Oracle Forms, SQL Developer or Toad as development environments. More specialized skills might include using JDeveloper and the other Java/SOA tools.