Rating Legend

Response
SUP
MOD

CST
NS
Priority

Priority
 Explanation
Supported as delivered "out-of-the-box"
Supported via modifications (screen configurations, reports, GUI
tailoring, etc)
Supported via customization (changes to source code)
Not supported
Critical (C), Desirable (D), or Nice to Have (N)

Critical (C): The functionality is vital for NIC to run its business.
Desirable (D): The functionality is desirable for NIC to meet its
strategic objectives.
Nice To Have (N): This is an optional functionality.
 SUP MOD CST NS
Oracle Financials 79.71 10.14 10.14 0.00 100.00
PeopleSoft HRMS 85.93 5.19 8.89 0.00 100.00
Siebel CRM 60.23 19.32 20.45 0.00 100.00
Oracle Portal 97.50 2.50 0.00 0.00 100.00
Oracle IDM 97.87 2.13 0.00 0.00 100.00
Oracle SOA 97.22 2.78 0.00 0.00 100.00
Hyperion 41.46 58.54 0.00 0.00 100.00
REBI 93.02 2.33 4.65 0.00 100.00
OBIEE 85.26 12.63 1.05 0.00 98.95
Platforms -Gen req 100 0.00 0.00 0.00 100.00
Platforms -DB 100 0.00 0.00 0.00 100.00
Platforms -DW 100 0.00 0.00 0.00 100.00
ETL 100 0.00 0.00 0.00 100.00
MDM 86.96 0 4.35 8.70 100.00
MRM_DQ_DM 61.40 7.02 3.51 21.05 92.98
ID Functional Requirements - Enterpris Priority SUP MOD CST NS Remarks
(C/D/N)
General Requirements

Oracle General Ledger (OGL), part of the Oracle Financials suite, is a single repository for all accounting
information for the company. OGL provides unique features that help managing the company’s accounting
information in one single place - like Flexible Chart of Accounts (CoA) design, automated journal processing and
financial consolidation & closing process etc. The design of a CoA structure is key to delivering the complex
statutory & management reporting requirements of NIC. OGL provides a very flexible CoA structure comprising of
up to 30 segments, which can be configured to capture financial information about different dimensions as per
the business needs of NIC, from different sources. Each segment can contain segment values comprising of up
to 25 alphanumeric characters, thus providing unmatched strength and flexibility in managing information about
all dimensions of the business. This flexibility allows for configuring a thin or a thick general ledger as per
business needs.

Should be a comprehensive package An unlimited parent-child roll up hierarchy further provides for comprehensive segmental reporting at various
catering to all accounting and levels of the organizational tree. The integrated ledger architecture guarantees data integrity, audit ability, and
reporting needs of the NIC at various control. It simultaneously maintains all financial balances—including actual, budget, summary, foreign currency,
levels (Operating Office, Regional statistical, and average balances—in a single balanced ledger. OGL automatically synchronizes and updates
Office, Head Office, Processing detail and summary balances with a single posting process, rendering accurate reports immediately available.
FIN1 Centres, etc.) C X
Should allow centralization of the
accounts function at Accounts All accounting from multiple offices and systems can potentially be interated into one single repository, Oracle
FIN2 Processing
Should haveCentre
a Reinsurance C X General Ledger. Please refer to the response in FIN1
Accounting module to facilitate RI
accounting at the Accounts RI functionality is not supported in Oracle Finance. However, Accounting entries can be captured from RI system
FIN3 Processing Centre C X to Oracle Finance.
Oracle Payables (OP), a component of the Oracle Financials suite will serve as a centralized payment
workbench for all the invoices of NIC. OP has the flexibility to create single disbursements for immediate payment
needs or to create payment batches. If you routinely create the same groups of payments you can schedule the
automatic initiation of your payment batches. You can also manage how you group your payments using flexible
criteria to select which customers / suppliers / agents you want to pay and what payment method you want to
use. In case of vendor payments, OP helps ensure that you take all favorable discounts while at the same time
Should allow centralized payments of preventing duplicate or unauthorized payments.
claims, commissions, various service
charges, etc. OP supports local tax calculation and reporting needs. For example, OP has support for automated calculation
and accounting of partially recoverable and non-recoverable value-added tax (VAT) and withholding tax. You can
capture VAT detail on expense report receipts to allow for reporting and reclamation of VAT.

OP also lets you issue future dated payments and automatically manage the accounting issues of liability relief
FIN4 C X and payment maturity.

Oracle General Ledger can be designed to act as the single repository of all accounting information from multiple
systems and processes. The level of granularity at which this information is captured can be decided at the time
Should be capable of addressing all of implementation. The company has two options, one to configure a thick GL, which would essentially capture all
transaction accounting needs such transaction level details into the repository. Second option is to configure a 'thin' GL - capturing summary
as receipts, payments, etc. at all information that would be useful in management and financial reporting. Having said this, all accounting, from
FIN5 offices of the Company C X receipts and payments from all offices will be stored in Oracle General Ledger
 OGL comes with an integrated reporting solution called as the Financial Statement Generator (FSG) that
improves the timeliness and accuracy of financial reporting. It's reusable and interchangeable report components
allow you to mix and match existing rows and columns to create entirely new financial or management reports in
seconds. FSG supports different output options, including eXtensible Business Reporting Language (XBRL), text,
PDF, HTML, and spreadsheet outputs. Additionally, it allows you to give your reports a customized look with no
programming effort required—you can easily apply multiple layouts to the same report to include different font
colors, corporate logos, headers and footers. With FSG, you can:
Should be able to generating all · Generate financial reports, such as income statements and balance sheets, based upon data in your general
standard accounting reports at every ledger
accounting center (individual offices · Define security rules to restrict financial information contained in FSG report output generated by specific users
and processing centres) for the and responsibilities.
purpose of audit and profit-centre · Define your reports with reusable report objects, making it easy to create new reports from the components of
FIN6 analysis C X reports you’ve already defined.
Should be able to generate
consolidated accounting reports at
the OO, Regional and Head Office The CoA structure in OGL holds the key to the analysis and reporting output you require. The CoA can be so
levels without necessity for physical designed to track accounting entries by each business unit in the organization hierarchy and reporting may be
transfer of files or a separate done so as to support drill up, drill down and drill across. The Financial Statement Generator (FSG) can be used
FIN7 consolidation procedure C X to build reports as needed based on data stored in the GL repository
Should provide control over Oracle Applications provide for an utility called 'Approval Management Engine' (AME) that enables you to build
designation of authorized signatories organisation specific approval rules for various business processes. AME can be completely user defined with
and control on authority limits of multiple levels of approval, iterations, rule / tolerance based approvals depending upon the requirements for
FIN8 signatories
Should have standardized error C X each business process
handling routines with facility for Available. For every record entered, wherever fileds are marked mandatory, the system checks and flashes
FIN9 seeking help C X errors if no input is provided.
Should be capable of handling
FIN10 revised 8 digit pin codes C X Available. The pin code as a part of the address information for a counterparty can be captured
Should provide integration with
knowledge management to enable
access to FAQs (Frequently Asked
FIN11 Questions) and other help C X Available
Should support accounting of long- Oracle Financials will integrate with the Core Insurance systems. It is expected that all accounting information
FIN12 term policies C X from the core systems will be moved into Oracle Finance at regular intervals.
Should have facility to define
comprehensive workflow for different Combination of the Approval Management Engine and Oracle Workflow can be used to configure business
FIN13 account processes C X processes with controls within Oracle applications

General Ledger
Oracle General Ledger provides a very flexible chart of account structure comprising of up to 30 segments, which
can be configured to capture financial information about different dimensions as per the business needs for each
organization, from different sources. Each segment can contain segment values comprising of up to 25
alphanumeric characters, thus providing unmatched strength and flexibility in managing information about all
dimensions of the business. This flexibility allows for configuring a thin or a thick general ledger as per business
needs of each individual entity. An unlimited parent-child roll up hierarchy further provides for comprehensive
segmental reporting at various levels of the organizational tree. A key feature of the system is the capability to
Should be able to maintain chart of capture user defined information where required. The feature 'Descriptive Flex Field' (DFF) is omni present within
FIN14 accounts C X Oracle Applications.
Should be able to create and
maintain accounts and account
FIN15 information on-line C X Available
Should be able to create memo
accounts for collecting non-financial Memo accounts can be created and statistics like head count, square feet etc information can be imported or
FIN16 statistical information C X entered into General ledger
Should be able to segregate expense
accounts by division, department and
FIN17 work, cost or profit center C X The Chart of Accounts definition can be used for this
Consolidation of accounts / account balances across various dimensions such as multiple business units /
operating offices , multiple sub accounts (example total assets, total current liabilities etc) , multiple regions /
Should be able to transfer or geographical locations etc can be delivered easily by defining the chart of accouns in a manner that is most
consolidate accounts and suitable for NIC's reporting and accounting requirements. In addition, the solution provides the flexibility to build
FIN18 automatically
Should combine
be able allsettlements
to record details C X parent child hierarchies to an unlimited detail
and adjustments through journal
FIN19 entries C X Available
 Oracle General Ledger lets you build reversing journal entries to reverse accruals, estimates, errors or
temporary adjustments and reclassifications. You can assign a reversal period and, if average balances is
Should be able to carry out reversal enabled, a reversal effective date to a journal entry. You can enter a reversal period and effective date at any
FIN20 of journal entries C X time,can
You even after thejournal
organize journal is posted.
entries with common attributes into batches. For example, you might group your journal
Should be able to post journal entries entries by type or date. You can have multiple journals in one batch, or you can have a separate batch for each
FIN21 in batchbe able to sort information
Should C X journal entry.
from a header record in each
FIN22 transaction C X Reports can be generated based on information recorded at the journal level
Should be able to repeat details from
the previous journal (e.g. date,
description) while at the same time New journals can be created using existing journals through the 'Copy' feature. To automatically number journals
FIN23 preventing duplication of journal entry D X and avoid duplication, sequential numbering may be used.
Should be able to enter description
FIN24 for each detail line of a journal D X Descriptions may be entered for batch, journal header and each journal line
Should be able to create multiple The Journal Approval Process feature of Oracle General Ledger can be used to configure necessary authority /
batches of journal entry at one time, approval levels within NIC obtains the necessary management approvals for journal batches. The process
with predefined authority levels for validates the journal batch, determines if approval is required, submits the batch to
FIN25 the same
Should be able to automatically C X approvers (if required), then notifies appropriate individuals of the approval results.
accept and post journal entries from General ledger is tightly integrated with Oracle Payables, Oracle Receivables, Oracle Cash Management and
Account Payable, Accounts Oracle Assets (all of these form a part of the Oracle Financials suite), the latter acting as subledgers. All
FIN26 Receivable, etc. C X accounting from the subledgers is directly posted into Oracle General Ledger
Should have unique number for each
FIN27 journal entry C X Automatic sequential numbering maybe enabled to create unique id for each journal
Should be able to look-up by account
FIN28 number and description during entry C X Available
Should be able to create automatic
recurring entries that allocate one
account balance among several
FIN29 others based on ratios C X Mass allocation journals can be used to create required allocations
Should be able to terminate a
recurring journal entry based on the
automatic accumulation of all
FIN30 payments
Should be equaling total
able to set commitment
starting and C X Oracle Payables may be used to manage recurring commitments with a threshold.
ending period/year for recurring
FIN31 entries
Should be able to enter and maintain C X Available
statistical information either along
with or independently of journal Statistical information may be maintained in the form of journal entries or against journal lines based on
FIN32 entries D X relevance.
Should prevent duplicate posting to
FIN33 the same account C X Journals once posted cannot be posted again. Journals can be sequentially numbered to avoid duplication
Should be able to check before a
period close that all the vouchers
have been authorized and posted
and Should give a warning if some All unauthorized / unposted journals are stored separately. These can be viewed and actioned upon before
unauthorized /unposted voucher period closing. The system generates reports of list of oustanding items that need to be addrssse d before
FIN34 remains in the system C X closing. You can configure alerts to warn the user about unposted journals
Should ensure at year-end close that
all entries are in balance and that all
FIN35 periods have been closed C X Available. Opening and closing period can be done through a user interface.
In general, a large number of reversals happen as part of month end closing and opening procedures. This can
be done automatically using the feature Automatic Journal Reversal. First you define journal reversal criteria for
journal categories. You can also choose to enable automatic generation and posting of journals. When you
create a journal entry you want to automatically reverse, specify a journal category that has assigned reversal
criteria. Your journal will be reversed based on the method, period and date criteria you defined for that journal
category.
Once you have posted journals using journal categories associated with journal reversal criteria, you can:
• automatically generate reversals when a new period is opened.
Should identify and process accruals • manually launch a reversal program which finds and generates all journals marked for reversal for a
with automatic reversal in the next specific period, including any journals that were manually selected for reversal.
FIN36 accounting period C X • automatically post any reversal journals including reversals that were not automatically generated.
 You can use the feature 'summary templates' to create summary accounts, whose balances are the sums of
multiple detail accounts. All those aggregate balances that you use for routine analysis can be configured as
summary acounts. Summaryaccounts can be queried online and also be used in financial reports,
MassAllocations, and recurring journal formulas. You specify when you want General Ledger to begin
Should automatically roll-up detail maintaining your summary account balances. You can also assign budgetary control options to a summary
FIN37 accounts to summary accounts C X template for which you want to perform summary level budgetary control.
Should be able to calculate and
maintain current, prior, and previous Accounting information is maintained by date / period. Reporting can be done across present and past periods.
FIN38 year comparative
Should information
provide capability to revise C X Very commonly used time dimensions in reporting are PTD, QTD and YTD
invalid journals, subject to predefined
FIN39 authority C X Journal entries maybe changed with requisite authority till the time they are posted.
Should be able to define a number of General Ledger allows you to define suspense accounts to post unbalanced amounts. Suspense accounts
FIN40 suspense
Should be codes
able to post errors to C X maybe defined for each journal source / category.
different suspense codes according
FIN41 to the source
Should be able to correct C X Please refer to response to FIN40 above
transactions posted to suspense real
FIN42 time C X Available

Oracle General Ledger’s Financial Statement Generator (FSG) improves the timeliness and accuracy of financial
reporting. Its reusable and interchangeable report components allow you to mix and match existing rows and
columns to create entirely new financial or management reports in seconds. FSG supports different output
options, including eXtensible Business Reporting Language (XBRL), text, PDF, HTML, and spreadsheet outputs.
Additionally, you can quickly create professional quality reports by defining report layouts using a word
processing application and leveraging all of the formatting features, such as changing the font size and color,
adding corporate logos, etc. By applying multiple layouts to the
FIN43 Should have a GL report writer C X same report, you can quickly produce reports for different audiences.
Should be able to generate unlimited
number of financial reports for
balance sheet, income statement,
supporting schedule, cash flow and Available - Standard Reports are available for Account Analysis. Howerver, Financial Reports like Balance
FIN44 other specific account analysis C X Sheet, Income Statement, etc. can be built using FSG feature in Oracle Finance.
Financial Statement Generator is a intuitive, user driven reporting tool. Range of accounts, dimensions, periods
etc can all be specified while creating the report. Optionally, using Oracle Business Intelligence dashboards /
Should be able to specify account for viewlets may be built such that a user can drag / drop pr choose elements from a lookup or drill down to further
FIN45 inclusion by : C X details. The reporting possibilities are unlimited.
- natural account number
- profit center / cost center
- range of account numbers
- range of account numbers with
specified exceptions
Should be able to specify the
contents of each column with no
restriction i.e. current month, current
budget, year to date, budget to date,
FIN46 last year to date C X Available
Should support online posting of all
financial transactions in GL and
FIN47 updating of all reports C X Available
As mentioned earlier, the subledger architecture withing Oracle Financials lets a user drill across applications
seamlessly provided he has necessary authority. For example, a user can drill down from a GL Summary
Should support drilldown from GL Balance in Oracle General Ledger to detailed journal lines, to individual transactions and down to purchase order
FIN48 entries to individual transactions C X and invoice in Payables / Receivables and back
Should support mapping of
transactions to respective operating
office based on user id / office code
to facilitate generation of various Journal entries / transactions from source systems need to be fetched in a manner that they are mapped to the
FIN49 reports office wise C X relevant operating offices / branches / business units/ products. Based on this reports may be generated.
Should allow OO, RO, HO,
Processing Centres to drill down to
transaction level in respect of Access control in the application maybe configured according to requirements. Security rules is a feature that can
offices/intermediaries under their be used to allow access to specific segments / dimension values, for example employees of company A may be
FIN50 administrative control C X able to access transactions of A alone.
Should provide for “what if” analysis
FIN51 with option to post / not post to GL D X Report may be configured to combine existing account balance with unposted journal entries.
 Should have ability to track earned /
unearned premium based on the Risk
Commencement Date to date of
financial year ending (should have
FIN52 provision for 1/365) D X Accounting and Invoicing Rule feature in Oracle Receivables can be used.
Should be capable of recognizing
and accounting Premium Received in
Advance and subsequent accounting
of premium from date of risk
FIN53 commencement C X Accounting and Invoicing Rule feature in Oracle Receivables can be used.
You can set up your accounting periods in the Calendar during the initial set up of Oracle GL. Each ledger / set of
Should allow user to indicate closure books is associated with a Calendar and consequently periods. At the time of setup you can define the number of
of an accounting period for a given future periods you want to keep open for future transaction entry. Periods can be closed when accounting
office and prevent further accounting processes are finished. They can be reopened for changes unless they are completely closed, which means that
FIN54 in the closed period C X no changes will be allowed in that period.
Should enforce uniformity in
transaction date and accounting date
in respect of all accounting
transactions except those done
through Journal Vouchers, in which
case the accounting can be
backdated. The Accounting date will
FIN55 change automatically with the c C X Oracle GL stores transaction / accounting date against each journal
Should have ability to track
FIN56 backdated adjustments C X Transaction entered and posted in prior periods can be categorized into a separate journal category for tracking
Should have facility for Multi currency
transaction, indexation, exchange
gain / loss, accounting treatment to
Exchange Gains/Loss as per Oracle General Ledger provides multi-currency functionality to satisfy the most demanding global financial
company’s stated Significant requirements. You can capture and report on any number of currencies from the balance level to the subledger
Accounting Policy in the Annual transaction level. Currency conversion, revaluation, remeasurement, and translation are all performed in
FIN57 Report D X accordance with local and international accounting standards.
Should be able to override standard
currency exchange rate with each
FIN58 input transaction D X Available
When the standard exchange rate is
overridden, output report generated
FIN59 should show: D X Report may be configured for the same.
- the standard exchange rate
- the override exchange rate
- the person entering the override
transaction
All postings and account balances
should be maintained in both local
currency and user-defined foreign Oracle General Ledger supports the configuration of reporting ledgers which can be in currencies other than
FIN60 currencies D X functional / base currency to store / report on transactions
Should be able to calculate foreign
FIN61 exchange gains/losses D X Oracle General Ledger calculates the currency translation loss / gain and posts it to a account that you define
Should maintain a history of
exchange rates. The history shall
capture the effective date of a
change to an exchange rate, the date Oracle GL lets you maintain daily exchange rate for chosen currencies. Whenever a transaction / journal entry of
it was changed and by whom and a particular currency whose conversion rate has been defined, Oracle GL automatically displays the exchange
details of what the rate was changed rate. Descriptive flex fields can be used to define any additional information while entering the daily exchange
FIN62 from/to D X rates. The exchange rates are archived for reporting.
Should provide multi-currency
support with ability for authorized
user to create a new currency and
exchange rate in addition to those All ISO standard currencies are preseeded in the application. Additional currencies and exchange rates may be
FIN63 already available D X defined as required.
Should permit modification /
cancellation of receipts / payment
FIN64 vouchers only by designated users C X Available through system security.
 Recievables

Should be capable of automating

reconciliation of Bank Statements
and updating 64VB compliance on
FIN65 confirmation of payments C X To be integrated by custome solution. Including Custom interface & reports.

Should allow 64 VB compliance to be

updated immediately at the Customer
Facilitation Units in case of cash
FIN66 payments C end of 80 X To be integrated by custome solution. Including Custom interface & reports.

Should support integration with the

Core Insurance application be able to
automatically cancel the policy,
reversing all the original accounting
entries and alert the client (email,
SMS, Client portal) as well as the Based on the business events, workflow notification can be used to send e-mail. However, SMS can be
FIN67 Customer Facilitation Unit at the issu C achieved through integration with thrid party software.
Should be able to keep track of
premium receipt from client in case of
payment through Bank Guarantee
and generate alert when payment is Feature Available. Oracle Receivables can be used to track receipt of payment from the insured. To generate
FIN68 not done before due date C alert, custom workflow is required.
Should be able to deduct commission
recoverable from the payable
FIN69 commission
Should allow for creation of C X Commission to be paid to an agent may be arrived by netting off his outstanding receivables and payables.
receivables at policy level, client
level, and agent/broker and coinsurer In Oracle Receivables, a separate profile class will be maintained for Policy Level / Client Level and agent/broker
FIN70 levels C X and consumer levels.
Should allow set off of receivables
FIN71 and payables at client level D X This can be achieved by Netting feature available in Oracle Finance.

Should allow treatment of negative

payables as receivables (negative
payables can come into effect when
recovery of agency commission due
to refund/cheque dishonor exceeds
the commission payable on business
procured for a given agent for a given
FIN72 period) C X Available
Should support adjustment of
premium on proposals against
amount in the client’s suspense
account or against subsidy already
FIN73 received from the government C X Work around

Should support Payment Before

Cover option as per Indian
FIN74 regulations C X To be integrated by custome solution. Including Custom interface & reports.
Should be able to maintain an
Accounts Receivable master record
with details (Code, Name, Address,
Phone no., Email id, Payment Terms,
Bank Account details, Payment
FIN75 history, etc.): C X Available

Payables
Should support integration with the
Core Insurance application to update
Agent/ Broker/ Corporate
Agent/Statutory & Regulatory
Payments in the database when a It can be achieved by integration with Oracle Payables. Oracle Payables may be used to store master details of
FIN76 policy is issued C X all agents / brokers / insured / vendors for making payments.
 Should be able to check & generate
alert for Claims Processing Centre, if
the claims payment can not be made
within 3 days of acceptance of offer Alerts may be configured from Payables to trigger alerts / reminders / messages on payment of claim or any
FIN77 by the client C X event relating to the invoice processing.
Should be able to generate agent
commission statements
weekly/monthly, and upload it on the
FIN78 agents portal D X Through Customization.
Should provide ability to modify
commission rates at defined authority
level with cap as per IRDA
FIN79 guidelines/company
Should policies
allow for creation of C Through Customization (Only Commission amount can be captured through DFF.)
receivables and payables at policy
level, client level, and agent/broker Receivables / Payables may be created at individual party / customer / supplier level. Oracle applications lets you
FIN80 and coinsurer levels C X maintain a master of all your customers / suppliers
Should allow client level account
maintenance for both receivables and
FIN81 payables C X Available.
The feature 'Netting Agreements' can be used to support this. The standard report "Supplier Customer Netting
Report" displays the net balance in Oracle Payables and Oracle Receivables for Suppliers and Customers The
Supplier Customer Netting report will show a transaction listing and total balance for Receivables and Payables
Should allow set off of receivables where the transactions are in the selected currency and for the selected range of customers or suppliers. The
FIN82 and payables at client level D X report will calculate a net amount owed where a customer and supplier exist with exactly the same name
Should allow for creation of payable
at the policy level or client level in Excess premium may be paid off back to the customer through Oracle Payables. Another option is to treat the
FIN83 case of provide
Should receipt of excess
facility premium
to inform C X premium as an advance and recognise it over the life of the policy or until it is exhausted
clients /agents /brokers of excess
payments, subject to minimum
FIN84 amount configurable C X Alerts may be configured to check for payments beyond a threshold
Should support integration with the
Human Resource Management
System (HRMS) to retrieve payroll Payroll data will be uploaded on a regular interval into Oracle Financials for accounting and reporting through the
FIN85 data every month C X GL APIs
Should allow retrieval of statutory &
regulatory payment information from
FIN86 the database C X All information stored in the application schema can be retrieved for reporting
Should maintain a Payables register Oracle Payables lets you enter payment information through Invoice entry. All the information required for
FIN87 with the following: C X payment can be recorded through preseeded fields or user defined attributes
- Account Head
- Nature of Payment
- Statutory Classifications
- Invoice Number
- Date of receipt
- Amount
- Date sent for approval
- Person sent for approval
- Approval receipt date (later)
- Transmittal number (later)
- Invoice Numbers
Should be able to maintain master All supplier/ customer detail relevant for payment such as name, PAN, address, bank account numbers, payment
FIN88 accounts payable data C X terms or any other details as required

- Address and contact details

- Bank details
- Payment terms
- Employee remarks
Should generate reports on Ageing This is a standard report delivered through Oracle Payables. Unpaid invoices may be viewed in time buckets
FIN89 analysis for payments due C X specified by the user
 Should maintain and generate
reports on Outstandings with reasons Invoice outstanding can be listed. Reason for non payment can be reported provided it is captured against each
FIN90 and action plan C X invoice.
Oracle Payables automatically creates invoices to pay interest for overdue invoices if you enable automatic
Should be able to calculate interest interest calculation for a supplier. The new interest invoices created are sent for approval and payment. The new
on overdue balances as it may be invoices are in the amount of the interest owed, and the interest invoice number is the same number as the
FIN91 specified by the user C X overdue invoice number, but with the prefix, ”INV”.

Receipts

Should support integration with the

Core Insurance application to
automatically book premium when a
FIN92 policy is issued to the client C X An update will happen from AR on receipt of money from the customer.
Should enable multiple payment
modes like Credit Card, Debit Card, This can be achieved trhough setup. Using Oracle Receivables you can automate payment receipt, application
NEFT/ECS/RTGS, Cash, Cheque, and refunds across a variety of convenient payment choices including ACH, credit cards, and purchase cards to
FIN93 Bank Guarantee, Deposit account D X encourage timely payment. Late charges can be also be configured.
Should allow collection of premium in
FIN94 multiple modes against one policy D X Feature Available.
Should allow allocation of a single
FIN95 collection
Should haveagainst multiple
facility policies
for final D X Feature Available.
adjustment of the premium against
declarations under declaration
FIN96 policies C X This can be achived by Deposit Feature in Receivables and the Invoice can be matched with the deposit.
Should allow the Customer
Facilitation Unit at NIC offices to
maintain daily cash balance slip, for
reconciliation with physical collection
FIN97 at day end C X Feature Available.
Should be able to check if the
amount available in the deposit
account of the client with NIC is
sufficient, in case he client chooses
to pay the premium from his deposit
account; should be able to check the
balance in the deposit account on
FIN98 risk date as C X Feature Available.

Should support the concept of a

client suspense account (amount
received but pending allocation
towards premium is put into this
suspense account and is traceable
FIN99 by Receipt number or client code) C X This can be achieved by On-Account feature in Receivables Receipt.

Should allow for collection of a sum

against Deposit account maintained
by the client and adjustment of
premium on proposals against such
deposits. System should be able to
work out the balance availability both
on basis of a/c date as well as risk
FIN100 incept C X Work around
Should raise an exceptional reporting
FIN101 for every cheque dishonored C X DFF will be defined to capture 'Cheque Dishnour'. Based on this a repot has to be developed.

Payments

Should support integration with the

Core Insurance application to alert
the Accounts Processing Centre to
release payment, when a claim is Oracle Payables will need to be integrated with Core Insurance system to trigger generation of invoices for
FIN102 settled C X payment once a claim is approved.
 Should enable electronic funds
transfer to clients (if their bank
account details are available) towards Oracle Payables supports a variety of payment modes including check, electronic funds transer, etc. Electronic
FIN103 payment of claims D X payments may be generated in in EDI, XML, or other standard, global formats
Oracle Payables is tightly integrated with Oracle Approvals Management that enables built-in policy
enforcement. Routine compliance is dramatically streamlined as exceptions can be automatically routed to
management, Oracle Payables allows you to create and maintain enterprise-wide business rules at both the
Should allow online approval of invoice header and line levels giving you added control and flexibility. Real-time enforcement can significantly
FIN104 payments
Should by provision
have the authorized users
for making C X lower your exposure to fraud, error, and unauthorized payments
weekly/ monthly payments to agents, Oracle Payables lets you group different parties into pay groups and assign them a payment priority. You can
other intermediaries through pick up a pay group instead of each agent / supplier in a payment batch for making payments. Payment batches
FIN105 NEFT/ECS/RTGS D X can be scheduled to run at regular intervals
organization. With Payables you can initiate and monitor payment processing from one central window - the
payment workbench. You have the flexibility to create single disbursements for immediate payment needs or to
create payment batches. If you routinely create the same groups of payments you can schedule the automatic
initiation of your payment batches. You can also manage how you group your payments using flexible criteria to
select which suppliers you want to pay and what payment method you want to use. Oracle Payables helps
ensure that you take all favorable discounts while at the same time preventing duplicate or unauthorized
payments.

With Oracle Payables, you have support for your global payment needs. You can issue future dated payments
and automatically manage the accounting issues of liability relief and payment maturity. You can efficiently
handle prepayments and any associated taxes. And you have the flexibility to remit payments to your suppliers to
Should allow centralized payments as many bank accounts as they request.
FIN106 through processing centres C X
Should provide control on authority
limits of signatories (temporary limits
in case a person is absent) and allow
for online approval of payments by
FIN107 the authorized users C X Can be delivered using the Approval Management engine

When Payables formats payments, it creates an output file that you can use to print checks or, if you are making
electronic payments without the e–Commerce Gateway, you can deliver the output file to your bank for
processing. If you are making electronic payments with Oracle e–Commerce Gateway, during formatting, the
Remittance Advice Outbound Extract Program from the Oracle e–Commerce Gateway application automatically
Should support cheque printing with formats the payment batch and creates a flat file in your e–Commerce Gateway output directory.
dynamic incorporation of signatures
based on the user ids of the persons Incorporation of digital signatures will have to be customized
FIN108 authorizing the payment D X
Should enable electronic funds
transfer to agents towards payment
FIN109 of commissions C X Available. Please refer to response in FIN103
Should enable salary transfer directly
to the bank accounts of employees,
FIN110 every month C X Available. Please refer to response in FIN103

Should support integration with the

Core Insurance application to alert
the Accounts Processing Centre for
surveyor/advocate/investigator
fee/broker commission payment and
FIN111 enable electronic payments C X Oracle Payables will need to be integrated with core insurance for generation of invoices.
Should allow the Accounts
Processing Centre to receive and
approve (or decline) requisition to
release funds for Petty Cash, Office/
FIN112 Personnel Expense C X Can be configured
You can define 'Payment Format' for each type of payment mode you use (check / wire / EFT etc). You can
Should be able to capture data for define any number of payment formats. A payment format will capture necessary specifications for payment such
printing cheque automatically from as currency, number of invoices allowed per payment, invoice grouping, the position of the check stub (for
FIN113 the system D X payment formats using payment programs that produce a stub) etc
Should be able to print cheque drawn You can maintain multiple bank accounts and check books (of the same bank or of with multiple banks ) and print
FIN114 on multiple
Should banktoaccounts
be able recover in the D X checks from any of them for a payment
event of a failure in the cheque
FIN115 printing process D X Available
 Should be able to prevent the same
cheque from being printed in both the
FIN116 original and the recovery process run D X Available
With Oracle Cash Management, you can reconcile payments created in Payables to your bank statements. When
you reconcile payments using Oracle Cash Management, Cash Management updates the status of Payables
payments to Reconciled. Oracle Cash Management offers comprehensive bank reconciliation capabilities,
Should be able to carry out cheque enabling you to maintain accurate cash balances, identify and resolve exceptions, manage bank errors, and
FIN117 reconciliation C X monitor fraud. Please refer to the cash management section for more details on capabilities
Oracle Cash Management offers comprehensive bank reconciliation capabilities, enabling you to maintain
Should reconcile voided, cancelled or accurate cash balances, identify and resolve exceptions, manage bank errors, and monitor fraud. Please refer to
FIN118 returned cheque C X the cash management section for more details on capabilities
During reconciliation, should
calculate uncleared payments (for Oracle Cash Management offers comprehensive bank reconciliation capabilities, enabling you to maintain
more than 6 months separately -will accurate cash balances, identify and resolve exceptions, manage bank errors, and monitor fraud. Please refer to
FIN119 go into stale accounts) C X the cash management section for more details on capabilities
Should generate alerts for cheques
FIN120 pending for more than 3 days D X Alerts can be configured for unreconciled / outstanding checks
Should be capable of tracking
FIN121 rejections, retransmissions, returns C X Reconciliation feature in Oracle Cash Management can deliver this
Should be capable of handling
FIN122 SWIFT, NEFT, RTGS messages C X Available
Employee expense reports may be entered directly or be uploaded into Oracle Payables through the Payables
Should be able to handle employee open interface. The expense report functionality lets you enter the relevant details of expenses to be reimbursed
expense reimbursement description, to an employee such as employee name, number, GL account, date, expense lines, ( this is defined by the
dates and time periods, and cross expense template you select - templates can be created for specific regions / types of expenses), amounts,
reference to related sales outcome currency etc. You can apply advances if any paid to an employee before paying off the net amound due to the
FIN123 by: C X employee
Should distinguish between types of
prepaid advances and adjustment of
FIN124 same while passing the bill C X As mentioned above, advances paid to an employee can be attached to a expense report for net payment
Should be able to select bank
accounts for disbursements, including
reviewing multiple bank accounts to
determine the proper account to
FIN125 issue checks from C X Multiple bank accounts and check books can be maintained
Should be able to process manual
FIN126 cheques C X Manual payments can be created
Oracle Payables supports future dated payments to control the timing of your payments, and therefore control
your cash flow. Any payment document can be future dated. You can record a stop payment on a future dated
payment document or void a future dated payment document as you would any payment document. Oracle
Should be able to issue post dated Payables generate a few standard reports called Future Payment Maturity Date Report which lets you view the
FIN127 cheques C X amount and maturity dates of unmatured payments
In case of posted payment being When you void a payment, or confirm a stop payment, Oracle Payables automatically reverses the payment
voided, GL posting should be status and accounting records for the invoices that you paid. Payables automatically reverses and voids interest
FIN128 automatically reversed C X invoices associated with a void payment or stop payment.
Should generate alerts / reminders
FIN129 based on the Payment terms with the D X Alerts can be configured
party
Should be able to record reasons
FIN130 against payments C X Available
Should provide facility to issue one
cheque for multiple
claims/transactions and facility to
issue the cheque in name of third
party; should allow multiple payees
FIN131 for a single transaction C X You can
You can use
record the payee
'payment information
priority' a value,atranging
the time of creating
from 1 (high) the payment
to 99 in a descriptive
(low), assigned flex field
to an invoice that determines
Should have provision to set payment how Payables selects invoices for payment in a payment batch.
priorities (for cases when limited You can assign default payment priorities to suppliers, supplier sites, and invoice scheduled payments in
FIN132 funds are available) C X Payables.

Third Party Administrator (TPA)

 Should allow integrations with
systems of TPAs to account for It can be achieved thru integration with Oracle Payables. Payments made to TPAs and taxation will be handled
FIN133 claims handled
Should be able by them
to compute and C X from Payables like all other payment transactions
deduct service tax on service charges
FIN134 to TPAs C X Please refer to respones in FIN133 above
Should be able to calculate service
FIN135 charges for TPAs C X Please refer to respones in FIN133 above

Co Insurance Accounting
Accounting entries from the Co Insurance solution can be posted into Oracle General Ledger. The net amount
Should have provision for Co- payable / receivable from a co insurer will have to be communicated to Oracle Financials for further processing
FIN136 insurance accounting C X (creating a receipt or processing a payment as the case maybe)

Should be able to update Co-

insurance Accounts in the database
when a policy is issued or a claim is
settled, based on coinsurance details
entered during policy issue, and
FIN137 automatically inform the follower C X Integration should happen from Co-Insurance solution to Oracle Payables.
Should be able to incorporate
coinsurance information where NIC is
the follower and provide trigger for
FIN138 reinsurance arrangements, if required C X Integration should happen from Co-Insurance solution to Oracle Payables.
Should enable the Accounts
Processing Centre to retrieve and
send coinsurance statements to
coinsurers, and make payments on As mentioned earlier, it is expected that co insurance accounting entries are posted into Oracle GL for creating
FIN139 net basis C X statements of account for co insurers. The net amount payable can be paid off from oracle payables .

