Sponsored Project Cost Funding Pattern Distribution Adjustments

Sponsored projects with award funding patterns now have a mass adjustment action to reverse existing costs and distribute them using the funding patterns that are active for the associated expenditure item date. This allows for previously generated project costs to be redistributed applying funding and budget updates applicable to the distribution rules. This reduces the need for project cost transfers and increases the accurate consumption of available funds, meeting contract obligations.

To perform this action, query the costs you want redistributed using the sponsored project funding pattern.

Manage Project Costs

Then select the new adjustment type of Distribute Sponsored Project Costs Using Funding Patterns.

Create Mass Adjustments

The business benefit of this adjustment is that it provides enhanced accuracy and timeliness in processing sponsored project costs. It accommodates updates to business rules or funding conditions that impact funding patterns, thereby removing the need for manual reversals of existing project costs and subsequent new project cost creations. 

Here's the demo of these capabilities: 

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

When using this adjustment, review the project costs carefully. Note that every time you run this adjustment without a valid business reason, each adjustment is executed separately, and then reversed and re-created.

Key Resources

• To get a comprehensive overview of the funding pattern solution watch Project Cost Distribution Using Award Funding Patterns Readiness Training
• Related help:
  • Using Grants Management
• Based on Idea 679164 from the Project Management Idea Labs on Oracle Cloud Customer Connect

Access Requirements

To use this feature, you need these privileges:

• Privilege Name and Code:
  • Manage Award Funding Patterns (GMS_MANAGE_AWARD_FUNDING_PATTERNS_PRIV)
    • Allows users to manage award funding patterns assigned to a sponsored project.
    • Rolled up to Duty Role - Award Management (ORA_GMS_AWARD_MANAGEMENT_DUTY)
  • Distribute Award Project Costs and Quantities (PJC_DISTRIBUTE_AWARD_PROJECT_COSTS_AND_QUANTITIES_PRIV)
    • Allows users to initiate the Award Distribution process, which matches the costs and quantities provided to available award funding patterns, distributes costs as appropriate, and displays the results.
    • Allows users to initiate the adjustment type of Distribute Sponsored Project Costs Using Funding Patterns.
    • Rolled up to Job Roles:
      • Grant Management
        • Grants Accountant (ORA_PJF_GRANTS_ACCOUNTANT_JOB)
      • Procurement
        • Buyer (ORA_PO_BUYER_JOB)
        • Purchase Order Authoring (ORA_PO_SPO_CREATION_DUTY)
        • Category Manager (ORA_PON_CATEGORY_MANAGER_JOB)
        • Procurement Contract Administrator (ORA_PO_PROCUREMENT_CONTRACT_ADMIN_JOB)
        • Advanced Procurement Requester (ORA_POR_ADVANCED_PROCUREMENT_REQUESTER_ABSTRACT)
        • Procurement Preparer (ORA_POR_PROCUREMENT_PREPARER_ABSTRACT)
        • Procurement Requester (ORA_POR_PROCUREMENT_REQUESTER_ABSTRACT )
        • Contingent Worker (ORA_PER_CONTINGENT_WORKER_ABSTRACT)
        • Employee (ORA_PER_EMPLOYEE_ABSTRACT)
        • Requisition Self Service User (ORA_POR_REQUISITION_SELF_SERVICE_USER_DUTY)