Oracle Technical Consultant Roles and Responsibilities

Oracle Technical Consultant Roles and Responsibilities

 

1. Receiving the functional design document from functional consultant like MD50, CV040, and TE010 etc.

2. Understanding MD50, CV040, TE010 etc. If any issue with document then he will discuss with the functional consultant either by telephonic conversion or by chatting.

3. After completion of the issue, we will prepare the technical design document MD020, MD050, MD120, CV060 etc.

R-Report

I-Interface

C-Conversion

E-Extension

4. After approving this document with the functional consultant we will start development of the RICE Component, developement & Customizations.

5. Writing the

Package,

Procedures,

Functions,

Sq. queries,

Sq. loaders,

Sq. reports,

plsql reports,

xml reports,

bi publisher reports,

sql forms,

form personalisation,

Form customization (custom.pll),

New profile options development

Development & customizations.

6. Moving applications related development or customizations (concurrent programs, execuitables, request groups, request sets, value sets, profiles,) from one instance to another instance (development, testing, clone, production) using FND_LOAD commands.

7. Delivery the component to the reporting manager.

 

 

---------------

--    Company

 

è     Oracle

è    Manager

è    Project manager

è    Reporting manager

è    Project leaders

è    Team leaders

è    Seamier team member

è    Junior team member

è   Fresher

 

--Types of projects

1. Implementation

2. Supporting

3. Customization/Up gradation

4. Migration

--Functional Document

BP030 - Data gathering requirement

BP080 - Future Process Model

BR100 - setup Document

RD020 - current Business Document

RD040 - Business Volume & Matrices

TE040 - System test script

MD050 - Functional Design Document

CV040 - conversion

--Technical Document

MD070 - Technical Design Document

MD120 - Migration Document

CV060 - Technical Design Document

 

Oracle Functional Consultant Roles and Responsibilities

Oracle Functional Consultant Roles and Responsibilities

 

1. Analysis the business requirement

2. Understand Business Functionality

3. Understand Daily Business transactions

4. Understand the materials & Items of different categories.

5. Understanding the dealings of Multiple Organization.

6. Understanding Employee essential information dealing process.

7. Have to analysis the gap between old system and new oracle system and providing solution with customization if necessary.

8.Analyzation of multi orag structure, in case if he wants to start the busuiness in another country

9.preparing BR100,MD50,CV040,TE010 etc. AIMS docs.

10. Preparation of user training document.

11. Functional Consultant will sent document MD50, CV040 to deliver the company as per business requirements.

12. Understand the business functionality steps, data flow diagrams, gap analysis.

BR100-Business Requirement.

MD50-Module Design

CV040-Conversion

TE010-Testing Document

And Interacting With Clients.

 

---------------

--    Company

 

è     Oracle

è    Manager

è    Project manager

è    Reporting manager

è    Project leaders

è    Team leaders

è    Senior team member

è    Junior team member

è   Fresher

 

--Types of projects

1. Implementation

2. Supporting

3. Customization/Up gradation

4. Migration

--Functional Document

BP030 - Data gathering requirement

BP080 - Future Process Model

BR100 - setup Document

RD020 - current Business Document

RD040 - Business Volume & Matrics

TE040 - System test script

MD050 - Functional Design Document

CV040 - conversion

--Technical Document

MD070 - Technical Design Document

MD120 - Migration Document

CV060 - Technical Design Document

Best Practices for interfaces for inbound and out bounds

Best Practices for interfaces for inbound and out bounds

1. Create a staging table from mandatory,conditional requied,optional requied columns from inteface select statement as xx_table_name

2. alter the table add columns as process flags, error flags

3. Load the data through sql loader as per client requiments

4. write a plsql procedures to validate data and transfer to interfce tables

5. submit standard programe to import data


SELECT * FROM USER_ERRORS  (FOR PROCEDURES AND FUNCTIONS)

Oracle General Ledger Reports

Oracle General Ledger Reports

