Processes and Reports Procedures

This chapter describes the processes and reports procedures.

This chapter covers the following topics:

Definition

A process is a set of non-interactive tasks run in the background to accomplish a specific goal. A report is an organized display of Grants Accounting information.

Overview

Oracle Grants Accounting runs processes and provides summary reports.

A report can be viewed online or sent to a printer. The content in a report can range from a summary to a complete listing of values.

This chapter describes the following processes and reports:

GMS: Award Overdraft Status Report

The GMS: Award Overdraft Status Report process alerts award personnel when the balance status of an award is in deficit. The balance status represents the difference of the approved budget minus commitments and minus actual expenditures. If the combination of commitments and actual expenditures are over the approved budget, the award will be listed on the Award Overdraft Report.

GMS: Costing and Funds Check on Expense Report Adjustments

The GMS: Costing and Funds Check on Expense Report Adjustments process computes the burden costs associated with the adjusted expense report expenditure items. The process also determines the default account for the raw costs. In addition, it initiates a funds check to determine whether funds are available for transactions. You must run this process before you accrue revenue and generate invoices for adjusted expense report expenditure items.

Note: This process does not recalculate raw costs for adjusted expense report expenditure items.

Note: If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Grants Accounting derives using AutoAccounting.

The GMS: Costing and Funds Check on Expense Report Adjustments process generates the following reports:

GMS: Costing and Funds Check on Straight Time Labor

The GMS: Costing and Funds Check on Straight Time Labor process computes the raw labor costs for timecard hours. The process also determines the default accounts for the raw costs. In addition, it initiates a funds check to determine whether funds are available for transactions. You must submit and release expenditure batches before you run this process. You must run this process before you accrue revenue and generate invoices for labor expenditure items.

Note: If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Grants Accounting derives using AutoAccounting.

The GMS: Costing and Funds Checking on Straight Time Labor process generates the following reports:

GMS: Costing and Funds Check on Straight Time Labor for a Range of Projects

The GMS: Costing and Funds Check on Straight Time Labor for a Range of Projects process computes the raw labor costs for timecard hours. The process also determines the default accounts for the raw costs. In addition, it initiates a funds check to determine whether funds are available for transactions. You must submit and release expenditure batches before you run this process. You must run this process before you accrue revenue and generate invoices for labor expenditure items.

Note: If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Grants Accounting derives using AutoAccounting.

The GMS: Costing and Funds Check on Straight Time Labor for a Range of Projects process generates the following reports:

GMS: Costing and Funds Check on Usages and Miscellaneous Costs

The GMS: Costing and Funds Check on Usages and Miscellaneous Costs process computes the raw costs for nonlabor assets usage. The process also determines the default accounts for the raw costs. In addition, it initiates a funds check to determine whether funds are available for transactions. You must submit and release expenditure batches before you run this process. You must run this process before you accrue revenue and generate invoices for assets usage expenditure items.

Note: If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Grants Accounting derives using AutoAccounting.

The GMS: Costing and Funds Check on Usages and Miscellaneous Costs process generates the following reports:

GMS: Delete Unreleased Draft Invoices for a Range of Awards

The GMS: Delete Unreleased Draft Invoices for a Range of Awards process enables users to delete unreleased invoices for a range of awards.

The GMS: Delete Unreleased Draft Invoices for a Range of Awards process generates the following report:

GMS: Distribute Supplier Cost Adjustments and Funds Check

The GMS: Distribute Supplier Cost Adjustments and Funds Check process computes the burden costs associated with the adjusted supplier cost expenditure items. The process also determines the default account for the raw costs. In addition, it initiates a funds check to determine whether funds are available for transactions. You must run this process before you accrue revenue and generate invoices for adjusted supplier expenditure items.

Note: This process does not recalculate raw costs for adjusted supplier cost expenditure items.

After you run this process, you must rerun the process PRC: Create and Distribute Burden Transaction to ensure that the generation of burden expenditure items for adjusted supplier cost expenditure items is performed correctly.

Note: If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Grants Accounting derives using AutoAccounting.

The GMS: Distribute Supplier Cost Adjustments and Funds Check process generates the following reports:

GMS: Distribute Supplier Cost Adjustments and Funds Check for a Range of Projects

The GMS: Distribute Supplier Cost Adjustments and Funds Check for a Range of Projects process computes the burden costs associated with the adjusted supplier cost expenditure items. The process also determines the default account for the raw costs. In addition, it initiates a funds check to determine whether funds are available for transactions. You must run this process before you accrue revenue and generate invoices for adjusted supplier expenditure items.

