18 Oracle Grants Accounting

Oracle Grants Accounting extends the functionality of Oracle Projects to provide an integrated award and project management solution for grant receiving organizations. Oracle Grants Accounting tracks multi-funded projects and the required compliance terms and conditions by award.

This chapter describes the following test flows in Oracle Grants Accounting:

  • Award Revenue and Invoice Generation

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

18.1 Award Revenue and Invoice Generation

Award revenue and invoice generation covers the award template creation, award creation, incurring actuals, and revenue and invoice generation.

A sponsored capital project is created which gets funded by an agreement. Award budgets are created and baselined. Pre-approved miscellaneous expenditure items are created and cost distributed. Burden transactions are also created for this expenditure item. Award revenue is generated and accounted. Project invoices are also generated and fully processed by interfacing the same to Receivables.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Table 18-1 Setup Data for Award Revenue and Invoice Generation Flow

Window Name Field Name Field Value Comments

Project Type

Service Type

Administration

 
 

Burden Schedule

GMS_Schedule

Raw expenditure of type Consulting, results in Burden Expenditure of type Overhead.

Burden Multiplier of 0.1 is applicable

 

Budget Entry Method

By Lowest Task, GL Period (Rev)

Budget entry method has Entry Level = Lowest Tasks, Categorized by Resources = Yes and Time Phased By = GL Period

 

Resource List

GMS_Resource_List

 

Award Template

Indirect Cost Schedule

GMS_Schedule

Raw expenditure Type - Consulting results in Burden Expenditure Type - Overhead

Burden Multiplier of 0.1 is applicable

 

Customer

Department of Labor

 
 

Award type

Federal Agency Grants

 
 

Employee

Palmer, Mr. James John (Jim)

 

Award Budget

Budget Entry Method

By Lowest Task,GL Period (Rev)

Budget Entry Method is defined as:

Entry Level - Lowest Tasks

Categorized by Resources - Yes

Time Phased By - GL Period

 

Resource List

GMS_Resource_List

 

Pre Approved Batches

Expenditure Type

Professional

Computers

Consulting

Airfare

Overhead

Fringe

 

Project Template

Employee

Palmer, Mr. James John (Jim)

 

Project Asset

Employee

Palmer, Mr. James John (Jim)

 
 

Asset Category

COMPUTER-SERVER

 
 

Asset Book

PROGRESS SandL

 
 

FA Location

GERMANY-NONE-BERLIN-MANUFACTURING