Download - Bigbang Oracle
-
8/13/2019 Bigbang Oracle
1/12
1
Oracle EBS Fitment-SISSProject Godzilla(Big Bang)
presented toSony
April 2003
-
8/13/2019 Bigbang Oracle
2/12
2
Current System Footprint
S-PALSProject informationProject resources
Project profit and lossEstimates and orders
Acceptance inspectionand billing
Subcontracting
MALINOSMan-hour control
SOROBANFinancialaccounting
R/3 FI
Personnelinformation
Controlling duties
PLANETBusiness plan, plan-do check
D,M
D
M
M
M
D
D,M
O
M
PROSESProduct sales
D
D
RINGYSettlement control,
capital investment, plan-do check
Y
Settlingtravel
expenses
PalettePartner
track recordcontrol
M
M
D
Sales, billing
Cost unitcode
Personnel
Attendance Man-hour
Man-hour
Project code,resource
O
M
Expenses
Capitalinvestment
Sales, stocking
Sales, cost,device
ACCOUNT-MAN Charge control
Sales, billing
LUMAMLease, maintenance,
line control,charge control, business plans
Sounding outpartner companies
Attendance
O
Scope
NT/Sybase
NT/Oracle
Data
NT/SQLServer
UNIX/Sybase
NT/Oracle R3
O:OnlineD:DailyM:MonthlyY:Yearly
M/F
SPRITEInternet
catalogue
D
Order
Shipping
-
8/13/2019 Bigbang Oracle
3/12
3
Proposed Strategy
Oracle ProjectsProject information
Project resourcesProject profit and lossOracle Time
and Labor
OracleFinancials
AP,AR,FA,GL
Personnelinformation
Controlling duties
Fixed Assets
Oracle OM &Shipping
Product sales
Sales OnlineQuoting and
Forecasting
i-Expense
PalettePartner
track recordcontrol
Personnel
Attendance
Man-hour
Project code,resource
Expenses
Sales, stocking
Sales, cost,device
ACCOUNT-MAN Charge controlCustom Leasing
Solution
Sounding outpartner companies
Attendance
Scope
SPRITEInternetcatalogue
Order
Shipping
Capitalinvestment
OraclePurchasing
i-Procurement
Capitalinvestment
Third Party TimePunching System
OracleLabor
Dist
OracleInventory
-
8/13/2019 Bigbang Oracle
4/12
4
Solution Footprint-Oracle Applications
Custom Module- Custom Cost Allocation- Resource and Asset Allocation
- Business Logic- Facilitator in Estimates- Stores changing Wage Rates etc
GL AR AP OM PO
FA
INV
PC PB
Project Accounting
HRMS Legacy System
L e v e r a g e
L e g a c y ,
i f r e q u
i r e d
&
u s e f u l
I-Expense
P r o j e c t
S p e c
i f i c
E x p e n s e
B o o
k i n g
M a t e r
i a l f o r
P r o j e c
t Invoicing for Projects includingIncluding Interdivisional billing
Asset Register
Vendor Master
Item Master
Employee Master
CustomerMaster
DedicatedAssets
Shared Assets
I-Procurement
Sales OnlineExpense/Liability thatNeeds allocation/appropriationAcross Projects/Tasks/divisions Project SpecificExpense/Liability
CRMFoundation
OracleTime andLabor
Third Party Timepunching System
-
8/13/2019 Bigbang Oracle
5/12
5
Oracle Apps Solution-Module Wise Mapping
Planet
Functionality1. Sales Projections2. Cost Projection3. Staff Projection4. Capital Investment Projections
5. Profit and Loss Projections6. Cost Distribution
Base Oracle EBS Fitment1. Sales Projections-Sales Online,Project Accounting
2. Cost Projections-Project Costing and GL3. Staff Projections-HRMS,Project Costing4. Capital Investment Projections-FA ,Project Costingand Oracle Time and Labor
5. P/L projections-Project Accounting and GL6. Cost Distribution-Project Costing and GL
Customization/Workarounds1. Customized reportingmight be required forgetting sales,purchase andoutsourcing projections aswell as costs in the samereport.
2. Capital investment projections can be storedon GL/as well ProjectBudgets.But reportingmight be customized
3. Cost distribution across projects and divisions can be achieved both in GL or
Oracle Projects.Somecustomization might berequired after detailed
process study.4. Redistributing costs at
project level across projectsmight require somecustomization
-
8/13/2019 Bigbang Oracle
6/12
6
Oracle Apps Solution-Module Wise Mapping
S-PALS/MALINOS
Functionality1. Estimate2. Order Receipt3. Receiving Inspection4. Issuance of Invoices5. Project Management6. Project Profit and Loss Mgmt7. P/L Management by category8. Transfer between Division9. Outsourcing of operations
Base Oracle EBS Fitment1. Estimate-Sales Online and Project Accounting
2. Order Receipt-Sales Online3. Receiving Inspection-Order Management and AR4. Issuance of Invoices-AR and Project Billing5. Project Management-Project Accounting and OTL6. Project Profit and Loss Mgmt-PA and GL7. P/L Management by category-PA and GL8. Transfer between Division-GL9. Outsourcing of operations- PO,INV and Project Accounting
Customization/Workarounds1. Issuance of a PrintedInvoice Might need to becustomized
2. Issuance of Invoice will bea custom report
3. If the Estimation Process iscomplex then a custommodule may be built
Note:Workar ounds andCustomi zations can beeasi ly buil t by designin gthe char t of accounts wi tha pr oject segment.I n sucha case, projectbudgeting,Forecasting,cha rging and all ocation canbe done at both levels-BothGL and Proj ects andhence the fl exi bili ty tor ecord and report atProj ect,division andcategory l evel for
everything.
If the Project Executionrequirements areexhaustivethen a web based
custom solution can beconsidered to be builtand interfaced to PA
-
8/13/2019 Bigbang Oracle
7/12
7
Oracle Apps Solution-Module Wise Mapping
LUMAM1. Lease Management2. Capital Investment Plan3. Charge Processing4. Receiving Inspection
Base Oracle EBS Fitment1. Oracle FA,GL,Project Accounting
Customization/Workarounds1. Receiving Inspectionfeature might need somecustomization around FA
2. Creating Invoices from FAwill need a customizationinto AR interface
3. Capital investment Planreporting will becustomized drawing datafrom FA,GL and ProjectAccounting
-
8/13/2019 Bigbang Oracle
8/12
8
Oracle Apps Solution-Module Wise Mapping
PROSES1. Selling Management2. Purchase Management3. Expenses Management
Base Oracle Fitment1. Selling Management-Sales Online,
Order Management and Project Billing2. Purchase Management-Purchasing,Project Accounting and
i-Procurement.3. Expense Management- i-Expense and Project Accounting
Customization/Workarounds1. Reports may be customized
-
8/13/2019 Bigbang Oracle
9/12
-
8/13/2019 Bigbang Oracle
10/12
10
Oracle Apps Solution-Advantages
Advantages of the Oracle Applications based Solution
1. Oracle Projects and GL Chart of accounts with a Project segment will provide enormous amount of flexibility in the following areas
Cost Distribution mechanism Profitability and revenue reporting based on projects,divisions or
groups Category wise charging and reporting can be achieved easily. Both GL budgets and Project Budgeting feature can be used for
most of the budgeting andforecasting requirements
3. Customer based analysis can be carried out in Accounts receivable
4. Single sign-on is automatically achieved for all the Oracle Applicationsmodules5. Project Information is easily available from Oracle Projects6. Oracle time and labor will enable time to be directly charged to project
at the time of entry itself.7. All customizations are easy and economical because of use of
PL/SQL,Oracle Forms and reports
-
8/13/2019 Bigbang Oracle
11/12
11
Oracle Apps Solution Footprint-Sales OnlineMapping
Qualify Lead
AssignOpportunity
AssignPartner
CreateOpportunity
Work onOpportunity
Propose aSolution
Convert toQuote
Covert toOrder
NegotiateCrossSell/Upsell/Reprice
ConfigureReviewPipeline
ModifyForecast SubmitForecast
GenerateBaselineForecast
Order Management and Shipping
Lead Management Opportunity Management
Quote Management Forecast Management
Customizedreporting to measureforecasting efficiency
Customized reportsto compare
final quoteand initial quote
-
8/13/2019 Bigbang Oracle
12/12
12
Our PromiseWith utmost respect to Hum an Values ,
we promise to serve our customer with Integri ty ,
through Innovat ive , Value for Mo ney solutions,
by applying thought, day after day.