Note: This process does not recalculate raw costs for adjusted supplier cost expenditure items.

After you run this process, you must rerun the process PRC: Create and Distribute Burden Transaction to ensure that the generation of burden expenditure items for adjusted supplier cost expenditure items is performed correctly.

Note: If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Grants Accounting derives using AutoAccounting.

The GMS: Distribute Supplier Cost Adjustments and Funds Check for a Range of Projects process generates the following reports:

GMS: Encumbrance Funds Check

The GMS: Encumbrance Funds Check process reserves funds for manual encumbrances. This process is also used to encumber Oracle Labor Distribution encumbrance transactions that interface to Grants Accounting.

The GMS: Encumbrance Funds Check process generates the following reports:

GMS: Encumbrance Funds Check for a Range of Encumbrance Groups

The GMS: Encumbrance Funds Check for a Range of Encumbrance Groups concurrent program reserves funds for manual encumbrances for a range of encumbrance batches. This program also reserves Oracle Labor Distribution encumbrance transactions that are interfaced to Oracle Grants Accounting.

This process generates the following reports:

GMS: Encumbrance Funds Check for a Range of Projects

The GMS: Encumbrance Funds Check for a Range of Projects concurrent program reserves funds for manual encumbrances for a range of projects. This program also reserves Oracle Labor Distribution encumbrance transactions that are interfaced to Oracle Grants Accounting.

This process generates the following reports:

GMS: Generate Draft Invoices for a Range of Awards

The GMS: Generate Draft Invoices for a Range of Awards process creates multiple invoices for multiple awards from expenditure items and events. This process also deletes unreleased draft invoices and creates invoice write-offs, credit memos, and invoice cancellations.

The GMS: Generate Draft Invoices for a Range of Awards process generates the following reports:

Note: If you submit this process with the Customer Merge process in Oracle Receivables, the process that you submit first runs. The other process runs after the first one completes.

GMS: Generate Draft Invoices for a Single Award

The GMS: Generate Draft Invoices for a Single Award process creates a single invoice for a single award from expenditure items and events. This process also deletes unreleased draft invoices and creates invoice write-offs, credit memos, and invoice cancellations.

The GMS: Generate Draft Invoices for a Single Award process generates the following reports:

Note: If you submit this process with the Customer Merge process in Oracle Receivables, the process that you submit first runs. The other process runs after the first one completes.

GMS: Generate Draft Revenue for a Range of Awards

The GMS: Generate Draft Revenue for a Range of Awards process calculates revenue for a range of awards.

The GMS: Generate Draft Revenue for a Range of Awards process generates the following reports:

GMS: Generate Draft Revenue for a Single Award

The GMS: Generate Draft Revenue for a Single Award process calculates revenue for a single award.

The GMS: Generate Draft Revenue for a Single Award process generates the following reports:

GMS: Generate Revenue Accounting Events

The GMS: Generate Revenue Accounting Events process collects revenue distribution lines in Oracle Grants Accounting and uses AutoAccounting to determine the default unearned revenue and unbilled receivables accounts. It also calculates the amounts to be distributed to the default unearned revenue and unbilled receivables accounts. Finally, the process creates accounting events in Oracle Subledger Accounting.

If the process is able to successfully generate an accounting event, then it updates the status of the revenue distribution line to Accepted.

If the process cannot successfully determine an account or is unable to generate an accounting event, then it updates the status of the revenue distribution line to Rejected.

After the process generates revenue accounting events, you can run the process PRC: Create Accounting to create the draft or final accounting in Oracle Subledger Accounting.

The profile option PA: Interface Unreleased Revenue to GL determines whether this process includes unreleased draft revenue. See: PA: Interface Unreleased Revenue to GL, Oracle Projects Implementation Guide.

GMS: Installment Closeout Notification

The GMS: Installment Closeout Notification process alerts award personnel that an award is nearing the installment end date. If open commitments exist when the notification is generated, they are listed in the notification.

GMS: Interface Invoices to Receivables

The GMS: Interface Invoices to Receivables process collects all eligible draft invoices in Grants Accounting, and interfaces them to Oracle Public Sector Receivables receivables interface tables. The process also maintains the balances of unbilled receivables and unearned revenue and creates default accounting transactions for these amounts.

Once interfaced to these interface tables, the draft invoices await further processing by Receivables' AutoInvoice process. If any of the draft invoices are rejected during the interface to Receivables, then the interface status for these invoices is set to Rejected in Transfer. Draft invoices that successfully interface have the transfer status set to Transferred to Receivables.

