Fnd client package

Use fnd client before u select rows from views.

Fnd_client_info.set_org_context('500');

This will enable data from the org you want to retrive.

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.

AIM TECHNOLOGY

APPLICATION ANALYSIS IS DONE FROM STARTING BUSINEES REQUIREMENTS AND ENDS UP WITH TECHINCAL GUIDE FOR IMPLEMENTATION.

Few important documents are

MD030-BUSINESS REQUIREMENTS

MD050-FUNCTIONAL REQUIREMETS

CMD040-RELAESE DOCUMENT

MD070-TECHNICAL DOCUMENT

Passing Parameter to Report

Example 1: Passing parameters to report

1) Go into the Data Model and then change the query:

select a.*, b.dname

from emp a, dept b

where a.deptno=b.deptno

and a.deptno = :p_deptno

2) Save

3) Re-run the report

4) Now the report will prompt the user to enter Department Number.



Example 2: Passing lexical parameter to report– example 1

1) Go into the Data Model and then change the query:

select a.*, b.dname

from emp a, dept b

where a.deptno=b.deptno

&order_by

2) Save

3) Re-run the report

4) Now the report will prompt the user to enter Lexical parameter. Let say you enter ‘order by dname’ and then run the report.



Example 3: Passing lexical parameter to report – example 2

5) Go into the Data Model and then change the query:

select a.*, b.dname

from emp a, dept b

where a.deptno=b.deptno

&and_cond

6) Save

7) Re-run the report

8) Now the report will prompt the user to enter Lexical parameter. Let say you enter ‘and a.deptno=10’ and then run the report.