Re - Insurance Accounting
Should enable the Accounts
Processing Centre to retrieve Claim
wise/ Policy wise Re-insurance
payment details (no input should be
required from the operating offices as
all the data is updated real time in the Accounting from the reinsurance system may be posted regularly to Oracle General Ledger for consolidation.
FIN140 database) C X Payments on account of reinsurance can be processed through oracle Payables

Should enable the Accounts

Processing Centre to consolidate
(based on treaty particulars) and
send quarterly reinsurance
FIN141 statements to reinsurers C X Customization
Should support integration with core
insurance to capture all Reinsurance
transactions so as to enable
generation of financial statements on
Net basis, at the Company level,
without need for separate application
FIN142 software for RI C X Can be achieved with proper integration with Core Insurance. FSG can be used in GL to generate these reports.
Should support integration with core
insurance to capture all Reinsurance
transactions so as to enable
generation of financial statements on
Net basis, at Operating Office level,
without need for separate application
FIN143 software for RI N X Can be achieved with proper integration with Core Insurance. FSG can be used in GL to generate these reports.

Should be able to capture accounting RI accounting entries can be captured in Oracle Finance.
details for various types of treaties
(Proportional / Non – proportional),
including inflation adjustments
(indexing) where required as per RI
FIN144 program for the relevant year C X
Proportional
- Facultative
- Surplus
 - Quota Share
- Pool (Motor, Terrorism & Hull, etc.)
- Retro-cession
Non - proportional
- Facultative
- XL Treaties
- CAT XL
- Risk XL
- Location XL
Feature Available. Standard reports for Statement of Accounts are available in Oracle Finance. However, If
Should allow generation of Periodical
some parameters have to be modified, it can be customized.
Statement of Accounts for ceded
business - Posting of Accounts to
respective accounts – Treaty
wise/broker wise/Country
FIN145 wise/Currency
Should enable wise/Reinsurer
accounting of wise C X
Business placed on behalf of Co- Feature Available.
insurer/Business Associates/Foreign
FIN146 Branches C X

Should have accounts Receivable Can be achieved thru customization.

and Accounts Payable tracker with
reminder option periodically (Period
to be specified by the user) to follow
FIN147 up with Reinsures / brokers C X
FIN148 Should generate required reports C X Oracle Financials has stnadard Reports. However, if some of the parameters have to be modified, it can be done
Should be able to generate final thru customization.
accounts in case of portfolio entry or
FIN149 withdrawal C
FIN150 calls C X Cash Calls can be accounted in Oracle Receivables by using Miscelleneous Receipt feature. A Receivable
activity has to be defined and the respective account will be assigned in the Receivable activity.
Tax

Should enable deduction of

appropriate TDS and other taxes
from commission/ brokerage, etc. fee The Localization feature of Oracle Financials supports Tax Deduction at Source. Please refer to the white paper Document
FIN151 payable C X attached on more details about Localization
Should provide for a default set of tax
rates and exemption limits to be set
for various types of payments (such
as commission, brokerage,
professional fees etc.) and various
types of assesses (such as corporate
FIN152 / non-corporate etc) C X Please refer to the localization paper attached. Tax rates and thresholds may be set up as required
Should provide for differential rates of
tax and exemption limits for individual
deductees wherever the same differs
from the default rates set for that
FIN153 categorybeofable
Should deductees
to handle TDS C X Available
exemption certificates with floor and
FIN154 cut-off level C X Available

India localization reports different TDS transactions which could be used for compiling the tax returns. India
Localization support the reports listed below.
· Withholding tax certificate – Form 16
· Details of Tax credited or paid during the period and of TDS at prescribed rate - in the case of companies
· Details of Tax credited or paid during the period and of TDS at lower rate or no tax deducted in accordance with
the provision of section 197- in the case of companies
· Details of Tax credited or paid during the period and of TDS at prescribed rate - in the case of persons other
than companies
Should be able to generate all · Details of Tax credited or paid during the period and of TDS at lower rate or no tax deducted in accordance with
necessary TDS related certificates the provision of section 197- in the case of persons other than companies
FIN155 and returns C X Any other reports may be configured
 Should support automatic generation
of e-TDS returns file as per formats
prescribed by the Income Tax
FIN156 department (Quarterly/Yearly) C X Oracle Payables can provide eTDS returns as per the income tax act
Should maintain a history of tax rate
changes, capturing the effective date
of a change to a tax rate, the date it
was changed and by whom and
details of what the rate was changed
FIN157 from/to C X Available
Should allow for computation,
collection and accounting of service
tax as per existing rates, allow for
modification of service tax rates and
specifying the effective date of
change and maintain a history of The Service Tax functionality in the Localization feature covers the regulation prescribed for service tax
FIN158 service tax rate changes C X calculation
Should generate necessary returns
for Service Tax collected, service tax The Service Tax functionality in the Localization feature covers the regulation prescribed for service tax
FIN159 exempted premium C X calculation
Should be able to account for service
tax on service charges to TPAs, and
FIN160 deduct TDS for the same C X Localization feature of Oracle Payables will support this
India Localization feature capture the service tax registration details for the organization as well as for the parties
at party site level. User can define the service tax and its associated tax components like Education Cess and
Should not allow service tax release Higher Education Cess; associate the tax rate applicable for every tax component, define the tax computation
unless Service Tax registration logic; define the tax recovery rules etc. Organizations can classify the service tax transactions to the appropriate
FIN161 number is recorded C X service tax categories
Should provide facility for deduction
of Tax at Source on interest paid on
FIN162 TP claims (per claimant) C X Available through TDS feature of Localization
FIN163 Should take care of exception rules

Accounts Consolidation
Should enable the Accounts
Processing Centre to retrieve
consolidated quarterly/annual
accounts (no input should be Oracle Financials will maintain all accounting information centrally, avoiding any data silos at branch / region
required from the operating offices as level. Consolidation and reporting would be centralised.
all the accounting data is updated
FIN164 real time in the database) C X You can maintain multiple ledgers within Oracle General Ledger and consolidate these for reporting using the
Global Consolidation System (GCS). You would maintain multiple ledgers when you have entities with different
currency / chart of accounts / calendar or accounting basis. A brief description of GCS below:
OGL offers a multi-source consolidation solution that streamlines the consolidation process by centralizing all
consolidation tasks, enabling you to quickly close your books and rapidly distribute vital financial information
throughout your enterprise. With the Global Consolidation System (GCS) you can either do:
· Reporting Consolidations: Define an FSG report which consolidates data stored in a single ledger or which
sums data across separate sets of books on the same applications instance.
· Data Transfer Consolidations: With data transfer consolidations, you move your financial data from diverse
Should be able to consolidate ledgers and data sources into a single consolidation set of books. You can report on and analyze consolidated
general ledgers using different financial information from this consolidated set of books.
FIN165 accounting
Should periods
be able to define period start C X
and end dates in the consolidation
FIN166 module
Should be able to make consolidation C X You can define the period for which you want to run the consolidation process
for the subsequent periods even if
the consolidation of first period is still
FIN167 open C X Period for consolidation can be chosen from the GUI. Process can be run for individual periods
 To consolidate multiple sets of books that have different functional currencies, accounting calendars, or charts of
accounts, you can first map your subsidiaries’ charts of accounts to your parent’s chart of accounts. A
consolidation mapping is a set of instructions for mapping accounts or entire account segments from a subsidiary
set of books to the parent set of books. When you subsequently transfer amounts from a subsidiary to your
parent, General Ledger creates an unposted consolidation journal batch in your parent set of books based on the
subsidiary’s mapping information. For each dimension of the chart of accounts, you can use segment / dimension
rules or account rules, or a combination of both to specify how to consolidate balances or transactions from your
subsidiary to your parent.
Segment rules: map subsidiary account segments to parent account segments. For example, you can map your
All codes entered should be able to subsidiary’s Department
be validated on-line, and the code segment to your parent’s Cost Center segment.
description displayed for visual Account rules: map a specific subsidiary account or a range of accounts to a specific account in your parent set
FIN168 checking C X of books. For example,
Should be able to reproduce the
chart of accounts from any of the
general ledgers in the consolidation Chart of Accounts for consolidation may be defined separately, or any of the COA in ledgers may be used for
FIN169 module as a basis for consolidation C X consolidation
Should display list of all valid codes
and their descriptions at points when
FIN170 codes are required to be entered C X Please refer to response in FIN168. Available
Consolidated trial balance, account analysis etc are standard reports from Oracle GL. Oracle General Ledger
porvides numerous standard reports relating to account / journal analysis, budget reports, chart of account
reports, currency listings, trial balance reports (average, budget, detail, summary etc), etc. Segmental revenue
can be reported provided chart of accounts is designed in a manner to support such reporting. All other reports
Should be able to generate the can be easily created through Financial Statement Generator, a tool inside Oracle General ledger or through
FIN171 required reports, including: C X Oracle Business Intelligence
- trial balance
- three main revenue accounts (fire,
marine, misc)
- segmental revenue accounts
- profit and loss account
- balance sheet
- IBNR

- Cash Flow
- Reports & Schedules as per IRDA,
other statutory requirements
-- net
Calculation
movementof ratios
by account showing
opening balance at start of the
month, all transactions and closing
balance
- net movement by account showing
opening balance at start of the range
of continuous vouchers , net
transactions during the range and
closing balance at the end of the
range
Should be able to convert various Oracle General Ledger provides extensive multicurrency capabilities. You can translate your actual and budget
office balances of foreign offices in account balances from your functional currency to another currency. If average balance processing is enabled,
various currencies into rupees and you can translate both average and standard balances. Translation is an integral part of the consolidation
generate consolidated balance sheet process. The Consolidation workbench guides you through all steps for consolidation including Mapping,
FIN172 of all such offices D X Translation, Transfer, Review, Post, Eliminate and Report
Should support prep of a/c where
transfer of office takes place during
the financial year from one controlling
FIN173 office to another C X Mass allocation engine can be used to transfer accounting entries from one office to another
Should have provision for calculation
FIN174 of solvency ratio X Can be done through Financial Statement Generator or Oracle Business Intelligence
Should have provision to track actual
transaction dates for various Available. Online query is a powerful feature in Oracle General Ledger that lets you query summary, detail, actual
FIN175 transactions (prior period items) C X or budget balances / journals. Drill up / through detail is provided
Should be capable of supporting
FIN176 migration of legacy accounting data C Historical accounting data can be stored inside oracle applications for reporting.
 It is likely that most reports will be
produced by means of an end-user
report writer. Such a report writer
should be able to access all data
items in the database to enable a Oracle Financial Statement Generator is an inbuilt reporting tool in Oracle General ledger. For all custom / ad hoc
wide range of custom reports to be reporting NIC may use Oracle Business Intelligence (BI) which provides powerful fucntionality for reporting,
FIN177 written (subject to approval) C X analytics, dashboarding, alerts, etc

Budgetary Control
Should allow uploading of a Budget
Form, to be accessible to NIC offices,
for capturing expenses under various
FIN178 budget heads C X Based on security profile, relevant forms are available. Hyperion Planning
Should enable the NIC offices to
access, fill and submit the Budget
forms uploaded by accounts (existing Based on security users can fill budget data. Existing data will need to be interfaced from relevant applications
FIN179 data should be automatically filled) C X into Hyperion Planning
Should enable accounts department
to analyse expense data of previous
years, to review budget forms
submitted by NIC offices (through
FIN180 system) D X Such reviews can be done using forms and reports from within the application. Hyperion Planning
Should have a built in workflow, to
enable accounts department to
upload consolidated budget in the
database and forward it to
FIN181 appropriate authorities for approval C X The system allows for workflow along with notes. The system sends out email alerts of workflow notifications
Should be able to monitor budget
utilization periodically to check for
revision (e.g. if the expense is found
to have reached 80% of the budget at
the time of quarterly monitoring,
check if revision is required in the
FIN182 budget) C X The system allows creating revised budget and forecasting. Hyperion Planning
Should have an in-built budget
preparation & Control module.
Should be capable of preventing
charging of expenses to a given head
of account, other than
fixed/committed in nature, if the
budget allocated for that head of Once budgets are created and finalised in Hyperion Planing, they wil be moved to Oracle General Ledger from
FIN183 account is exhausted, with a prior C X where budgetory control can be enabled
Should allow review of performance
vis-à-vis Budget by authorized
persons at various levels (OO, RO,
FIN184 HO, Processing Centres) C X Based on security review reports can be made available. Hyperion Planning
Should allow to store the budgeted
data for 5 years; also it should have
the facility of making the budgets for
FIN185 5-8 years C X Allows users to store multi years data. Hyperion Planning
Should be able to create different
FIN186 type of budgets in the same year C X The solution can have multi-scenario and multi version. Hyperion Planning
Should monitor effects of expenses The percentage of GA Expenses to Gross Premium receipts can be monitored via reports/forms. Hyperion
FIN187 on 40C C X planning
Should allow the user to maintain
FIN188 budgets on-line C X It is a centralized web application giving single version of truth. Hyperion Planning
Should be able to maintain original
budget, revised budget and latest
FIN189 forecast C X Multi scenarios can be maintained. Hyperion Planning
Should automatically allocate an
annual budget over multiple
accounting periods based on an
equal amount or a specific monthly Equal split and a few monthly profiles are available out –of the box. Any specific profile can be easily configured.
FIN190 profile C X Hyperion Planning
 Should automatically generate a
budget from previous years actual or
budget with a percentage increase or Business Rules can be easily configured to carry out such exercise. It also has this functionality built in during
FIN191 decrease C X form inputs. Hyperion Planning
Should have a facility for project wise
FIN192 budget spreading across years C X Allocation rules can be configured. Hyperion Planning

Should provide budgeting on a

FIN193 monthly, quarterly and annual basis C X This is part of initial set up. Hyperion Planning
Should provide capability to prepare
Unit budget in a prudent manner with
a scientific approach by analyzing Budget forms showing past data and the current budget periods input, help prudent budgeting. Hyperion
FIN194 past data C X Planning
Should have the facility of providing
various simulations/scenarios based The application provides a frame-work for driver (budget assumptions) based budgeting. Multi scenario/versions
FIN195 on certain assumptions D X help cerate simulations. Hyperion Planning
Should facilitate multiple level
FIN196 approvals and multiple iteration C X The workflow is not limited and can have multilevel approvals. Hyperion Planning
Should have the facility of preparing
the budget at the Department/Project
level and then automatic
FIN197 Consolidation
Should at corporate
have the facility of level C X Consolidation is the primary strength of the MOLAP technology used in this application. Hyperion Planning
preparation of budgeted P&L and
Fund Flow based on the working The working sheets information will be used by easily configurable rules for creation of P&L and Funds Flow.
FIN198 sheets
Should have the flexibility of C X Hyperion Planning
importing & exporting the budgets
FIN199 worksheets C X Data can be easily moved to and from applications. Hyperion Planning
Should allow multiple models to be in
use at the same time (actual results, There is a flexibility to create multiple business models/rules for each combination of Scenario/Version. Hyperion
FIN200 budget versions
Should have the and forecasts)
facility to use C X Planning
financial calculations (i.e. the
compound interest calculation, It has a wide list of pre built functions for computations. However advanced calculations can be built using the
FIN201 discounted cash flows etc.) D X business rules engine of the application. Hyperion planning
Should support multicurrency data
FIN202 collection D X The application provides for multicurrency as a in built feature. Hyperion Planning
Should enable simulations to be run, i What-if, Best Case, Worst Case, etc, all such simulations can be run from within a single application. Hyperion
FIN203 e what-ifprovide
Should scenarios
the ability to define D X Planning
and add new business units including
those that do not exist in the General Changes to existing metadata and hierarchy is achieved from the GUI. It can also be scheduled. Hyperion
FIN204 Ledger N X Planning
Should provide the ability to split
FIN205 and/or merge
Should business units
allow comparison of business N X Same as above
unit structures in different models
with mapping of changes where
FIN206 necessary N X Multiple alternate hierarchy can be built in the application. Hyperion Planning

Should support the

product/customer/channel revenue
dimension (both interest and
operating income) as well as cost
(both interest and operating cost) and
can calculate the profitability of The application is multi dimensional and can support can support product / customer / channel analysis. It is also
FIN207 product/ customer/ channels D X not limited to the above. Hyperion Planning

Funds Management
 Should support integration with Core