The Interface Invoices to Receivables and the AutoInvoice Import processes can run in parallel when submitted in different operating units only if the Conflicts Domain for the AutoInvoice process has a value of Org ID. In this case the incompatibility between the processes is of type Domain. If the Conflicts Domain has a value other than Org ID, then the processes run in succession. In this case the incompatibility between the processes is of type Global.

Note: If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Grants Accounting derives using AutoAccounting.

The GMS: Interface Invoices to Receivables process runs the following process:

The GMS: Interface Invoices to Receivables process generates the following reports:

GMS: Report Notification Scheduler

The GMS: Report Notification Scheduler allows users to schedule notification. This process sends notifications to award personnel associated with an award for reports that are due.

GMS: Report on Award Listings

The GMS: Report on Award Listings provides a listing of all awards and their statuses.

GMS: Report on Project Listings

The GMS: Report on Project Listings provides a listing of all projects and their statuses provided the projects are sponsored, funded by an award, and have a baselined budget.

GMS: Submit Interface Streamline Process

Streamline processes submit and monitor a series of programs that must be run sequentially to complete a function. For example, cost and funds checking labor costs, generating cost accounting events, creating accounting in Oracle Subledger Accounting, and transferring the costs to Oracle General Ledger requires that you submit several programs. Instead of running the individual programs one at a time, you can choose to submit the program GMS: Submit Interface Streamline Process and select the streamline option DXL: Distribute and Interface Labor Costs to GL. The streamline process then submits and monitors the programs in sequence until all programs complete.

Important: Each streamline option parameter for costs enables you to run the process for one type of costs. To process more than one type of costs, you must run the interface streamline process separately for each type of cost. The streamline process option automatically sets the process category for both the PRC: Generate Cost Accounting Event and PRC: Create Accounting programs. For additional information, see the following topics:

Note: For the program PRC: Create Accounting , the interface streamline process automatically sets the Mode parameter to Final, Transfer to General Ledger parameter to Yes, and the Post in General Ledger parameter to No. As a result, the program PRC: Create Accounting initiates the journal import program in Oracle General Ledger.

You must select one of the following values for the Streamline Option parameter when you submit the program GMS: Submit Interface Streamline Process:

GMS: Unbilled Receivables Aging

The GMS: Unbilled Receivables Aging process allows users to review, by award, eligible revenue items that have not yet been invoiced, or those revenue items not included on a released draft invoice. The report generated by this process lists the receivables in 4-Bucket Aging. Aging buckets are time periods you can use to review and report on your open receivables.

For more information on Aging buckets, see Oracle Receivables Implementation Guide.

The GMS: Unbilled Receivables Aging process runs the following process:

The GMS: Unbilled Receivables Aging process generates the following report:

GMS: Update Actual and Encumbrance Balance

The GMS: Update Actual and Encumbrance Balance process improves the performance of funds check by updating actuals and encumbrance balances every two hours. This process is automatically started when Grants Accounting is installed. If the database is shut down, this process must be manually started after bringing the database back online. Only one GMS: Update Actual and Encumbrance Balance process should be running at a time. Running more than one consumes resources unnecessarily.

The GMS: Update Actual and Encumbrance Balance process runs the following process:

Required Processes and Reports in Oracle Projects

Grants Accounting uses processes and reports in Projects. To run Projects processes and reports, see Processes, Oracle Projects Fundamentals.

GMS: Award Overdraft Status Report Procedure

To run the GMS: Award Overdraft Status Report process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Award Overdraft Status Report from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Key Member field, select a key member from the list of values, or leave the field empty to select all key members.

  7. In the Award Role field, select an award role from the list of values, or leave the field empty to select all award managers.

  8. In the Organization Name field, select an organization name from the list of values, or leave the field empty to select all organizations.

  9. In the Funding Source field, select a funding source from the list of values, or leave the field empty to select all funding sources.

  10. In the Award Type field, select an award type from the list of values, or leave the field empty to select all types.

  11. In the Award Status field, select an award status from the list of values, or leave the field empty to select all active awards.

  12. In the Purpose Code field, select a purpose code from the list of values, or leave the field empty to select all purpose codes.

  13. In the Through Date field, enter a date which falls within the active award date range, or leave the field empty to select all awards with a date falling within the active award date range.

  14. Click OK to apply the parameters.

  15. Click Submit to send the request to the concurrent manager.

  16. View the request in the concurrent manager as follows:

    View - Requests

  17. Close the window.

