Showing posts with label Projects. Show all posts
Showing posts with label Projects. Show all posts

April 17, 2010

Projects

Highlights in User guide of Oracle Projects:-

 
Oracle Projects consists of three products:

• Oracle Project Costing

• Oracle Project Billing

• Oracle Personal Time and Expense



Oracle Project Costing

With Oracle Project Costing, you can:

• Enter projects and tasks. You can define chargeability control to

limit charges to your projects and tasks

• Enter cost budgets and baseline them

• Track committed costs of requisitions, purchase orders, and

supplier invoices

Overview of Oracle Projects 1 – 3

• Record detailed cost transactions for timecards, expense reports,

asset usage, and supplier invoices. You can let your project

managers and staff enter their timecards and expense reports

directly for online approval using Oracle Personal Time and

Expense or in pre–approved batches

• Interface costs between other Oracle Applications while

maintaining a detail audit trail

• Collect CIP costs and interface asset costs to Oracle Assets when

you are ready to place the asset in service

• Report project status online and in reports



Oracle Project Billing

• Enter project customers and contacts with whom you have

negotiated and contracted project work

• Enter agreements (contracts) from your customers and fund

projects with those agreements

• Generate revenue using various methods including time and

materials, percent complete, and cost plus

• Create draft invoices from detail transactions and milestones for

online approval by your project or accounting managers

• Interface revenue to Oracle General Ledger and invoices to

Oracle Receivables while maintaining a detail audit trail

• Report project revenue, invoice, and receivables status online

and in reports


Oracle Personal Time and Expense

Oracle Personal Time and Expense makes it easy for your employees to

record and submit their timecards and expense reports, whether they

are in your office or on the road.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...