insurance to be able to retrieve
information on payment commitments
(like Claim payments, Reinsurance
Premium Payment, Claims payment
for inward reinsurance, Payroll,
Agent/Broker Commissions,
FIN208 Surveyor/Investigator/Adv
Should have an interface with the C X On Integrating with other financial modules and core insurance solution, will support these requirements.
bank account to monitor daily
FIN209 balances C X Bank statements may be uploaded daily to monitor and reconcile bank accounts

Bank/ Cash Management

Should be able to make following
FIN210 Cash / bank payments: C X Oracle Payables can be architected to serve as a single window for all your payment transactions.
- Vacation Settlement
- Cash Advances
- Lump sum / Re-imbursement
Payments
- Other payments
- Electricity Bill
- Water Bill
- Telephone Bill
Should be able to capture petty cash
FIN211 transactions C X Available
Should be able to capture petty cash
transactions in other locations on a
FIN212 real timebebasis
Should able to maintain detailed C X Available
information on the Bank record
FIN213 including: C X Bank accounts , internal and external (of suppliers / vendors / agents etc) can be centrally maintained.
- Bank code
- Branch name and address
- Type of Account
- Account No
- Fund based Limit
- LC limit
- Bank Guarantee Limit
- Signatories authorize to operate the
account
- Relevant GL code
- Name of the chief manager or
contact person
- Telephone No
- MICR & IFSC Code (for NEFT &
RTGS) be able to add and maintain
Should
the cheque book No. issued by the
FIN214 bank C X Available

Oracle Cash Management supports forecasting in any currency, across different organizations, for multiple time
periods. With the external cash flow interface distributed database support, you can generate a forecast that
combines relevant transaction information from both local and remote databases. You can define multiple
forecast templates for different purposes and different time buckets.
Should be able to generate a Oracle Cash Management can build a cash forecast based on forecasted transactions, such as outstanding
projected cash flow statement, orders and invoices that will produce a cash flow some time in the future. With it you can analyze historical
FIN215 monthly C X transactions, such as past payments and receipts, and project the historical trend into the future.
 Cahs requirements can be analysed using the Cash Positioning functionality of Oracle Cash Management. Real
time cash positioning is essential for preventing bank balance overdrafts and for effectively managing liquidity.
Oracle Cash Management gives you direct access to daily cash flows from your operational systems as well as
those reported by your bank. You can quickly analyze your daily cash position by currency, bank account, or
cash pool, allowing you to project your daily cash needs and evaluate your company's liquidity position. Oracle
Cash Management supports positioning in multiple currencies, across different organizations, for multiple bank
accounts. You can define reusable
Should generate comprehensive worksheets to easily generate daily cash positions. You can quickly analyze your positions at a summary level or
cash requirements reports as defined drill down to the specific transactions for more detailed information. Once you have ascertained an accurate cash
FIN216 by the user C X position and decided how to handle your cash surplus or deficit, you can execute bank account transfers.
Should be able to process manual
FIN217 cheques C X Available
When you void a payment, or confirm a stop payment, Oracle Payables automatically reverses the payment
Should automatically reverse GL status and accounting records for the invoices that you paid. Payables automatically reverses and voids interest
FIN218 posting if a posted payment is voided C X invoices associated with a void payment or stop payment.
Oracle Cash Management lets you automatically or manually record and reconcile bank statements, matching
against system transactions using rules and tolerance levels. You can review and correct any import validation or
reconciliation errors online. Oracle Cash Management can automatically reconcile correcting statement lines
against error statement lines and provide an audit trail for verifying correction of bank errors. Oracle Cash
Management provides an easy-to-use reconciliation report that compares your bank statement balance with your
cash account in Oracle General Ledger, identifying any discrepancies in your cash position. You can also archive
and purge historical bank statements.

Oracle Cash Management offers extensive reconciliation integration with Oracle Payables and Oracle
Receivables for effective cash management. Oracle Payables and Oracle Receivables generate reconciliation
Should perform automatic bank accounting entries for cash clearing, bank charges, and foreign currency fluctuations. You can clear transactions
reconciliation every 15 days or as set prior to reconciliation to maintain more up-to-date cash balances. Oracle Cash Management further streamlines
FIN219 by the user C X
Should have in-built bank
FIN220 reconciliation facilities C X Please refer to response in FIN219
Should identify and report gaps in
FIN221 cheque be
Should sequence
able to identify and C X Can be tracked
generate a listing of outstanding
FIN222 cheques C X Report can be generated
Should include voided, cancelled or
FIN223 returned cheques in reconciliations C X Please refer to response in FIN219
Should be able to identify and flag
FIN224 the un reconciling items C X Unreconciled items can be flagged and rules be built to automatically resolve them and maintain a audit trail
Should be able to specify the date of Actual value dates can be captured directly from the bank statement during the reconciliation process against
FIN225 realization of cheques or collection C X transactions
Should be able to capture date of
FIN226 Bank Transfer C X This will be a part of the bank statement
You can setup Oracle Cash Management to electronically download bank statements from your bank to your
local directory. Once you receive the file, you can load the bank statement information into the Bank Statement
Open Interface tables using the Bank Statement Loader program or a custom loader program. The Bank
Statement Loader program supports standard formats such as BAI2 and SWIFT940, as well as user-defined
formats. Once you have populated the open interface tables, you can import the bank statement information into
Oracle Cash Management for reconciliation. If your bank delivers previous day account statements in the IFX
XML format, you can set up Oracle XML Gateway to receive and process these bank statements using a secure
internet connection. Oracle XML Gateway validates the XML messages using the IFX Release 1.2 specifications
Should be able to import the bank and predefined Oracle Cash Management mapping rules. Upon successful validation, Oracle XML Gateway
statements for the purpose of bank populates the Bank Statement Open Interface tables and launches the Bank Statement Import program to
FIN227 reconciliation C X transfer the bank statement information to Oracle Cash Management.
Should be able to capture cash Cash advances paid to employees can be recorded and applied whenever expense reimbursements are made to
FIN228 advances paid to the employees C X the employee
Should be able to generate Cash
Payment vouchers based on these
FIN229 settlement expenses C X Available
Should be able to maintain Bank
required formats for Payroll payment Although the delivered Electronic Transfer Formats (EFT_NAME) component is available for ICICI, yet
FIN230 advice be able to allow direct
Should C X EFT_Name compenent can be used to meet specific requirements.
payments of Payroll in case of There are various modes of payment available in GP. Org may use either multiple mode like Cash or cheque or
FIN231 discrepancy C X both for payment.
 Fixed Assets When you add an asset in Oracle Fixed Assets, you can enter the asset number, or leave the field blank to use
automatic asset numbering. If you enter an asset number, it must be unique and not in the range of numbers
Should accommodate a user- reserved for automatic asset numbering. Automatic asset numbering is a feature you can enable to automatically
FIN232 definable asset number C X code your assets
Should be able to accommodate
FIN233 unlimited number of assets C X Available. Assets may be categorised, numbered and assigned information as per NIC's requirements
Should be able to maintain details of
written-off assets, whilst excluding
these from general reporting and all
FIN234 current asset valuation calculations C X The Asset Workbench lets you manage all asset related operations such as addition, transfer, retirements etc
Should generate sequential number
FIN235 per asset C X Please refer to response in FIN232 above
Should be able to enter Project /
Department cost center codes in the
fixed assets system at the time of
FIN236 approval of Capex C X theinformation,
All chart of accounts definition
financial may be
or otherwise done to
related in the
manner
assettocan
accommodate
be maintainproject / cost Assets
in the Fixed centersregister such as
Should be able to maintain name, number, value, assigned cost center / employee / department, depreciation rule, prorate convention,
comprehensive fixed assets register, original cost, supplier, PO number etc. Any information specific to an asset can be recorded in the user defined
FIN237 including: C X fields available
- value of asset
- date of purchase
- asset reference code
- description
- short name
- memorandum notes (optional, and
up to 1,000 characters)
- depreciation type
- depreciation formula
- accumulated depreciation
The Physical Inventory feature in Oracle Assets assists you in comparing and reconciling your physical inventory
data. To use the Physical Inventory feature, you must first take physical inventory of your assets. You can track
physical inventory using a unique identifier, which can be either the asset number, tag number, or serial number,
the location of the asset, the number of units or any other information that may make it easier for you to keep
track of the assets you are comparing, such as a description of each asset. You can load physical inventory data
into Oracle Assets using the interface tables or import it from an excel sheet using the Application Desktop
Integrator. The Physical Inventory comparison program highlights the differences between the asset information
in Oracle Assets and the actual assets in physical inventory. You can view the results of the comparison online
Should facilitate inventory verification by running the Physical Inventory Comparison Report. You can reconcile the differences between physical
FIN238 periodically C X inventory and the information in your database by updating each asset manually, or you can use the mass
Should be able to categorize assets Assets may be categorized as per regulatory / internal requirements and depreciation rules be assigned. The
to facilitate a variety of depreciation system allows the flexibility to do 'what if' analysis on assets. So you can evaluate the impact of changing a
FIN239 rates C X depreciation rule on an asset
Should be able to change the method
FIN240 of depreciation C X Available
Should be able to maintain the status
of an asset and related details stored The financial inquiry feature within Oracle Assets gives you a complete view about the status of the asset such
when the asset is sold or discarded as orginal cost, book value, depreciation, accumulated depreciation, rate of depreciation, method, life of asset. In
along with a flag to highlight 'sold addition, the 'retirement' window shows all retirement details suhc as the cost of retirement, gain/loss, status of
FIN241 /discarded' C X retirement etc
Should automatically generate the
necessary transactions to support All accounting entries on transfer / addition/ retirement / depreciation etc automatically generated and deposited
FIN242 asset write-on's/write-off's C X in Oracle General Ledger. You can define the rules for accounting from fixed assets
Should automatically generate the All accounting entries on transfer / addition/ retirement / depreciation etc automatically generated and deposited
FIN243 entry for loss/Profit of sale of assets C X in Oracle General Ledger
Should automatically generate the
necessary transactions to support All accounting entries on transfer / addition/ retirement / depreciation etc automatically generated and deposited
FIN244 asset transfers C X in Oracle General Ledger
 Oracle Assets allows you to schedule repair and service events for your long–term capital assets, to help ensure
you maintain your long–term assets in a timely manner. You can plan for maintenance to occur at appropriate
times, such as seasonal downtime. You can also schedule maintenance to occur at specific intervals, for
Should facilitate tracking of example, monthly. Using Oracle Assets to schedule your asset maintenance also allows you to record the
FIN245 maintenance
Should (AMC) update the
automatically C X maintenance history of assets, in addition to scheduling future maintenance events.
location of an Asset as soon as a
Transfer Note is approved for transfer
FIN246 of the asset C X Transfer can be done online through the Asset workbench
Should automatically post write-on,
write-off and transfer transactions to
FIN247 the General
Should Ledger post
automatically C X Available
depreciation allocations as per user You can run depreciation program to automatically calculate and create accounting entries for depreciation.
FIN248 defined criteria C X Accounting entries will be created as per the rules set up by the user
Should request user verification for all Oracle applications provides comprehensive security and control for access to specific features. Rule based
FIN249 transactions/processes performed C X access / approval can be configured using the Approval Management Engine
Should be able to post adjustment
transactions online to the General
FIN250 Ledger generate annual insurance
Should C X Available
re-valuation and replacement cost Provided the revaluation and replacement cost figures are loaded / calculated against assets, reports can be
FIN251 reports C X generated
Should be able to generate Asset
FIN252 Valuation Report, by category C X Available
Fixed Assets generates a wide variety of standard reports. Some of them are:Budget and Capital spend
reports, Asset Listings: Fixed Asset Book Report, Asset Depreciation Listing, Asset Inventory Report, Asset
Register, Asset Tag Report, Unassigned Assets, Expensed Property Report, Parent Asset Report, Physical
Inventory Comparison Report, Maintenance Reports: Asset Maintenance Report, Depreciation Reports:
Depreciation Projection Report, What – if Analysis Reports, Unplanned Depreciation Report, Accumulated
Depreciation Balance Report, Accounting Reports: Journal Entry Reserve Ledger Report, Revaluation
Reserve Report, Cost Clearing Reconciliation Report, IT Fixed Asset Schedule & Depreciation Report,
Transaction Reports: Asset Transfer Reports, Asset Retirement Reports, Asset Additions Reports, Asset
Should be able to generate Asset Reclassification Reports, etc…
Write-On, Transfer and write-off
FIN253 Report, for a given period C X Any additonal reports may be configured using Oracle Business Intelligence
Should be able generate Asset Write-
On, Transfer and write-off Report, by
FIN254 Cost Center / Project C X Please refer to the response in FIN253 above
Should be able to track insurance
status of assets, with alerts when You can maintain insurance details of each asset and generate alerts to relevant officials for renewal. Similar
FIN255 renewal is due C X process can be followed for maintenance

Payroll
GP has capability to run payroll any number of times based on organisational need. It has also got the capability
Should be able to run multiple to run different payrolls for different kinds of payments like for salary & re-imbursements two payroll or even more
FIN256 payrolls in a single instance C X than two payrolls can be run.
Should be able to maintain a single
central payroll repository and be able
to run and access payroll from any
location in a centralized or The payroll data is maintained in a single database which can be access from any location provided the access is
FIN257 decentralized manner C X given. It can also be run centrally or decentrally based on organisational need.

Should be able to handle the entire

tax computation as per Income Tax
Act without any need for repeated
manual calculations. The tax slabs,
rates and surcharges should be Local country extensions are bundled with global payroll application. It has got inbuilt tax calculation functionality
maintained by the system and the tax as per IT act without manual intervention. Even PT gets calculated & deducted statewise. Any changes happen
FIN258 should be computed automatically C X in IT act in the country, gets immediately provided and updated thru PATCH.
 Should be able handle the payment
of reimbursements. This payment
should be set to be checked against
the overall limit which will be
dynamically reduced based on each
part payment. The balance against Payroll re-imbursement elements can be created at the time of configuration and overall balance gets updated
this eligible limit can be viewed for accordingly. To make the visible to employees in self service, the access needs to be given thru modifications or
FIN259 the employee at C X customisation.
Should support superannuation Superannuation is just like another payroll element. Element creation is part of configuration and the computation
FIN260 computation C X of the same happened according to the rule defined in the element.
Should be capable of calculating Effective date functionality helps make such intelligent calculation and process in the payroll without manual
FIN261 arrears when the scheme is revised C X intervention.

Should be able to define various

formulae and be able to link them to
other calculation formulae / elements
such that when there is a rule change Although the change in any statutory elements taken care by Oracle by providing such changes thru Patches as
only the component which has & when any changes happen, yet in case of any limit or slab changes the effective date concept with value
undergone a change will be effected change capability available in the application. it helps the organization make such changes by themselves by
FIN262 (e.g. tax slabs) C X putting those changed value. payroll automatically take those changes with that effective date and process.
Should take care of final settlement
process to arrive at net to be
FIN263 recovered or due C X Full & final settlement elements can be created and the settlement amount can be computed from it.
Simulation option should be available
that can test run payroll for a chosen payroll can be run any number of times for simulation exercise and also simulation exercise can also be done in
FIN264 payroll period C X test instance to check variance etc.

Should be able to support the

retrospective computation of changes
to the various data heads and makes
the appropriate computation and
payments in the current period. Any changes happen at any point of time retrospectively or future dated, Payroll identifies those changes and
These include changes in make those calculations and pay the same in current month. That means arrears etc can be calculated and paid
FIN265 organization data, Employee data C X at any point in time to employee without manual intervention.
A retrospective computation of the
salary should be initiated
automatically for those employees
whenever there is a relevant change.
The appropriate re-computation of Any changes happen at any point of time retrospectively or future dated, Payroll identifies those changes and
the statutory aspects to be carried make those calculations and pay the same in current month. That means arrears etc can be calculated and paid
out. Tax should also be automatically at any point in time to employee without manual intervention. Even tax part gets calculated automatically with
FIN266 carried out an C X those changes.
Should be able to support various
pay methods e.g. Autopay, EFT, There are various payment method options available in the application. Any one or multiple options can be used
FIN267 Cash, Cheque etc. C X to make payments to employees. Like some amount in Cash rest in cheque or electronic payment etc
Global Payroll for India enables you to define the year-end report parameters and generate the following
reporting forms:
· Form 3A.
· Form 5.
· Form 6.
· Form 7.
· Form 12BA.
· Form 16.
· Form 24.
Should be able to prepare and submit · Form 24Q e-filing.
FIN268 quarterly and annual tax returns C X
 Global Payroll for India enables you to define the year-end report parameters and generate the following
reporting forms:
· Form 3A.
· Form 5.
· Form 6.
· Form 7.
· Form 12BA.
· Form 16.
· Form 24.
Should support generation of Form · Form 24Q e-filing.
FIN269 16 and other
Should statutory
support documents
integration with C X
HRMS to take care of leave, Peoplesoft HRMS itself is an integrated application. All odules & submodules like Leave,Attendance etc are
FIN270 attendance, etc. X preintegrated with payroll.
Should be able to facilitate the back Arrear calculation is done by the system on entering back dated data at respective places for employees. System
FIN271 dating of allowances C X checks those changes and allowance details and process it in payroll.

Audit Trail Oracle Financials audits user activity. The system allows each user access to be recorded. The username,
date and times of the user access is recorded, as well as the responsibility / role selected, screens and reports
used and the concurrent processes executed. The auditing facility allows the administrator to select the
level of auditing required. This may be dynamically changed at any time. The application can also monitor
unauthorized user access. An audit log is maintained of invalid authorization attempts. The user name, user id
System should audit all activities in and data and time of the attempted login are logged. Business documents, such as purchase orders, invoices,
the core insurance solution and other offers, requisitions, etc. have an automatic “paper trail” of changes and additions in the form of versioning. When
integrated applications and maintain a PO is changed by a user, the system actually creates a new version of the PO, leaving the original PO
logs of the same. The following unchanged. This makes it easy to view the history of changes to any given business document. Basic auditing is
activities should be mandatorily performed on all data and transactions within the Oracle applications, regardless of whether they are a business
FIN272 logged: C X
Sessions
Implication

Approvals
Workflow changes
Changes in Master Tables
Rate Changes
Manual Overrides
Failed Authentications
Generation of Duplicate documents
Set Off and Write Off activities
All mails and alerts originating from
the application
All customer activities having a
financial implication
Exception reports for all categories
Changes in Database, Control files
including DML commands
Following information should be
FIN273 available along with the log C X Available
User ID and User Name
ID
Office Code
Business Channel Code
Resource ID of hardware
Time and Date
FIN274 logs
Should be able to query the activities C X Available
on any of the dimensions defined
FIN275 above C X Available

Integration Requirements
Should also be able to integrate with
FIN276 various applications including: C X Integration can be done through Standard APIs &
Core Insurance X Custom Interface, where APIs are not involved.
 Customer Relationship Management
(CRM) X
Human Resource Management
System (HRMS) X
Investment Management System X
(DMS) X
Investment Accounts X

276 220 28 28 0
79.71014 10.14 10.1 0
64 VB says that no risk can be assumed by an
insurer unless premium is received in advance.
System to update receipt of premium in
cash/bank statements before the policy coverage
starts
64 VB says that no risk can be assumed by an
insurer unless premium is received in advance.
System to update receipt of premium in
cash/bank statements before the policy coverage
starts

Section 64 VB of the Insurance Act 1938 prohibits

insurance companies from extending credit so
that credit so that in effect all insurance in India
is on a “cash before cover” basis.
Premium received is mapped to the client code
in Core insurance solution
Document
ID Functional Requirements - Priority SUP MOD CST
(C/D/N)
[Given by
NIC]

HRMS1 Manpower Requirement X

Assessment

HRMS1 Recruitment X

HRMS1 Posting X

HRMS1 HR administration and record maintenance X

HRMS1 Promotions X

HRMS1 Transfers X

HRMS1 Deputation X

HRMS1 Disciplinary proceedings X

HRMS1 Staff Welfare Maintenance X

HRMS1 Performance Appraisal X

HRMS1 Training and Skills Management X

HRMS1 Career Planning X

HRMS1 Succession Planning X

HRMS1 Compensation / Payroll System X

HRMS1 Attendance, Leave Management and Leave encashment X

HRMS1 Loan Management X

HRMS1 Advances X

HRMS1 Retirement, Pension and other X

HRMS1 Terminal Benefits Management X

HRMS1 Provident Fund Management X

HRMS1 Reservation Management X

HRMS1 Health Insurance (including retired employees) X

HRMS2 Should have standardized error C X

handling routines with facility for
seeking help

HRMS3 Should be capable of handling revised 8 digit pin codes C X

HRMS4 Should provide integration with C X

knowledge management to enable
access to FAQs (Frequently Asked
Questions) and other help

Recruitments
HRMS5 Appropriate authorities should be D X
able to raise and monitor Resource
Requests (Recruitment
Authorization Form)

HRMS6 Resource Request raised should be D X

applicable for all types of
employees (Employees,
Consultants & Contractors
National/Expats)

HRMS7 System to be work-flow enabled to D X

facilitate the approval of the
Resource Requests

HRMS8 Should be able to advertise openings internally (filled up D X

through promotions, job rotations
etc.) and externally (Manpower agency, Advertisements)

HRMS9 Should display all available vacancies with D X

corresponding job
role descriptions and competencies
required
HRMS10 Allow applicant to view vacancy D X
details or do a simple/advanced
search for jobs
HRMS11 Enable online filling up & N X
submission of applicant resume

HRMS12 Should be able to enter and D X

maintain applicant's extensive
details

HRMS13 Track the number of applications D X

received and the status of each of
the applications

HRMS14 Candidate should be able to post the resume over a web N X

form. This web form should be designed so
that the key fields needed for
resume ranking are captured and the resume filtering
and ranking
becomes easier

HRMS15 If a hard copy is received, Recruiter N X

should be able to enter the key
fields in the web form

HRMS16 An automated response should be sent when the N X

candidate fills up the web form. Even if the Recruitment
staff completes the form the system
should be able to acknowledge the candidate by e-mail

HRMS17 Track progress of internal & D X

external applicants

HRMS18 Track applicants by personal data, D X

skills, and a designated amount of
prior work experience

HRMS19 It should be possible to identify the N X

source of the application (individual,
consultant, referral etc.)

HRMS20 Track rates and supplier information for contract staff D X

HRMS21 Enable Online search for qualified N X

applicants based on job
requirements

HRMS22 Should be able to build & maintain a N X

CV repository
HRMS23 Should be able to reject a resume N X
and not put in the CV repository for
future reference

HRMS24 Should be able to park resumes for N X

a fixed time period

HRMS25 Allow resume to be part of the CV N X

repository for a fixed time period
even in the case of a rejection

HRMS26 Should be able to retrieve information from the data N X

bank, for
example by name, competencies,
designation etc
HRMS27 Should be able to do resume N X
Filtering, ranking to get the best fit
for the job requirements

HRMS28 Pre-Interview (e.g. Psychometric) Online assessment N X

through the
internet: Provision of candidate
user-id & password & link through
NIC website

HRMS29 Capture details on interview D X

schedules for candidates short
listed

HRMS30 Capturing Interview Assessment details into the system D X

for
candidates interviewed. Facility for
one person to enter details or consolidated entry
HRMS31 View employment contracts of temporary and contract D X
workers

HRMS32 Initiate background checks on candidates & view results N X

HRMS33 Should be able to send our D X

notification that the candidate
application is put on
hold/rejected/selected

HRMS34 Should be able to generate Offer letters based on D X

standard templates

HRMS35 Should be able to capture Medical check up details for D X

the candidate
HRMS36 Ability to propose/establish a suitable salary offer for B X
selected
candidate based on proposed
grade, position, qualification,
experience, Company rules and the details of interview
assessment

HRMS37 Should be able to generate a D X

checklist of all the necessary
documents required from a
successful candidate

HRMS38 Convert Applicant to Employee when hired D X

HRMS39 Should assist in online D X

tracking/monitoring of applicants
through each stage of the
recruitment cycle

HRMS40 Should track recruitment costs versus budget by D X

interfacing with
Financial GL system. Generation of
Recruitment status report (Position filled against budget)

HRMS41 Should generate a history file of unsuccessful N X

candidates, to decide whether the candidate should be
considered or not for a similar
position arising in the future
depending on the reasons (e.g. medically unfit, declined
the offer etc).

HRMS42 Should be able to intimate departments concerned D X

(workflow
enabled) about the joining date
(Dept Heads, IT, Admin etc.) a week before the
employee reports
HRMS43 Should be able to generate joining D X
Induction check-list

HRMS44 Have facility to fill the joining N X

formality forms and submit them
online for further processing and
approval

HRMS45 Should enable allotment of system generated employee C X

code/number

HRMS46 Ensure alerts for renewal of C X

contracts (if applicable) at the right
time

Reporting Requirements:
HRMS47 Should be able to generate the following reports D X
Recruitment Status report
(Positions filled versus budget)
Status in terms of candidates short listed, kept on hold,
finally selected, etc.
Interview Report - Schedule

Performance Management
HRMS48 Should be able to set up C X
Performance Rating/Definition

HRMS49 Should be able to maintain C X

Appraiser/Reviewer details for each
employee/period

HRMS50 Employees should be able to enter C X

& store their annual objectives, Key
Performance Areas (KPAs), etc.
and break them down to any
predefined period (monthly, quarterly, etc.)

HRMS51 Should have a workflow capability allowing for revisiting C X

of objectives, KPAs, etc. and final approval of
these and routine responsibilities by
the supervisor/appraiser on a
quarterly/annual basis; Should allow distribution of KPAs
under
functional heads

HRMS52 Should be able to view D X

qualifications and competencies
required for a standard position/role

HRMS53 Should be able to generate C X

appraisal forms & evaluation criteria C
for employees

HRMS54 Should maintain details on appraisal policy; how does C X

the
appraisal system work, instructions
of filling up forms, guide to common
terms, KPA weightages according
to position, FAQs and answers, etc

HRMS55 Should be able to track the entire process, generate C X

reminders,
automated mails from HR to
facilitate the entire periodic appraisal process
HRMS56 Should maintain Performance C X
Management for all types of
employees (Employees, Retainers
& Consultants)

HRMS57 Should have a facility for a C X

Probationary appraisal process

HRMS58 Allow employees to enter self appraisals and C X

supervisors/appraiser to enter ratings/comments,
discuss & close
(with restricted access to relevant people only)

HRMS59 Should allow capturing locational/functional preferences C X

of
employees, training requirements
and other information provided during appraisal
HRMS60 Allow employees to enter a D X
development plan, action plan, etc.
and access to appraiser to approve
each

HRMS61 Allow identification of training D X

requirements and approval by
supervisor

HRMS62 Should be able to maintain training D X

need requirements with the Training
Module

HRMS63 Access to reviewers to the final C X

appraisal for their
approval/comments

HRMS64 Should have a facility to monitor C X

status of appraisals at any point in
time

HRMS65 Should generate list of employees D X

securing below certain
percentage/ranking

HRMS66 Should generate list of employees who have not C X

completed their
appraisal (self/discussion/closure)
based on designation/authority

HRMS67 Should have a built in workflow notifications to keep C X

managers,
employees and HR administrators
up-to-date for the entire performance management cycle
HRMS68 Should have a workflow support for N X
Salary Review Process

HRMS69 Secure web access for other out location offices D X

HRMS70 Should have linkages to Employee D X

Compensation & Benefits Plan

HRMS71 Should have a facility for peer, D X

subordinate & supervisor
reviews(180, 360deg etc.)

HRMS72 Should be able to maintain updated D X

Employee Resume

HRMS73 Performance appraisal process C X

should be supported for any desired

period (Half-yearly, Annual, etc.)

HRMS74 Should be able to manage promotions, transfers and C X

postings of all employees within the
Organization or on deputation to
outside Organizations, with adequate security built in for
access

HRMS75 only to the authorized persons C X

Should be able to manage and facilitate budgeting
of vacancies for
different cadres or posts based on
reservation, requirement and also on business
growth, any other

HRMS76 Should be able to pick up the D X

choice of posting from the self
appraisal form and link it at the time
of TMP, mutual transfers

HRMS77 Should provide ability to maintain grievance matters C X

and information, disciplinary actions, punishment
details, leave record and link them to performance
appraisal

Training & Development

HRMS78 Should support preparation of D X
yearly (or user defined) training
calendar

HRMS79 Should be able to track and D X

schedule courses for both in-house
and external courses

HRMS80 Should be able to maintain and Track instructor's profile D X

(part time, full time, in house, etc.) &
feedbacks on their performance,
training facilities, standard
equipment required for courses,
and equipment available at training facilities

HRMS81 Should be able to provide link to N X

training institute URLs for training
details

HRMS82 Should have facility to receive D X

“Training Needs Analysis” forms
from various locations/departments
for the purpose of creating a training plan

HRMS83 Should have facility to complete course booking online N X

HRMS84 Should be able to make online approvals for training N X

requests

HRMS85 Support to identify training needs D X

from the Performance Appraisal
system on the basis of the
development areas identified

HRMS86 Should be able to check training D X

room and instructor availability
online

HRMS87 Should have provision to maintain minimum and D X

maximum number of employees per course and create
waiting lists if enrollments exceed
maximum number of employees/agents

HRMS88 Should be able to auto enroll waitlisted N X

employees/agents
HRMS89 Should be able to track training D X
requirements for jobs or re-
certifications
HRMS90 Should be able to track information about new joinee D X
training

HRMS91 Should have the facility to capture D X

competency based trainings for
each position

HRMS92 Should be able to Identify relevant D X

training programs based on
competencies with justification as to
who to attend etc.

HRMS93 Should identify competencies that employees gain from N X

completing a
course and provide for automatic
updation of employee competency inventory

HRMS94 Should have the capability to maintain training budgets D X

at
employee level, department level,
senior management level
HRMS95 Should be able to track training budgets for budget D X
periods
HRMS96 Should track training costs for employees D X

HRMS97 Should be able to generate and D X

email training letters to employees,
including course confirmation,
cancellation, and rescheduling

HRMS98 D X
Should provide comparison between planned and real
costs
HRMS99 Should be able to record and review D X
employee feedback for various
parameters viz., training facility,
instructor, and course materials

HRMS10 Should be able to maintain Training D X

0 history of all employees with
effective dates

HRMS10 Should be able to record test results conducted as a part D X

1 of the training
certification
HRMS10 Should be able to maintain feedback from employees as D X
2 well
as instructors on training for
assessment of training

HRMS10 effectiveness and impact D X

3 Should be able to identify key
positions for the purpose of
succession planning

HRMS10 Should have the ability to plan for N X

4 vacancy of the key position in
advance

HRMS10 Should be able to identify the gaps / N X

5 developmental areas between the
identified employees and
requirements of the key position

HRMS10 Should be able to define training N X

6 courses and groups courses into
training programs - and tie to job
codes for career planning

HRMS10 Should support identification of training elements as D X

7 result of QA &
Risk Management (to come via
technical department)

HRMS10 Should be able to allocate training costs to D X

8 offices/departments
HRMS10 Should be able to identify trainer / D X
9 instructor competencies and match
to courses

HRMS11 Should be capable of reallocating D X

0 budget if there is a department to
department transfer

HRMS11 Should help track & analyse D X

1 workgroups for quality
enhancement after training

HRMS11 Should help analyse relevance of D X

2 training taken to current or future
job profile
HRMS11 Should have Provision for E- Learning D X
3 - Registration Capabilities
- Management of curriculum and courses
- Student Interfaces to courseware
- Administration (for example, test and assessment
capabilities, certification, instructor assignment
to the courses, any regulatory requirements and history)
Reporting Requirements

HRMS11 Should be able to generate the C X

4 required reports including: Critical
- Overall Training MIS report should be generated
department wise, locations wise
- Training Gap: Requirement vs. coverage plans for
individuals
- Total No. of Staff
- Budget Available
- Budget utilized
- % of staff who have attended a
particular no. of man days of training
- % of staff who have attended at least one training
- Average training man days
- % type of training
- List of training attended
/scheduled/approved by organization/ department/
employee/ period
- List of employees who failed to attend a training

Leave Management
HRMS11 Should be able to define and C X
5 maintain leave calendars for
different types of leave

HRMS11 Should be able to set up Leave X

6 Types/Codes (Annual, Sick, Maternity/Paternity, Casual,
Compassionate etc.)

HRMS11 Should be able to set up leave entitlement/carry forward C X

7 details –
Leave type/Grade wise

HRMS11 Should be able to maintain rules for leave taken in terms C X

8 of rules for availing leave, encashing leaving,
accrual of leaves, lapsing of leaves,
ceilings for accumulation of leaves, rules for combination
of leave types,
etc.

HRMS11 Should have provision to handle C X

9 leave spill over, if the leave spills
into next year
HRMS12 Should be able to make leave adjustments/maintenance C X
0 option
with Control

HRMS12 Should have linkages to Attendance D X

1 Capturing system (swipe card,
manual input, etc.) - should be able
to take into account absence due to official reasons
(tours, etc.)

HRMS12 Should have an alert for the supervisor if someone D X

2 remains absent without approval for more
than a particular no. of days &
enable the supervisor to send notice to the employee (if
necessary)

HRMS12 Should support flexi-time leave D X

3 calculations so that employee can
apply for flexi-leave online

HRMS12 Should be able to check the leave D X

4 balance and approve flexi-leave
accordingly & update

HRMS12 Should allow employees to raise a C X

5 leave request after availing the
leave

HRMS12 Should have facility to maintain C X

6 National Festival Holiday calendars
for different regions/countries

HRMS12 Should be able to enter /update C X

7 leave details & record the same
with proper validation

HRMS12 Should alert/raise task for the C X

8 supervisor (work flow enabled) once
leave details completed by
applicant

HRMS12 Should provide an option to Approve/Reject/Forward the C X

9 leave application and enter
Remarks/Recommendations at each level

HRMS13 Should enable automatic escalation D X

0 in case of delays (based on defined
rules)
HRMS13 Should send email notifications to the originator at each C X
1 level

HRMS13 Should automatically update leave C X

2
details, once leave application is
approved by the supervisor

HRMS13 In case of cancellation of leave by employee or C X

3 employee joins office before the leave period is over,
should automatically credit these
leave days back to employee.
[Employee request for Leave credit with Approval from
supervisor should be sent to HR]

HRMS13 Should be able to inquire and view C X

4 the status of leave request at any
point of time by applicant/supervisor

HRMS13 Should be able to record Leave C X

5 Encashment request

HRMS13 Should be able to record details for C X

6 accounting of Compensatory Off
Leave [Facility to have individual
employee calendar]

HRMS13 Should be able to view leave details C X

7 and balance of any type of leave
(Past/Approved)

HRMS13 Should have options for various record search criteria C X

8
HRMS13 Should have link to payroll & C X
9 employee history

HRMS14 Should have a link with the appraisal system D X

0
Reporting Requirements
HRMS14 Should be able to generate the following reports: C X
1 - Leave balance report by
Department/section/unit head
- Leave listing by employee/types
- Leave accrued/availed listing by
employee/department/type

Compensation Management/ Payroll

HRMS14 Should be able to define Grade C X
2 Codes/Classes/Groups
HRMS14 Should be able to associate Grade C X
3 Codes with Salary Steps

HRMS14 Should be able to associate Grade C X

4 Codes with Job Codes, Position

HRMS14 Should be able to define C X

5 Compensation Rates

HRMS14 Should be able to maintain full C X

6 history of all Employee deployment information, such as
organization,
grade & job changes

HRMS14 Should be able to keep a full history C X

7 of employee payment and rules

HRMS14 Should be able to maintain C X

8 information on any type of cash or
non-cash compensation

HRMS14 Should be able to compute varied benefits provided to C X

9 employees such as Leave Travel Allowance, Medical
Reimbursement, Medical Insurance, Furniture, House
Rent
Allowance, Company Cars,
Company Housing and other long term reimbursements.
Eligibility,
computation and taxability
(professional tax for different states)
should be considered

HRMS15 Should be able to create and C X

0 maintain Medical Insurance
premium table (Premium paid for
employees & dependants)

HRMS15 Should have a option to have C X

1 Compensation details in any
currency

HRMS15 Should be able to grant D X

2 bonuses/allowances automatically
or based on manager's discretion
HRMS15 Should be able to have unlimited C X
3 number of fixed and variable
allowances for all employees

HRMS15 Should be able to define various C X

4 pay elements like earnings and
deductions using a rules based
framework

HRMS15 Accommodate the temporary override of all allowances: C X

5 - For a single payroll processing period
- For a pre-defined number of periods at a fixed amount
- For a pre defined number of periods but a variable
amount based on – Percentage/Period

HRMS15 Should be able to flag allowances as active and inactive C X

6

HRMS15 Should maintain a full history of employee allowances C X

7

HRMS15 Should have an option of different rules for the same C X

8 allowance for:
- Individual employees
- User defined groups of employees
- Employee type
- Provide a facility to backdate allowances
- Addition of new allowances
- Increase/decrease of allowances

HRMS15 Should provide a facility to apply D X

9 future commencement and
completion dates for all allowances

HRMS16 When a new employee joins in between the financial C X

0 year, some pay details must be carried over
from the previous employer and
recorded in payroll system; Facility
HRMS16 Should be able to accommodate C X
1 unlimited fixed and variable
deductions for all employees

HRMS16 Should be able to calculate and/or validate deductions C X

2

HRMS16 Should be able to maintain details C X

3 on pension contributions at a user
defined % of salary components
according to existing regulations

HRMS16 Should be able to accommodate C X

4 user defined deductions [Generic
Criteria

HRMS16 Should be able to accommodate the C X

5 temporary override of fixed
deductions:
- For a single payroll processing period
- For a pre-defined number of periods at a fixed amount

HRMS16 Should be able to set up a limit to D X

6 which gross or net pay can be
reduced with deductions:
- % Of gross pay
- % Of net pay
- % Of basic salary or other salary element or
combination of basic + other salary element
HRMS16 Should have a facility to mark validity of a Deduction C X
7

HRMS16 Should be able to flag a deduction as active or inactive C X

8

HRMS16 Should include only active deductions in payroll C X

9 calculation

HRMS17 Should automatically change a C X

0 deduction class to inactive if that
deduction is currently not applicable
to any employee

HRMS17 Should allow the implementation of a deduction at a C X

1 selected date and
provide start and stop dates for all
deduction types

HRMS17 Should be able to backdate the deduction allowing the C X

2 system to
accumulate the balance due to date
(i.e. retroactively apply a deduction)

HRMS17 Should be able to apply deductions C X

3 to be applied for a fixed period

HRMS17 Should maintain a full history of employee deductions C X

4
HRMS17 Should also maintain a full history of C X
5 employee deduction calculation
rules

HRMS17 Should be able to maintain standard deductions codes C X

6
HRMS17 Should be able to establish a deduction range for each C X
7 type:
- By employee
- By job classification
- By employee segment

HRMS17 Should have facility to handle pay C X

8 scales of the parent organisation in
case of deputation

HRMS17 Should enable setting priorities for deductions C X

9

HRMS18 Should have the ability to process a one time deduction C X

0
HRMS18 Should have facility to import C X
1 deductions from external agencies
(e.g. societies, etc.)

HRMS18 Should have facility to export soft copies of deduction C X

2
HRMS18 Should show balances of loans and advances in the pay C X
3 slips
HRMS18 Should be able to determine CTC D X
4 for employees

HRMS18 Should be able to capture ESOP N X

5 details given to employees

HRMS18 Should have online provision to N X

6
exercise ESOP with relevant lock-in
period and other rules built in

HRMS18 Should be able to update ESOP N X

7 balances

HRMS18 Employee should be able to view N X

8
updated ESOP balance in their
account

HRMS18 Should support integration with the C X

9 Enterprise Financial to process all
perks and benefits payable and
reimbursements, as allowed
HRMS19 Should provide a self-service application to all C X
0 employees so that employees can view salary details,
leave details as well as apply for leave, advances or
loans
HRMS19 Should enable employees to fill their training C X
1 requirements, view
their LTS or Leave encashment
details, Mediclaim details, and Life
Insurance accumulations

HRMS19 Should be able to handle suspensions C X

2
HRMS19 Should enable checking Holiday N X
3 Home availability, booking of the
holiday home for the specified
period through the employee’s portal

HRMS19 Should have a provision for new allowances or C X

4 deductions in future

HRMS19 Should support integration with the financial package C X

5 for matters which
have a financial implication like TE
Bills processing, entertainment
expenses, other authorized payments

HRMS19 Should be able to withdraw all C X

6 privileges on any form of exit like retirement,
termination and also on
a transfer (revised privileges to an
employee who is transferred must be given only on his
reporting

HRMS19 Should provide capability to view C X

7 Arrear calculations, DA arrears for
pensioners

HRMS19 Should be able to handle terminal C X

8 benefits including pensions, family
pensions, gratuity, etc

HRMS19 Should be able to handle employee C X

9 benefits like PF, NMBS, etc
HRMS20 Should be able to handle C X
0 processing of PF loan applications, mutual benefit
society

HRMS20 Should be able to handle post retirement medical C X

1 benefits
HRMS20 Should support integration with C X
2 software used by various Thrift &
Credit Societies for data exchange

HRMS20 Should support generation of e-TDS C X

3 and e-Returns as prescribed by IT
act (as amended from time to time)

HRMS20 Should provide user friendly interface to employees D X

4 with inbuilt
logic for filing e-returns

HRMS20 Should have capability to generate C X

5 PF statement, Accounting of PF
accrual including company
contribution, PF Loan details etc.
Housing Loan

HRMS20 Should enable processing of C X

6 Housing Loans according to
company rules

HRMS20 Should enable integration with financial package to C X

7 facilitate
disbursement of loan by Accounts
Processing Centres

HRMS20 Should be able to consider the recoveries for IT C X

8 Benefits subject to
IT rules

HRMS20 Should be able to rework Housing C X

9 Loan balances in case of
foreclosures, other adjustments

HRMS21 Should enable revision of housing loan eligibility C X

0 with retrospective
effect (involving transfer of
Supplementary loan to Scheme loan, with
retrospective revision of
interest rates)
 Reporting Requirements
HRMS21 Should be able to meet the various reporting C X
1 requirements including the following:
Generation of payroll report based on inputs from all HR
coordinators & submission to finance
Report showing Employee no, name, Date of Joining,
job title, grade basic salary, allowances and gross salary
Facility to generate reports on increments history,
position history, salary history
Information for salary to Finance Dept from HR
authorized by HR HOD
- New Entrant: Name, DOJ (Date of Joining)
- Resignat+B358ions: Name, DOR (Date of Resignation)
- Other Additional
Payments/deductions
- Consultant Payment
- Site Allowance
- Company Leased
Accommodation
- Superannuation Payment
- Remittances made to LIC, etc.
- Medical Reimbursement
- Functional Allowances

HRMS21 Should facilitate maintenance of a single database of C X

2 all employees, including the part-time employees or
temporary employees and
process the payroll and terminal
benefits payable to employees with an interface to the
Enterprise Financial Application
HRMS21 Should be able to record and store comprehensive c X
3 information for an
employee, including:
Employee No.
Employee Name
Employees Present Residential
Address with pin code
Employee Permanent Address with pin code
Phone
Mobile
E-Mail
Sex
Nationality
Religion
Education Qualification
Previous Employment
Date of birth
Work Experience
Languages known (Mother
Tongue, Other languages known)
Marital Status
Employee photo, Signature
Passport / PAN Number
Date of Joining NIC
Date of Joining Parent Company
Category (OBC, SC/ST, General)
Bank Account information
Emergency Contact
Physical Disability
Ex- Service man Status
State of Domicile
Home State
Details of Dependants
Probation period and probation extension
Confirmation Date
Details of perks entitled (Vehicle Entitlement, Telephone,
Company Owned Accommodation, etc.)
HRMS21 Should permit multiple positions/depts. to same X
4 individual
HRMS21 Should enable archiving of data C X
5 (where data are unavailable as soft
copies, hardcopies can be scanned
and archived)

HRMS21 Should capture details from the examining body like C X

6 National
Insurance Academy for class I promotions
HRMS21 Should provide facility to view the latest circulars for D X
7 the employees online and an upload facility for the
department to publish all the
circulars and updates for the benefit of the employee
Should be able to maintain the current and full
history of all
employee related information with C
an option to drill down to any specific parameter
(illustrative):
Disciplinary Proceedings
Details of disciplinary cases initiated & completed
against the employee
Date of suspension, revocation, explanation date, reply
date
Record on Non- Vigilance
Suspension cases
Details of grievances initiated by
employees/unions/associations
Details of strikes
Details of employees on strike on the particular date,
employees on work and employees on leave
Duration of the strike to be recorded
Zone wise strike details
Details of the unions in existence
Details of employees affiliated to the unions
Capability to record the nominees from the union, the
HRMS21 Should
demandsbe able
of the to maintain the current and full
union C X
8 history of all
employee related information with
an option to drill down to any specific parameter
(illustrative):
Disciplinary Proceedings
Details of disciplinary cases initiated & completed
against the employee
Date of suspension, revocation, explanation date, reply
date
Record on Non- Vigilance
Suspension cases
Details of grievances initiated by
employees/unions/associations
Details of strikes
Details of employees on strike on the particular date,
employees on work and employees on leave
Duration of the strike to be recorded
Zone wise strike details
Details of the unions in existence
Details of employees affiliated to the unions
Capability to record the nominees from the union, the
demands of the union

Competency Management
HRMS21 Should be able to create and maintain jobs & job D X
9 descriptions
HRMS22 Should be able to maintain a skill set dictionary D X
0
HRMS22 Should track employee D X
1 competencies and
accomplishments
HRMS22 Should be able to list the skills and accomplishments of D X
2 each
employee, and also qualify each to
a role, job, or training regime within the organization
HRMS22 Track & Maintain Competencies : Competencies are D X
3 directly related to an employee’s current role and may
encompass skills, abilities, knowledge, or behavior.
Unlike
accomplishments, competencies
are measured using a defined scale (one employee
might have more sophisticated computer skills than
another, for example).

HRMS22 Track Accomplishments : Accomplishments are tangible, D X

4 typically one-time achievements. An accomplishment
might be a degree, license, language, test score, honor
or award, or membership. In
tracking employee accomplishments, you record your
employees' educational
achievements, language skills,
licenses and certifications.

HRMS22 Perform real-time match and gap analyses between the D X

5 workforce'
current competencies and
organization’s requirements

HRMS22 Should be able to assign clusters and individual D X

6 competencies/accomplishments to
a role and utilize the Person to Role
Match inquiry

HRMS22 Should be able to establish competency definitions, D X

7 attach
proficiency ratings and set up
training programs to improve competencies
HRMS22 Should be able to create teams based on group N X
8 competencies
HRMS22 Should be able to maintain a repository of competency N X
9 profiles

HRMS23 Should be able to maintain a list of C X

0 claims that require an approval as
per the policy

HRMS23 Should be able to maintain list of C X

1 claims allowed (as per the HR policy), depending on the
category/class of employee (Short term loan, Relocation
allowance,
LTA, Car expense, Medical,
Telephone/Mobile, Remote allowance, Professional
Membership, Educational
Assistance, Notice Period salary etc.)
HRMS23 Facility for employees to raise an online claim. It is C X
2 expected that the employee understands the policy to
know his eligibility etc. before
raising the claim. But, it might
happen that the supervisor/HR can
allow the employee flexibilities on certain grounds.
Hence, the system at any point should not prevent the
employee from raising a claim

HRMS23 Should be able to submit claim for approval (workflow C X

3 based)

HRMS23 Supervisor/HR should be able to C X

4 check for eligibility & validity of
claim and then approve/disapprove

HRMS23 Should automatically notify accounts to make payment C X

5 for all
approved claims with relevant
supporting documents

HRMS23 Should automatically intimate employee that the claim C X

6 has been
processed or kept pending for
various reasons

HRMS23 Should allow employees at any C X

7 point in time to track the status of
their claim

Employee Separation
HRMS23 Should be able to maintain (enter C X
8 and update) employee exit details
with proper validation
HRMS23 Should send alerts/notification for C X
9 employee exit (via Email) to the
following:
- HOD
- Access Card processing Unit
- Payroll
- Accounts
- Administration department

HRMS24 Facility to maintain a checklist to C X

0 track status of various processes
involved in Employee Exit process

HRMS24 Should automatically generate an C X

1 Alert/Notification to Payroll
processing Unit once the clearance
from all checklist items
[Units/Departments] is received

HRMS24 Should be capable of capturing the exit interview details N X

2

HRMS24 Should be able to generate the Full C X

3 & Final settlement report, the
service certificate etc

HRMS24 Provision for debiting from C X

4 employee the pro-rata amount of all benefits like Loans
and allowances, etc. If the employee has claimed for the
whole year but quits in the
middle of the year, the system should be able to
generate the receivables accordingly

HRMS24 Should be able to generate the required reports for D X

5 attrition analysis
CDA Rules
HRMS24 Should have the provision of keeping a record of CDA C X
8 rules
HRMS24 Should enable conducting CDA C X
9 inquiry proceedings through
workflow system

HRMS25 Should be capable of recording C X

0 CDA actions taken and effecting
necessary systems such as C
Enterprise Financials, etc.

Integration Requirement
HRMS25 Should also be able to integrate C X
1 with the other applications including
Enterprise Financial
Workplace Management System
Access Management System

Recom
mended
BoM

Talent Acquisition Manager

Core HR
Benefits
Training
e Performance, e Bnenefits, e Pay
Global Payroll & Absence Management
ELM

270 232 14 24
85.93 5.1852 8.889
Remarks No of Mandays of Interdepend
Effort required for encies/
Modification / Overlaps/
Cutomization) Inputs
required
from the
allied
Position Management &
Reporting tool helps identify
vacant & planned positions
End to end recruitment
solution helps track, maintain
applicant data
Vacancies can be posted on
various sites & job portals
Workforce admin helps
maintain complete employment
history of employee from hire
to retire admin module
Workforce
maintains the complete
promotions records. Using self
service manager can
recommend for promotions.
Workforce admin module
maintains the complete
transfer records. Using self
service manager can
recommend for transfers.
Global & local assignments
can be maintained &
processed with deputation
allowance.
Disciplinary Actions, grievance
handling are part of core HR
Using Base Benefits of core 40 Mandays
HR, various staff welfare can (Aprox)
be maintained.However some
enhancemengts may be
needed to meet PSU specific
requirements

ePerformance has complete

performance appraisal
functionality
Training Admin module has
complete training admin
functionality starting from
Training budgeting, calendar
creation, cost analysis,
resource managemnt and
online enrolling tracking of
training programs
career planning module helps
to identify career path for
various positions & employees.
Succession planning module
helps to identify key positions
& create succession planning
Global Payroll module with
Local country functionality
takes care of compiling of data
from various other modules
and process it as per defined
rules & policies of the org

Absence Management has got

online leave management
capability & integrated with
payroll for LOP deductions etc
Elements are building blocks 15 Mandays
of payroll. Various ruls and
validations can be written to
process those elements based
on org need. Loans &
Advances are among them.
Some customisations or rule
definitions need to be built to
work in org defined way.

Elements are building blocks

of payroll. Various rules and
validations can be written to
process those elements based
on org need. Loans &
Advances are among them.

Elements are building blocks

of payroll. Various rules and
validations can be written to
process those elements based
on org need. Terminal benefit
elements can also be defined
and processed based on org
policies & need.

In Workforce Administration
Module using the Job
Transaction
Elements are building blocks
of payroll. Various rules and
validations can be written to
process those elements based
on org need. Terminal benefit
elements can also be defined
and processed based on org
policies & need.
Elements are building blocks 25 Mandays
of payroll. Various rules and (Aprox)
validations can be written to
process those elements based
on org need. PF management
elements can also be defined
and processed based on org
policies & need.

Using Health Benefit Plan in

Benefits Module
Create Messages in Message
Catalog for all Modules

Using the Personal Information

in Workforce Administration
Administer Training Inbound and
(Integaration Methodology) Outbound
Interfaces should
be created. 5
(Approx) for
Inbound , 5
(Approx) for Out

Recruiting Solution has end to

end recruitment functionality
with self service option. Based
on Roles, user can perform
this action
Recruiting Solution has end to
end recruitment functionality
with self service option. Based
on Roles, user can perform
this action.

Although many workflows are

inbuilt, additional Workflows
can also be created using
approval workflow engine
based on requirements.
Recruiting Solution has
capability to post vacancies on
multiple sites

Using Profile Management, we

can define Job description and
attach to roles which is used
for creating Job requisitions
Candidate gateway in
Recruiting Solution has such
functionality
Recruiting Solution has end to
end recruitment functionality
with self service option. Based
on Roles, user can perform
this action.
Applicant data can be
maintained extensibly in
recruiting sol

Track & maintain applicant

data can be done easily

Candidate gateway in
Recruiting Solution has such
functionality

Applicant data can be

maintained extensibly in
recruiting sol. The data can be
entered by applicant or
recruiter based on role 7
access given to them.
Correspondence feature of
recruiting sol has capability to
send such notifications

Track & maintain applicant

data can be done easily

Track & maintain applicant

data can be done easily

Source of CV received can

easily be maintained while
entering applicant data.

Source of CV received can

easily be maintained & tracked
Verity search engine in
Recruiting sol has capability to
search the data by keying in
Key words.
Applicant pool can be
maintained and purge & merge
the duplicate data whenever
required.
Applicant pool can be
maintained and purge & merge
the duplicate data whenever
required.
Applicant pool can be
maintained and purge & merge
the duplicate data whenever
required.
Applicant pool can be
maintained and purge & merge
the duplicate data whenever
required.
Verity search engine in
Recruiting sol has capability to
search the data by keying in
Key words.
Verity search engine in
Recruiting sol has capability to
search the data by keying in
Key words.
Various questions can be
attached to job positions and
allow candidates to undergo
online test while applying
against such positions.

Capable to handle Inteview

scheduling & tracking

Capable to handle Inteview

evaluation online & tracking

Contract details can be

maintained for contractual
employees in workforce admin.
Capable to record background
check details
Correspondence feature of
recruiting sol has capability to
send such notifications

Correspondence & online letter

generation feature of recruiting
sol has capability to generate
letters & send such
notifications to candidates.
Capable to record Medical
check up details
Able to generate offer letter
after various validations by
generating reports.

Capable to generate various

Checklists and provide links
against those action items

Inbuilt functionality between

recruitment & workforce admin
sol
Applicant tracking & monitoring
is the basic functionality.

Using Reporting tools, various

reports can be generated

Various comments & reasons

can be recorded against each
applicant

Workflow notifications can be

sent thru Approval Workflow
engine.

Handles Using Checklist

functionality

Handles Using Self Service

option

Emp id can be generated

manually or automatically
based on requirement
Workflow notifications can be
sent thru Approval Workflow
engine.
Reports in Talent Acquisation Each Report will
management take 8 Mandays
(Approx)

Various Rating Models can be

created with def

Various Performance doc can

be created and its details can
be maintained in Performance
templates & document
Using Self service emp can
enter & store their KRA & sub
KRAs

Workflow notifications can be

sent thru Approval Workflow
engine based on requirements

Using Profile Management, we

can define Job description and
attach to roles which may be
used for performance
appraisal doc
Various Performance doc can
be created and its details can
be maintained in Performance
templates & document
Capable to create such links 5 (Approx) for each
and allow users to view such processes
details whenever required.

Workflow notifications can be

sent thru Approval Workflow
engine based on requirements
Performance doc can be
generated for emp, retainers,
contractors provided their data
is maintained in the system

Using ePerformance, end to

end Performance appraisals
cycle can be maintained,
tracked and processed.
Performance templates can be
configured and such access
can be defined while creating
perf documents

Various sections can be

created to add into perf doc to
take care of such requirements

Various sections can be

created to add into perf doc to
take care of such requirements

Various sections can be

created to add into perf doc to
take care of such requirements

Training needs can be

captured in one of the section
and identified as training
needs for training module
Access can be defined at the
time of creation of template

Monitor Per doc helps to track

& monitor all perf docs

Can be done using reporting 4 (Approx)

tools

Can be done using reporting 4 (Approx)

tools

Workflow notifications can be

sent thru Approval Workflow
engine based on requirements
Workflow notifications can be
sent thru Approval Workflow
engine based on requirements
There are various security
levels which can be used to
make it secure based on org
requirements
Peoplesoft HRMS is integrated
HR solution where all modules
like Performance Mgmnt,
Compensation, recruitment are
integrated. Any info entered in
one of the module reflects in
other immediately.

Capability to handle any kind

of appraisal process

Using updated Profile

Management, employee
resume can be generated
Capable to handle the
frequency based appraisal
system

Workforce admin module takes

care of it

Reusuable templates specific

to govt takes care of this
functionality. Some of the
vendors have built it as
reusable functionality for
PSUs.

Reusuable templates specific

to govt takes care of this
functionality. Some of the
vendors have built it as
reusable functionality for
PSUs.
Using reporting tool, such
reports can be generated and
use it as input for appraisal
cycle.
Using reporting tools, such
needs can be identified.

Training module has capability

to schedule, track & maintain
training details.

Training module has capability

to track & maintain resources,
facilities, instructors details.

ELM has capability to conduct

online training session and
also provide external training
institute links.
Training Need analysis forms 15 Mandays
need to be developed for the (Approx)
same.

Online training enrollment can

be done using Employee &
manager self service and also
by training administrator
using Manager Self Service,
online training approvals can
be done and summary can be
viewed & tracked.
Training needs can be used as
one of the sections of
performance document which
is integrated with ELM to
identify training needs.
Training module has capability
to track & maintain resources,
facilities, instructors details.

Administer Training (Managing

Waiting Lists)

Administer Training (Enrolling

in Course)
Administer Training (Track
Training Requests )
Training programs can be
created for Induction and
complete tracking can be done
Administer Training (Defining
Instructor Competencies and
Accomplishments)

Administer Training (Enrolling

Employees by Department
Demand )

Administer Training

Administer Training (Planning

Training Budgets)

Capable to track & handle

training budgets & cost.
Capable to track & handle
training budgets & cost.
Capable to send various
correspondence to employees
using Online letter generation
functionality.

Using reporting tools, such

reports can be generated

Using training feedback form,

training assessments can be
done. Accordingly other
feedbacks can be obtained.
Online assessment can also
be conducted using
assessment tool.

Capable to track & maintain

training history.

Training certifications & their

expiration alert can be
triggered & recorded.
Using training feedback form,
training assessments can be
done. Accordingly other
feedbacks can be obtained.
Online assessment can also
be conducted using
assessment tool.

Using position management,

key positions be identified and
succession planning be done.

Position Management is
capable to handle this.

Position Management is
capable to handle this.

career Planning & profile

management can jointly
handle this.

Using reporting tools, such

reports can be generated

Plaining Training Budgets in

Administer Training
Delivered functionality of
training module

Capable to handle such

changes

using Assessment tool, such

evaulations cane be done

using Assessment tool, such

evaulations cane be done
Using complete ELM solution,
all the below requirements can
be maintained & tracked.

Reports in Administer Training Each Report will

take 5 (Approx)

Using Absence elements,

Various leave rules & types
can be created

Using Absence elements,

Various leave rules & types
can be created

Using Absence elements,

Various leave rules & types
can be created

Using Absence elements,

Various leave rules & types
can be created

Using Absence elements,

Various leave rules & types
can be created
Using Absence elements,
Various leave rules & types
can be created

Capable to build interface

between Attendance system
and leave management
system.

There are many workflows by

defualt available with various
processes, yet many more
workflows could be generated
using Approval workflow
engine.

Using Absence elements,

Various leave rules & types
can be created

Self Service option employee

& manager can check leave
balance and take appropriate
actions
Self Service option employee
& manager can check leave
balance and take appropriate
actions
Holiday list can be attached to
location/different regions to
identify absence details
accordingly
Self Service option employee
& manager can check leave
details and take appropriate
actions
Worklist functionality &
workflow raises tasks for
various concerned users

Self Service option employee

& manager can check leave
details and take appropriate
actions

Using Approval workflow

engine, escalations can be
created
There are many workflows by
defualt available with various
processes, yet many more
workflows could be generated
using Approval workflow
engine.
Inbuilt functionality

Capable to update leave

balance on cancellation

Self Service option employee

& manager can check leave
details and take appropriate
actions
Using Absence elements,
Various leave rules & types
can be created
Using Absence elements,
Various leave rules & types
can be created

Self Service option employee

& manager can check leave
details and take appropriate
actions
Inbuilt Feature

Delivered integration between

Payroll & absence
management
Inbuilt Feature

Reports

Delivered functionality of
compensation.
Delivered functionality of
compensation.

Associated while creating job

codes

Delivered functionality of
compensation.

Workforce admin takes care of

it

Functionality of Global Payroll

Using Payroll elements

functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing.

Using Payroll elements 12 Mandays

functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing.

Using Base Benefits, such

elements can be defined.

Delivered functionality of
compensation.

Using Payroll elements

functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.
Using Payroll elements
functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Using Payroll elements

functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Temporary override may be

done at element level in the
payroll element screen for
limited period.

Payroll element can be made

active & Inactive on payroll
element definition screen
Compensation history can be
maintained and tracked on
compensation history page.
Using Payroll elements
functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Using effective date

functionality, such
requirements can be taken
care of.
Previous employment salary
details and investment details
can be captured using self
service or otherwise and
consider for next financial year
tax calculation.
Using Payroll elements
functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Using Payroll elements

functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Using Payroll elements

functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Using Payroll elements

functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Inbuilt Feature

Setup Earnings and

Deductions in Global Payroll
Using Payroll elements
functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Using effective date

functionality, such
requirements can be taken
care
Usingof.
effective date
functionality, such
requirements can be taken
care
Not of.advisable to practice in
this way. Reports can be
generated to identify those
deductions and later decision
of making it Inactive should be
made.
Using Payroll elements
functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Using Payroll element

definition, we may create back
dated elements and process it
retroactively.

Using effective date

functionality, such
requirements can be taken
care of. functionality
Delivered

using reporting tool, we can

identify the same.

Using Payroll elements

functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.
Using Payroll elements
functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing. Using
Compensation Self Service,
bonus can be distributed.

Linked with workforce admin

where such changes are made
and system automatically
checks the eligibility of payroll
during the deputation period
Arranging deduction elemsnt in
sequential order in a section
checks its sequential process
and process the same.
Inbuilt Feature

Interface in Global Payroll Interafce will take 5

(Approx)

Interface in Global Payroll

Pay Slip enhancement in 15 Mandays

Global Payroll (Approx)
Pay Slip enhancement in 15 Mandays
Global Payroll (Approx)

using Payroll element

definition, ESOP details can be
captured
Although US specific module is
given, yet may be customised
to meet org requirements.

using Payroll element

definition, ESOP details can be
captured
using Payroll element
definition, ESOP details can be
captured

Integration Methodology (By Inbound and Integration

Component Interface , SQR, Outbound with Financial
Integartion Broker) Interfaces should module
be created. 5
(Approx) for
Inbound , 5
(Approx) for Out
e Pay

self service option can take

care of the requirements,

Workflow admin & GP jointly

can take care of it
New Process in Workforce 5 (Approx) for each
Administration component

Using Payroll elements

functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing.
Effective date functionality
helps to take care of future
dated creation of elements

Integration Methodology (By Inbound and Integration

Component Interface , SQR, Outbound with Financial
Integartion Broker) Interfaces should module
be created. 5
(Approx) for
Inbound , 5
(Approx) for Out
Using Payroll elements
functionality, various payroll
elements can be defined. Rule
engine helps to create various
rules with validations and use
it for payroll processing.
Effective date functionality
helps to take care of future
dated creation of elements

Can be viewed at formula 10 Mandays

screen

Using Job Information in

Workforce Administration

Using benefit Plans in Benefits

Although PF loan can be 10 Mandays
processed thru payroll, yet
some of the PSU specific rule
need to build up.
Job Information in Workforce
Administration
Integration Methodology (By Inbound and Integration
Component Interface , SQR, Outbound with Thrift
Integartion Broker) Interfaces should and Credit
be created. 5 Societies
(Approx) for each
Inbound , 5
(Approx) for Each
Self Service Applications in e Report will take 5
Pay (Approx)

Self Service Applications in e Report will take 5

Pay (Approx)

Reports in Benefits Report will take 5

(Approx)

By Benefit Plan in Benefits Report will take 5

(Approx)

Integration Methodology (By Inbound and Integration

Component Interface , SQR, Outbound with Financial
Integartion Broker) Interfaces should module
be created. 5
(Approx) for each
Inbound , 5
(Approx) for Each
Local country functionality
helps calculate & deduct IT as
per Income tax act.

Loan start date & end date

functionality allows the users
to foreclose housing loan.

Housing Loan element It will be created

definition can be changed with along with the
effective date and processed Previous
proactively & retroactively. requirement
(HRMS209)
Reports in Global Payroll, Assumed there
Administer Workforce and would be 3
Benefits Reports. The
development
would take 20
Mandays (approx).
Job Transactions in Workforce
Administration

Job Transactions in Workforce

Administration
Peoplesoft Archiving
Methodology

Workforce Administration
workforce Administration (Job 30 Mandays
Transactions)

workforce Administration (Job The half of the

Transactions) requirement
delivered in
PeopleSoft. But,
Strike and the
details of strike
required
customization. The
total development
time would be 10
Mandays

Administer Workforce (Setup

Jobcode)
Manage Competencies

Profile Management maintains

& track employee competency,
accomplishments and other
details
Profile Management maintains
& track employee competency,
accomplishments and other
details
Profile Management maintains
& track employee competency,
accomplishments and other
details. Different rating Scale
can be defined and attach to
various competencies

Profile Management maintains

& track employee competency,
accomplishments and other
details

Search & Compare capability

of Profile Management helps
search & compare based on
various parameters like skills,
accomplishment etc.
Match Competency to role &
Role to competency
functionality helps identify
person suitability.

Competency definitions,
proficiency etc are configured
at set up level and updated
regularly.
Teams can also be created
and compared to various roles
& jobs
Competency Repository can
be maintained in Profile
Management.
e Benefits(By Self Service) 10 mandays

Although benefits can be

defined in base benefit module
of core HR, yet Some of the
vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality
Although benefits can be
defined in base benefit module
of core HR, yet Some of the
vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality

Although benefits can be

defined in base benefit module
of core HR, yet Some of the
vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality
Although benefits can be
defined in base benefit module
of core HR, yet Some of the
vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality
Although benefits can be
defined in base benefit module
of core HR, yet Some of the
vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality
Although benefits can be
defined in base benefit module
of core HR, yet Some of the
vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality
Although benefits can be
defined in base benefit module
of core HR, yet Some of the
vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality

using Workforce Admin

module, employee related Exit
informations are entered and
using employee checklist full &
final settlement can be
processed.
Using wokflow engine, such 3 Mandays
alerts can be developed &
used.

Administer Workforce(Manager
Self Service)

Using wokflow engine, such 3 Mandays

alerts can be developed &
used.

Using ePerformance template,

exit interview form can be
created and used to capture
the details of the same.
Using reporting tool & XML 10 Mandays
publisher such reports can be
generated & printed.

Proration functionality of
Payroll calculate the balance
or due amount and process.

Reports in Workforce 10 Mandays

Administration

Using Workforce Admin 20 Mandays

module, employee details can
be maintained Disciplinary
records & grievance handling
are recorded. To record strikes
some enhancements are
required to be done. Some of
the vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality
Using Workforce Admin
module, employee details can
be maintained Disciplinary
records & grievance handling
are recorded. To record strikes
some enhancements are
required to be done. Some of
the vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality
Using Workforce Admin 8 Mandays Integration
module, employee details can with
be maintained Disciplinary Financial
records & grievance handling module ,C
are recorded. To record strikes etc
some enhancements are
required to be done. Some of
the vendors have created
Reusuable templates to meet
PSU specific requirements and
may consider it as Out of the
box functionality

Integration Methodology (By Inbound and Integration

Component Interface , SQR, Outbound with other
Integartion Broker) Interfaces should modules like
be created. 5 Finance and
(Approx) for each Third Party
Inbound , 5 Applications
(Approx) for Each
 Functional Priority
HCL HCL
Requirements - (C/D/N) HCL-
ID - -
[Given by MOD
SUP CST
NIC]

General Requirements

Should have
standardized error
handling routines
with facility for
CRM1 seeking help C X
Should be capable
of handling
revised 8 digit pin
CRM2 codes C X

Should provide
integration with
knowledge
management to
enable access to
FAQs
(Frequently Asked
Questions)
CRM3 and other help C X
Customer Identification

Should enable
existing/prospective
customers to
interact with NIC
through multiple
channels (including
the following),
by providing web
based access to
CRM4 these channels: X
 NIC Office (Walk-
in/Email/
CRM4 Fax/Letter) C X X

CRM4 Call Centre D X

CRM4 Internet /Transaction D X

Agent/Broker/
CRM4 Alliance Partner D X
 Should provide
anywhere,
anytime (365 X 24 X
7)
functioning i.e.
should enable
location
independent and
person
independent
transactions such as
policy issue,
renewals,
endorsements,
claims intimation
CRM5 and settlement D X X

Should provide web-

based
access to alliance
partners/brokers/
agents (Partner
Portal/Agent
CRM6 Portal/Broker Portal) D X

Should be able to
unify customer
information and
provide a single,
integrated, multi
channel view of
total relationship
profile of the
customers,
CRM7 including: C X

Customer type (e.g.

individual
policy holder,
corporate, SME,
CRM7 rural sector) X
CRM7 List of all policies X

CRM7 List of all claims X

List of sales
CRM7 opportunities X
List of all policy
quotes and
CRM7 applications X
List of complaints
and service
CRM7 requests X
List of alerts and
CRM7 warning X

Should be able to
assign a unique
Prospect ID to a
prospective
CRM8 customer C X

Should be able to
identify and
merge duplicate
CRM9 client records C X

Should avoid
CRM10 duplicate data entry C X
 Should allow
capture of highly
detailed information
on Personal,
Demographic and
even Lifestyle
areas of any
stakeholder like
customer, agent,
broker, TPA,
Hospital, even TP
CRM11 claimants etc. C X

Should provide the

ability to
identify and
authenticate the
customer with
information such as
his customer
identification
number, date of
birth, etc. for all
interactions which
involve sales
and service
CRM12 transactions C X
Should have ability
to maintain
contact information,
CRM13 such as: C X
Name, title, phone
numbers,
fax numbers,
contact address,
CRM13 email X

CRM13 Contact reason X

CRM13 Salesperson's notes X

Privacy and contact

channel
preference, contact
timeslot
CRM13 preference X
 Should record
history of changes
CRM14 in client information C X

Should have
provision to capture
client's personal
information such
as
profession/interests/
tastes/hobbies in
order to provide
information about
the other
CRM15 products D X

Should provide
facility to capture
client bank details
for Electronic
Clearing System
CRM16 (ECS) D X

Should be able to
categorize
contact (employee,
partner, etc.)
by picking from a
configurable
CRM17 drop-down list C X

Should provide a
360-degree
view of the
customer in one
screen, including
customer
details, policies,
claims, policy
quotes and
applications, policy
service requests,
customer
service requests,
any important
CRM18 alerts, etc. C X
 Should provide a
complete history
of the multi-channel
interactions
with the customer
across all
interaction channels
including
face to face
interaction, inbound
and outbound calls,
email, fax,
CRM19 internet, etc. C X
Customer Self-Service

Should be able to
direct the
customer to the right
process,
based on the
recorded purpose of
interaction (e.g. if
purpose is
related to Sales
(policy/Renewal),
this is an input to
Policy Sales
Process; if purpose
is related to
some information
required, this is
an input to
Customer
Information/Request
Handling
process; if the
purpose is related
to any
Feedback/
Complaint/
Grievance,
this is an input to
Complaints/
CRM20 Grievance process) D X
Should enable
Customer
Selfservice
by facilitating direct
transactions through
Internet/mobile/
CRM21 phone/SMS, etc. D X
 Should provide
downloadable
proposal and claim
CRM22 forms D X
Grievance Redressal

Should provide
facility to
customers for
grievance reporting
through multiple
CRM23 channels: X

CRM24 NIC Offices C X

CRM25 NIC Portal D X

CRM26 Call Centre (24 x 7 x D X

CRM27 Phone/SMS D X
Agents/Corporate
Agents/Alliance
CRM28 Partners/Brokers D X

Should provide
facility to track the
status of grievance
reported
through a ticket
CRM29 number C X

Should maintain
record of all
complaints received
and action
CRM30 taken till disposal C X

Should be able to
generate
reports on the time
taken in
dealing with the
CRM31 grievance C X
Should enable
review of pending
CRM32 grievances C X
 Should be able to
generate
reports like cause
wise, region
wise, product wise,
age wise
analysis of
grievances and their
CRM33 disposal C X

Should be able to
capture service
request information
including
requester contact
information,
service request
description,
date/time resolution
needed,
special
instructions/comme
nts,
service request
status, type of
service request,
activities and
interaction involved
or planned,
reply channel
CRM34 preference, etc. C X

Should be able to
identify the
concerned NIC
office in case of a
grievance (after
customer
identification) and
forward the
grievance to the
CRM35 same C X
 Should be able to
capture the
source of grievance
(referred by
the ministry,
ombudsman, IRDA,
directly by
customer), and
assign
CRM36 priority accordingly C X

Should enable the

concerned NIC
office to forward the
grievance to
RO/HO, in case it is
unable to
CRM37 solve it C X

Should be capable
of checking if
the grievance is
resolved in time
(or the customer
has been
informed in case of
genuine
delays), and
escalate the same
in
CRM38 case of delay C X

Should be able to
close the ticket
number once the
grievance is
resolved to the
satisfaction of the
CRM39 customer C X
Customer Service Requests

Should provide
facility to
customers to make
information &
other service
requests through
CRM40 multiple channels: X
CRM40 NIC Offices C X

CRM40 NIC Portal D X

CRM40 Call Centre (24 x 7 x D X

CRM40 Phone/SMS D X

Agents/Corporate
Agents/Alliance
CRM40 Partners/Brokers D X
 Should enable
Service staff to
view policy and
claim information
to handle common
service
requests such as
inquiries about
premium due dates,
past claims
and payment
transactions, and
CRM41 interaction history C X

Should provide a
common front
end and ability to
create FNOL
(Claim) across the
CRM42 organization C X

Should be able to
integrate
Service, Sales and
Marketing
operations to
capitalize on
crossselling
and up-selling
opportunities when
serving an
CRM43 inbound request D X
Should provides
alert message
capability to prompt
the service
staff of any up-
selling and
crossselling
opportunities when
CRM44 servicing customers D X
 Should be able to
check (after
customer
identification) if the
customer query is a
1st level
query (readily
CRM45 available) C X

Should be able to
communicate
response to the
customer directly,
if Customer request
is a 1st level
CRM46 query C X

Should be able to
assign a ticket
number and update
the CRM
database to track
the request, if it
is not a 1st Level
CRM47 query C X

Should be able to
check if a SLA
driven response
time is available,
and communicate
the same to the
CRM48 customer C X

Should be able to
communicate
with respective
department and
request for expected
response
time, if a SLA driven
response
CRM49 time is not available C X
 Should have a built-
in workflow to
forward the query to
the relevant
department, along
with
generation of an
alert (email,
SMS) for the
concerned NIC
CRM50 officer C X
Should be capable
of checking if the
request is serviced
in time (or the
customer has been
informed in case of
genuine delays),
and escalate the
same in case of
CRM51 delay C X

Should be able to
close the ticket
number once the
query/request is
serviced to the
satisfaction of the
CRM52 customer C X
Should allow NIC
service staff to
create public notes
that everyone with
access to the
service record can
see, or personal
notes that only they
CRM53 can see C X
RTI Requirements
 Should enable
uploading the
obligations to be
fulfilled by a public
authority as per
CRM54 section 47 of the Act C X

Should enable a
separate rule based
CRM55 workflow for RTI C X

Should enable DMS

support with
appropriate time
limit (i.e. the period
for which the
information can be
bought under the
CRM56 Act) C X
Should enable
generation of alerts
regarding the time
limit available for
disposal of a
CRM57 request C X
Should be able to
send alert to the
appropriate
authority who is to
provide the
information
CRM58 requested C X

Should enable
scanning of
Application/Appeal
at the time of
CRM59 registration C X
 Should enable
generating a Unique
Application No. for
each application
(indicating source)
and tagging of the
application with
Customer ID (when
application is from a
customer) or
Employee number
(when the
application is from
CRM60 an employee) C X

Should enable the

generation of
required reports
CRM61 including: C X
Pending
applications/appeals
DO/RO/BO wise at
any point of time
Applications/appeals
source wise
Details of
preliminary fees and
additional fees
collected during a
particular period
Number of cases
where information
has been provided
or refused (along
with details of
section wise
exemption in case
of refusals)
Nature of
information wise
details of
applications/appeals
 Number of CIC
cases decided in
favour of NIC,
imposing penalty,
etc.

Name of CPIO who

is to bear the
penalty/compensati
on with amount,
case wise
Customer Segmentation & Profiling

Should be able to
define and maintain
the segment
information for high-
valued NIC
customers (segment
ID and segment
attributes e.g. total
relationship size
range, Customer
Lifetime Value
CRM62 Indicator, etc.) D X

Should be able to
maintain information
about individuals or
institutions who
have been identified
by NIC as potential
target customers
(who may not have
had any previous
CRM63 contact with NIC) D X
Should be able to
automatically
transfer prospect
information into
phone/e-mail lists
for telemarketing or
CRM64 campaign purposes D X
Should be able to
maintain various
strategic
measurements at
customer segment
or individual
customer level
(Customer value /
profitability, Share of
CRM65 wallet, etc.) D X
 Should be able to
maintain trends of
customer values /
profitability and
identify necessary
corrections to the
marketing plan or
overall customer
CRM66 strategy D X
Should enable client
status labeling
( e.g., VIP status or
CRM67 blacklisted status)
Corporate D X
Accounts

Should be able to
maintain and view
account information,
CRM68 including: C X
Static information,
such as account
type, name, main
CRM68 contact, etc. X
CRM68 Account's status X

Account's business
profile, investor
profile, management
team, market
CRM68 statistics X
Account's
organization chart,
which includes
profiles of each
contact entity, and
relationship
between these
CRM68 entities X

Service address,
where the statement
will be sent to, if not
same as the main
CRM68 contact address X
 Should provide
ability to define an
Account Plan for a
corporate customer,
CRM69 with: C X
Specification of
goals and objectives
(e.g. target revenue
CRM69 to achieve) X

Specification of
sales and service
CRM69 activities X
Marketing & Campaign Management

Should enable
Marketing
Department to
retrieve data of
existing customers
CRM70 from the Database C X

Should support
integration with the
Analytics
Application, to
enable the
Marketing
department conduct
customer & market
analysis to arrive at
arrive at
Segmentation &
Target Marketing
CRM71 Strategies for NIC D X
 Should support
integration with
Document
Management
System (DMS) to
enable the
Marketing
department to
upload the finalized
Segmentation &
Target Marketing
Strategies, Branding
Strategy and
Positioning Strategy
documents for NIC
CRM72 in the database D X

Should enable the

marketing
department to
upload the Discount
Guidelines (based
on the finalized
pricing strategy) in
CRM73 Should
the database
allow the C X
Marketing
Department to
upload the draft
marketing budget,
with built-in
workflow to forward
it to appropriate
authority for
CRM74 approval C X

Should enable the

Marketing
Department to
compare the
marketing
expenditure against
CRM75 marketing budget C X

Support integration
with Document
Management
System to enable
the Marketing
Department to
upload reports in the
database on Market
Research
CRM76 conducted by it D X
 Should be able to
provide a
centralized view of
all the marketing
programs and
CRM77 activities: C X
Already conducted
in the past, currently
in progress and
planned for future
Across channels
Across the entire
organization

Should provide
ability to organize,
track and maintain
all the components
of a marketing
CRM78 campaign including: C X
Customer segment
and list

Offers

Channels
Campaign results /
status

Campaign schedule
Other campaign
variables

Should provide
ability to associate a
marketing target
prospect and
customer lists with a
CRM79 campaign, either: D X
Through standard
queries within the
application UI, or
By performing
upload / import from
an external data
source
 Should enable
associating a list
with multiple
CRM80 campaigns D X
Should provide
ability to
assign/distribute call
list to branch sales
representatives and
call center agents
based on their skill
CRM81 sets D X
Should be able to
define and save (for
reuse) campaign
CRM82 customer segments D X

Should provide
ability to use
graphical campaign
design tool to
flexibly plan and
design campaigns
CRM83 that are: N X
Multi-phase
Across multi-
channels, including
branch, call center,
email and internet
Recurring,
Event-triggered

Should enable
maintaining and
viewing offers
CRM84 belonging to: D X
A particular
department (e.g.
Retail or Corporate)
A particular product
or product group
 Should provide
ability to create and
associate calling
script with a
campaign to guide
agents through the
interactions with the
customers/prospect
s to ensure the
quality of calls and
guarantee
consistent tele-
marketing campaign
CRM85 execution D X
Should provide
graphical tool to
create and modify
CRM86 calling scripts D X
Should provide
user-friendly
capability to define
documents
associated with the
CRM87 campaign D X
Should be able to
provide design tool
to enable Marketing
users to target
customers or
prospects by
creating
personalized web
CRM88 and email content N X

Should be able to
capture customer
response to a given
marketing campaign
and analyze the
overall return
relative to cost, by a
salesperson or
sales team or the
entire campaign
CRM89 execution channels D X
 Should provide
ability to keep track
of the status of each
campaign call, such
as complete, no
answer, call back
later, not interested,
CRM90 etc. C X

Should be able to
detect & trigger
Marketing Events
CRM91 based on: D X
Customer
behavioral change
from average
transaction

Customer inactivity
Significant events
(e.g. birthdays)
Sales Process Management

Should enable
systematic sales
workflow processes,
to ensure the staff
execute the sales in
CRM92 an orderly way X
Should provide
ability to suggest
alternative offers or
offers in addition to
the one requested
by the customer /
prospect, within the
defined sales
CRM93 process C X

Should allow cross-

sale / up-sale of
additional products
and services based
on customer /
prospect
characteristics and
needs, within the
defined sales
CRM94 process D X
 Should capture the
leads in the Leads
CRM95 Database D X
Should be able to
track all quantitative
and qualitative
information of leads
and opportunities
from creation
through closing,
following a
systematic sales
process. The
information
CRM96 includes: D X
Source or referral
Sales revenue
Product
associated/intereste
d
Desired budget
amount
Likely competitors
Contacts made
Quotes and
proposals prepared,
milestone dates,
etc.

Should enable the

Sales Department to
adjusts lead status,
as it works on them.
A sample Lead
status can be: .
Open: Followed
upon within 48
hours . Working:
Day 1 through Day
30 . Developing:
Schedule Follow up
beyond 30 days .
Archive: Non
responsive or no
CRM97 current interest D X
 Should allow the
Sales Department to
upload sales targets
and key evaluation
parameters for
agents/staff/partners
in the database, to
be accessible to
respective
agents/staff/partners
CRM98 through Portal C X
Should enable the
Sales Department to
monitor
performance against
CRM99 set goals C X

Should be able to
monitor leads and
opportunities to
provide automatic
alert, escalation or
reassignment if the
employee who owns
that leads /
opportunities does
not follow-up within
a prescribed time
CRM100 frame D X

Should be able to
qualify leads
CRM101 using standardized D
methods and
processes X

Should provide
ability to select
CRM102 and view lead D
source category,
such as: X

Initiating
salesperson

Initiating
organization unit
 Marketing campaign

Should provide
ability to select /
CRM103 update opportunity D
status and
probability of win X

Should provide
ability to send
emails/SMS
regarding new
CRM104 D
products as and
when
required within the
regulatory
framework X

Should be able to
capture and
track information
CRM105 regarding lost D
opportunity (reason
for loss,
competitor
information, etc.) X

Should be able to
track leads
against policy
CRM106 purchases to D
provide a view of
close rates and
salesperson
productivity X
Should provide
customer need
assessment
functionality that
help
CRM107 D
the NIC employee
or agent to
determine customer
needs,
including: X
 Simple qualifying
questions to
determine which
cover or policy
might be best
suitable for the
customer

Upon capturing the

customer’s
needs, the system
can provide a
product
recommendation to
the
employee /
customer with all the
pertinent product
information

Should enable sales

agents to
pre-qualify and
assess the
customer prior to
CRM108 the application D
process; provide
pre-built
financial calculator
to perform
what if analysis for
premium X

Should enable NIC

sales officers
and agents to create
policy quote
CRM109 through CRM C
system (quote
capability should
integrate with
policy administration
system to
get data on rating) X

Should manage
quote approval
CRM110 process, maintain C
versions and
status X
 Should support
guided interactive
customer selling via
a series of
Questions &
Answers related to
the customer needs
CRM111 and product D
preferences, as well
as illustrating
the tradeoffs
between the offers
(based on the
customer
preference, a set of
Insurance
products could be
suggested) X

Should enable
carrying out
manual or
configurable, rule-
based automatic
allocation or
routing of
opportunities,
service
CRM112 requests, contacts, C
and activities,
to the right sales
team entity
(assignment rule
could be based
on territory, career
level/experience,
product,
industry, monetary
values, etc.) X

Should be able to
report revenue
by account or
product, employee,
CRM113 C
organization unit,
over a time
period (monthly,
quarterly or
yearly) X
 Should be able to
preserve
CRM114 snapshots of C
historical revenue
data for analysis,
and monitor
revenue trends,
shortfalls and
increments X

Should be able to
track forecast
revision history and
CRM115 calculate net C
changes between
different
revisions X

Should be able to
split revenue
CRM116 for sharing between C
multiple sales
persons X
Should be able to
measure real-
time actual
performance to date
CRM117 versus quota and C
forecast, by the
following
dimensions: X
units -
salesperson/
Branch/Region//
Reta
il or Corporate
Customers

By customer
By customer
segment

By product

By channel

By industry
By limit or exposure
range /
category
 Over a time period
(monthly,
quarterly or yearly)

Should be able to
automatically
send letters in
CRM118 predefined formats D
to clients, agents,
other
stakeholders X

CRM119 C

Should enable
updation of CRM
module with the
conclusion of
each transaction X

Should be able to
generate report
on proposals which
CRM120 have not D
matured into
policies for follow
up/analysis X
 Should maintain a
history of
changes made to
interested
parties' reference
information.
CRM121 Changes to C
interested parties
reference
information shall be
stored i.e. the date,
time, user's id
and what the data
changed from /
to. X

Should provide
capability to
Configure
predefined authority
CRM122 C
levels for user
groups (creating
logs and audit trails
to monitor
and control) X

Should provide
ability to derive
static data like
name, address,
contact details, mail
ids etc. from
CRM123 the database, select D
them from
dropdown lists and
insert them in
documents and
correspondence,
automatically or
manually created X
Should be able to
identify valued
customer
CRM124 irrespective of the D
mode
of communication X
 Should use
reference to the
caller
ID to invoke all
static information
CRM125 and populate the D
same in future
transactions, without
express data
entry, palpable to
the customer X

Should allow
policies to be linked
and reported on a
linked basis in
order to manage
and control
CRM126 accumulation of risk. C
E.g. where
the same
policyholder has a
policy covering
commercial
vehicles and
another for private
cars X

Should have
flexibility to
accommodate
additional data
CRM127 requirements e.g. a C
broker
supplies new
information or a
different broker is
used X
 Should be able to
provide both
client and specific
Intermediary
centric views of
business. An
authorized business
user shall
view a client record
that provides
CRM128 a summary of all C
policies held
and/or quotes
obtained by that
client. The user
shall also view a
summary of a given
broker's and
sub-brokers'
portfolio detailing all
policies placed
and/or quotes
obtained through
them. X

Should link
customer’s claims
history with the
CRM129 renewal module to D
help decide whether
to invite
renewal of his policy
or not X
Channel Management

Should support all

types of sales
channels e.g.
Bancassurance,
CRM130 C
agents, brokers,
telemarketing,
post offices, other
alliance
partners X
 Should have
provision for
controlled
maintenance of
master
reference
information about
business partners
and other
interested parties
such as names,
addresses, contact
details,
general financial
CRM131 details, activities, C
turnover, financial
standing,
Employment Details
& key
personnel. An
authorized
business user shall
successfully
create a new
business partner
record, capturing
contact details.
The user shall also
successfully
amend a business
partner record. X
 Should allow
transfer of business
from one
agent/broker to
another
agent/broker;
Should provide
facility for multiple
modifications
to intermediaries for
CRM132 C
active
policies
(inception/death/
prospective)
(integration with
Enterprise
Financials to take
care of
changes accounting
entries
towards
commission) X

Should enable
sending auto
reminders to agents,
brokers,
CRM133 D
corporate agents
about the expiry
of their licence
through email,
SMS, etc. X

Should provide
facility to
agents/other
CRM134 channel partners to D
view their customer
profiles
through portal X

Should provide
information to the
agents/channel
partners on their
CRM135 D
target, amount of
premium
brought in by them,
commission
earned etc. X
 Should enable
setting up of a
differential
commission
CRM136 structure C
based on product,
region, vehicle
make, etc.
Should be able to
CRM137 provide leads D
to agents through
agent portal X

Should provide
customized
portals designed
uniquely for
CRM138 each sales & D
distribution channel,
other stakeholders
(agent, broker,
alliance partners,
etc.) X

Should provide
access to
partners, agents,
brokers for
CRM139 online quotations, D
policy issue,
claims registration,
commission
statements, sales
campaigns, etc. X
Should enable the
Marketing
department to
upload
performance
CRM140 C
evaluation
parameters for the
channel
partners in the
database X

Should allow the

Marketing
Department to
CRM141 upload the terms C
and SLAs
negotiated with the
partner in the
database X
 Should support
integration with
HRMS to enable
Computer Based
CRM142 D
Training for the
channel partners
(by uploading the
training material in
the Portals) X

Should be able to
monitor the
service levels
provided by the
channel partners,
CRM143 taking data C
from Core Insurance
Database,
and compare them
against the
agreed SLAs with
respective
partners X

Should be able to
monitor the
sales performance
of channel
CRM144 partners against the C
targets set
for them, using the
performance
evaluation matrix
uploaded in the
database X

Should be able to
generate status
reports on service
CRM145 levels and C
sales performance
of channel
partners X
 Should support
integration with
CRM to monitor
customer
feedbacks/
grievances
CRM146 /satisfaction levels C
regarding
service provided by
channel
partners, and
generate status
reports for the same
periodically X

Should have
capability for
deactivation of
codes for
CRM147 C
intermediaries
whose licenses
have been
cancelled or not
renewed X
Integration Requirement

CRM148 C

Should also be able

to integrate
with various
applications
including: X

Core Insurance
 Document
Management
System

Analytics
Applications

Enterprise
Financials

176 106 34 36
60 19.32 20.5
 No of
Mandays
Remarks of Effort
(This could be application Snaphots that show required Interdependencies/Overlaps/
the feature being supported, explanation for for Inputs required from the allied
how the application can be customized or Modificati applications
modified to meet the requirement, etc) on /
Cutomizat
ion)

eneral Requirements

Siebel CRM provides pre defined error codes

for users, system administrators and
implementation teams. These error codes can
be communicated to the support teams to seek
help. This ensures speeding up of the process
of resolution

Standard Siebel functionality, is delivered

through out of the box functionality.

CRM system would interface with the Refer Integration with the KM portal to
knowledge management system built for all NIC CRM148 be developed for NIC

The Siebel application (version 8) Channel

management enables web-based solution that
leverages on Siebel’s smart web architecture.
Siebel also supports 5 client types deployed in
Internet or Intranet environments

Siebel Web Client

Siebel Wireless Web Client
Siebel Handheld Client
Siebel Mobile Web Client
Siebel Dedicated Web Client
NIC office staff will be enabled through
comprehensive Siebel front office solution for
interactions with existing customers and
prospects. Customer communication over e-
mail, FAX and letter can be directed to the
relevant NIC office or branch location. Siebel
provides Integrated Desktop to officers to Refer Requires integration
manage multichannel interactions CRM148 with Communication Servers.

Call Center agents can use Siebel Customer

Support, Sales or combination of the
applications depending upon the responsibility
they handle.

Siebel has comprehensive internet component

for customer self service. Transaction kiosks
can have the same Siebel component installed.
Alternate approach is to integrate Internet and Requires integration with web
Transaction Kiosk applications with Siebel. portal & extranet portals
Internet and Transaction kiosk application could Refer proposed in the EASI
be the front end of Core Insurance Platform. CRM148 architecture
Siebel provides agent portal and Partner portal,
enables agents, brokers alliance partners to
provide necessary information to customers and
to register/record the customer requests.
Since Siebel eInsurance module is a web-based
architecture, it provides the transactions to be
performed from any location, and Siebel access
control mechanism allows transactions to be
person independent.Siebel can be customized Refer Integration required with the
to the specific needs of NIC CRM148 core insurance application

Siebel Partner and Agent Portal provides web

based access to alliance partners and agents.

Siebel Insurance is an information management

application designed to meet the needs of the
insurance industry as they relate to sales,
marketing, and customer service.
The Contact Summary view provides a
comprehensive view of a contact’s relationship
with an end user’s organization in an editable
format. This view displays the customer’s
contact information, financial accounts,
applications, alerts, campaigns targeted at the
customer, and service requests and
opportunities associated with the customer.
Siebel provides unified information about
customer throiugh pre built data model and pre
built user interface. Customer model is
comprehensive and has an ability to address
Individual, Corporate, SME and Rural customer
type.
Available Out-of the Box in Siebel Insurance
Module.
Available Out-of the Box in Siebel Insurance
Module.
Available Out-of the Box in Siebel Insurance
Module.

Available Out-of the Box in Siebel Insurance

Module.

Available Out-of the Box in Siebel Insurance

Module.
Available Out-of the Box in Siebel Insurance
Module.

Standard Siebel functionality, Prospect Id is

automatically generated by the application when
prospect/customer record is created.

Siebel Data Quality provides the views to allow

a user to match and cleanse contact, prospect
and account data in real-time-during data entry
or modification, or as a batch process. Siebel
application has an inbuilt functionality to merge
duplicate records.
Note: If there are any specific needs for merging
of two records, customization would be required
and subsequently it impacts the effort.
Siebel application does not allow duplicate
entries based on the unique keys defined at
data level. And Siebel provides the users with
warning message when potentially the same
customer entry is taking place. User can take a
call as to whether new entry should be done or
not
Siebel application allows to capture highly
detailed information in the respective modules
and entities. Also enable to track and facilitate
the searchable functionality to identify the stake
holders.
Note: Any non-vanilla information to be
captured requires an additional effort in
modifying the application

Siebel application has the functionality to search

customer and other information based on the
given combination of multiple parameters
information. Allows to authenticate and identify
a specific customer.

Siebel application has the ability to maintain all

required information of Contact.

Siebel Application has pre defined fields to store

Name, title, phone numbers,
fax numbers, contact address, email.
Contact Reason is not available at Contact
entity and it can be implemented by necessary
modifications. 2
Salesperson's notes is not available at Contact
entity and it can be implemented by necessary
modifications. 2

Privacy, preference, contact timeslot

preference are not available at Contact entity
except contact channel. And it can be
implemented by necessary modifications. 2
Siebel Business Applications has the Audit Trail
functionality to capture the history of changes in
Client information. Configuration would require
based on the needs.

Siebel application allows to capture client's

personal information such as profession/
interests/tastes/hobbies. And it allows to
configure to define the product based personal
information.
Note: Any non-vanilla information to be
captured requires an additional effort in
modifying the application

Siebel application allows to capture client bank

details and would requires modification to
implement and interact with Electronic Clearing
System. 5

Siebel application stores the information in

respective entities such as Contact, Employee,
partner, etc.
Siebel application allows to configure to bring all
information together, can be configured to
categorize the contact information based on the
needs.

Siebel applications Contact screen allows to

configure to provide the 360-degree view of the
customers and their households, their activities,
their policies, and associated underwriting
information.
 Siebel can be configured to provide a complete
history of the multi channel interactions. It would
require to configure in such a way that all
information is visible in a single view
ustomer Self-Service

Details captured through Web portal or Extranet

portal should be tighly coupled with CRM
applications. When customer is accessing a
specific link, the right Sales/Service/Marketing Refer Required integration with Web
process would be triggered in the background CRM148 portal and Extranet portal

CRM system would interface with the customer Refer Integration with customer
selfservice portal to capture transaction details CRM148 selfservice portal for NIC
 Supported as Out of the box functionality, it can
be configured to save it as an attachment and it
can be associated with specific contacts or
service requests based on the needs.
Grievance Redressal

Siebel Insurance module allows agents to

perform service transactions.
Siebel Insurance – Service module allows to
record the complaints from the customers and
allows to track the requests
Siebel has comprehensive internet component
for customer self service. Alternate approach is Refer Required integration with Web
to integrate NIC portal applications with Siebel. CRM148 portal and Extranet portal
Siebel Insurance module can be used by Call
Center agents for recording and tracking.

Siebel Insurance – Service module allows to Requires

record the complaints from the customers and Refer Integration with external
allows to track the requests CRM148 communication devices.
Siebel agent portal and partner portal enables
agents and alliance partners to register
customer grievance.

Siebel Insurance – Service module allows to

record the complaints from the customers and
allows to track the requests

Siebel Insurance – Service module can be used

to track complaints to closure.
Siebel Insurance product is shipped with
standard report functionality, using which
Insurance specific MIS report can be
customized and generated.

Siebel Insurance – Service module can be used

to view complaints based on their status.
Siebel Insurance product is shipped with
standard report functionality, using which
Insurance specific MIS report can be
customized and generated.

10

Siebel Insurance – Service module can be used

to capture these details.Application provides
comprehensive functionality for Customer
Service, Policy Service through comprehensive
service request capability
Note: Any other additional Service request
related details to captured requires modification

Siebel customer support provides the ability to

assign service provider for different types of
service requests. Based on type of customer or
type service request, appropriate resolution
agency can be identified. Siebel also has
workflow and Business Rules engine. Workflow
and Business Rules engine provide an ability to
assign appropriate resource to the requests.
 Source of service would be one of the
configurable dropdown field in Siebel Customer
support application

NIC office can assign the request to appropriate

role, responsibility and individuals. Assignment
will be through the list of stakeholders or that of
groups

Customer Support in Siebel provides the

capability to assign resolution and response
times to service request types. Based on this
information, delays can be tracked and
appropriate escalations can be handled. Timely
resolution related alerts can be delivered to
service executive's user interface in the
application

Available as a standard Out-of the Box

functionality in Siebel Service reuest.
omer Service Requests

Siebel Insurance – Service module allows

agents to perform key service transactions,
such as name or address changes, fulfilling
requests for statement or check copies,
performing fee reversals and funds transfers,
initiating stop payments on checks, and tracking
these requests to completion.
Siebel Insurance – Service module allows to
create/record the requests from the customers Required integration with Web
and allows to track the requests. portal and Extranet portal

Siebel would integrate with NIC's portal

application

Siebel allows to capture all service related

information and can be used by Call Center
agents for recording and tracking.

Phone is over call center or IVR. For SMS

requests, SMS needs to be integrated with
Siebel through the usage of SMS gateway

Siebel Agent portal and partner portal provides

the ability to alliance partners to provide
functionality of service request creation on
behalf of customer
Siebel Policy, Claims provides complete view of
policy data and claims related data. Policy and
Claims is completely available to customer
support. Service staff will get entire visibility and Requires integration with Core
service functionality through Out of the Box Refer Insurance for displaying Policy &
Siebel capability CRM148 Claim details in Siebel

Siebel allows to create all pre-built requests and

can be directly recorded in Siebel service
request module. Support executive would be
able to create FNOL through every customer
facing function in NIC

Sales, Service and marketing modules can be

integrated in Siebel and Siebel provides
business rules and alerts engine that provides
ability to do cross selling and up selling to the
customers during service interaction. This
requires configuration of the application to
trigger sales opportunities and activities

Alert messages can be configured in Siebel

such that it is prompted to the users during the
service call 5
This requirement can be configured to show the
defined queries that are defined at different
levels. Alternatively FAQs, Solutions and Smart
Scripts can be used.

FAQ can have solutions associated with that.

Siebel Insurance – Service module allows

agents to create, assign and track the service
request information. Service request will be
automatically re-assigned to the next level using
assignment manager / workflow 10

Siebel Insurance – Service module can be

configured to capture SLA against each service
request type & category

The service request can be re-assigned to

different departments using assignment
manager / workflow. The re-assignation of
service request can be informed to the
respective departments by integrating with Requires integration with
communication servers and triggering Refer email/sms communication
emails/sms CRM148 servers
 Siebel assigns the service requests to the
concerned authority. Service assignment is
possible through Siebel Workflow as well as
Siebel assignment manager. Delivery of the Requires integration with
notification or alert can be done on the SMS or Refer email/sms communication
through an email CRM148 servers

This feature can be achieved using Siebel

Workflows and assignment manager. 5

Available out of the box in Siebel as Service

Request Closure functionality.

Available out of the box in Siebel, Private and

Public note are standard features in Siebel
Application
RTI Requirements
Siebel would integrate with the DMS application Refer
to upload CRM148 Requires integration with DMS

Can be achieved using Siebel workflows.

Workflow Utility allows to define business
workflow for Service Request/ Issue resolution. 5

Siebel has tools to integrate with necessary

applications. Integration with document
management system would have couple of
mechanisms. Documents would have document
id and also the customer id for whom the
document has been stored. Siebel also has
account and contact id. With these references, Refer
DMS integration has to be accomplished. CRM148 Requires integration with DMS

Siebel has the ability to generate appropriate

alerts. Alerts can be based on the pre-defined
SLA conditions. Also alerts can be configured
using Siebel workflows for defined conditions to
meet the requirements. 5

Alerts can be delivered to appropriate persons

based on the role, responsibility or dedicated
individuals through different channels such as
Portal, Email or SMS. This functionality can be
achieved using Siebel assignment management
and workflows. 2

Siebel does not have this feature, but this can

be achieved by integrating with Documentum.
Scanned Documents can be attached and Refer Integration with Documentum
reused based on the needs. CRM148 would be required
This feature is available out-of-the-box in
Siebel. Service request would be of type RTI
case or RTI request. It will have Unique id
associated with each application.

Siebel Insurance product is shipped with

standard report functionality, using which
Insurance specific MIS report can be
customized and generated.

15

Can be created and maintained in Siebel

Can be created and maintained in Siebel

Can be created and maintained in Siebel

Can be created and maintained in Siebel

Can be created and maintained in Siebel

 Can be created and maintained in Siebel

Can be created and maintained in Siebel

er Segmentation & Profiling

Siebel offers segment definition and attachment

of segment information to the customer.
Customer Lifetime Value can be indicated

Possible to create and maintain prospect

information

Standard marketing application capability. Also

Siebel allows for exporting information to an
excel sheet. Batch programs can also be written
to extract data in formats like csv

Possible to maintain profitability metrics. Siebel

provides for certain out of the box metrics. In
case there are additional requirements the
same will have to be developed.
Account plans can be modified. In case the
same needs to happen automatically depending
on certain conditions the same will need to be
customized 10
Customers can be classified into various types.
Available in Siebel customer data model. Status
can be updated by Sales, Support or Marketing
professionals

Siebel allows for maintaining and displaying

account information including information
regarding the account structure and the
contacts and the relationship between them

Available as Siebel out of box functionality..

Available as Siebel out of box functionality..

Available as Siebel out of box functionality..

Available as Siebel out of box functionality..

Multiple addresses can be associated with an

account/contact. It is possible to classify the
same as legal address/ mailing address etc. It is
also possible to change the mailing address.
 Siebel has out of the Box Account Plan for
corporate customers. Collaborative corporate
sales teams can utlize the account plans to
achieve defined customer strategy

Siebel Forecasting can be used to support the

same.
Ability to create Activity templates that can be
associated with either an opportunity or service
request. Each activity in an activity template can
be assigned to a specific individual/ user/group.
g & Campaign Management

Marketing department can directly access the

customer information through the Siebel
database

Siebel can be integrated with standard analytics

solutions. The same can be done through Refer Integration required with
Siebel EAI CRM148 Analytics
Lead list management as a part of Campaign
Management in Siebel supports uploading of
lists of customers that can be associated with
specific campaigns. Additional documents like
literatures/ brochures can also be uploaded and
associated with campaigns. The documents can Refer
be in multiple formats like. doc. .pdf, .jpeg etc. CRM148 Integration required with DMS

Any document like a discount guideline can be

uploaded into Siebel. It may also be possible to
set the same up as a smart script that will guide
the user.

Approval workflow will have to be built 5

Actuals vs. Budgetred figures can be seen at

every individual campaign level

It is possible to upload and organize documents

in Siebel. Siebel provides for catalogs and
categories under which documents can be
uploaded and access rights can be set for the Refer
same. CRM148 Integration required with DMS
All campaigns and events that are executed can
be seen including the ones that are planned and
the ones that have been completed. The
information can be aggregated at unit level or at
organization level or across organizations. This
is applicable across channels.

Standard Siebel Application feature.

Standard Siebel Application feature.

Standard Siebel Application feature.

Campaigns are associated with offers which

can be associated with products. A campaign
can be set up for a particular segment, the
results can be updated and the history can be
seen. A start date and end date is associated
with every campaign. Siebel supports assigning
of variables with a campaign like Products etc.
Available as part of out of the box marketing
campaign module.
Available as part of out of the box marketing
campaign module.
Available as part of out of the box marketing
campaign module.
Available as part of out of the box marketing
campaign module.
Available as part of out of the box marketing
campaign module.
Siebel Application can be configured as per the
needs.

Lead list can be uploaded and associate with

campaign. List management in Siebel allows for
uploading from an external source.

Standard Siebel Application feature.

Standard Siebel Application feature.

A list can be associated with multiple number of
campaigns.List is an independent object of
Marketing application. This can be utilized in
every campaign

Leads can be assigned based on skills across

different departments and different users. Siebel
uses Assignment manager to handle this
functionality.

Lead lists that are uploaded into Siebel can be

reused

Siebel provides a UI friendly screen where

campaigns can be defined and can be
associated with various channels and can be
made recurring and multi Phase. Event based
campaign is also supported by Siebel. Siebel
does not provide for a design tool. 5
Can be configured and maintained in Siebel

Can be configured and maintained in Siebel

Can be configured and maintained in Siebel
Can be configured and maintained in Siebel
Campaigns for a dept can be shown, since
offers are associated with campaigns, the same
also can be handled. A view to show all
campaigns for a product will have to be
developed as the same is not available out of
the box 5
Can be configured and maintained using
dropdown codes from the standard application
screen
Can be configured and maintained using
dropdown codes from the standard application
screen
Call guides can be associated with campaigns

Siebel supports setting up of call scripts or

smart scripts ensuring guided process flow. 2

Documents can be associated with campaigns

as attachments or as literature.

Siebel supports creating personalized content

for customers both through the email and the
web channel.This feature can be achieved
through Siebel Web Offer Designer. 15

Siebel supports capturing customer response

and then promoting the response to an
opportunity in case the customer is interested
and associating a value with that oppty. Siebel
can support capturing returns at a campaign
level and at more granular levels like channels (
if it is a multi channel campaign) and individual
sales person.
 Various status can be supported depending on
the customers requirement. It's a standard
Siebel functionality

Workflow can be written in Siebel to identify

these events in the database which would then
associate these records with pre defined
events/ campaigns. And as another solution this
feature can be configured such a way that
Service request is created to indicate Customer
Behavioural change. 10

Can be achieved this functionality through

Siebel workflows and Service request creations.
Can be achieved this functionality through
Siebel workflows and Service request creations.
Can be achieved this functionality through
Siebel workflows and Service request creations.
s Process Management

Siebel's Sales force automation(SFA) has

multiple user friendly mechanisms to ensure the
structured sales process within the sales
department

Sales opportunities can be captured in Siebel to

cross-sell and up-sell products in addition to
those products and services requested by the
customer

Siebel Financial Services - Needs Analysis

module has sophisticated profiling and
calculation engines to cross-sell and up-sell
products to the customers.Needs analysis
provides complete information about customer
needs. Cross Sales, Up Sell offers can be
defined based on business logic of NIC.
Customer offer can be presented to the
concerned front office staff who is interacting
with the customer
Leads data can be captured directly in Siebel. Integration required with the
The data can also be uploaded from external Refer external
systems in to Siebel CRM148 system which stores leads data

Siebel's Opportunity & Activity management

tracks is used to initiate and close the sales life
cycle for the leads. These modules can capture
all lead specific information provided as part of
this requirement by NIC
Standard Siebel Feature
Standard Siebel Feature

Standard Siebel Feature

Standard Siebel Feature

Standard Siebel Feature
Standard Siebel Feature

Standard Siebel Feature

Siebel's opportunity management can be

modified to capture appropriate lead status.
Siebel workflow can be triggered, based on the
number of days specified against each criteria,
to change the status automatically. And Lead
status can be changed quickly by using
dropdown codes from the standard application
screen. 2
Siebel supports the functionality to upload the
files and its contents to the database from the
front end. This would require configuration as
per the specific requirements identified. If there
are bulk uploads then EIM would be used to
upload the data. 5

Siebel allows to capture the sales performance Refer

details of the sales staff. CRM148 Requires integration with CPM

Siebel workflow processes are used to monitor

the status of leads and opportunities. Automatic
alert, escalation or re-assignment can be
achieved using Siebel workflow and Assignment
manager 10

Lead qualification logic has to be customized in

the applicatiion 10

Siebel campaign module captures the lead

source and its category information
Siebel Campaign module is completely
configurable. Can be changed quickly by using
dropdown codes from the standard application
screen
Siebel Campaign module is completely
configurable. Can be changed quickly by using
dropdown codes from the standard application
screen
Siebel Campaign module is completely
configurable. Can be changed quickly by using
dropdown codes from the standard application
screen

This feature is available out-of-the-box in Siebel

opportunity module

Siebel product catelogue can store complete

information about the products, bundles and
associated offers. Once the catalogue is
created, necessary alerts can be delivered to
the concerned employees over multiple Requires integration with
channels. This can be achieved using Siebel Refer email/sms communication
workflow and email integration features CRM148 servers

This feature is available out-of-the-box in Siebel

opportunity module

Siebel opportunity and acivity module can be

configured to track leads

Siebel's Financial Need Analysis (FNA) module

is used to perform the assessment of customer
needs and also used to recommend the right
product to the customer. NIC specific
requirements may need modifications.
Siebel has out of box and powerful feature of
Needs Analysis and Needs capture. Needs
analysis has recommendations as an output.
This is a standard and out of Box functionality in
Siebel. Siebel also provides pre built calculator
functionality to the sales person

Siebel has out of box and powerful feature of

Needs Analysis and Needs capture. Needs
analysis has recommendations as an output.
This is a standard and out of Box functionality in
Siebel. Siebel also provides pre built calculator
functionality to the sales person

Siebel provides pre built calculator functionality

to the sales person. It can be modified based on
the requirements. 10

Siebel offers insurance specific quote

management functionality through the Siebel
application. Siebel Quote gets the rating data Integration would be required
from the policy admin system and generates an Refer with the Core
appropriate quote CRM148 Insurance system

Siebel Quote made specifically for financial

services has complete ability for quote
approvals and versioning process
This functionality can be achieved using
Siebel's Smartscripts feature. This feature
provides intuitive and interactive screens to
perform customer profiling (Question &
Answers) and finally create product
recommendations

Siebel provides assignment manager or

workflow to perform allocation of customer
interactions like leads, service requests,
opportunities etc. to the concerned team
members like sales team, contact or support
executive

Siebel Insurance product is shipped with

standard report functionality, using which
Insurance specific MIS report can be
customized and generated.

15
Siebel provides elaborate data model, that
captures various information about customers
like, segment, industry, customer type etc.
objects like leads and opportunities are linked
and related to the customer. Lead or opportunity
actually indicates the closure of the business,
this can be used for analysis in the form of
report or analytics. And Siebel's attachment
functionality also can be used to preserve the
snapshots of the historical revenue trends if
information is in Document based. 10

Siebel forecasting can be used to achieve this

functionality. Requires configuration as per the
needs. 5

Siebel forecasting can be used to achieve this

functionality.

Siebel has out of box and powerful feature of

forecasting functionality. Which enables to
measure real-time actual performance to date
versus quota and forecast by organization units,
customer, customer segment, product, channel. Refer
Industry and etc. CRM148 Requires integration with CPM

Siebel forecasting can be used to achieve this

functionality.
Siebel forecasting can be used to achieve this
functionality.
Siebel forecasting can be used to achieve this
functionality.
Siebel forecasting can be used to achieve this
functionality.
Siebel forecasting can be used to achieve this
functionality.
Siebel forecasting can be used to achieve this
functionality.

Siebel forecasting can be used to achieve this

functionality.
Siebel forecasting can be used to achieve this
functionality.

Siebel has flexible Workflow Utility. Siebel

workflow is configurable to define business
workflow for auto generation of predefined
formatted letters and Siebel can be integrated
with the systems identified for the Sales or Refer Requires integration with the
Service fulfillment. CRM148 system identified for fulfillment

Customer transactions could be policy

transactions like claims, payments of premium,
policy changes etc. there would be some non
policy transactions like service requests, leads
and campaigns etc. policy transactions would
be made available in Siebel system based on
batch upload through Siebel EIM utility. There
are some real time interactions requirements.
These real time interactions are delivered
through Real Time Integration capability through
Siebel Integration utilities.

Siebel captures status and stage against every

opportunity. This is used to generate necessary
conversion report. Siebel Actuate report can be
customized to generate all MIS reports required
from the Siebel CRM application 5
Siebel's' Audit Trail feature supports this
functionality. Audit trail module can be tailored
to the NIC specific requirements

Siebel supports creating and maintaining role

and responsibility matrix for the user groups.
Audit trail module is used to create logs and
enforce monitoring and controlling mechanisms

Siebel uses correspondence templates for

populating the customer related information to
documents or email. The dispatching of the
same can be triggered to the fulfillment
systems. 2

Available out of the box

Siebel allows to capture the static information
and populate wherever required. Requires
configuration. 4

Siebel provides single customer view that

provides complete view of every holding and
policy that the customer would be having. Using
this data, customer analysis can be done by
sales officers of NIC

Siebel data model is extensible for

organizational requirements. Siebel as such
provides out of box industry specific attributes to
be populated over several interactions, it also
allows the data model to be extended
The customer summary screen in Siebel can
provide 360 degree view the customer details,
policies and quotes. Integration would be
required with the Core Integration would be required
Insurance system in order to display quotes, Refer with the Core
policies and cliams information CRM148 Insurance system

Siebel application has full fledged modular at

integrated claims management functionality.
Necessary interface with renewal system needs
to be built to reflect the link with renewals
status. Integration would be required with the Integration would be required
Core Insurance system in order to display Refer with the Core
cliams information. CRM148 Insurance system

Siebel has comprehensive agent portal and

partner management system. This provides
complete ability to support business channels
Siebel has pre built insurance industry specific
partner data model. This partner data model
ensure the controlled access to the business
information
Siebel's Partner and Agent portals are equipped Integration with Enterprise
with all transfer and assign features to built and Financials to take care of
configure the application to meet the Refer changes accounting entries
requirements. CRM148 towards commission

Siebel has standard and configurable alert

functionality to send reminders to the respected
individuals. Siebel has got integration Requires integration with
capabilities with email and SMS servers to send Refer email/sms communication
reminders CRM148 servers

Siebel has standard and insurance business

specific agent portal and Partner management
portal applications.

Siebel would integrate with Core Insurance

system and Enterprise financials to capture Integration would be required
these details. And Siebel agent and partner with the Core
portal can be configured to provide all captured Refer Insurance system & Enterprise
information to agents and partners. CRM148 Financials
This will be handled in eBao

Can be achieved though Siebel Agent portal

application

Siebel allows to customize the portals for all Refer There is a dependency on the
channels uniquely. This requires customization. CRM148 extranet and web portal

Siebel agent portal and necessary components

of P&C Claims, Policies provide detailed
visibility and ability to capture transactions of
policy servicing and claims and also necessary
sales campaigns

Siebel supports the functionality to upload the

files and its contents to the database. This
would require configuration as per the specific
requirements identified. If there are bulk
uploads then EIM would be used to upload the Refer
data. CRM148 Requires integration with CPM

Siebel supports the functionality to upload the

files and its contents to the database. This
would require configuration as per the specific
requirements identified. If there are bulk
uploads then EIM would be used to upload the
data. 5
Siebel would integrate with PeopleSoft using Refer Integration
EAI adapters to achieve this CRM148 with Peoplesoft HRMS module

Siebel partner manager functionality provides

comprehensive capability that is insurance
industry specific to monitor partner
performance. Siebel would integrate with Core
Insurance system to capture these details and Integration
Configuration would be required to meet this Refer would be required with Core
requirement. CRM148 Insurance System

Siebel partner manager and Siebel Agent portal

provides the functionality of entire lifecycle
management for agents and brokers. Target
setting is done through partner manager who in
NIC is responsible for channel management.
Agent portal provides transactional ability and
then the system builds view of channel Refer
performnace CRM148 Requires integration with CPM

Siebel Actuate can be used to generate MIS

reports pertaining to channel management
requirements 5
Siebel Partner management is integrated with
the CRM application by virtue of its framework.
Status reports for any specific requirement can
be generated periodically 5

Partner management system can keep the

information about partner's status. Siebel can
be configured to achieve this requirement
though workflows 3
Integration Requirement

Siebel has exclusive integration features that

would enable the application to integrate
seamlessly with the other applications.
The Siebel Business Platform includes a set of
tools, technologies, and pre-built functional
Integrations that facilitate application
integration. This set of products is referred to as
Siebel Enterprise Application Integration (Siebel
EAI). Siebel EAI provides components for
integrating Siebel Business Applications with
external applications and technologies within
your company and is designed to work with
third-party solutions such as those from IBM,
TIBCO, Web Methods, and others. Siebel EAI
provides bidirectional real-time and batch Integration with
solutions for integrating Siebel applications with CI,DMS,Analytics, Enterprise
other applications. 250 financials and portal applications

Siebel provides comprehensive integration

capabilities. Siebel has EIM, EIA and other
utilities to ensure and manage necessary
integrations. Siebel Application can be
integrated with Core Insurance Systems.
Siebel provides comprehensive integration
capabilities. Siebel has EIM, EIA and other
utilities to ensure and manage necessary
integrations. Siebel Application can be
integrated with DMS.

Siebel provides comprehensive integration

capabilities. Siebel has EIM, EIA and other
utilities to ensure and manage necessary
integrations. Siebel Application can be
integrated with Analytics Application.

Siebel provides comprehensive integration

capabilities. Siebel has EIM, EIA and other
utilities to ensure and manage necessary
integrations. Siebel Application can be
integrated with Enterprise Financials.
###
 ID Functional Requirements - CORE Insurance Priority SUP MOD CST
(C/D/N)
Portal

PTL1 Should adhere to Web 2.0 standards D X

PTL2 Should have Web 2.0 Roadmap in 1 year C X

PTL3 Should support JSR 286 standards or equivalent N X

PTL4 Should support JSR 168 standards or equivalent C X

Should Support all leading browsers such as
PTL5 Internet Explorer, Firefox, and Netscape C X

Should support multiple interfaces based on

delivery channels (In this case, Internal Portal,
Extranet Portal, Internet Portal, Kiosks, SMS/PDA,
PTL6 Dashboards,
Should support Mobile
delivery worksites
to wireless devices that C X
support wireless browsers following open
standards on mobile phones and which can
PTL7 support WML C X

Should support HTTP and HTTPS protocol &

PTL8 LDAP directory server C X

Should provide protocol switching support (HTTP

PTL9 to HTTPS) C X

Should be able to integrate with interfaces from

PTL10 third party payment gateways. C X
Should provide regional language support for Hindi
PTL11 based on UNICODE C X
Should provide regional language support for
PTL12 Other Indian Languages based on UNICODE N X

Should use open standards based on XML for

PTL13 managing application data C X

Should support caching for performance. It should

also store favorites, frequently types fields, etc in
PTL14 the cache. C X
 Should integrate with Single sign on, roles and
rights managements provided by identity
PTL15 management system C X

PTL16 Should support Ajax and Ajax Security C X

Should be able to personalize contents based on

PTL17 roles, access rights and service D X

Should support dynamic generation of contents as

PTL18 provided by Web Content Manager C X

Should be able to accept keyboard shortcuts (e.g.

PTL19 F1 - for help, F9 - list, etc) C X
Should provide integration between the
PTL20 personalization engine and the search engine D X

Should provide collaboration features such as Web

Conferencing, Team Calendar and Whiteboard
PTL21 facilities D X
Support for web services (SOAP, WSDL, UDDI,
PTL22 JCA, JAAS, X.509, WSRP, etc ) C X

Support for Web Services for Interactive

PTL23 Applications (WSIA) C X

PTL24 Support for 2-phase commit transactions C X

Should support dynamic generation of Forms and
interactive forms for data entry and modification.
Should support W3C standard e-Forms such as x-
form and xfdl, which are interactive in nature for
PTL25 data entry and modifications D X

e-Form should support overlapping digital

PTL26 signatures for the security of issuance of e-policy D X
 Should support import of external data through
upload of flat files, CSV files, excel files, and other
open standard spreadsheets with configurable
PTL27 limits C X
PTL28 pages D X
Should support self service content customization
and management for users through a Rich Text
PTL29 Editor with full D X
Should be able to support portlets from Integrated
PTL30 Enterprise Operational Applications C X
Should be able to support portlets from BI
PTL31 applications C X

Should be able to publish data from external

PTL32 systems strictly based on rights D X

Should be able to support data from external

systems delivered through SOAP messaging
PTL33 frameworks on top of HTTP C X
Should be able to support data fromexternal
PTL34 systems delivered using REST D X
Should be able to support portlet to portlet
PTL35 communication C X
PTL36 Should provide for state / session management C X
PTL37 Should support templates C X Both Oracle Portal and Webcen

Should support email integration with groupware

PTL38 (Lotus, MS Exchange, etc) C X
Should offer the necessary environment in order to
develop an Automated Registration Authority
application for digital certificates delivering to
PTL39 registered users. D X

Should provide hierarchical website structure and

PTL40 navigation D X

40 39 1 0
97.5 2.5 0
NS Remarks

Oracle Portal 10.1.4 and above adhere to

WEBCENTER adhere to web2.0
standards
Both Oracle Portal and Webcenter has
been web2.0 compliant for last one year
Oracle WEBCENTER is compatible with
JSR286 standards
Both Oracle Portal and WEBCENTER is
based on JSR 168 standards
Both Oracle Portal and Oracle Webcenter
supports all leading browsers
Oracle Portal and Webcenter togather
with Oracle Wireless can easily fit into the
requirements for providing content to
PDA/SMS mobile worksitesetc. Moreover
the Portal Architecture is designed in such
a way as to support intranet-internet
deployment with proper security
implemented
Oracle Wireless will give the functionality
to deliver the content to Portal devices.
Oracle Wireless supports WML
Oracle Internet directory is LDAP V 3.0
compliant directory server is part of the
same Portal installation. Both Oracle
Portal with all its components and
Webcenter support bith HTTP and HTTPS
Both Oracle Portal comes with Oracle
Webcache which is the front-end of all the
applications which supports the switching
mechanism
Both Oracle Portal and Webcenter will
help to integrate with payment gateways.
As the transaction require to be SSL
encrypted , both are supported

Supported

Supported
the data exchange mechanism can be
based on XML. Both Portal and
Webcenter provide ou-ofbox portlet
( Omni Portlet) which can display
data/graph based on XML/WSDL
Oracle Appilcation server will be front-
ended by Oracle Webcache which is used
for caching and hence enhancing the
performance
As all the portal components are based on
the roles and responsiblities in Portal
which is integrated by the identity
management system
Both Portal and Webcenter being web 2.0
complaint support Ajax and Ajax security

Both Portal and Webcenter integrate with

Oracle Identity management which
defines the different roles and
responsibilities. The users can be given
privilege to personalize contents based on
the roles
Supported. andportlets
Various access are
rights
available
as out-ofbox which support dynamic
contents as will be provided by web
content manager
As this feature is primarily coming from
client server requirement the same feature
can be build using pseudo java based
environment like Applets or etc which can
trap client requirements. The same can be
deployed in Oracle Portal and Webcenter.
But usage of F11 will be limited as the
applications will be accessed through
Browser pressing F1 can open help of the
respective browser

Supported
Oracle WEBCENTER has in-built
integration engine which helps in
integrating with the different collaborative
suites like Team calendar , conferencing
etc

Supported
Support for Webservices for interactive
applications is always there both in Portal
and Webcenter. Both of the tools provide
out-of-box Omni Portlet which can
consume webservices
Oracle Portal is based on OC4J
technology which is used to host the portal
application in Oracle Application Server.
Oc4J supports 2-phase commit
transactions
Oracle Portal porvides with a development
environment where forms can be
generated online and used for data-entry.
Also x-form can be generated and easily
integrated with the Portal solution
Supported. While uploading of eforms ,
digital signatures can be used to check
the authenticity of the documents
 Omniportlet which is available to both
WEBCENTER and Portal can upload data
from flat files. Moreover the fileupload
facility can upload any flat fils in portal
repository
Supported
Oracle Portal and Webcenter comes with
portlets with Rich text editor which can be
given to users for customizatrion
Supported for all portlets based on JSR
168 specifications
Supported for all portlets based on JSR
168 specifications
Oracle Portal can publish data to outside
sites depending on the rights being given
in the identity management system which
can be based on single user or on
federation
Both Portal and Webcenter uses out of
box portlet called Omni Portlet which can
consume webservices. The
communication to webservices happens
using SOAP messaging on HTTP only

Supported

Supported
Supported
oth Oracle Portal and Webcenter support templates for various aspects like look and feel etc.
Both Oracle Portal and Webcenter comes
with Portlets which does integration to
exchange,lotusnotes,Oracle Collaboration
Suite etc.
The Identity management system which
will be used for user registration can be
modified with custom inbuilt workflow for
the registration
In The portal builder whenever the users
use the navigator feacture all the page
and templates are available as hierarchial
structure for ease of navigation

0
ID Functional RequirementsPrioritySUP MOD CST NS
(C/D/N)
IDM

Should allow seamless

IDM1 user creation and C X
management

Should be able to
IDM2 provide user creation C X
request functionality

Should be able to
IDM3 delegate user creation C X
request
Should provide self
service for password
IDM4 management to users C X
with configurable
options
Should provide self
service identity
verification and
IDM5 C X
password retrieval
with configurable
options

Should provide
IDM6 configurable security C X
and password policies

Should provide user

provisioning and
password
IDM7 C X
synchronization across
all the proposed
enterprise applications
 Should provide user
provisioning and
password
IDM8 C X
synchronization across
directory servers such
as Active Directory
Should provide user
provisioning and
IDM9 password C X
synchronization across
all leading databases
Should provide user
provisioning and
IDM10 password C X
synchronization across
all Operating Systems
Should provide user
provisioning and
password
IDM11 C X
synchronization across
all messaging
platforms
Should provide self
service for profile
IDM12 addition, modification, C X
and management to
the users
Should be able to
provide single sign on
IDM13 (SSO) when an user C X
login through the
enterprise portal
Should be able to
IDM14 cache user id and user C X
profile
After login through
SSO, the user should
IDM15 C X
be redirected to the
users target page
Should be able to lock
access to all managed
IDM16 resources based C X
configurable no. of
failed attempts
Should be able to
maintain roles and
IDM17 C X
user role mapping for
access management
Should be able to add,
IDM18 modify and delete C X
roles
 Should be able to
IDM19 assign and remove C X
user roles
Should be able to
IDM20 assign multiple roles C X
to users
Should be able to
provide self service for
IDM21 C X
role modification
request
Should be able to
provide sophisticated
web based workflow
IDM22 C X
for requesting role
modification and
maintenance
Should be able to
provide controlled
IDM23 C X
access based on user
role
Should be able to
provide automatic
IDM24 access rights C X
provisioning to users
or user groups
Should be able to
provide access control
IDM25 and SSO across C X
multiple platforms and
domains
Should be able to
provide access as well
IDM26 C X
as access denial to
users

Should be able to
provide federated
IDM27 C X
access to the
managed
Should beresources
able to
provide federated sign
on to users from
partner (Strategic
Alliance) domain, who
is already
IDM28 D X
authenticated by
partners identity
server. Should
support SAML, Liberty
standards & WS-
Federation
 Should be provided
for not only the users
accessing the
IDM29 applications from PCs C X
but also from other
devices such as PDAs,
Mobile phones etc.
Should adhere to
standards for ease­of-
integration with
existing systems and
future IT investments.
Native support for
IDM30 known industry C X
standards, such as
aznAPl, JAAS, J2EE,
LDAP, PKIX, x.509v3,
X.500, Triple-DES
encryption, SSL and
WAP is necessary.

Should support
Certification Authority
IDM31 (CA) as part of a C X
public-key
infrastructure (PKI)

Should be able to
integrate with
IDM32 C X
industry-leading Web
application servers

Should be able to
deprovision a user
IDM33 C X
when the user retires
from the system
Should be able to
remove all access
IDM34 rights when the user C X
retires from the
system
Should be able to
handle any exception
that occurs during
IDM35 C X
user provisioning and
password
management
 Should have a fail safe
IDM36 capability in case of C X
exceptions

Should maintain
transaction tracking
and integrity while
user provisioning and
IDM37 C X
password
synchronization across
various systems and
managed resources
Should provide
connectors and
adapters for all the
applications,
IDM38 databases, operating C X
systems, messaging
frameworks, directory
services and all other
managed resources
Should provide
regular updates and
IDM39 patch updates for the C X
connectors and
adapters

Should meet audit

requirements by
IDM40 C X
identity reconciliation
and corrective actions

Should be able to
reconcile user
IDM41 C X
accounts across all
managed resources

Should be able to
identify rouge
IDM42 C X
accounts and notify
users

Should have facility to

IDM43 assign denial policies C X
to rogue accounts
 Should provide audit
IDM44 C X
trail and reporting

Should meet statutory

IDM45 reporting C X
requirements

Should have provision

for accepting
IDM46 N X
password from virtual
keyboard

Should have achieved

Common Criteria
Evaluation Assurance
IDM47 Level 3 (EAL 3) N X
certifications or above
or equivalent
certification

47 46 1 0 0
97.872 2.12766 0 0
Remarks

Oracle's IDM Solution allows to create users from

authoritative data source like HRMS application,
LDAP, etc through trusted reconciliation. After the
users is created in OIM based on their role user
accounts are provisioned/created in various
applications.
In Oracle's IDM solution user creation request is
provided by Self Service which can use an integrated
workflow for approvals. Workflow can be configured
for manager approval process & will handle
escalations based on time delays.
Oracle's IDM Solution provides delegated
administration. Delegated admin in turn can manage
the user lifecycle (incld user creation) for his
application / group / project.
Oracle's IDM Solution provides users with an option
to reset password using the self-service option.
Password policies can be set to define the length /
alphanumeric option / aging etc.

Oracle's IDM Solution provides users with option of

Lost Password management. This is based on on
challenge response mechanism.

Oracle's IDM Solution features very rich password

policy management capabilities. Most best-practice
password policies are supported out-of-the-box and
are configurable via an intuitive user interface.
Supported password complexity requirements
include: password length, alphanumeric and special
characters usage, upper and lower case usage, full or
partial exclusion of username and historical
passwords. Furthermore, Oracle Identity Manager
allows the application of multiple security policies per
resource. For instance, less-privileged users may be
subjected to a more relaxed password policy,
whereas privileged administrators may be subject to
a more stringent policy.
Oracle Identity Manager enables policy-based
automated provisioning of resources with fine-grained
entitlements. For any set of users, administrators
may specify access levels for each resource to be
provisioned, granting each user only the exact level
of access required to perform his job. These policies
can be driven by user roles or attributes, enabling
implementation of role based access control (RBAC),
as well as attribute based access control. Oracle
Identity Manager can also synchronize passwords
across managed resources and enforce differences in
password policies among these resources.
Oracle Identity Manager provides user provisioning
and password synchronization across the following
directory servers out of the box - Active Directory,
SUN JAVA systems directory, Novell eDirectory and
Oracle Internet Directory.

Oracle Identity Manager provides user provisioning

and password synchronization across the following
databases out of the box - Microsoft SQL, IBM DB2,
Sybase and Oracle.
Oracle Identity Manager provides user provisioning
and password synchronization across the following
operating systems out of the box - Microsoft
Windows, various flavours of UNIX (including HP Unix,
IBM AIX, IBM OS/400 AS/400 Advanced, SUN Solaris
and Red
Oracle Hat Linux.
Identity Manager provides user provisioning
and password synchronization across the following
messaging system out of the box - Microsoft
Exchange, IBM Lotus Notes / Domino, Novell
GroupWise and Open Source mailing systems like
Zimbra.
Self Service interface will be provided for user profile
addition, modification and management. Most best
practices allow users only to update non critical
information without an approval system.

Oracle Access Manager provides web single sign to all

applications when users login through the enterprise
portal. This is achieved by passing the user
credentials through the header and sesssion based
cookies.
User id entries can be cached in Oracle Internet
Directory. And user id related policies are cached in
OAM.
Oracle Access Manager after the web based single
sign on will redirect the user to the designated page
based on his role and profile. This is based on the
users information stored in the LDAP ( for ex Active
Directory)
In Oracle Access Manager user accounts can be
locked based onlnumber of wrong attempts, Password
expiration etc. This is enforced using password
policies.

User role and user mapping information is stored in

the Oracle Access Manager. This information is stored
in the LDAP server.

Role Management (add, modify & delete) is handled

by Oracle Access Manager based on static, dynamic,
hybrid and nested groups.
Roles can be assigned and removed for users
depending on user attributes and is implemented by
using the above specified groups.

Mutlple roles can be assigned to the user in the

Oracle Access Manager.

Oracle Access Manager self service workflows can be

setup for role modifications.

Pls refer to IDM 21. Further to that Oracle provides a

graphical user interface to design complex workflow
without any coding / scripting efforts.

Oracle Access Manager controls the access to the

enterprise resources based on the users' roles. Access
Rights are based on the users role.

Oracle Identity Manager will provision users and also

define membership to groups. Access policies in turn
will provide access to various resources based on the
users role.

Oracle Identity federation provides cross domain

SSO. Oracle Access Manager provides SSO to all web
based application. For client server based applications
Oracle Enterprise Single Sign will be used.
Oracle Identity Manager also supports a denial policy.
Denial policy is used to explicitly deny user access to
specific resources, thereby enforcing security or
governance policies such as segregation of duties.
Access Policies are also provided based on the users
role.
Oracle Identity Federation (OIF)is an industry-leading
federation solution providing a self-contained and
flexible multi-protocol federation server deployable
with existing identity and access management
systems.

OIF provides federated ( cross domain single sign-on)

with trusted partner domains. Oracle Identity
Federation is Liberty Alliance certified for Web
Services(WS-Federation), Liberty ID-FF and SAML
2.0. OIF provides cross protocol support enabling
organizations to federate on different protocols listed
above.
Users access to applications through PDAs and mobile
phones can be controlled by using Oracle Access
Manager through an access gate.

Oracle Identity Management supports standard

protocol like SMTP, HTTP(S), SOAP, LDAP, ADSI,
KERBEROS, PKI (X.509, AES, SHA-1, RC6, PKCS)
SSL, TLS, JAAS, EJB, J2EE Connector, JNDI, JDBC,
ODBC, OCI, WSDL, UDDI, J2EE, .NET, C/C++, XML
DTD, HTML, HTMLCSS, XML Namespaces, XML
Schema, XPATH, XSD, XSLT. It also provides C/C++
based APIs for client/server or non-Java applications
to leverage Oracle Access Manager infrastructure.

For highest level of authentication for their Single

Sign-on applications, Oracle offers certificate based
authentication (X.509 client certificates) for the
Oracle Single Sign-on Server using Oracle Certificate
Authority (OCA) or any 3rd party CA. Certificate only
authentication allows users who have been issued a
digital certificate by the OCA or any 3rd party CA to
authenticate against your web applications.

Oracle Identity manager supports the following

Application Server -JBOSS, WebSphere, WebLogic &
Oracle Application Server.
When the user retires the information is updated in
the Authoritative data source like the HRMS
application or an LDAP. This trigger is captured in the
Oracle Identity Manager which deprovisions / disables
the user in all the target application in which the user
had rights to.
When retiring / deprovisioning the user all access
rights to target applications are removed by the
Oracle Identity Manager.

Refer to IDM36 and 37.

Oracle Identity Manager provides fail safe of an
provisioning process by specifying a duration for the
task within which the provisioning should be
completed. It also retries the event for a specified
number of times before that task can be assigned to
a specifc administrator or user.

Oracle Identity Manager provides integrity of a

provisioning transaction by executing undo or
recovery process if the provisioning process has not
been completed succesfully.

Pls refer to IDM 8, 9, 10, 11. Further to that Oracle

also provides out of the box connector to PeopleSoft,
SAP, Oracle Retail, Oracle eBusiness Suite, J D
Edwards, Flat File, SPML, BMC, CA Top Secret, IBM
RACF, RSA etc.

Oracle provides regular updates & patches for it's

Identity and Access Management suite. Patches and
updates can e downloaded from
https://metalink.oracle.com/updates/ for exisiting
customers.
All reconcilliation activities are logged on the Audit
server and can be queried for user account updates.
Reconcilliation engine also detects any accounts or
changes to user access privileges affected outside of
Oracle Identity Manager’s control, it can immediately
take corrective action, such as undo the change or
notify.
Oracle Identity Manager’s most powerful capabilities
is the reconciliation engine. The reconciliation engine
helps to detect and map existing accounts in target
resources, enabling the creation of an enterprise-wide
identity and access profile for each employee, partner
or customer user.
Oracle Identity Manager can provide continuous
monitoring of rogue and orphan accounts. By
combining denial access policies, workflows and
reconciliation, an enterprise can execute the requisite
corrective actions when such accounts are
discovered, in accordance with security and
governance policies.
Oracle Identity Manager supports a denial policy.
Denial policy will be used to explicitly deny rogue
accounts from accessing enterprise resources.
Oracle Identity Manager is a fully integrated platform
for audit and compliance. An integrated application
means once a resource is brought under
management, the connection can be leveraged for
both auditing and compliance use, avoiding
duplication of integration cost. An integrated
application means the audit and compliance features
need not be restricted to just reporting. Oracle also
provides attestation feature which allows perodic
validation of users accesss to enterprise resources.
Oracle Identity Manager reports on both the history
and the current state of the provisioning
environment. The system captures all necessary data
to answer the question “Who has access to What,
When, How, and Why?” Some of the identity data
captured includes user identity profile history, user
group membership history, user resource access and
fine-grained entitlement history. Oracle Auditing also
allows out of the box integration with 3rd party tools
like Crystal Reports.
Auditing capabilities combined with the transaction
data generated and captured by Oracle Identity
Manager’s workflow, policy, and reconciliation
engines, an enterprise has all the required data to
address any identity and access related audit inquiry.
Oracle Identity Manager's reporting and auditing
capabilities enable an enterprise to cost effectively
cope with ever increasingly stringent statutory
/regulatory requirements, such as Sarbanes-Oxley,
21 CFR Part 11, Gramm-Leach-Bliley, HIPAA, and
HSPD-12.
Oracle Adaptive Access Manager provides virtual
keyboard to provide user credentials including
password. Virtual keyboard helps prevent man in the
middle attacks / Pharming, Session hacking, Malware,
Spyware, Phishing, Torjan, Key stroke loggers,virus
and Bots. Following are the types of virtual keyboards
provided - Keypad, Slider, Quiz Pad, Text Pad,
Question Pad and
In 1994, Oracle Pinthe
was Pad.
first vendor to complete
ITSEC and TCSEC security evaluations. Now, with
over twenty independent security evaluations for its
products, Oracle is the undisputed leader in
independent security evaluations.Oracle Internet
Directory and the Oracle Database 10g are EAL4+
certified. Further the Oracle Application Server 10g is
also EAL4+ certified.
ID Functional Requirements - CORE Insurance Priorit SUP MOD CST NS
(C/D/N)
BPM
Modeling
Should provide graphical modeling environment for
process flow, resources, organization, cost, time,
BPM1 data and performance measurement C X

Should support for BPEL export of the business

BPM2 process C X
Should support integration of process models
developed using industry standards (such as
BPM3 BPMN, etc) C X

Should conform to industry workflow standards like

BPM4 WfMC, BPEL C X

BPM5 Should support Business rules and templates. C X

Should provide browser-based rules management
BPM6 interface
Should allow Human task services that will allow D X
role-based task assignment, invocation and
BPM7 escalation C X
BPM8 Should support rich human interactions C X
Should provide Business process integration
BPM9 semantics C X

BPM10 Should maintain versions of process models C X

BPM11 Should provide scenario based process modeling C X

Should provide graphical choreographer with

BPM12 minimal coding for process development C X
Should have feature for approval of Process
BPM13 Models before deployment to production C X

Business Rules Management

Should be able to define the Rules in terms of

multiple rules as follows: a. Logical Conditions b.
Mathematical Computations c. AND / OR
BPM14 combinations d. Combination of above C X

Should be able to define Event Based and

BPM15 Condition based Triggers C X
Should Provide English Language Like or natural
BPM16 Business language like syntax C X
BPM17 Should Provide versioning of Rules C X
BPM18 Should have the ability to define parent child role C X
BPM19 Should have nested rules C X
Should provide the methodology and tools for
BPM20 building industry specific rule templates C X
Should provide user-friendly interface and rule
BPM21 editing functionalities C X
BPM22 rules C X
BPM23 Should provide rules consistency validation C X
Should be able to diagnose rules overlapping and
BPM24 under-covering the business rules C X
Should provide a single platform / environment for
BPM25 modeling ,coding, debugging and deploying C X
Should be able to detect rule conflicts and
BPM26 redundancies across defined rules C X

BPM27 Should be able to monitor and report on rules C X

Should be able to monitor and report on business
processes and escalate and alarm on business
BPM28 bottlenecks C X
Should have feature for approval of rules before
BPM29 deployment to production C X
Should support 24/7 availability with high
BPM30 availability hardware platform. C X

Deployment
Should enable Service Oriented Architecture
BPM32 based application and BPM development C X
Should be based on Enterprise Service Bus
BPM33 (ESB(SOA Suite))
Should conform to architecture
Web Services standards – C X
WSDL, SOAP, UDDI, WS- *, WSRP, JCA, JAAS,
BPM34 etc C X
Should conform to industry Service Component
BPM35 Architecture and Service Data Objects C X
Should provide out-of-the-box JMS and JCA-
BPM36 complaint adapters C X

Should Provide consolidated runtime platform for

Enterprise Application Integration and Business
BPM37 Process management C X
Should support flexible Exception handling
BPM38 framework and transaction management C X

Should support dynamic-ways of

BPM39 execution/selection of services. D X
Should provide standards-based, metadata-driven
BPM40 adapter development kit and framework. D X
 Should provide multiple ways of deployment of
process models that are Flow-based, State-
BPM41 machines-based etc C X
Business process should have transformation
services include mapping, mediation and
BPM42 assembly. C X
Should provide visual tools to configure integration
logic with existing and new applications and
BPM43 humansprovide
Should in the network.
common event infrastructure C X
based on common event formats which should
enhance tracking, auditing, and monitoring of
BPM44 business processes. C X

Enterprise Service Bus

BPM45 Should provide intelligent routing between services C X

Should be able to convert transport protocols

BPM46 between requester and service C X
Should support multiple transport types and
BPM47 message format C X
Should be able to transform message format
BPM48 between requestor and service C X

Should be able to handle business events from

BPM49 disparate sources C X

Should support connectivity between end points

through a variety of protocols and application
BPM50 programming interfaces (APIs) C X
BPM51 Should support
Should support the
JMSfollowing transports: · C X
Enterprise Transport,webservices
Transport,multicast transport , mobile
BPM52 transport,telemetry transport end of X

Should support a variety of transports, including

BPM53 TCP/IP, SSL, HTTP, and HTTPS C X

Should support SOAP/HTTP, SOAP/JMS, WSDL

BPM54 1.1 C X
Should support WS-* Standards including WS-
BPM55 Security, WS-Atomic Transactions C X
Should support UDDI 3.0 Service Registry, Web
Services Gateway, Service Component
BPM56 Description Language (SCDL) C X
Should support routing transport protocols such as
BPM57 file, FTP, POP/SMTP, IMAP, RMI out of box C X
 Should support multiple messaging models such
as synchronous, asynchronous, Publish and
BPM58 subscribe. C X
Should support dynamic reconfiguration of service
BPM59 interactions to meet changing business needs. C X
Should support Service Component Architecture
BPM60 (SCA) and Service Data Objects (SDO) C X
Should be able to track message delivery and
BPM61 redelivery C X
Should be able to configure message delivery
BPM62 options C X

Should provide reports and notifications for

BPM63 message delivery failure C X
Should provide multi threading of processes and
BPM64 parallel execution of jobs C X

Should support 24/7 availability with high

BPM65 availability hardware platform. C X

Integration Framework
Should be able to integrate services published in
BPM66 the service bus C X

Should be able to integrate services published in

BPM67 external systems C X
X
Should support a variety of Internet and Web
services standards, such as java,J2EE, XML,
JCA , JAAS , X.509,LDAP,WSDL,WSRP,SOAP ,
BPM68 UDDI and Microsoft .Net C X

Should Provide an interface to integrate flat files

BPM69 and csv files C X

Should be able to integrate with services from third

BPM70 party payment gateways. C X
Should provide adapters for SOAP/HTTP and
BPM71 REST/HTTP C/D X
 Should support XML as an internal document
BPM72 format. It should also support XPath and XQuery. C X

Should provide notification capability that is

BPM73 capable of supporting email and SMS C X

Should be able to stream process data to an

external monitor to support Business Activity
BPM74 Monitoring capability C X

Should provide out-of-the-box performance reports

(e.g. process execution time), viewable via a web
BPM75 console C X

Should have configurable logging capability. Use

BPM76 of open frameworks for logging is preferred. C X

BPM77 Should support X.509 digital certificates C X

BPM78 Should support SSL/TLS Security C X

Should have comprehensive transaction
BPM79 compensation (rollback) models C X

Should support 24/7 availability with high

BPM80 availability hardware platform. C X

Data transformation and Mapping

Should support for reading data from multiple data

BPM81 sources to compose a message response C X

Should support for storing data from a single input

BPM82 to multiple data stores C X
 Should have ability to read messages in CSV
BPM83 format D X

Should support for reading messages in XML,

BPM84 DTD and XSD formats C X
Should support for reading messages with multi-
BPM85 character delimited formatting D X
Should be able to create and read Java Serialized
BPM86 Objects C X
Should Provide a graphical map to map source
BPM87 fields to/from target fields C X
BPM88 Should support Large Business Objects C X
Should support for transformation rules with
content-driven logical and conditional operations.
The system should provide IF, ELSE, AND, OR (or
similar) operators that operate on request and
response values including built-in process
BPM89 templates C X

BPM90 Should support

Should support transformation
XSL data transformations
rules in more than C X
one transformation through implementation of sub-
BPM91 flows C X
Should support visual XSLT transformation for
BPM92 messages C X

BPM93 Should provide a test tool for the XSLT C X

Business Activity Monitoring

BPM94 Should provide web-based UI analytics capability C X

Should provide role-based access to business
BPM95 dashboards C X
Should provide personalized configuration of the
dashboards, KPI's, scorecards, alerts, tables,
BPM96 reports etc C X
BPM97 Should provide monitoring of the business process C X
Should provide feature to drill down and drill up on
BPM98 process nodes C X
Should support closed-feedback loop development
BPM99 for true BPM implementation C X
Should be able to define process KPI's,
BPM100 scorecards, thresholds, etc C X

Business Process Simulation

Should provide test environment for process

BPM101 simulation C X
 Should provide interactive GUI for simulation
BPM102 analysis C X

Should provide cause and effect framework for

BPM103 simulation analysis C X
Should have the ability to define simulation
environment for testing the rules defined in the
BPM104 rules engine using Simulation Scenario building C X
Should be able to define and solvable constraint
BPM105 satisfaction problems C X
Should have the ability to predict impact of
changes by testing rules against simulated
BPM106 business conditions C X
Should integrate with predictive modeling for what
BPM107 if and scenario analysis C X

Should provide frameworks for Discrete event

simulation o Versatile, graphical modeling
capabilities; create and save custom components.
Model animation for validation and debugging.
BPM108 Ability to save simulation process models. C X

108 105 3 0 0
97.22 2.7778 0
Remarks

Oracle BPA Suite provide a graphical user interface where the

functional persons can develop the process flow starting for the
high level design and then blowing down to the nitigrities of the
individual
Oracle BPA process
Suite and BPEL Process Manager provide the
uniquenesss of once developed Process in BPA suite can be
directly exported to BPEL code which can then be used in BPEL
Designer

Oracle BPA Suite Support devlopment of standard based

processes based on BPMN,EPC etc
Oracle BPEL Process Manager the runtime engine for workflow is
based on BPEL standard. Oracle BPA Suite which is the modeller
can design models which can be directly converted to BPEL Code
to be used in BPEL Process Manager
Oracle SOA Suite supports Business rules interface and
templates. This is part of Oracle Business Rules. All the

Out of Box for Oracle Business Rules

Out Of Box for Oracle BPEL Process Manager( SOA Suite)

Out Of Box for Oracle BPEL Process Manager( SOA Suite)

Out Of Box for Oracle BPEL Process Manager( SOA Suite)

In Oracle BPEL Process Manager( SOA Suite) , versioning of
processes are available as default
Oracle BPA Suite has got sevaral templates which can be used to
do various scenario based modelling
Oracle BPA Suite Provides the graphical interface which gives the
user the flexibility to design the process with zero coding. The
process once developed will be converted to BPEL code which
can be used by the designer to put the final integration touchpoints
to finalise the process before deploying to BPEL Process
Manager(SOA SUite)
The same can be developed using the APIs in BPEL Process
Manager

Out of Box Support For Oracle Business Rules

The same is possible in all the SOA Suite products like ESB, BPEL
Process manager , Oracle Web Services Manager and Business
Activity Monitoring

Out of Box Support For Oracle Business Rules

Out of Box Support For Oracle Business Rules
Out of Box Support For Oracle Business Rules
Out of Box Support For Oracle Business Rules
One can use various industry specific templates based on XML
which can be used directly in Business Rules
Web -based Graphical interface is being given for defining and
editing facilities
Out of Box Support For Oracle Business Rules
Out of Box Support For Oracle Business Rules

Out of Box Support For Oracle Business Rules

Out of Box Support For Oracle Business Rules

SAME AS BPM23
Oracle Business Rules comes with the Rule Monitor which halps to
monitor and produce reports on the Rules
Oracle Business Process Manager ( SOA Suite) in conjuction with
Business Activity Monitoring will be able to give the required
funstionality

The same can be easily achieved with Rules APIs

As Oracle Business Rules is deployed on Oracle Application
Server

Oracle BPA Suite and SOA Suite are based on Service Oriented
Architecture
Oracle BPEL Process Manager and the ESB runs on the
Enterprise Service BUS which is the messaging backbone

All the SOA suite Products conforms to WSDL standards

Out - box support

JMS and JCA compliant adapters are available as out-ofbox for all
components of SOA Suite
Oracle SOA Suite provides the most comprehensive runtime
platform for having the integration across various Application with
the availability of oit-of-box application adapters to connect to any
industry leading applications. Oracle BPA Suite in conjuction with
Oracle SOA suite helps to design the integration scenario and help
in the implementation
Oracle BPEL Process Manager provides the inbuilt framework for
exception handling in process flow and transaction management
Both Oracle ESB and BPEL Process Manager provides the
dynamic ways ffor execution based on if-then-else or based on
some complex business rules
The adapter development framework available from Oracle is
based on metadata and open technology
There are various ways of deployment of process once designed.
The same can be directly deployed to BPEL Process manager
once developed in Jdeveloper by a click of button. The same can
be exported in files and deployed through batch file
Both Oracle ESB and BPEL process Manager provide with XSLT
transformer which is graphical and userfriendly. The tnasformer
can be used for mapping and assembly
Oracle Jdeveloper the development tools for both Oracle Esb and
Oracle BPEL Process manager helps to integrate new process
using the complete visual environment
Auditing , monitoring of Business Process and tracking of
individual process is available out-of-box as part of BPEL monitor
which is completely web-based.

Oracle ESB(SOA Suite) provides routing between services

depending on conditions
Oracle ESB(SOA Suite) comes with various adapters like
SOAP/HTTP etc which helps to convert transport protocols
between requester and service
ESB(SOA Suite) support multiple transport types like OEMS ,
JMS , MQ etc and different message formats

SAME as BPM 46
As ESB(SOA Suite) is able to talk to disparate systems through
various adapters , handling of Business Events is possible within
ESB(SOA Suite) as default functionality
Oracle ESB(SOA Suite) comes with various out-of-box adapters l
which helps to connect to disparate systems with various protocols
. Oracle Jdeveloper the development tool for ESB(SOA Suite)
based project will help to do application programming using the
interface APIs
Out Of box functionality

Oracle Integration products are associated with Oracle Integration

adapters which support all the mentioned transports

Oracle BPEL Process Manager(SOA Suite) and ESB(SOA Suite)

includes support for SOAP/HTTP protocols. The integration
software provides out-of-the-box support for consuming web
services through WSDL definition.
X. Oracle provides support for WS-Security through Web Services
Manager.

Oracle Supports the feature using Oracle Service Registry( SOA

Suite)

Supported Out of box

Oracle BPEL Process Manager(SOA Suite) support both
synchronous and asynchronous as well as Publish and Subscribe
Both ESB and BPEL Process Manager ( SOA Suite) support the
same

Oracle SOA Suite Components are build on SCA architecture

Both ESB and BPEL Process Manager ( SOA Suite) support the
same
Both Esb and BPEL Process Manager are with wizard driven
adapters which can be configurable for message delivery

Oracle BPEL PM provides out-of-the-box, integrated process

reports. Users are able to view execution times for instances,
measure them against SLAs, or simply just view how many
processes have been completed in the past week. Oracle BPEL
Process Manager provides a Notification activity that can be added
to the process design. This notification node support multiple
channels of delivery such as email, SMS and fax notification.
Both ESB and BPEL Process Manager ( SOA Suite) support the
same
All the components of Oracle SOA Suite support High Availability .
Moreover all the SOA Suite components are deployed on X.
Oracle Application Server provides high availability through
clusterable components. Various components within Oracle
Application Server (integration, portal, etc), can be deployed in an
active-active configuration, providing scalability and high
availability to the middleware tier. Load balancing between multiple
tiers within the Application Server is provided, and multiple
algorithms (weighted, random, round-robin) are available to meet
different needs.

Oracle ESB and and BPEL Process Manager(SOA Suite) is

capable of integrating services published in the environment
Oracle ESB and and BPEL Process Manager(SOA Suite) is
capable of integrating services published in the environment with
the help of out-ofbox adapters

Oracle BPEL Process Manager includes support for

SOAP/HTTP,JCA protocols with JAAS security. The integration
software provides out-of-the-box support for consuming web
servicesBPEL
Oracle through
PMWSDL definition.
provides a Native Format Builder, to generate
XML schema equivalents for use inside BPEL Process Manager.
The wizard works with CSV, Fixed-length, DTD or COBOL
Copybook files.
Oracle ESB and and BPEL Process Manager(SOA Suite) is
capable of integrating to services published in the environment
with the help of out-ofbox adapters. Oracle Web Services
Manager( OWSM) will take care of security and encryption

SAME AS BPM 54
Oracle BPEL Process Manager(SOA Suite) processes all
documents internally as XML. Xpath and Xquery are both used for
processing the message variables (such as transforms, message
enrichment, etc).
Oracle BPEL Process Manager( SOA Suite) provides a Notification
activity that can be added to the process design. This notification
node support multiple channels of delivery such as email, SMS
and fax notification.
Both Oracle ESB and Oracle BPEL Process Manager ( SOA Suite)
support streming of data to different message queues. Business
Activity Monitoring can pick data using the Enterprise Link to its
Active Data Cache
Oracle BPEL PM provides out-of-the-box, integrated process
reports. Users are able to view execution times for instances,
measure them against SLAs, or simply just view how many
processes have been completed in the past week.
X. Oracle BPEL PM allows configurable logging for multiple levels
(Debug, Info, None) at the domain level. Log4J (an open, popular
logging framework) is used internally for logging, and is
configurable to meet custom logging requirements
Oracle Application Server security services include the ability to
restrict or allow access to files and services based on the identity
of users established by means of basic authentication, by client-
supplied X.509 certificates, and by IP or hostname addresses.
The web server component of Oracle Application Server provides
the standard web server security features including Encryption,
Authentication and Authorization. Using standard SSLv3 and TLS,
Oracle Application Server is able to provide network encryption
using the more recent NIST (National Institute of Standards and
Technology) approved AES Cipher suites.In order to secure back
end communication between the application server and the
database, you have a choice of using SSL or other native
encryption algorithms offered by Oracle Advanced Security, an
Oracle
Oracle Database Enterprise
BPEL Process Edition option.
Manager(SOA Suite) has got the error
catching facility and roolback to the previous state should there be
any error
X. Oracle Application Server provides high availability through
clusterable components. Various components within Oracle
Application Server (iSOA Suite amongst them), can be deployed in
an active-active configuration, providing scalability and high
availability to the middleware tier. Load balancing between multiple
tiers within the Application Server is provided, and multiple
algorithms (weighted, random, round-robin) are available to meet
different needs.

During the Process Flow , Oracle BPEL Process Manager(SOA

Suite) can read data from multiple data-sources and through the
assign activity the message can be composed of data from
variable sources
During the Process Flow , Oracle BPEL Process Manager(SOA
Suite) through the invoke activity the message can be store
composed of data to multiple stores
The file adapter from BPEL Process Manager and ESB ( SOA
Suite)
Oraclegives
BPELthis
PMfunctionality as out-of-box
provides a Native Formatfeature
Builder, to generate
XML schema equivalents for use inside BPEL Process Manager.
The wizard works with CSV, Fixed-length, DTD or COBOL
Copybook files.

Supported
One usingJava
can inbuilt the same fileBPEL
code in adapter mentioned
Process in BPM84
Manager or ESB(SOA
Suite) which can be used for creating /reading Java Serialized
Objects
Oracle BPEL Process Designer includes a visual XSLT designer
for message transformation.

Out-of-box
Oracle BPEL Process Designer includes a visual XSLT designer
for message transformation.

Out-of-box
Oracle BPEL Process Designer includes a visual XSLT designer
for message transformation.
After the XSLT has been built, Oracle JDeveloper offers the option
to test the XSLT to review if the desired results are generated. The
tool can generate a test document, and parse the document using
the defined XSLT.

Oracle Business Activity Monitoring is completely web-based tool

where the development,designing of reports , viewing of
reports,administration everything is completely webbased

Rolebased access is supported for BAM

Personalized content in Dasboard is also supported in BAM

Default functionality

Default functionality

Can be achieved with little customization

Default functionality

Oracle BPA Suite provides a simulation engine where one puts

various inputs and the simulation runs to find out the process
bottlenecks
Oracle BPA Suite is entirely based on GUI for doing the designing
and Simulation
As Simulation is for doing the cause and effect analysis , Oracle
BPA Simulator pin-points the places of Bottlenecks and
improvements on the same

Oracle BPA Suite Simulator provides the interface for defining

rules and and testing the rules

Oracle BPA Suite Simulator provides the interface for defining

rules and and testing the rules and the impact on the business
process on chanign the rules
Oracle BPA Suite provides the environment for doing what-if and
scenario analysis in the simulator

Oracle BPA Suite provides the interface for doing event simulation.
As the simulation environment is part of the same modeling
environment where one define the business proess so the ability of
creating and vaing custom components is available out-of-
box.Debugging environment is available out-of-box. Simulator also
gives the faacility to save the simulation process models
 ID Product Features Priority SUP MOD
(C/D/N)

The data should be presented in fully

customizable views including data tables,
graphs, scorecard dashboard creation
through – dials, gauges, views, strategy
maps and critical success factor dials. The
flexible interfaces should allow creating
CPM1 any views to be displated. C X
Should have the dashboard capability to
use speedometers, charts, tickets, dials,
gauges, pivotal tables or other customized
images to signal KPL status. Associate
CPM2 any image to a certain threshold or range C X
value.
Should be integrated with the Data Mining,
Data warehousing, Data Quality,
Reporting, Statistical and Application
Development Tools
CPM3 C X
Should have the ability to recalibrate
targets in response to changes in
performance with integrated planning
capabilities.

CPM4 C X
Should have the capability to determine
and re-calibrate the asking rate against a
target

CPM5 C X
Should allow indication at an aggregate
level that one of the sub-measures is “red”
(under-performing) although the aggregate
CPM6 level is still “given” or “orange” C X
Should refresh tables and charts
automatically to get the latest version of
the truth

CPM7 C X
Should support strategy maps. These
maps should be customizable and values,
alerts, traffic lights etc should be inherited
CPM8 from the source data C X
Should support frameworks like Balance
Scorecard and also allow developing
CPM9 Customizable frameworks C X
 Should also support support six sigma
CPM10 framework N X
Should have the ability to create
CPM11 scorecards through wizards C X
Should have the ability to configure
CPM12 (add/modify/delete) and define KPI’s C X
Should provide features to create any
CPM13 number of threshold ranges for KPI’s C X
and benchmarks
Should provide the flexibility in defining
any detailed tolerances for any measure
CPM14 and any scorecard C X
Should provide for a communication
channel at individual KPI level. It should be
able to store a history of comments
CPM15 associated with a KPI, with a Date and C X
Time stamp.
Should be able to configure alerts and
notifications for defined metrics and
notification by delivery channels such as
CPM16 email/sms/warning at dashboards, etc C X
Should be able to send alerts to specific
people when specific measures need input
or are performing exceptionally (under or
over performance) through integration with
CPM17 email / sms C X
Should allow drill down and drill through
CPM18 onto pre-configured reports and views C X
Should allow comparison of business unit
structures (company level, department
level, regional office level, branch office
level) in different models with mapping of
CPM19 changes where ever necessary C X
Should have the ability to link related
performance measures within the
organizational hierarchy to ensure integrity
CPM20 of calculation of these measures D X
Should allow appropriate report to
CPM21 appropriate people. C X
CPM22 Should allow configuration of groups C X
Should provide dashboard views Channel
wise reports – Region wise, year wise
(with drill down capability – for Operating
office/Regional Office : month on month
and quarter on quarter basis), Product
wise, Product Segment Wise, strategic
partner group wise, any other logical
grouping) for:
Premium Growth C
Claims
Profitability
Outstanding Claims Number
No of Policies
 No of livesGrowth
Customer covered(Retail, Corporate,
Rural)
Claim Turn Around time
etc
CPM23 X
Should provide dashboard views for
Employee Performance – region wise,
CPM24 year wise, function wise (claims, sales etc) C X
Should provide dashboard views for
Business targets-Financial goats, plans
and metrics such as such as premiums,
revenues, controllable expenses, key
CPM25 ratios and profitability and incidences of C X
variations
Should provide dashboard views for
CPM26 Investment Income growth C X
Should provide dashboard views for
CPM27 IRDA/IFRS/regulatory compliance C X
Should provide dashboard views for
CPM28 management of asset/liabilities D X
Should provide dashboard views for
Forecasting and budgeting, and large
CPM29 variances C X
Should provide dashboard views for
CPM30 Performance SLAs C X
Should provide dashboard views for
CPM31 Customer satisfaction rating C X
Should provide dashboard views for
CPM32 Agency/broker satisfaction rating C X
Should provide dashboard views for
Unfavourable changes in risk exposures,
CPM33 portfolio concentration or product mix C X
Should provide dashboard views for
Operational risk exposures such as
information security, systems failture and
CPM34 transaction processing problems C X

Should provide dashboard views for

Increases in loss severity or frequency C
CPM35 X
Should provide dashboard views for Loss
CPM36 reserve adequacy C X
Should provide dashboard views for
Inadequate or inappropriate use of
CPM37 reinsurance to spread risk C X
Should provide dashboard views for
CPM38 Emerging loss/risk exposures C X
Should provide metadata reporting across
ETL jobs, RDBMS and reporting tools to
CPM39 technical dashboard C X
Should provide reports of metadata
CPM40 changes and updates to the technical C X
dashboards
 Should be able to set Data Quality alerts to
enforce data governance rules and send it
CPM41 to technical dashboards C X

41 17 24
41.46341463 59
CST NS Remarks

The scores and

statistics can be
integrated into
the CPM
framework

Sophisticated
planning around
financials and
complicated
scenarios can be
built using the
OLAP cubes and
visualized on the
Dashboards
The writeback
feature enables
us to re-
caliberate against
a target

The tables and

charts will be
updated as per
the Data refresh
Cycle
The definition of
the reports needs
to defined during
The definition of
the reports needs
to defined during
deployment

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above

Same as above
0 0
0 0
 ID Product Features Priority SUP MOD CST NS
(C/D/N)
REBI1 Should provide features for:
1. Canned Reports X
2. Parameterized Reports C
3. Ad-Hoc reports
REBI2 Should provide access to a
complete
list of self-serve report types, X
adaptable to any data source, and
operate from a single metadata
layer for a variety of benefits such
as multilingual reporting.
C
REBI3 Should provide self-sufficient and
easy
access to enterprise data sources X
on multiple platforms, operating
systems and databases.
C
REBI4 Should have the ability to visually
access any supported database
and support for native data types
via ODBC, OLEDB, OLE DB for
OLAP, and others such as DB4,
Flat files, Excel / Access, etc.

X
C
REBI5 Should provide support for data
sources of any class provided in the C X
solution basket.
REBI6 Should provide flexibility to choose
and
customise the template of reports & C X
report output formats.
REBI7 Should provide flexibility to design
the template of reports & report
output formats based on role
C X
specific rights

REBI8 Should have the ability to define

report
layout through wizards: tables, C X
graphs, headers & footers
REBI9 Should enable users to save
template
for individual consumption as well D X
as share templates with others
REBI10 Should have a graphical query
builder
for users to visually access and X
manipulate their data without SQL
expertise.
C
REBI11 Should provide feature to preview
REBI11
generated query code, check the X
query syntax validity or copy the
code for reuse in other applications.
C
REBI12 Should have feature to maintain X

favorite queries C

Should have web based ad-hoc

analysis tool where end user can X
interact with logical view of
information creating charts, pivot
REBI13 tables, reports,
gauges, etc C
Should be able to parameterise
data to interactively filter the
information required for intelligent
REBI14 decision-making C X
Should have Point and click wizards
that enable users to create, delete
and reorder pages, add and remove
content and modify page layout to
self- sufficiently organize content in
their
work area. X
REBI15 D
Should provide feature to visually
build
calculated variables / computed X
columns from a comprehensive list
REBI16 of
pre-defined and user defined C
functions.
Should be able to organize
information
REBI17 for easy viewing with a Select and C X
Sort interface.
Should allow position and sizing of
REBI18 graphs, tables, text, images, etc., D X
with layout capabilities.
Should be integrated with OLAP X
REBI19 capabilities C
Should be integrated with
forecasting
REBI20 solution. C X
Should provide support for
capabilities
such as trickle feed ETL, Business X
Activity Monitoring, Federated data
access directly from OLTP systems
REBI21 C
Should provide multidimensional
data
exploration: drill, rotate, filter, X
REBI22 reorganize, sort, toggle totals, C
export to various target formats.
Should provide relational data
 exploration: rotate, filter, reorganize, X
sort, toggle totals, export to
configurable and role based target
formats.
REBI23 D
Should provide feature to slice and
dice multidimensional data and
applying filters on any level of a
REBI24 hierarchy. C X
Should be able to be delivered
through channels in various formats
multiple X
REBI25 like HTML, RTF, Doc, Excel, Text, C
and form.
PDF
Should provide the facility to save
REBI26 output in tables or data as the same D X
as the input format.
Should provide integration with X
REBI27 Microsoft word, excel, and C
powerpoint
Should be able to deliver graphics
results directly into Word or Excel in X
any of these formats: GIF, JPEG or
PNG.
REBI28 D
Should provide the ability for users
to
create, organize and secure X
documents of disparate types
based upon their
REBI29 own folder structures as a web- D
based application.
Should digitally sign reports that are
REBI30 sent outside NIC (such as statutory C X
reports, partners reports, etc)
Should allow creation of filters to
control data displayed on a report.
For Example:
Greater Than, Less Than, Equal To,
Not Equal To, Between,
Not Between,
Regular Expressions and other text X
filters

REBI31 C
Should have static or dynamic
REBI32 interactive (Java or ActiveX) charts D X
and graphs.
REBI33 Should allow linking to other reports C X
Should be web enabled and provide
 portlets that provide shortcuts to the X
folders or to the documents and be
delivered through the enterprise
REBI34 portal C
The presentation layer should have
web based delivery channel based
on HTML/DHTML/JavaScript. The
main idea is that there should be
NO client downloads, no plug-in’s,
No ActiveX controls, No Applets.

X
REBI35 C
Should be able to deliver reports at X
run time, and also to email and
REBI36 inbox C
Should allow browsing of metadata
repositories to locate applications, X
dashboards, performance indicators
and reports.
REBI37 D
Should be able to print reports and
specify page range while printing

REBI38 C X
Should provide expansion and
collapse capabilities to let users
REBI39 consume
act and
on information with fewer clicks D X
Should be able to configure start X
page number while configuring
REBI40 reports D
Should allow passing of parameters X
to the reports at run- time.
REBI41 C
Should provide Ad-hoc reports X
REBI42 through
the portal C
Should provide report on the usage, X
frequency, and severity of the
REBI43 reports C

43 40 1 2
93.02326 2.325581 4.651163
Remarks

All the dashboards, Ad-Hoc reports,

canned reports, parameterized
reports are available as a thin client
web base

It has got single metadata layer to

access the reports.
The multilingual reporting is base on
the capabilities of underline web
browser used to access the reports

OBIEE supports on multiple

platforms and operating systems
and databases

OBIEE supports all database As

well as others.

Customization of report template can

be done only by authorized user with
users rights defined at user or role
level
The favorite query can be Stored and
can be viewed
as and when required to
in dashboard
Oracle BI has a complete Web Base
GUI Interactive dashboards with full
ad hoc queries and analysis

OBI is supported

The analytics system can be

integrated with any third party
forecasting solution
Can directly interact with the OLTP
solution. The trickle feeds and Activity
monitoring can be done depending
upon the capabilities of underline ETL
tool.

Using pivot table in OBI Answer

you can achieve it.
Using Dimensional hierarchy you
can able to able to achieve it

OBI Delivers helps in delivering

to multiple channels

Saving report & data storage?

OBI supports

OBI supports

The third-party digital signature

needs to be integrated with the BI
report
OBI supports in creation of filter

OBI supports

Linking reports is possible in OBI

Oracle Business Intelligence
Interactive Dashboards, Ad-Hoc
query. This 100 percent thin client
solution provides fully interactive
collections of analytic content with a
rich variety of visualizations. Running
on a Web-based architecture, the
dashboards provide users with
information filtered and personalized
for their identity, function, or role

If reports are taken in HTML. Use the

underline capability of the printer
attached with the browser For PDF
use the printing option of PDF
 ID Product Features Priority SUP
(C/D/N)
All analytical CRM functionality
should use data from data marts that are cleansed, de- X
AnCRM1 duped,
consolidated and optimized C
Should be able to define data models and metrics for X
AnCRM2 analytics C
Should have detailed error handling/reporting capabilities. X
AnCRM3 C
Should be able to leverage predicting modeling and
forecasting capabilities for modeling
AnCRM4 C X
AnCRM5 Should support PMML C

Should provide simulation model for

Sales forecasting, Pipeline forecasting, Campaign X
Forecasting and predictive analysis
AnCRM6 C
Should be able to define thresholds X
AnCRM7 for models and recalibrate models at run time C
Should be able to integrate with communication medium
AnCRM8 such as email, IVRS, etc. C X
Should be able to predict the

purpose of visit of a customer once the customer is

identified by the system
AnCRM9 N
Should seamlessly integrate with X
AnCRM10 Operational CRM C
Customer Analytics
Should provide 360 degree view of customers X
AnCRM11 C
Should be able to build views by customer profiles X
AnCRM12 C
Should show number of high value customers that are at X
AnCRM13 risk of churn C
Should be able to show details of X
AnCRM14 insurance products already sold to a customer C
Should be able to show customer satisfaction levels X
AnCRM15 C
Should be able to segment X
AnCRM16 customers C
Should be able to identify profitable customer groups X
AnCRM17 C
Should be able to identify customers based on frequency of X
AnCRM18 purchase C
Should be able to identify top
AnCRM19 customers and well as bottom customers C X
Should be able to maintain a customer retention program X
AnCRM20 C
Should support aggregation techniques to group customers X
AnCRM21 C
Should be able to show effectiveness of retention programs X
AnCRM22 C
Should be able to identify customer
AnCRM23 wise cross selling / upselling potentials C X
Should be able to identify cross sell / X
AnCRM24 up sell product categories C
Should provide upsell loyalty awareness information X
AnCRM25 C
Should be able to define specific
automated event triggers (e.g., birthdays, anniversary,
festivals, delinquency and length of time as a customer) to
initiate targeted customer campaigns?
X
AnCRM26 C
Should be able to show customer behavior based on
AnCRM27 predefined customer behavioral attributes C

Should be able to integrate with various data sources from

the data mart as well as external data sources
AnCRM28 C X
Should be able to import external lists of customer
information purchased from various sources
AnCRM29 C X
Should be able to segment customer and products for X
AnCRM30 maximizing revenue C
Should be able to analyse customer segment lifecycle X
AnCRM31 C
Should provide views for lead filtering analysis X
AnCRM32 C
Should provide analysis of effectiveness of the lead X
AnCRM33 sources C
Should have predefined model for segmenting customers X
AnCRM34 for cross sell and upsell C
Should provide feature to develop analytical models for
segmenting customers for cross sell and upsell
AnCRM35 C X
Should provide features for X
AnCRM36 Customer Profitability Analysis C
Should be able to score customer satisfaction X
AnCRM37 C
Should be able to identify seasonal customers
AnCRM38 C
Should provide details of customer channel analysis and
customer wise channel analysis
 Should provide details of customer channel analysis and
AnCRM39 customer wise channel analysis C

Campaign Management
Should be able to integrate with budgeting of campaigns
AnCRM40 C

Should have the ability to de-

duplicate campaign selection lists at the household,
individual or more defined level (e.g., using specific
AnCRM41 criteria)? C X
Should support ranking of criteria to
AnCRM42 select the “best” record for a target group. C
Should be able to execute marketing campaigns via:
• E-Mail – HTML, Text formats supported
• MMS, WAP & SMS
AnCRM43 • RSS Feed C
Should provide “Spam-Engine”
AnCRM44 integration for CAN-SPAM C
compliance testing
AnCRM45 Should honour a do not call registry. C
Should support both online and
offline campaigns marketing can have a stronger
understanding of all consumer interactions that occur,
AnCRM46 regardless of touch point. C X
Should be able to track campaign responses X
AnCRM47 C
Should be able to identify seasonal campaign requirements
AnCRM48 C
Should qualify a customer as a target
for the campaign only after validating that the lead is not an
existing customer of the product selected for campaign
based on
emailId/telephone no.
AnCRM49 N
Should have the ability to define a communication strategy
with dynamic understanding of prior and
pending communication to customers
AnCRM50 C
Should have the ability to maintain
campaign communications' history to understand what X
individuals received what offer through which channel, on
AnCRM51 what day. C
Should be able to integrate with call center campaign X
AnCRM52 C
 Should be able to integrate with email campaign X
AnCRM53 C
Should be able to integrate with SMS Campaign X
AnCRM54 C
Should be able to define thresholds for campaign X
AnCRM55 effectiveness C
Should be able to monitor campaign effectiveness X
AnCRM56 C
Should be able to monitor the
success of email campaigns, X
AnCRM57 including number of emails delivered, open rate, bounce- C
backs, and offer effectiveness
Should be able to monitor the
success of call center campaign, including the number of
calls made,
average days to follow-up, cross-sell X
AnCRM58 and up-sell effectiveness, and total order revenue. C
Should be able to provide automated follow-up (i.e., re-
solicitation or fulfillment) for campaign responders
AnCRM59 C X
Should be able to automatically
identify and track responses to marketing campaigns using X
any direct or indirect channels
AnCRM60 C
Should be able to schedule and
control execution of event-driven marketing campaigns
including on-
the-fly segmentation,
extraction/output processing to the appropriate channel(s), X
response analysis, follow-up segmentation, communication
to responders and non-responders

AnCRM61 C
Should also provide reports for inferred campaigns X
AnCRM62 C
Should be able to deliver all customer issues in single view X
AnCRM63 C
Should provide real time information
AnCRM64 of targets and actuals related to campaigns C
Should provide information of potential opportunities X
AnCRM65 C
Should be able to analyse and forecast ROI from a X
AnCRM66 campaign C
Should allow features for campaign optimization. X
AnCRM67 C
Contact Center Analytics
Should provide features for Contact
AnCRM68 center agent adherence and occupancy C X
Should provide features to monitor
call center cost (overall fixed and variable) and average X
cost per episode
AnCRM69 C
Should provide contact center utilization and gains and X
AnCRM70 losses C
Should provide customer analytics
(experience, service, satisfaction) of customer avaiing X
contact center services
AnCRM71 C
Should provide contact center X
AnCRM72 scorecard C
Should provide end to end view of
cases registered in contact center (open, close, recurrence, X
ageing, and forecasting)
AnCRM73 C
Should provide detailed analytics of abandon rate X
AnCRM74 C
Should provide detailed service level exceptions and X
AnCRM75 performance analysis C
Should provide analytics for customer query trends X
AnCRM76 C
Should be able to integrate with
AnCRM77 campaigns originating from contact centers C X
Should provide product profitability
AnCRM78 for product sales attributable to contact center C X
Should provide customer profitability for business from
AnCRM79 customers through contact center C X
Sales Analytics
Should be able to analyse sales profitability by region
AnCRM80 C X
Should be able to analyse sales profitability by agency X
AnCRM81 C
Should be able to analyse sales by discounts X
AnCRM82 C
Should be able to analyse sales force by discounts X
AnCRM83 C
Should be able to analyse sales vis- X
AnCRM84 à-vis discounts, incentives to sales force C
Should be able to establish patterns of sales X
AnCRM85 C
Should be able to analyse sales force performance as a X
whole and drill down to details

AnCRM86 C
 Should be able to categorize sales X
AnCRM87 force based on targets and performance C
Should be able to identify sales force underwriting profitable X
AnCRM88 customers C
Should be able to identify sales force underwriting X
AnCRM89 unprofitable customers C
Should provide feature for pipeline X
AnCRM90 analytics C
Should be able to identify opportunities in the pipeline X
AnCRM91 C
Should be able to forecast sales by agencies X
AnCRM92 C
Should be able to forecast sales by X
AnCRM93 regions C
Should be able to forecast sales force that may miss X
AnCRM94 targets C
Should be able to forecast regions that may miss targets X
AnCRM95 C

95 81
85.26316
MOD CST NS Remarks

Depends upon the

underline data in the Mart

OBI Presentation
Services (Log Files
generated)
OBI Administration &
Presentation Services

The data-mining model

needs to adhere to PMML
The data-mining engine
supports this functionality.
Triangulated forecasting is
out of the box available

Functionality of the data-

mining engine

Some configuration as to
be done for IVRS
OBI Administration &
Presentation Services
X ( Login details are
available)

Is integrated with Siebel

CRM. For other CRM
customization is required

OBI Presentation Services

(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
Configured in Admin tool

OBI Presentation Services

(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
 (Answers & Dashboard )

Configuration as to be
done in OBI Admin &
Presentation
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
iBots as to be created

Customer behavioral
attributes needs to be
defined
X
Need some configuration

Configuration as to be
done in OBI Presentation
(Marketing)
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
Cross sell and upsell
depending upon the
products offered
Configuration as to be
done in OBI Admin &
Presentation (Marketing)
OBI Presentation Services
(Answers & Dashboard )
Attributes of CSI needs to
be defined
Need to know definition of
seasonal customer
X
Different channel needs to
be configured
 Different channel needs to
be configured

Campaign as to be
imported
X

Happens in conjunction with

the operational CRM

OBI Presentation Services

X (Answers & Dashboard )
iBots as to be created.

X
Supported in conjunction
with the operational CRM

X
X Need configuration
OBI Presentation Services
(Answers & Dashboard )

OBI Presentation Services

(Answers & Dashboard )
OBI Presentation Services
X (Answers & Dashboard )
OBI Presentation Services
X (Answers & Dashboard )

OBI Presentation Services

X (Answers & Dashboard )

The communications need

to be trapped in the
operational CRM
 OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )

OBI Presentation Services

(Answers & Dashboard )

iBots as to be configured

iBots as to be configured

iBots as to be configured

OBI Presentation Services

(Dashboard )
OBI Presentation Services
(Answers & Dashboard )
X Need to be
Configured in Admin tool
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )

OBI Presentation Services

(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )

OBI Presentation Services

(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )

OBI Presentation Services

(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )

OBI Presentation Services

(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
Configured using
Dimensional hierarchy in
Admin Tool
 OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard ))
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )
OBI Presentation Services
(Answers & Dashboard )

12 1 0
12.63158 1.052632
ID Functional Requirements - CORE Insurance Priority SUP MOD CST
(C/D/N)
Platforms
General Requirements
Platform / Middleware
Should be a Enterprise class middle Ware with
PLAT1 proven scalability C X
PLAT2 Should support 64-bit architecture. C X
Shall be capable of scaling up in capacity without
PLAT3 losing function. C X
PLAT4 Shall support real time deployment of applications C X
Shall provide tools and shall be capable of
providing an environment for developing and
PLAT5 deploying distributed applications. C X
Shall accommodate the interconnection of multiple
applications without compromising security,
PLAT6 performance etc. C X
Shall provide support for multiple platform
PLAT7 including hardware and operating systems. C X
Should allow interoperability with all Operating
Systems, Databases, Application servers, Web
PLAT8 services and other third party tools. C X
Shall allow flexible and reliable access control
mechanisms to assure that business partner data
is accessed only in the intended ways, and only by
PLAT9 the intended parties. C X
Shall allow system administrators to manage large
numbers of business logic components in a
uniform way, without having to understand or apply
PLAT10 unique procedures to particular components. C X
Shall allow system administrators to make
infrastructure component selections without
impacting applications, and to tune and scale
those components and have a uniform and generic
means of measuring the performance and
PLAT11 resource needs of all applications. C X
Should provide native support for SOAP (Simple
object access Protocol), WSDL (Web Services
Language Description and UDDI (Universal
Description Discovery and Integration) for standard
PLAT12 based application connectivity. C X
Should support a comprehensive BPEL process
PLAT13 manager to allow process integration. C X
Shall provide business process integration based
PLAT14 on BPEL standards. C X
PLAT15 Shall provide adaptors required for integration. C X
Shall provide support for native web services that
provides easy exposure of application functions as
standards- based Web services that leverage the
reliable, scalable, and high- performance
PLAT16 infrastructure provided by the application server. C X
 Shall provide integrated in-built messaging to have
high-performance, reliable, and scalable
messaging for asynchronous processing in
PLAT17 distributed applications. C X
Shall provide database drivers tested for all
PLAT18 leading relational databases. C X
Shall provide rules engine based on real-world
conditions that facilitate flexible and powerful
PLAT19 securityprovide
Should policies.a messaging bridge to provide C X
built-in interoperability with other messaging
PLAT20 products. C X
Should provide pluggable security framework like
Open Service Provider Interface that allows
extension of application server security by
leveraging existing security solutions, developing
custom security service providers, or using off-the-
PLAT21 shelf third- pa C X

Should provide the feature of

connection pooling to allow reuse of
different types of connections required
to establish communications with
clients to databases, application
PLAT22 adaptors, and message factories. C X
Should support interoperability with external
security products for easy integration with external
security products that allows using the full scope of
security functionality available from best-of-breed
PLAT23 third- party security products C X
Shall have minimum patch releases and with the
PLAT24 facility of auto update of patches. D X
Shall provide support for two phase deployment to
ensure reliable and error-free roll out of
PLAT25 applications in large production environments. C X
Should support fail over to ensure no service
PLAT26 interruption in mission critical applications. C X
PLAT27 Should support enterprise wide clustering. C X
PLAT28 Should support MAN /WAN clustering C X
Should provide support for Load balancing for Web
tier, business components messaging factories
and destinations, database connections, and the
others for better load handling, scalability, and
PLAT29 higher quality of service. C X
Should support LDAP compliant directory server
PLAT30 for identity management services. C X
PLAT31 Should support in built load balancing features. C X
Should support hardware and software load
PLAT32 balancing
Should features.
provide support for SNMP, which is a C X
Standard protocol for network management and
PLAT33 monitoring. C X
Should provide Web-based console for intuitive
PLAT34 Web-based management features. C X
PLAT35 Should be certified for J2EE 1.4/1.5. or equivalent. C X
Should have the best performance as per SPECj
PLAT36 Application server results. N X
Shall provide the interoperability
matrix between Servers/storage/SAN
fabric /OS/Database/Third party File
PLAT37 systems) X
Shall submit the details of supported hardware for
the quoted middleware and the same shall be
PLAT38 available on a publicly accessed website. C X

Data Warehouse
Should support various table joins such as inner,
outer, left, right, full. Joins can be run in parallel
PLAT69 and can use indexes. C
PLAT70 Should support Star Schema optimization. C
Should support Parallel Aggregation management
PLAT71 for optimization. C
Should provide partitioning capabilities for its data /
tables across multiple storage devices and I/O
Channels. Provide Partitioning capabilities by size
PLAT72 or by overflow. C
Should provide bitmap Indexing and B-Tree
Indexing capability and also dynamically adapt to
PLAT73 the cardinality and distribution of the data. C

Should segment the indexes to support parallel

processing and provide superior performance for a
PLAT75 number of processes, including join optimization. C
Should provide complete integration with the meta
PLAT76 data repository management system and ETL C
Should have GUI based Cube builder and Cube
PLAT77 Exploration Clients C
PLAT78 Should have locking capability with tables C
Should have query optimization capability to
PLAT79 improve performance C
PLAT80 Should have
Should support parallel
backup query
utility for executions
real incremental C
backup, periodical full backup and restore
capabilities. It should also support automated
PLAT81 incremental backup. C
Should provide Automatic Aging rollout for
maintaining rolling window of data (last 5 years,
last 12 months, last 30 days) in a data warehouse,
etc for removing & loading the time based units of
data from the data warehouse table which would
PLAT82 ensures that C
Should support open data access from all client
types across the enterprise with support of industry
standards - OLE DB for OLAP, MDX, ODBC, and
PLAT83 JDBC. C
PLAT84 Should be able to run in clusters C
Should support cubes in relational storage
(ROLAP), multidimensional storage (MOLAP) and
HOLAP and support the support the OLAP OLE
PLAT85 DB for OLAP (ODBO) standard. C
Should be able to spread the OLAP data sources
across multiple file
Should provide caching facility for the OLAP server
PLAT87 that stores frequently accessed cubes in memory. C
System administrators should be able to measure
application performance to fine tune cache sizes
and cube structures according to the usage
PLAT88 patterns of an OLAP data source. C
For monitoring activity and performance, it should
be able to integrate with monitoring and load
PLAT89 testing tools for application response management C

Operating Systems
PLAT90 Should be a 64-bit architecture C
PLAT91 Should support hotswappable addition of memory C
PLAT92 Should support Multicore Processors. C
PLAT93 Should support IPv6. D
Should support IPSEC enhancements for better
PLAT94 security and Performance. C
PLAT95 Should support 32 way/ 64way multiprocessing. C
Should support very High scalability in terms of
PLAT96 processing capacity and Physical memory. C
PLAT97 Should support Non - uniform memory access C
PLAT98 management. C
PLAT99 Should support IP Masquerading. C
PLAT100 Should support server and storage virtualization. C
PLAT101 Performance. C
Should support High Performance File systems,
PLAT102 which enables concurrent file access. C
PLAT103 Should support Network Load C end of 210

Should support Networking and interoperability

with Heterogeneous servers, storage, Operating
PLAT105 systems, Database and third party tools. C
Should support easy integration of Directory
PLAT106 Servers like RHDS/Open LDAP/ADS. C
PLAT107 Should support enhanced application availability. C
Should support volume snapshots / Point in time
PLAT108 copies. C
Should support online resizing of storage pools
PLAT109 and data relocation. C
Should have built in real-time application
PLAT110 debugging and optimization capabilities. C
Should support Remote management facility and
PLAT111 trouble shooting capabilities. C
 Shall provide highly scalable and flexible security
PLAT112 capabilities. C
Should support easy integration with the
messaging systems in the application software for
PLAT113 alert notifications to predefined group of users. C
Shall submit the details of certified hardware for
the quoted operating system and the same shall
PLAT114 be available on a publicly accessed website. C
Shall provide the interoperability matrix between
Servers/storage/SAN fabric/OS/Database/Third
PLAT115 party File systems). C
PLAT115 Shall provide the interoperability C
matrix between Servers/storage/SAN
PLAT115 fabric/OS/Database/Third party File systems). C