GMS: Costing and Funds Check on Expense Report Adjustments

To run the GMS: Costing and Funds Check on Expense Report Adjustments process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Costing and Funds Check on Expense Report Adjustments from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Expenditure Batch field, select an expenditure batch from the list of values, or leave the field empty to select all expenditure batches.

  7. In the Project Number field, select a project number from the list of values, or leave the field empty to select all projects.

  8. In the Employee Name field, select an employee name from the list of values, or leave the field empty to select all employees.

  9. In the End Date field, enter a date through which costing and funds checking are performed, or leave the field empty to use the current date as the through week ending date.

  10. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  11. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  12. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  13. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  14. Click OK to apply the parameters.

  15. Click Submit to send the request to the concurrent manager.

  16. View the request in the concurrent manager as follows:

    View - Requests

  17. Close the window.

GMS: Costing and Funds Check on Straight Time Labor Procedure

To run the GMS: Costing and Funds Check on Straight Time Labor process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Costing and Funds Check on Straight Time Labor from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Expenditure Batch field, select an expenditure batch from the list of values, or leave the field empty to select all expenditure batches.

  7. In the Project Number field, select a project number from the list of values, or leave the field empty to select all projects.

  8. In the Employee Name field, select an employee name from the list of values, or leave the field empty to select all employee names.

  9. In the End Date field, enter a date through which costing and funds checking are performed, or leave the field empty to use the current date as the end date.

  10. In the Incurred by Organization field, select an organization from the list of values, or leave the field empty to select all organizations.

  11. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  12. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  13. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  14. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  15. Click OK to apply the parameters.

  16. Click Submit to send the request to the concurrent manager.

  17. View the request in the concurrent manager as follows:

    View - Requests

  18. Close the window.

GMS: Costing and Funds Check on Straight Time Labor for a Range of Projects Procedure

To run the GMS: Costing and Funds Check on Straight Time Labor for a Range of Projects process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Costing and Funds Check on Straight Time Labor for a Range of Projects from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the From Project Number field enter a project number to use as the low end of the project number range, or leave the field empty to select all eligible projects whose project numbers come before the project number entered in the To Project Number field.

    Optionally, leave both the From Project Number field and To Project Number field empty to select labor costs from all eligible projects.

  7. In the To Project Number field, select a project number from the list of values to use as the high end of the project number range, or leave the field empty to select all eligible projects whose project numbers come after the project number entered in the From Project Number field.

  8. In the End Date field, enter a date through which costing and funds checking are performed, or leave the field empty to use the current date as the end date.

  9. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  10. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  11. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  12. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  13. Click OK to apply the parameters.

  14. Click Submit to send the request to the concurrent manager.

  15. View the request in the concurrent manager as follows:

    View - Requests

  16. Close the window.

GMS: Costing and Funds Check on Usages and Miscellaneous Costs Procedure

To run the GMS: Costing and Funds Check on Usages and Miscellaneous Costs process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Costing and Funds Check on Usages and Miscellaneous Costs from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Expenditure Batch field, select an expenditure batch from the list of values, or leave the field empty to select all expenditure batches.

  7. In the Project Number field, select a project number from the list of values, or leave the field empty to select all projects.

  8. In the End Date field, enter a date through which costing and funds checking are performed, or leave the field empty to use the current date as the through date.

  9. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  10. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  11. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  12. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  13. Click OK to apply the parameters.

  14. Click Submit to send the request to the concurrent manager.

  15. View the request in the concurrent manager as follows:

    View - Requests

  16. Close the window.

GMS: Delete Unreleased Draft Invoices for a Range of Awards Procedure

To run the GMS: Delete Unreleased Draft Invoices for a Range of Awards process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Delete Unreleased Draft Invoices for a Range of Awards from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the From Award Number field, enter the lowest award number to be submitted for draft invoice deletion.

    If this field is left blank, all eligible awards with numbers less than the award number entered in the To Award Number field will be selected.

  7. In the To Award Number field, enter the highest award number to be submitted for draft invoice deletion.

    If this field is left blank, all eligible awards with numbers greater than the award number entered in the From Award Number field will be selected.

  8. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  9. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  10. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  11. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  12. In the Award Organization field, enter the award organization for which draft invoices need to be deleted.

    If this field is left blank, all awards will be selected.

  13. In the Sponsor Name field, enter the name of the sponsor for which draft invoices need to be deleted.

  14. In the Delete Only Unapproved Invoice field, select Yes to delete only unapproved invoices or No to delete all unreleased invoices.

  15. Click OK to apply the parameters.

  16. Click Submit to send the request to the concurrent manager.

  17. View the request in the concurrent manager as follows:

    View - Requests

  18. Close the window.

