Oracle Grants Accounting (GMS)

This chapter covers the following topics:

Create, Submit and Baseline Award Budget using PLSQL

The objective of the current flow is to create, submit and baseline award budget with multiple lines.

Flow Type

Hybrid

Technical Name

GMS_Baseline_Award_Budget_PLSQL

Prerequisites

Project and Award creation

Profile Options

The following profile options must be set:

Profile Value
GL Ledger Name Progress State & Local
MO: Operating Unit Progress Master
MO: Security Profile Progress Master

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
SELECT User_Name JPALMER
Responsibility Responsibility_Key GRANTS_ACCOUNTING_PROGRESS
  Product_Code GMS
PA_SET_GLOBAL_INFO Operating Unit ID 1448

Setup Data

The following data must be set up:

Entity Field Name Field Value
SELECT Project Number GMSI01
  Award Number GMSA1
  Task Number 1.0
  Task Number 2.0
  Resource List GMS_Resource_List
GMS_BUDGET_PUB_CREATE_DRAFT_BUDGET_Main Budget Entry Method Code By Lowest Task, GL Period
  Budget Type Code AC
GMS_BUDGET_PUB_ADD_BUDGET_LINE_Main Resource Alias Computers
  Resource Alias Professional

Description of the Scenarios in the Flow (Grants Accounting)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Get_Variables     - SELECT
Create_Draft_Budget This scenario verifies if the new job is created GMS_BUDGET_PUB.CREATE_DRAFT_BUDGET - GMS_BUDGET_PUB_CREATE_DRAFT_BUDGET_Main
ADD_BUDGET_LINES This scenario creates the award budget lines. GMS_BUDGET_PUB.ADD_BUDGET_LINE - GMS_BUDGET_PUB_ADD_BUDGET_LINE_Main
Submit_Budget This scenario submits and baselines the award budget. GMS_BUDGET_PUB.ADD_BUDGET_LINE. SUBMIT_BUDG_CONC_PROCESS - GMS_BUDGET_PUB_SUBMIT_BUDG_CONC_PROCESS_Main
Baseline_Budget This scenario baselines the award budget. GMS_BUDGET_PUB.BASELINE_BUDGET - GMS_BUDGET_PUB_BASELINE_BUDGET_Main
VERIFY_BASELINE_BUDGET This scenario verifies the award budget baselined above using UI components   - UI Component: VRF_AWARD_BUDGET