38 38 0 0
100
NS Remarks
end of 205
 ID Functional Requirements Priority SUP MOD CST NS
(C/D/N)
PLAT39 Should be an Enterprise class C X
Database with the ability to
support connection pooling,
Load sharing and Load
balancing when the load on the
application increases.

PLAT40 Should provide Non-Escalating C X

rowlevel locking and multi
version read consistency. As
part of "Amendment of RFP for
EASI" - Should provide non-
escalating row-level locking and
multi version read consistency
(MVRC) OR ANSI.
PLAT41 Should support for Database C X
Clustering of more than 16
Number of clusters that can be
PLAT42 configured.
Should support Active - Active C X
cluster and cluster must be
horizontally scalable.

PLAT43 Database clustering should not D X

depend on any third party
clusterware or transaction
routing engines or physically
altering schemas or objects. As
part of "Answered Pre-Bid
Queries.pdf"/Amendment - NIC
requires both OS and DB level
clustering on HA for specific
applications like Core, F&A,
HRMS, CRM, DMS and MDM
and metadata management.

PLAT44 Should support Data C X

Partitioning, which enables
manageability of large data
tables and indexes.
PLAT45 Shall include tools for enterprise C X
class High Availability Solution
like monitoring performance,
diagnose and alert for problems,
tuning bottlenecks, resource
monitoring and automatic
resource allocation capabilities.