GMS: Distribute Supplier Cost Adjustments and Funds Check Procedure

To run the GMS: Distribute Supplier Cost Adjustments and Funds Check process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Distribute Supplier Invoice Adjustment Costs and Funds Check from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Project Number field, select a project number from the list of values, or leave the field empty to select all projects.

  7. In the End Date field, enter a date through which supplier invoices are distributed and funds checking is performed, or leave the field empty to use the current date as the end date.

  8. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  9. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  10. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  11. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  12. Click OK to apply the parameters.

  13. Click Submit to send the request to the concurrent manager.

  14. View the request in the concurrent manager as follows:

    View - Requests

  15. Close the window.

GMS: Distribute Supplier Cost Adjustments and Funds Check for a Range of Projects Procedure

To run the GMS: Distribute Supplier Cost Adjustments and Funds Check for a Range of Projects process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Distribute Supplier Cost Adjustments and Funds Check for a Range of Projects from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the From Project Number field enter a project number to use as the low end of the project number range, or leave the field empty to select all eligible projects whose project numbers come before the project number entered in the To Project Number field.

    Optionally, leave both the From Project Number field and To Project Number field empty to select supplier cost adjustments from all eligible projects.

  7. In the To Project Number field, select a project number from the list of values to use as the high end of the project number range, or leave the field empty to select all eligible projects whose project numbers come after the project number entered in the From Project Number field.

  8. In the End Date field, enter a date through which supplier invoices are distributed and funds checking is performed, or leave the field empty to use the current date as the end date.

  9. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  10. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  11. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  12. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  13. Click OK to apply the parameters.

  14. Click Submit to send the request to the concurrent manager.

  15. View the request in the concurrent manager as follows:

    View - Requests

  16. Close the window.

GMS: Encumbrance Funds Check Procedure

To run the GMS: Encumbrance Funds Check process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Encumbrance Funds Check from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Encumbrance Batch field, select an encumbrance batch from the list of values, or leave the field empty to select all encumbrance batches.

  7. In the Project Number field, select a project number from the list of values, or leave the field empty to select all projects.

  8. In the End Date field, select enter an encumbrance end date, or leave the date empty to use the current date as the end date.

  9. In the Incurred by Organization field, select an organization from the list of values, or leave the field empty to select all organizations.

  10. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  11. Click OK to apply the parameters.

  12. Click Submit to send the request to the concurrent manager.

  13. View the request in the concurrent manager as follows:

    View - Requests

  14. Close the window.

GMS: Encumbrance Funds Check for a Range of Encumbrance Groups Procedure

To run the GMS: Encumbrance Funds Check for a Range of Encumbrance Groups process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request option.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Encumbrance Funds Check for a Range of Encumbrance Groups from the list of values.

  5. Click OK.

    The Parameters window appears.

  6. In the From Encumbrance Batch field, select the starting encumbrance batch of the range from the list of values.

  7. In the To Encumbrance Batch field, select the ending encumbrance batch of the range from the list of values.

  8. In the End Date field, select enter an encumbrance end date, or leave the date empty to use the current date as the end date.

  9. In the Incurred By Organization field, select an organization, for which encumbrances are charged from the list of values, or leave the field empty to select all organizations.

  10. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submissions of the program, or leave the field empty if automatic program submission is not in use.

  11. Click OK to apply the parameters you have entered.

  12. Click Submit to send the request to the Concurrent Manager.

  13. View the request in the Concurrent Manager as follows:

    View - Requests

  14. Close the window.

GMS: Encumbrance Funds Check for a Range of Projects Procedure

To run the GMS: Encumbrance Funds Check for a Range of Projects concurrent program, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request option.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Encumbrance Funds Check for a Range of Projects from the list of values.

  5. Click OK.

    The Parameters window appears.

  6. In the From Project Number field, select the starting project number of the range from the list of values.

  7. In the To Project Number field, select the ending project number of the range from the list of values.

  8. In the End Date field, select an encumbrance end date, or leave the date empty to use the current date as the end date.

  9. In the Incurred by Organization field, select an organization from the list of values, or leave the field empty to select all organizations.

  10. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submissions of the program, or leave the field empty if automatic program submission is not in use.

  11. Click OK to apply the parameters you have entered.

  12. Click Submit to send the request to the Concurrent Manager.

  13. View the request in the Concurrent Manager as follows:

    View - Requests

  14. Close the window.