Type	Name	Application
Program	Account Analysis - (132 Char)	General Ledger
Program	Account Analysis - (180 Char)	General Ledger
Program	Account Analysis - Average Balance Audit	General Ledger
Program	Account Analysis - Contra Account	General Ledger
Program	Accounting Setup Manager Post-Update Diagnosis Report	General Ledger
Program	ADS Financials	General Ledger
Program	AutoAllocation Launcher	General Ledger
Program	Budget - Frozen Budgets Accounts Listing	General Ledger
Program	Budget - Hierarchy Listing	General Ledger
Program	Budget - Journals by Account	General Ledger
Program	Budget - Master/Detail	General Ledger
Program	Budget - Organization Listing	General Ledger
Program	Budget - Organization Range Listing	General Ledger
Program	Budget - Summary/Detail	General Ledger
Program	Budget - Unbudgeted Master/Detail Accounts	General Ledger
Program	Budgetary Control Results Report	Public Sector Financials
Program	Program - Delete Budget Organization	General Ledger
Program	Program - Maintain Budget Organization	General Ledger
Program	Chart of Accounts - Account Hierarchy	General Ledger
Program	Chart of Accounts - Detail Listing	General Ledger
Program	Chart of Accounts - Inactive Accounts Listing	General Ledger
Program	Chart of Accounts - Mapping Rules	General Ledger
Program	Chart of Accounts - Rollup Detail Listing	General Ledger
Program	Chart of Accounts - Rollup Range Listing	General Ledger
Program	Chart of Accounts - Segment Values Listing	General Ledger
Program	Chart of Accounts - Suspense Accounts Listing	General Ledger
Program	Close Process - Create Balance Sheet Closing Journals	General Ledger
Program	Close Process - Create Income Statement Closing Journals	General Ledger
Program	Consolidation - Audit	General Ledger
Program	Consolidation - Disabled Parent Accounts	General Ledger
Program	Consolidation - Journals	General Ledger
Program	Consolidation - Restore Unconsolidated Status to Batches	General Ledger
Program	Consolidation - Unmapped Subsidiary Accounts	General Ledger
Program	Currency - Daily Conversion Rates Listing	General Ledger
Program	Currency - Historical Rates Listing	General Ledger
Program	EADS Transactions	Order Management
Program	FSG - Column Set Detail Listing	General Ledger
Program	FSG - Column Set Summary Listing	General Ledger
Program	FSG - Content Set Detail Listing	General Ledger
Program	FSG - Content Set Summary Listing	General Ledger
Program	FSG - Report Detail Listing	General Ledger
Program	FSG - Report Set Detail Listing	General Ledger
Program	FSG - Report Set Summary Listing	General Ledger
Program	FSG - Report Summary Listing	General Ledger
Program	FSG - Row Order Detail Listing	General Ledger
Program	FSG - Row Set Detail Listing	General Ledger
Program	FSG - Row Set Summary Listing	General Ledger
Program	FSG - Where Used	General Ledger
Set	FSG Run and Parse	General Ledger
Program	Program - Run Financial Statement Generator	General Ledger
Program	Program - FSG Transfer	Application Report Generator
Program	Program - Publish FSG Report	General Ledger
Program	General Ledger - (132 Char)	General Ledger
Program	General Ledger - (180 Char)	General Ledger
Program	General Ledger - Entered Currency	General Ledger
Program	General Ledger Account Balances Across Ledgers	General Ledger
Program	Journals - (132 Char)	General Ledger
Program	Journals - (180 Char)	General Ledger
Program	Journals - Batch Summary	General Ledger
Program	Journals - Check	General Ledger
Program	Journals - Day Book	General Ledger
Program	Journals - Document Number	General Ledger
Program	Journals - Entered Currency (132 Char)	General Ledger
Program	Journals - Entered Currency (180 Char)	General Ledger
Program	Journals - Entry	General Ledger
Program	Journals - Extended	General Ledger
Program	Journals - Line	General Ledger
Program	Journals - Tax	General Ledger
Program	Journals - Voucher	General Ledger
Program	Program - Create Journals	General Ledger
Program	Program - Delete Journal Import Data	General Ledger
Program	Program - Import Journals	General Ledger
Program	Program - Prepare Journal Batches for Management Segment Upgrade	General Ledger
Program	Open Period	General Ledger
Program	Periods - Close Period	General Ledger
Program	Periods - Gapless Close Period	General Ledger
Program	Periods - Permanently Close Period	General Ledger
Program	Other - MassAllocation Formula Listing	General Ledger
Program	Other - Recurring Formula Listing	General Ledger
Program	Other - Calendar Validation Report	General Ledger
Program	Other - Data Access Set Listing	General Ledger
Program	Other - Definition Access By User	General Ledger
Program	Other - Definition Access Set Listing	General Ledger
Program	Other - Ledger Set Listing	General Ledger
Program	Other - Open Encumbrance Balance	General Ledger
Program	Other - Transaction Code Listing	General Ledger
Program	Other - Units of Measure Listing	General Ledger
Program	Other - Value Added Tax	General Ledger
Program	Program - Automatic Posting	General Ledger
Program	Program - Automatic Reversal	General Ledger
Program	Program - Complete Management Segment Upgrade	General Ledger
Program	Program - Daily Rates Import and Calculation	General Ledger
Program	Program - Delete Ad Hoc Reports	Application Report Generator
Program	Program - Generate Ledger Flexfield	General Ledger
Program	Program - Generate Upgrade for Balances Entered in Ledger Currency	General Ledger
Program	Program - Incremental Add/Delete Summary Templates	General Ledger
Program	Program - Inherit Segment Value Attributes	General Ledger
Program	Program - Maintain Authorized Users for Journal Approval Reassignment	General Ledger
Program	Program - Maintain Summary Templates	General Ledger
Program	Program - Optimizer	General Ledger
Program	Program - Reporting Attribute Historical	General Ledger
Program	Program - Reporting Attribute Preparation	General Ledger
Program	Program - Revalue Balances	General Ledger
Program	Program - Track Budgetary Debit/Credit Accounts as Balance Sheet Accounts	General Ledger
Program	Program - Upgrade Journal Lines For Reconciliation	General Ledger
Program	Publish RX Reports	Assets
Program	Reporting Currency - Create Opening Balance Journals in Reporting Currency	General Ledger
Program	Setup Flattening Program for Table Validated Value Sets	General Ledger
Program	Translation	General Ledger
Program	Reconciliation - Automatic Reconciliation	General Ledger
Program	Reconciliation - Reconciled Transactions	General Ledger
Program	Reconciliation - Unreconciled Transactions	General Ledger
Program	Trial Balance	General Ledger
Program	Trial Balance - Additional Segment Detail	General Ledger
Program	Trial Balance - Average	General Ledger
Program	Trial Balance - Budget	General Ledger
Program	Trial Balance - Detail	General Ledger
Program	Trial Balance - Encumbrance	General Ledger
Program	Trial Balance - Expanded	General Ledger
Program	Trial Balance - Translation	General Ledger
Program	XBRL - Load Taxonomy	General Ledger
Program	XBRL - Remove Taxonomy	General Ledger
Program	XML Report Publisher	XML Publisher