PLAT46 Shall provide enterprise class C X

web management tools for
management and maintenance
of databases even from remote
places.

PLAT47 Support for central storage of C X

data with multiple instances of
Database in a clustered
environment access the single
database.
PLAT48 Shall efficiently control large C X
number of concurrent users.

PLAT49 Should support online indexing C X

operations.

PLAT50 Should provide highly flexible C X

Data management features for
storing huge volumes of data for
improved performance
PLAT51 Shall be able to handle various C X
types of indexes of large data.

PLAT52 Should support in a fully C X

automated Disaster Recovery
with seamless switch over
between primary and DR site.

PLAT53 Should support High C X

Performance File Systems
PLAT54 Should support parallel C X
processing of transaction to
achieve greater performance.
Should provide parallelism for
Queries and Insert, Update and
Delete operations.

PLAT55 The Database Architecture C X

should have the facility to
increase the number of
concurrent instances to keep the
database server parameters
(CPU, Memory, Hard disk, etc.)
low.
PLAT56 Should be consistent and work C X
seamlessly across all platforms
and operating systems like Unix,
Windows, and Linux. The quoted
database should be
commercially available at the
time of quoting this RFP.

PLAT57 Should support plug and play C X

data transfer across platforms or
operating systems.

PLAT58 Should support storing of Texts, C X