GMS: Generate Draft Invoices for a Range of Awards Procedure

To run the GMS: Generate Draft Invoices for a Range of Awards process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Generate Draft Invoices for a Range of Awards from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Bill Through Date field, enter a date through which the process creates invoices using expenditure items and events, or leave the field empty to use the current date as the bill through date.

  7. In the From Award Number field, select an award number from the list of values to use as the low end of the award number range within which awards are processed, or leave the field empty to select all eligible awards whose award numbers come before the award number entered in the To Award Number field.

    Optionally, leave both the From Award Number field and To Award Number field empty to select all eligible awards.

  8. In the To Award Number field, select an award number from the list of values to use as the high end of the award number range within which awards are processed, or leave the field empty to select all eligible awards whose award numbers come after the award number entered in the From Award Number field.

  9. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  10. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  11. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  12. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  13. In the Award Organization field, enter the award organization for which draft invoices will be generated.

  14. In the Sponsor Name field, enter the name of the sponsor for which draft invoices will be generated.

  15. Click OK to apply the parameters.

  16. Click Submit to send the request to the concurrent manager.

  17. View the request in the concurrent manager as follows:

    View - Requests

  18. Close the window.

GMS: Generate Draft Invoices for a Single Award Procedure

To run the GMS: Generate Draft Invoices for a Single Award process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Generate Draft Invoices for a Single Award from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Award Number field, select an award number from the list of values.

  7. In the Bill Through Date field, enter a date through which the process creates invoices using expenditure items and events, or leave the field empty to use the current date as the bill through date.

  8. In the Delete Only Unapproved Invoice field, select Yes to delete only unapproved invoices or No to delete all unreleased invoices

  9. Click OK to apply the parameters.

  10. Click Submit to send the request to the concurrent manager.

  11. View the request in the concurrent manager as follows:

    View - Requests

  12. Close the window.

GMS: Generate Draft Revenue for a Range of Awards Procedure

To run the GMS: Generate Draft Revenue for a Range of Awards process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Generate Draft Revenue for a Range of Awards from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Accrue Through Date field, enter a date through which the process selects expenditure items and events, or leave the field empty to use the current date as the accrue through date.

  7. In the From Award Number field, select an award number from the list of values, or leave the field empty to select all eligible awards whose award numbers come before the award number entered in the To Award Number field.

    Optionally, leave both the From Award Number field and To Award Number field empty to select all eligible awards.

  8. In the To Award Number field, select an award number from the list of values, or leave the field empty to select all eligible awards whose award numbers come after the award number entered in the From Award Number field.

  9. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  10. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  11. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  12. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  13. In the Award Organization field, enter the award organization for which draft revenue will be generated.

  14. In the Sponsor Name field, enter the name of the sponsor for which draft revenue will be generated.

  15. In the Release Draft Revenue field, select Yes to generate revenues as released.

  16. Click OK to apply the parameters.

  17. Click Submit to send the request to the concurrent manager.

  18. View the request in the concurrent manager as follows:

    View - Requests

  19. Close the window.

GMS: Generate Draft Revenue for a Single Award Procedure

To run the GMS: Generate Draft Revenue for a Single Award process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Generate Draft Revenue for a Single Award from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Award Number field, select an award number from the list of values.

  7. In the Accrue Through Date field, enter a date through which the process selects expenditure items and events, or leave the field empty to use the current date as the accrue through date.

    Note: The accrue through date is the date through which the system accrues revenue for a project. When accruing revenue, the system includes expenditure items having an expenditure item date on or before the accrue through date.

  8. Click OK to apply the parameters.

  9. Click Submit to send the request to the concurrent manager.

  10. View the request in the concurrent manager as follows:

    View - Requests

  11. Close the window.

GMS: Generate Revenue Accounting Events Procedure

To run the GMS: Generate Revenue Accounting Events process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Generate Revenue Accounting Events from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the From PA Date field, enter the start date for the PA Date Range for which you want the process to select draft revenues. If you leave this parameter blank, then the process selects all draft revenues having PA Dates before the date you enter in the To PA Date process parameter.

  7. In the To PA Date field, enter the end date for the PA Date Range for within which you want the process to select draft revenues. If you leave this parameter blank, then the process selects all draft revenues having PA Dates after the date you enter in the From PA Date process parameter.

  8. In the Award Number field, select an award number for which you want to generate revenue accounting events. If you leave this parameter blank, then the process selects all draft revenue across all awards.

  9. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  10. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  11. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  12. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  13. Click OK to apply the parameters.

  14. Click Submit to send the request to the concurrent manager.

  15. View the request in the concurrent manager as follows:

    View - Requests

  16. Close the window.

GMS: Installment Closeout Notification Procedure

Note: A default value in the Offset Days field of the Parameters window can be set using the profile option GMS: Notification Offset Days.

To set profile options, see 1. Specify Site-Level and Application-Level Profile Options.

To run the GMS: Installment Closeout Notification process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Installment Closeout Notification from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Offset Days field, use the default value or enter the number of days from the current date that installments should end on.

    Note: The current date, or date on which the process is run, plus the number of Offset Days entered, add up to the end date of the installments for which notifications are sent.

    For example, if the current date is November 7 and the process is run with the number of Offset Days entered as 20, then notifications for all installments with an end date of November 27 will be sent.

  7. Click OK to apply the parameters.

  8. Click Submit to send the request to the concurrent manager.

  9. View the request in the concurrent manager as follows:

    View - Requests

  10. Close the window.

For information on Installment Closeout Notification, see Installment Closeout Notification.

GMS: Interface Invoices to Receivables Procedure

To run the GMS: Interface Invoices to Receivables process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Interface Invoices to Receivables from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the From Award Number field, select an award number from the list of values, or leave the field empty to select all eligible draft invoices for all awards.

  7. In the To Award Number field, select an award number from the list of values, or leave the field empty to select all eligible draft invoices for all awards.

  8. In the Reschedule Interval (Days) field, enter a number to indicate the number of days between automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  9. In the Reschedule Time of Day field, enter the time of day to automatically submit the report, or leave the field empty if automatic report submission is not in use.

  10. In the Stop Rescheduling Date field, enter the date to stop automatic submission of the report, or leave the field empty if automatic report submission is not in use.

  11. In the Adjust Dates When Rescheduling field, select Yes or No from the list of values, or leave the field empty if automatic report submission is not in use.

  12. Click OK to apply the parameters.

  13. Click Submit to send the request to the concurrent manager.

  14. View the request in the concurrent manager as follows:

    View - Requests

  15. Close the window.

GMS: Report Notification Scheduler Procedure

Note: A default value in the Offset Days field of the Parameters window can be set using the profile option GMS: Notification Offset Days.

To set profile options, see 1. Specify Site-Level and Application-Level Profile Options.

To run the GMS: Report Notification Scheduler process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Report Notification Scheduler from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Offset Days field, use the default value or enter the number of days from the current date that the report should be due on.

    Note: The current date, or date on which the process is run, plus the number of Offset Days entered, add up to the due date for all reports for which notifications will be sent.

    For example, if the current date is November 7 and the process is run with the number of Offset Days entered as 20, then notifications for all reports with a due date of November 27 will be sent.

  7. Click OK to apply the parameters.

  8. Click Submit to send the request to the concurrent manager.

  9. View the request in the concurrent manager as follows:

    View - Requests

  10. Close the window.

For information on Report Notification, see Report Notification Scheduler.

GMS: Report on Award Listings Procedure

To print the GMS: Report on Award Listings, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Report on Award Listings from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Organization Name field, select an organization from the list of values, or leave the field empty to select all organizations.

  7. In the Award Number field, select an award number from the list of values, or leave the field empty to select all awards.

    If an award number is selected, the Award Name field is automatically populated when the list of values is accessed.

  8. In the Award Name field, select an award name from the list of values, or leave the field empty to select all awards.

    If an award name is selected, the Award Number field does not need to be populated. If the award number selected from the list of values does not match the award name, the Award Name field is cleared and is populated with the award name that matches the selected award number when the list of values is accessed.

  9. In the Sponsor field, select a sponsor from the list of values, or leave the field empty to select all sponsors.

  10. In the Primary Member field, select a name from the list of values, or leave the field empty to select all investigators.

  11. In the Award Status field, select an award status from the list of values, or leave the field empty to select all statuses.

  12. In the Purpose field, select a purpose from the list of values, or leave the field empty to select all purposes.

  13. In the Start Date field, enter a date for the low end of the date range within which the process selects awards, or leave the field empty to select all awards having start dates before the date entered in the End Date field.

    Optionally, leave both the Start Date field and End Date field empty to select all awards.

  14. In the End Date field, enter a date for the high end of the date range within which the process selects awards, or leave the field empty to select all awards having end dates after the date entered in the Start Date field.

  15. Click OK to apply the parameters.

  16. Click Submit to send the print request to the concurrent manager.

  17. View the request in the concurrent manager as follows:

    View - Requests

  18. Close the window.