Images, Multi-media content
within database.

PLAT59 Shall provide support for C X

deploying fine-grained access
control for segregation duties
and native encryption
capabilities.
 deploying fine-grained access
control for segregation duties
and native encryption
capabilities.

PLAT60 Shall provide a centralized audit C X

repository for all databases
implemented in the EASI. As
part of "Answered Pre-Bid
Queries.pdf"/Amendment -
Question: SI requests
elaboration on this requirement.
Is this about database auditing
or a separate application for
auditing ? Answer: X Database
auditing and no
separate application is required.

PLAT61 Shall provide the interoperability C X

matrix between
Servers/storage/SAN fabric
/OS/Database/Third party File
systems.
PLAT62 Should support in a fully C X
automated Disaster Recovery
with seamless switch over
between primary and DR site

PLAT63 As a part of the Database C X

solution, diagnostic, tuning,
configuration and change
management packs should be
provided and should be from the
same OEM as the database

PLAT64 Should have features to abstract D X

data from DBA's.

PLAT65 The diagnostic pack as C X

mentioned in point 25 should
provide with self diagnostic
engine and guided problem
resolution engine

PLAT66 The database solution should C X

provide unique, automatic and
deterministic SQL tuning
functionality
PLAT67 Shall provide support for C X
deploying fine-grained access
control for segregation duties
and native encryption
capabilities

PLAT68 As a scalability proof point, the C X

database should have minimum
1 million tpc-c benchmarks on
various hardware rchitectures.
Should have 3 rd party
documented Terabyte database
deployment sites in India.

30 30 0 0 0
100
 Remarks

Oracle Database 11g Enterprise Edition has a built-in

feature called Database Resident Connection Pool is
an ideal solution for efficiently handling a large number
(in the order of tens of thousands) of connections to
Oracle database from clients distributed over multiple
processes on multiple hosts. (Document attached)

Load sharing and balancing is a implicit feature of Real

Application Cluster (RAC) an option of Database. The
total load of the application on the database gets
shared/balanced across multiple instance of a single
database, each instance running on a separate server.
Oracle Database 11g Enterprise Edition supports
shared and exclusive locks for all DMLs and DDLs.
Locks are automatically released after a DDL is
executed or after a commit/rollback of a transaction.
The background process PMON also automatically
releases the locks on data that was acquired by a
session that has been terminated, without any
escalation.

Oracle Database 11g Enterprise Edition also support

multiversion read consistency as explained below:
The ANSI/ISO SQL standard defines four levels of
transaction isolation, with different possible outcomes
for the same transaction scenario. These levels are
defined in terms of three phenomena that are either
permitted or not at a given isolation level:
- Dirty read
- Nonrepeatable read
- Phantom read
Note that the ANSI/ISO SQL standard defines
transaction-level characteristics, not just individual
statement-by-statement-level characteristics.
Oracle Database explicitly supports the READ
COMMITTED and SERIALIZABLE isolation levels as
they're defined in the standard.
Moreover, Oracle Database also supports the spirit of
READ UNCOMMITTED. The goal of providing a dirty
read is to supply a nonblocking read, whereby queries
are not blocked by, and do not block, updates of the
same data. However, Oracle Database doesn't need
dirty reads to achieve this goal, nor does it support
them. Dirty reads are an implementation other
databases must use to provide nonblocking reads.
In addition to the four defined SQL isolation levels,
Oracle Database provides another level: READ ONLY.
A READ ONLY transaction is equivalent to a
REPEATABLE READ or SERIALIZABLE transaction
that cannot perform any modifications in SQL. A
transaction using a READ ONLY isolation level sees
only those changes that were committed at the time
the transaction began. Inserts, updates, and deletes
aren't permitted in this mode (other sessions may
update data, but not the READ ONLY transaction).
Using this mode, you can achieve REPEATABLE
READ and SERIALIZABLE levels of isolation.

Oracle Database 11g Enterprise Edition support

database clustering with scaling capability upto 128
nodes with Real Application Cluster (RAC), an option
of Database.
Oracle Database 11g Enterprise Edition provide High
Availability with Real Application Cluster (RAC) an
option of Database, which is a true Active-Active
cluster supporting grid computing, on-demand
capacity, load balancing, work-load management,
scaling the hardware infrastructure/horizontal scalable,
rolling patch upgrades etc.

Oracle Database 11g Enterprise Edition doesn’t

require any third-party/OS clusterware as Oracle Real
Application Cluster (RAC), an option of Database has
its own built-in clusterware called Cluster Ready
Services (CRS). Further, Oracle CRS can also be
configured to protect non-Oracle resources like
applications & file systems by relocating such
resources to surviving nodes.

However, Oracle Database 11g Enterprise Edition and

Real Application Cluster (RAC) can also work with
OS/Third-party clusterware like HACMP, HP Service
Guard, Sun Cluster, Windows Cluster Service and
Veritas Cluster.

Oracle Database 11g Enterprise Edition supports

Table and Index Partitioning that ensures availability,
linear scalability and manageability for VLDBs.
Partitioning is an Option of Database, which does
divide and conquer. It is transparent to an application
i.e. completely independent and can be defined
anytime after the design and deployment of the
database server without changing the application.
Partitioning Tables can be of different types like
Range, List, Hash, Composite, Interval, REF
(Reference) and Virtual Column Based, this gives very
high flexibility during implementation.
Oracle Database 11g Enterprise Edition has a built-in
GUI tool called Oracle Enterprise Manager (OEM) –
Grid/Database Control to manage and monitor with
alerts for enterprise level High Availability solutions like
Real Application Cluster (RAC), Data Guard, Streams
etc. With Oracle Diagnostic and Tuning Pack
integrated with OEM Grid control it can automatically
diagnose and alert performance problems, tuning
bottlenecks, resource monitoring and automatic
resource allocation capabilities.

Oracle Diagnostic and Tuning Pack uses features like

ADDM, AWR and ASH to proactively identify
performance bottelnecks and resolves the same
implicitly with SQL Advisor (create SQL profile and
tuning sets) and Access Advisor (create right kind of
indexes and materialized views).

Oracle Database 11g Enterprise Edition bundles an

Enterprise Management tool called Oracle Enterprise
Manager (OEM) – Grid Control which can manage,
maintain and monitor multiple databases in an
enterprise from a single window of a browser. OEM –
Grid Control is a web based tool, which can be
accessed from any node of intranet through a browser
as a thin client.
Oracle Database 11g Enterprise Edition supports
central storage for the database in a shared storage
with multiple instances of the same single database
running across multiple servers in a cluster. This is
enabled by Oracle Real Application Cluster (RAC) an
option of Database.
Oracle Database 11g Enterprise Edition supports large
number of concurrent user logins/ transactions in
thousands. As a proof point please refer to the "Winter
Corporation Report" (document attached) for top ten
Peak Loads showing the very high TPMC and
concurrency for Oracle Database.

Oracle Database 11g Enterprise Edition supports all

kind of index operations like creation, alteration,
deletion (drops), rebuilds, renames, defragmentation,
analyze (statistic collection) and relocation online. So it
avoids planned and unplanned downtimes, every thing
related to index could be performed online.

Oracle Database 11g Enterprise Edition supports many

featrues such as materialized views, several types of
data partititioning, parallelism, bitmap & function based
indexes etc. for flexible data management of large
volume of data to improve performance.

To improve better query performance Oracle has

enhanced the follwoing areas:
Full Table Scan
Large Number of Partitions
 Optimizer CPU Cost Model
Auto-Statistics
Parallel Single Cursor
Memory Reduction
Partition Aware MV Refresh
Dynamic Memory Tuning
Partition Outer Join
Native Numbers
ASM for I/O tuning
Resource Management
Stored Outlines
SQL Profile and Tuning Sets
Data Type and Storage etc.
Oracle Database 11g Enterprise Edition supports
various types of indexes like B-Tree, Bitmap,
Composite, Unique Key, Reverse Key, Function Based
and Bitmap Join Indexes. In case of large data, these
Indexes help to perform effective scanning of data in
various business situations.

Oracle Database 11g Enterprise Edition can provide

high availability with its; Data Guard built-in feature to
ensure disaster recovery. With the configuration of
Data Gaurd the transaction log is automatically
transported to multiple DR sites and are applied to the
DR database to synchronize the database with the
primary. On an event of a failure of the primary
server/database it automatically fails over to the
secondary (DR) server/database. This secondary
database can also be started in Read-only mode and
DSS & MIS load can be devoted to this site, this will
balance OLTP at primary and DSS & MIS at
secondary. On-line Backups can also be taken from
this secondary (DR) site to remove performance
hindrance at primary site.
Oracle Database 11g Enterprise Edition has it's built-in
high peroformance file system and volume manager
called Automatic Storage Management (ASM). ASM
provides DBAs a simplified management interface for
storage resources. ASM eliminates the need for
manual I/O performance tuning. It virtualizes
management of database storage to a set of disk
groups and provides redundancy options to enable a
high level of protection. ASM facilitates non-intrusive
storage allocation and provides automatic rebalancing.
It spreads database files across all available storage to
optimize performance and resource utilization. It is a
capability that saves DBAs time by automating manual
tasks and thereby increasing their ability to manage
larger databases and more of them with improved
efficiency.
Oracle Database 11g Enterprise Edition also works
with all leading file systems from OS and Third-parties
with high performance of I/O.
Oracle Database 11g Enterprise Edition, fully support
parallelism. For each query, insert, update and delete
operation a separate degree of parallelism hint can be
provided. A separate slave process is started
automatically for each degree of parallelism. In Real
Application Cluster (RAC) an option of database, it can
be configured in such a way that each of the processes
of a query can runs on a separate server of the cluster.