GMS: Report on Project Listings Procedure

To print the GMS: Report on Project Listings, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Report on Project Listings from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Organization Name field, select an organization from the list of values, or leave the field empty to select all organizations.

  7. In the Project Number field, select a project number from the list of values, or leave the field empty to select all projects.

    If a project number is selected, the Project Name field is automatically populated when the list of values is accessed.

  8. In the Project Name field, select a project name from the list of values, or leave the field empty to select all projects.

    If a project name is selected, the Project Number field does not need to be populated. If the project number selected from the list of values does not match the project name, the Project Name field is cleared and is populated with the project name that matches the selected project number when the list of values is accessed.

  9. In the Project Type field, select a type from the list of values, or leave blank to include all project types.

  10. In the Project Manager field, select a project manager from the list of values, or leave the field empty to select all project managers.

  11. In the Project Status field, select a project status from the list of values, or leave the field empty to select all statuses.

  12. In the Start Date field, enter a date for the low end of the date range within which the process selects projects, or leave the field empty to select all projects having start dates before the date entered in the End Date field.

    Optionally, leave both the Start Date field and End Date field empty to select all projects.

  13. In the End Date field, enter a date for the high end of the date range within which the process selects projects, or leave the field empty to select all projects having end dates after the date entered in the Start Date field.

  14. Click OK to apply the parameters.

  15. Click Submit to send the print request to the concurrent manager.

  16. View the request in the concurrent manager as follows:

    View - Requests

  17. Close the window.

GMS: Submit Interface Streamline Process Procedure

To run the program GMS: Submit Interface Streamline Process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Submit Interface streamline process from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Streamline Option field, select a streamline option from the list of values.

  7. In the Project Number field, select a project number from the list of values, or leave the field empty to select all projects.

  8. In the Through Date field, enter a date through which to process, or leave the field empty to use the current date as the Through Date.

  9. Click OK to apply the parameters.

  10. Click Submit to send the request to the concurrent manager.

  11. View the request in the concurrent manager as follows:

    View - Requests

  12. Close the window.

GMS: Unbilled Receivables Aging Procedure

To run the GMS: Unbilled Receivables Aging process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Unbilled Receivables Aging from the list of values.

  5. Click OK.

    The Parameters pop-up window appears.

  6. In the Effective Date field, enter the date. The report generated will age unbilled receivables backwards, starting from the date entered here and running until the start date is reached. The start date is the date entered for the Age Unbilled Receivables From parameter.

    To use the current date, leave the Effective Date field empty.

  7. In the Award Organization field, select an organization from the list of values.

    Note: All awards owned by the organization are grouped by their award manager. The Unbilled Receivables Aging Report displays summaries for each award manager.

    To select all organizations, leave the Award Organization field empty.

  8. In the Award Manager field, select an employee from the list of values or leave the field empty to select all award managers.

    Note: If you specify an award manager in the report parameters, but do not specify an organization, the report will group all awards by award manager, regardless of the award-owning organization. This option provides the real total of unbilled receivables for a particular award manager.

  9. In the Award Number field, select an award name from the list of values or leave the field empty to select all awards.

  10. In the Age Receivables From field, enter the date to be used when aging unbilled receivables.

  11. In the Number of Days in Buckets 1, 2, and 3 fields, enter the number of days intended for each bucket.

  12. Click OK to apply the parameters.

  13. Click Submit to send the request to the concurrent manager.

  14. View the request in the concurrent manager as follows:

    View - Requests

  15. Close the window.

GMS: Update Actual and Encumbrance Balance Procedure

To run the GMS: Update Actual and Encumbrance Balance process, perform the following steps.

  1. In Grants Accounting, navigate to the Submit Request window as follows:

    Reports - Run

    The Submit a New Request window appears.

  2. Select the Single Request radio button.

  3. Click OK.

    The Submit Request window appears.

  4. In the Name field, select GMS: Update Actual and Encumbrance Balance from the list of values.

  5. Click OK.

  6. Click Submit to send the request to the concurrent manager.

  7. View the request in the concurrent manager as follows:

    View - Requests

  8. Close the window.

Additional Processes and Reports

The following processes and reports in Oracle Projects can be used in Oracle Grants Accounting:

To run these processes and reports, see Processes, Oracle Projects Fundamentals.

For information about Oracle Subledger Accounting concurrent programs that you can run from an Oracle Grants Accounting Super User responsibility, see: Subledger Accounting Concurrent Programs, Oracle Projects Fundamentals.