Oracle Database 11g Enterprise Edition can be scaled

horizontally with multiple instances of a single
database across multiple servers with the help of Real
Application Cluster (RAC) an option of Database, there
by keeping the CPU, Memory Hard Disk low in each
server. Additional servers can added to the setup
without any down time.
Oracle Database 11g Enterprise Edition is available on
multiple operating systems like Windows, Linux and
different flavors of UNIX like HP-UX, AIX, Sun Solaris
etc. All features of Oracle Database remain same
across the platforms mentioned. It is commercially
available now for deployment.

Data Pump a built-in feature of Oracle Database 11g

Enterprise Edition allows data transfer across
hetrogeneous platform or operating systems. Data can
be transfer as plug and play from one database to
another by transporting tablespaces from one to
another database in an hetrogeneous environment
with this feature.
Oracle Database 11g Enterprise Edition have the
capability to store and retrieve various data types like
text, images, audio, video, spatial (for GIS), time series
and finger prints as data structures and datasets within
the database.
Oracle InterMedia is a general-purpose feature that
enables the efficient management, & retrieval of image,
audio, and video data. It is compatible with all popular
multimedia formats and can automate metadata
extraction and basic image processing. It increases
programmer’s productivity when developing multimedia
applications using JSPs, Servlets, and PL/SQL or
when using tools such as JDeveloper (ADF/UIX) and
Oracle Portal.
Virtual Private Database a built-in fuctionality of Oracle
Database 11g Enterprise Edition provides an ideal
solution for fine-grained access control and row level
security to protect private or sensitive information. It
allows data of varying sensitivities to be stored in a
single database and access to the data to be restricted
using security clearances.
Oracle Database 11g Enterprise Edition also have
native encryption capabilities with the DBMS_CRYPTO
package. Encryption and dencryption is allowed by an
application, which helps to protect sensitive data such
as credit card numbers etc. in the event of media theft.
Key management, one of the most important issues in
encryption projects, can be programatically defined
according to the security policy. Oracle allows storage
of keys in database tables as well as operating system
files, or users can manage their own keys.

Oracle Database 11g Enterprise Edition also have a

database option called Oracle Database Vault which
provides strong internal controls for regulatory
compliance and protection against insider threats. It
prevents highly privileged DBA users from viewing
sensitive application data, it also enforces policies on
who, when, where and how applications, databases
and data can be accessed and enables separation of
duties. Oracle Database Vault transparently protects
database applications without requiring any changes to
the existing application. This can be used if the
business demands it.

Oracle Database 11g Enterprise Edition provides

centralized audit repository as an audit warehouse for
all the database in the enterprise, satisfying
compliance regulations and mitigating the risks
associated with the insider threat. Oracle Audit Vault
an option of the database automats the collection and
consolidation of audit data. It provides a secure and
highly scalable audit warehouse, enabling simplified
reporting, analysis, and threat detection on audit data.
In addition, database audit settings are centrally
managed and monitored from within Audit Vault,
reducing IT security cost.

Oracle Database 11g Enterprise Edition provides

interoperability between various combinations/matrix of
servers platforms, storage/SAN fabric and
OS/Database/Third-party file systems. Document
attached for reference.
Oracle Database 11g Enterprise Edition can provide
high availability with its; Data Guard built-in feature to
ensure disaster recovery. With the configuration of
Data Gaurd the transaction log is automatically
transported to multiple DR sites and are applied to the
DR database to synchronize the database with the
primary. On an event of a failure of the primary
server/database it automatically fails over to the
secondary (DR) server/database. This secondary
database can also be started in Read-only mode and
DSS & MIS load can be devoted to this site, this will
balance OLTP at primary and DSS & MIS at
secondary. On-line Backups can also be taken from
this secondary (DR) site to remove performance
hindrance at primary site.
Oracle Database 11g Enterprise Edition has add on
packs like –
Oracle Diagnostic Pack to proactively diagnose
performance bottelneck/issues
Oracle Tuning Pack to implicitly tune database
perormance isuues
Oracle Configuration Management Pack to manage
the enterprise hardware/software configuration
interms of policies and SLAs, and
Oracle Change Management to track and compare
Metadata versions/changes for the database

Datasheet for the above are attached.

Oracle Database 11g Enterprise Edition has a built-in
GUI tool called Database Control which collect holistic
information about the database and can provide
concrete system information that helps in decision
making for DBA's thereby ease database management
and monitoring.
As already mentioned above Diagnostic Pack of Oracle
Database 11g Enterprise Edition integrated with Oracle
Enterprise Manager that provides automated database
analysis and self-diagnostic engine and guided
problem resolution engine with the help of Automatic
Database Diagnostic Monitoring (ADDM), Automatic
Workload Repository (AWR) and Automatic Session
History (ASH).
Oracle Database 11g Enterprise Edition supports
automated tuning mechanisms. Dynamic memory
allocation features of Oracle make it possible to create
a self-tuning Oracle SGA i.e. Oracle memory.
Automatic Storage Management (ASM) makes I/O
tuning completely automatic. Diagnostic and Tuning
Pack features as explained above makes Application
Tuning and SQL Tuning completely deterministic and
automatic, it can find where the problem is and fix it
implicitly.
Virtual Private Database a built-in fuctionality of Oracle
Database 11g Enterprise Edition provides an ideal
solution for fine-grained access control and row level
security to protect private or sensitive information. It
allows data of varying sensitivities to be stored in a
single database and access to the data to be restricted
using security clearances.

Oracle Database 11g Enterprise Edition also have

native encryption capabilities with the DBMS_CRYPTO
package. Encryption and dencryption is allowed by an
application, which helps to protect sensitive data such
as credit card numbers etc. in the event of media theft.
Key management, one of the most important issues in
encryption projects, can be programatically defined
according to the security policy. Oracle allows storage
of keys in database tables as well as operating system
files, or users can manage their own keys.

Oracle Database 11g Enterprise Edition also have a

database option called Oracle Database Vault which
provides strong internal controls for regulatory
compliance and protection against insider threats. It
prevents highly privileged DBA users from viewing
sensitive application data, it also enforces policies on
who, when, where and how applications, databases
and data can be accessed and enables separation of
duties. Oracle Database Vault transparently protects
database applications without requiring any changes to
the existing application. This can be used if the
business demands it.
Oracle Database 11g Enterprise Edition has more than
1 million TPC-C benchmark on various platforms like
HP-UX (Itanium), IBM AIX (P5), Linux (Intel X86,
Itanium) – giving the proof point that Oracle database
scales and performs across various platforms, with a
choice of operating system to selected by the
customer.
Oracle is leading the TPMC benchmark of 4.092 million
TPMC and is the only database having clustereded
and non-clustered benchmark results.
Winter Corporation a third part analyst in his Top Ten
Ranking of very large database installations has
documented Indian sites like “Reliance Infocom” who
have 11+ Terabytes of data in Oracle Database. Other
sites like Tata Tele Services, Hutchison Telecom India
and ICICI Bank Limited has also been document for
high peak loads, whose database is also in terabytes.
Document attached for reference.
 Product
Should Features
support various table joins such as inner, outer, Priority (C/D/N) SUP
left, right, full.Joins can be run in parallel and can use
PLAT69 indexes. C X
PLAT70 Should support Star Schema optimization. C X
Should support Parallel Aggregation management for
PLAT71 optimization.
Should provide partitioning capabilities for its data / C X
tables across multiple storage devices and I/O
Channels. Provide Partitioning capabilities by size or by
PLAT72 overflow. C X
Should provide bitmap Indexing and B-Tree Indexing
capability and also dynamically adapt to the cardinality
PLAT73 and distribution of the data. C X

Should store Metadata related to indexes separately

from the indexes themselves minimizing the index I/O
and enables parallel processing during index scans,
PLAT74 index builds and append (refresh) performance. C X
Should segment the indexes to support parallel
processing and provide superior performance for a
PLAT75 number of processes, including join optimization. C X
Should provide complete integration with the meta data
PLAT76 repository management system and ETL C X
Should have GUI based Cube builder and Cube
PLAT77 Exploration Clients C X
PLAT78 Should have locking capability with tables C X
Should have query optimization capability to improve
PLAT79 performance C X
PLAT80 Should support parallel query executions C X
Should have backup utility for real incremental backup,
periodical full backup and restore capabilities. It should
PLAT81 also support automated incremental backup. C X
Should provide Automatic Aging rollout for maintaining
rolling window of data (last 5 years, last 12 months,last
30 days) in a data warehouse, etc for removing &
loading the time based units of data from the data
warehouse table which would ensures that the right
amount of data is available to the intelligence
PLAT82 applications relying upon it. C X
Should support open data access from all client types
across the enterprise with support of industry standards
PLAT83 - OLE DB for OLAP, MDX,ODBC, and JDBC. C X
PLAT84 Should support
Should be able to run in
cubes in clusters
relational storage (ROLAP), C X
multidimensional storage (MOLAP) and HOLAP and
support the support the OLAP OLE DB for OLAP
PLAT85 (ODBO) standard. C X
Should be able to spread the OLAP data sources across
multiple file systems, enabling the multithreaded query
engine to execute multiple queries in parallel by reading
PLAT86 data from multiple locations at once. C X
Should provide caching facility for the OLAP server that
PLAT87 stores frequently accessed cubes in memory. C X
System administrators should be able to measure
application performance to fine tune cache sizes and
cube structures according to the usage patterns of an
PLAT88 OLAP data source. C X
 For monitoring activity and performance, it should be
able to integrate with monitoring and load testing tools
PLAT89 for application response management C X

21 21
100
MOD CST NS Remarks
ID Functional Requirements - CORE Insurance Priority SUP MOD CST
(C/D/N)
ETL
General Requirements
Should be able to seamlessly access native
interface to ORACLE, SQL Server, DB2 and have
specific data access application to access various
ETL1 application platforms C X

Should provide native access interface to PC Files

ETL2 – MS Excel, Flat Files, DBF, Foxpro, Open Office C X

Should be rich in the set of in-built transformations

and functions. The tool should provide in-built
transformation functions including slowly changing
ETL3 dimensions - type II. C X
Should be able to operate in real time, capturing
messages or extracting data at a moment’s notice
on the same platform that also integrates bulk
ETL4 data. C X

Should support targets which are normalized or

de-normalized. The tool should provide specific
functionality to support either of these two design
ETL5 approaches. C X

Should provide for automated slowly changing

ETL6 dimension for type II C X

Should provide for reuse of individual

ETL7 transformations. C X

ETL8 Should support for surrogate key generation. C X

Should provide for creation of user- defined

ETL9 external transformation functions. C X
 Should provide graphical user interface for
mapping transformation for versatile scripting
language, powerful debugging capabilities, and an
ETL10 open application programming interface (API) C X

Should be able to map and transform among

ETL11 convertible data types C X

Should be able to automatically transform based

ETL12 on functions and scripts C X

Should be also able to provide manual X

Should have the ability to generate extraction error
logs giving the Error No, Error Details and Type of
ETL15 Error C X

ETL16 Should have common logging. C X

Should have feature for error resolution tools with

techniques like: 1. Data consistency checks 2.
Data transformation (e.g. format change) 3. Data
ETL17 redundancy checks 4. Data Cleansing C X

Should provide metadata reporting across ETL

ETL18 jobs, RDBMS and reporting tools. C X

ETL19 Should provide batch and job reports C X

 Should be able to load the cleansed data to target
ETL20 data mart C X

Should have reporting of the results of an ETL

session, including automatic notification of
ETL21 significant failures of the ETL process C X
Should be able to populate ETL reports and push
ETL22 data to the dashboards. C X

Should have the ability to schedule ETL sessions

based on time or the occurrence of a specified
event, including support for command-line
ETL23 scheduling using external scheduling programs C X

Should support more than 5TB data source without

significantly degrading performance or requiring
ETL24 awkward database or platform swaps C X
Should provide multi threading of processes and
ETL25 parrallel execution of jobs C X

Real Time Integration and Federated Access C X

ETL26 Should be SOA based C X

Should provide GUI based interface to create,

ETL27 develop and deploy web services application C X
 Should provide interface to directly select any ETL
ETL28 job and deploy it as a web service C X

Should have the capability to disable a business

ETL29 rule validation
ETL30

Should support using ETL jobs, ETL31 database

ETL31 table, SQL as a service. C X

Should have the capability to make a ETL32

heterogeneous join between Oracle, N SQL
ETL32 server, DB2 databases. X

Should provide native connecters with file

systems, RDBMS, Microsoft Excel, ETL33 Access,
DB4 and Open standards C spread sheets through
ETL33 securedbe
Should environment
able to maintain data integrity ETL34 X
when data integration is happening C through
ETL34 backend X

32 32
100
NS Remarks

ODI provides a huge set of adapters

out-of-the-box for integrating
databases, technologies and
applications.
ODI provides access adapters to all the
PC files mentioned. For more specific
technologies, custom Knowledge
Modules can be built and used.
ODI provides access to existing
functions/stored procedures created in
the existing database/application which
can be reused. Slowly Changing
Dimensions are supported out-of-the
box for all major databases. Also user-
defined Technology-specific functions
can be created.
ODI supports several different
triggering mechanisms based on Files,
Queues, Databases etc. ODI also
supports batch processing using inbuilt
job schedulers.
Oracle Data Integrator does not
depend on whether the target is
normalized or de-normalized. Its is
based on the tables which are
normalized or denormalized depending
on
Thisthe schema requirement
functionality is supported out of
the box with ODI for all major
databases in the form of Knowledge
Modules.

Transformation Interfaces can be

duplicated and reused with minimum
configuration changes. Also changes
made to data models get reflected in all
interfaces using them. Thus reuse of
the data model and reuse of individual
tranformations is easy with ODI. This is
because of ODI's Repository based
architecture.
This is supported out-of-the-box in the
Slowly changing Dimensions
functionality.

Has great support for creation of user-

defined external transformation
functions in user-desired technologies.
The same function can be created
using multiple technologies and while
using the functions, the appropriate
technology can be selected.
ODI provides a GUI for mapping
transformation for versatile scripting
language and an Open API. ODI
debugging is not out of the box and
requires manual coding/analysis of
logs.
ODI provides conversion functions for
converting datatypes. ODI supports
usage of the target/source RDBMS
conversion functions too for data type
conversion.
ODI scenarios/jobs can be triggered
from Java code, command line, batch
scripts, http url, as a webservice etc.
ODI Scenarios/jobs can also be
triggered manually from the Command
Line, ODI Designer module and ODI
OperatorERROR
Detailed Module. logging is provided
using the Operator module. Log levels
can be set to reduce or increase Log
detail.
Common Logging is provided in the
ODI Operator module. Logging for all
executions is visible from this console.
ODI provides reasonable data
consistency checks like primary key,
alternative keys, foreign keys,
conditional checks etc. ODI supports
quarantining of Error records to Error
Tables and also automatic recycling of
the Error Records.

ODI Data Profiling and ODI Data

Quality are advanced tools which are
integrated add-ons for ODI. ODI Data
profiling is used for detailed Data
profiling and ODI Data Quality uses the
Profiling results to generate Data
Quality Projects which can be
embedded in ODI Work Flows. This is
one of the strong features of ODI.
ODI has a repository based approach
in which the Metadata of the systems
being integrated is maintained in the
repository. A web based tool named
Metadata Navigator is provided with
ODI which can provide web access to
Metadata. It also provides advanced
Data Lineage features using which data
can be traced from target to source.
ODI Designer and ODI Topology
Manager also support prebuilt PDF
Report generation for objects created in
them.
ODI Operator module supports batch
and job execution reports with details of
each step in the job.
Supported.
ODI Work flows can be designed to
send EMAIL notifications in case of
failures. Also the ODI Operator gives a
detailed view into the result of an ETL
session and can be configured to give
detailed information about each step of
the ETL session. These sessions can
be viewed through the Metadata
Navigator too.
This will require some custom coding to
be done.
Both Time-based and Event-based
Triggering of ETL Sessions is
supported. Also command line
triggering of ETL Sessions for external
scheduling programs is supported.
ODI does not have an ETL engine of its
own. If the Source/Taget Database can
support these volumes, ODI will work
fine as it uses the existing database
capacities
Load for itsoftransformation.
balancing ODI Agents is
supported which allows parallel
execution of jobs.

The same can be easily achieved using

the scheduler and the different
knowledge modules

ODI is fully SOA compliant. There are

three main SOA use cases that are
supported ->
1. ODI can call webservices
2. ODI provides a web service (to be
deployed on a compatible Application
server) which takes the ETL job name
and agent as an input and triggers the
given job.This enables ETL jobs to be
triggered as web services.
3. ODI supports Data services using
which any data source configured
within ODI can also be hosted as a
Data Web Service.
ODI Web services can be created,
developed and deployed using ODI
GUI. The Application Server for hosting
the web service is not bundled with
ODI.
 ODI provides a web service (to be
deployed on a compatible Application
server) which takes the ETL job name
and agent as an input and triggers the
given job.This enables ETL jobs to be
triggered as web services
Assuming Business rules here refers to
Transformation mapping rules, these
can be easily switched ON or OFF from
the ODI Designer and redeployed.

ODI is fully SOA compliant. There are

three main SOA use cases that are
supported ->
1. ODI can call webservices
2. ODI provides a web service (to be
deployed on a compatible Application
server) which takes the ETL job name
and agent as an input and triggers the
given job.This enables ETL jobs to be
triggered as web services.
3. ODI supports Data services using
which any data source(database table,
file etc.) configured within ODI can also
be hosted as a Data Web Service.
ODI can make a join between multiple
Technology source tables. E.g. a file
can be joined with an Oracle table
which in turn can be joined with SQL
Server table.

Provides a large list of out-of-the box

connectors. ODI is extensible and in
case some standard is not supported,
custom support can be built for that
technology by creating Knowledge
Modules which can then be reused.
This will require custom Knowledge
Module creation.
ID Functional Requirements - CORE Insurance Priority SUP MOD
(C/D/N)
Master Data Management
General Requirements

MDM1 Should be SOA enabled service C X

MDM2 Should have automated Match and Merge process C X

MDM3 Should have business services to manage master C X

data which should be web enabled

MDM4 Should be a Multi-Form MDM capable of managing C

master data across multiple systems and styles
(collaborative, operational, and analytical)
MDM5 Should be very flexible in terms of future C X
modifications without any kind of effort required in
terms of drop and re-import.
MDM6 Should provide workflow based master data C X
management
MDM7 Should provide centralized master data management C X

MDM8 Should have maximum number of out-of-the box web C X

services, Data Stewardship capabilities, Duplicate
Suspect processing feature and de- duplication
feature and should be very easy to integrate.
MDM9 Should be integrated with application either through C X
services OR through federated access of database
connectors

MDM10 Should support batch upload of master data in files of C X

CSV, Excel, XML formats.

MDM11 Should maintain audit trail and change history C X

MDM12 Should support automatic harmonization / C X

synchronization of data with all systems

MDM13 Should support event based synchronization C X

MDM14 Should be capable of data syndication in real time or C X

batch
MDM15 Should support 24/7 availability with hardware high C X
availability platform

MDM16 Should provide online taxonomy editing to allow D

restructuring and refining existing taxonomy
MDM17 Should display errors in master data in a C X
comprehensive and striking format

MDM18 Should allow versioning of master records and C

version management
MDM19 Should be able to maintain date (effective date) C X
based active / inactive status

MDM20 Should maintain a mapping of master data and C X

metadata of master data in a centralized store

MDM21 Should maintain the parameterised and externalised C X

business rules in central rules repository that should
be managed by Master Data Management Service
MDM22 Should provide single source for truth C X
MDM23 Should be able to maintain version control of master C X
data, business rule and meta data and implement a
change control mechanism if change is originating
from MDM system

23 20 0
86.95652174 0
CST NS

X
X
 X

1 2
4.347826087 8.695652174
Remarks

Oracle offers flexible options for master data management - industry-proven

products for respective master data like customer, financials etc. and a build
approach comprising Oracle technology product components supported by
infrastructural services.
In this case, we would propose a build-way rather than a specific product
approach for MDM since no single type of master data meets the overall
requirement. Moreover, probability of containing a particular type of master data
(customers, policies, claims, employees, user-identities, financials etc.) within a
source/target system is considerably high based on industry best practice
guidelines, a build approach would be more suitable from flexibility,
interoperability and reusability persepctive.
Henceforth, we would use a combination of technology products (Oracle Data
Integrator and its components like Data Quality, Data Profiler and various
infrastructural services like SOA suite, relevant services from middleware and
database platform) alongwith some specific customisable efforts/service as our
MDM solution

Oracle Data Integrator (ODI) provides built-in native support for SOA. ODI
Scenarios can be called as webservices and also ODI workflows can make
webservice calls as part of the ODI workflow. ODI also provides features to
convert any data source into a Data Service.
Oracle Data Quality (ODQ) - a related component of ODI supports advanced
Match and Merge Features. Duplicate records are identified and
merged into a unique “best” record, and all duplicates are linked to it
ODI services could be exposed as webservices which could further be
used/extended as a MDM business service, built using Oracle's SOA platform
and exposed a web-enabled services in portal
ODI alongwith ODQ can extract master data from different types of sources filter
and synchronize using SOA-based services as core functionalities attached to a
specific type of master data
SOA approach of synchronization functions are inherently capable of flexible
modifications of MDM business services and relevant definitions, rules

ODI can expose and consume standard-based workflows defined in underlying

SOA platform
ODI provides an Operator Interface which can be used for monitoring and
scheduling of MDM loading jobs from a central console. Thus the loading of MDM
can be managed centrally.
ODQ supports advanced de-duplication features with match and merge. ODQ in
conjunction with ODP can serve as an excellent Data Stewardship tool. ODI
supports webservices out-of-the-box. Three modes of SOA integration are
supported - a. ODI can call webservices, b. ODI scenarios can be triggered as a
webservice c. Can convert any data source into a Data Web Service
ODI provides out of the box knowledge modules to integrate various technologies
and applications. For databases ODI provides native connection adapters which
are very easy to use. For more details about available KMs refer to-
http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/
htdocs/documentation/oracledi_km_reference.pdf
ODI supports SOA integration in the following three ways -
a. ODI can call webservices
b. ODI Scenarios can be triggered as a webservice
c. Can convert any data source into a Data Web Service.

ODI supports out of the box Knowledge modules for Excel, CSV and XML
formats. For more details please refer to -
http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/
htdocs/documentation/oracledi_km_reference.pdf
ODI supports audit trail and change log of ODI and processes with versioning. It
also provides features like Markers to assign to different objects to visually
display different phases of the project.
ODI can work in trigger mode. ODI has out-of -the-box trigger mechanisms for
waiting for files, data in database, message on MQ etc. Using these ODI features
automatic harmonization/synchronization of data can be achieved. ODI also
supports Change Data Capture (CDC) using which only the changed data needs
to be transferred, thereby reducing the bulk of the messages.
ODI can work in trigger/event-driven mode. ODI has out-of-the-box triggers for
waiting for files, data in database, message on MQ etc. Using these ODI features
event-based synchronization of data can be achieved.
ODI jobs can be scheduled or triggered on data events. Thus ODI supports both
modes of data syndication.
This MDM solution approach directly exploits the foundation of middleware and
database platform for high availability requirements as these infrastructural
services directly work with the underlying hardware platform

Oracle Data Profiling tool can be used to display errors in the Master Data.
Profiling data includes reverse-engineering metadata from various data stores,
detecting patterns in the data so that additional metadata can be inferred, and
comparing the actual data values to expected data values. Profiling provides an
initial baseline for understanding the ways in which actual data values in your
systems fail to conform to expectations. Advanced Oracle Data Quality ensures
that bad data is automatically detected and recycled before it is inserted in the
target applications.
Oracle Data Integrator offers standard data quality features, while more
advanced matching and de-duplication capabilities are available with Oracle Data
profiling capabilities which ensure that data assessment is not a one-time activity,
but an ongoing practice that ensures data quality over time.
ODI does not support versioning of MetadataModels. This has to be custom built

ODI provides Knowledge modules for implementing "Slowly changing

dimensions". This feature can be used automatically maintain date and
inactive/active status at a record level.
Metadata is mapped to the master data and are contained in the ODI repository
and is exposed to metadata navigator for web-based browsing. Metadata is also
reverse-engineered to eliminate old metadata with changing master data
Oracle Business Rules or any third-party Rules engine which supports web-
services can be used in conjunction with ODI to separate out and maintain the
business rules.
Supported. This whole MDM approach is aimed at arriving at a single source of
Please refer the response to MDM18
 Product Features PrioritX (C/D/N)
Metadata RepositorX Management

Should provide a Central Metadata RepositorX to manage

MMDQDM1 the flow and traceabilitX of data and structures C

MMDQDM2 Should provide Central Administration Capabilities C

Should provide centralized management of access control

MMDQDM3 policies of resource for multiple applications C
Should provide centralize management of librarX and
server definitions. Should be able to integrate with existing
configuration management database of Infrastructure
MMDQDM4 management Solution C
Should provide the abilitX to store Business Metadata and
MMDQDM5 Technical Metadata. C
 All AnalXtical tools should share a common service
oriented architecture, common data access services,
common analXtical and calculation infrastructure, common
metadata management service, common sXmantec
MMDQDM6 business model, common securitX model and common a C

Should provide change management of metadata and

MMDQDM7 processes and maintain versioning C

Should capture and generate operational data definitions,

MMDQDM8 business rules and maintain versioning C
Should capture and generate data models (e.g. ERD, Star
MMDQDM9 Schema etc) and maintain versioning C

MMDQDM10 Should be able to Import/export metadata with other tools C

MMDQDM11 Should provide features for Impact analXsis C

MMDQDM12 Should update taxonomX C

Should provide reports of
metadata changes and updates to the dashboards
MMDQDM13 C
MMDQDM14 Should provide audit trail C
Should support 24/7 availabilitX with high availabilitX
MMDQDM15 hardware
Should beplatform.
able to maintain version control of master data, C
business rule and meta data and implement a change
control mechanism if change is originating in Metadata
MMDQDM16 RepositorX C

Data QualitX
 Should provide intuitive Graphic User interfaces for Data
Profiling, Data Standardization, Clustering and Data
Augmentation capabilities. In Data Profiling it should be
able to conduct the following analXsis : • structure
MMDQDM17 discoveries, • frequencX distribu C

Support data qualitX measurement on an on-going basis

MMDQDM18 embedded into batch, near-time, and real- time process C
Should be able to share Metadata across the entire
process and provide an accurate trail of actions applied to
MMDQDM19 the cleansed data C
The Data QualitX tool should be integrated with the ETL
functionalitX with data qualitX rules callable through
MMDQDM20 message queues, web services and custom end points. C

Should support Indian names, CourtesX Titles, and

MMDQDM21 address parsing and cleansing with C
Should encompass – uniform data value representation,
correct mistakes in spelling, applXing autocorrect feature
(e.g.: Kolkata in all cases where it is Calcutta),
inconsistencies of Indian specific data, standardize data
MMDQDM22 values, parsing
Should be of data toand
customizable atomic
allow enhancement of its C
knowledge base bX constantlX updating metadata
MMDQDM23 repositorX C
 Should support data cleansing and de-duplication,
duplicate suspect processing, house holding, with arraX of
out-of-the- box standardization rules conform data to
corporate standards – or can build customized rules for
MMDQDM24 special situations. C

Should have business rules and GUI’s for automatic

MMDQDM25 merging and manual merging. C
MMDQDM26 Should have Indian specific vocabularX libraries C
MMDQDM27 Should have Indian specific grammar rule libraries C
MMDQDM28 Should have Indian specific phonetics libraries C

Should have Indian specific standardization rules and

MMDQDM29 libraries C
MMDQDM30 Should have Indian specific regular expression libraries C

Should have rules to identifX individuals and organization

MMDQDM31 from the names (customer data, agents, others) N
 Should have intelligent logic for Indian names, addresses,
phone numbers, pan numbers, passport number and other
MMDQDM32 identification proof documents and demographic details C

Should be able to provide Audit

Should be able to set customized rules to validate and
MMDQDM35 audit operational processes C
MMDQDM36 Should be able to log exceptions and violations C

Data Mining
Should have a graphical user interface supporting the data
mining process with a drag and drop features for building
MMDQDM37 data mining processes C

Should access data from multiple sources of data through

native connectors. • RDMS - Oracle, DB2, SXbase, SQL
Server • Non Relational Database – PC Files, MS
MMDQDM38 Excel/Access, Email,DB4, Flat Files, and open office C
Should be able integrated with business intelligence
MMDQDM39 platform
Should be with common
flexible metadata management
in dimensional framework that adapts to C
business changes and can scale up to an enterprise
MMDQDM40 solution. C
Should allow flexibilitX of writing code / macros / scripts for
MMDQDM41 manipulation of data bX advanced users. C
MMDQDM42 Should follow methods supported for sampling such as: C
a. Simple Random Sampling
b. Cluster sampling
c. SXstematic Sampling
d. Stratified Random Sampling
Should provide data partitioning node to allow partitioning
MMDQDM43 of the model data into Training,Validation and Test data C
MMDQDM44 Should allow creation of descriptive statistics. C
MMDQDM45 Should allow interactive exploration of data C
MMDQDM46 Should allow cluster analXsis and association analXsis C
 Should have Decision tree profile to determine cluster
MMDQDM47 membership C
Should provide techniques for dimension reduction and
MMDQDM48 increase. C
MMDQDM49 Should provide data replacement techniques C
Should support parametric statistical and machine learning
MMDQDM50 data mining algorithms C
Support predictive modeling techniques such as logistic
MMDQDM51 regression, neural networks, etc C
Should provide verX high degree of flexibilitX in setting
MMDQDM52 parameters for data mining algorithms C
Should provide flexibilitX in defining parameters to
influence the topologX of neural net and support standard
MMDQDM53 methods in neural networks C
Should provide multi-stage modeling, comparison and
MMDQDM54 combinations of different models C
MMDQDM55 Should allow graphical visualization of segments of data C
Should support statistical and stochastic analXsis such as
MMDQDM56 time series analXsis, moving average,etc C
Should provide interactive visual graphics for model results
MMDQDM57 interpretation and evaluation such as Lift Curves etc C
Should provide reports for Staff time spent
MMDQDM58 integrating/validating data vs. analXzing C
Should provide report for Poor data qualitX causing rate
MMDQDM59 refilings and/or statistical agent fines C

57
SUP MOD CST NS Remarks

The Oracle Data Integrator

Metadata Navigator web
application provides access to
repositorX metadata from anX web
browser. Users can browse the
entire repositorX metadata and
graphical views of the data flows.
With the Data Lineage feature,
theX can easilX track data to the
source items from which theX were
derived and subsequentlX
integrated bX Oracle Data
Integrator. The Metadata is stored
in the ODI repositorX and can be
modified using the ODI Designer
module.

X
The Oracle Data Integrator
Metadata Navigator web
application provides access to
repositorX metadata from anX web
browser. Users can browse the
entire repositorX metadata and
graphical views of the data flows.
With the Data Lineage feature,
theX can easilX track data to the
source items from which theX were
derived and subsequentlX
integrated bX Oracle Data
Integrator. The Metadata is stored
in the entral ODI repositorX and
can be modified using the ODI
Designer module bX anX
authorized user. Thus centralized
administration can be achieved.

X
ODI provides a securitX manager
utilitX using which user profiles can
be created to grant access to
different modules/projects in ODI.
This can be used for centralized
management of access control
X
policies.

Not supported
X
 Not supported

X
ODI provides versioning of ODI
Interfaces, packages and
X scenarios. Metadata versioning is
not
ODIsupported.
can be used to reverse
engineer metadata from
operational sources like files,
database tables etc. Business
X rules cannot be automaticallX
captured.
Not supported
X
ODI can reverse-engineer
metadata from operational sources
like files, Oracle database etc. It
can export the metadata models to
xml files. Import of metadata in
third-partX tools would be a custom
X
effort.
ODI Metadata navigator provides a
data lineage feature which can be
used to do Impact analXsis of
changes to metadata and loading
X processes.
Through the ODI metadata
navigator the taxonomX definations
can be incorporated within the
metadata. The same can be
X enhanced depending on the need
with the use of APIs
Some reports are available out-of-
box and other reports can be
X easilX developed using APIs
X Available out-of-box

X
ODI does not support versioning of
metadata models.
X
 Oracle Data Profiling and Oracle
Data QualitX for Data Integrator
provide a single data qualitX
management interface from which
Xou can evaluate and manage the
data assets and operations critical
to Xour business. When integrated
with Xour business strategX for
data governance, the Oracle Data
QualitX products allow Xou to
monitor and improve data qualitX
throughout Xour enterprise,
regardless of where it is located,
and track Xour data qualitX
improvements over time.
X
The Time Series feature set is
delivered as part of Oracle Data
Profiling. Time Series is a
monitoring application that lets Xou
evaluate and monitor changes to
Xour data over a period of time. It
utilizes the Profiling data analXsis
features and compares snapshots
of Xour data over successive
inquiries. Time Series Projects
enable Xou to see trends in Xour
data usage and identifX anomalies,
as well as areas for improvement.
When Xou create a Time Series
Project, Xou identifX the Entities
Xou want to track and set the
parameters for monitoring changes
within these Entities.
X

Oracle Data QualitX projects can

be called as a step from the Oracle
X Data Integrator Package.
India falls under the categorX of
countries with well developed
parser rule and pattern files but NO
reference postal files.
Parser rule and pattern files correct
and recognize citX names,
common names/businesses,
misspellings and manX other best
practices that Trillium has built into
the product.
X
Not supported

X
Not supported
X
 Oracle Data QualitX for Data
Integrator is a total data qualitX
and governance product that gives
Xou a powerful tool set for
repairing and correcting fields,
values and records across multiple
business contexts and
applications. ODQ supports
duplicate suspect processing and
lots of other standardization
processes. More details are
available at -
http://www.oracle.com/
technologX/products/oracle-data-
ODQ Identifies the relationship
between rows in a file at the
business and consumer level. It
performs these functions:
■Identifies whether duplicate rows
exist in several files.
■Uses comparison routines to
determine the level of similaritX
between rows. Results are
categorized as Pass, Suspect, or
Fail, depending on the similaritX of
data elements.
■Uses window keXs to match
rows, and attempts to match rows
in the same window keX set.

ODQ constructs window keX from

the elements of input fields. For
example, a window keX might use
the first character of a business
name and first five characters from
a postal code field.

X Not supported
X Not supported
X Not supported
ODI Parser rule and pattern files
correct and recognize citX names,
common names/businesses,
misspellings and manX other best
practices that Trillium has built into
the product.
X
X Not supported
ODI Parser rule and pattern files
correct and recognize citX names,
common names/businesses,
misspellings and manX other best
practices that Trillium has built into
the product.
X
 Data qualitX rules can be created
for addresses, phone numbers,
pan numbers, passport numbers
etc. ODI Parser rule and pattern
files correct and recognize citX
names, common
names/businesses, misspellings
and manX other best practices that
X Trillium has built into the product.
The results of completed Metabase
activities can be viewed in the
Oracle Data Profiling and QualitX
Event Log. The Event Log
organizes final results of Metabase
activities into folders in the
Explorer. The information that
displaXs in a List View is based on
user access privileges. Users with
limited privileges can see the
events for Entities theX own or
have permission to access. Users
X with full privileges can see all
events in the log.
Not supported
X
X Not supported

Data Mining is the part of the DB

and hence can onlX work with
Oracle as source .However an ETL
tool can be used to bring the data
from the disparate sources and
X mined with ODM.

X
X

X
X
X
X
 X

X
X

X
X

35 4 2 12
61.40351 7.01754386 3.50877193 21.05263158