Contract and Invoice Creation

Before beginning the Project Portfolio Management (PPM) process, please determine one of two factors, whether or not the generated invoices will be PPM contract based or created as singular AR (Receivables) invoices:

• Retail Operations: Billing module is suggested due to the volume of revenue activities
• Non‐Retail Operations: PPM Project Billing is suggested due to flexibility of setting up contracts with multiple projects and tasks. Note that recharge operations must use PPM Project billing for external revenue to reflect revenue with each service line/task.

If you determine that AR (Receivables) invoices are better suited to your needs, KBA KB0032814 provides instructions on Creating an Invoice in Receivables.

Whichever you determine, please be aware that ALL UCSD invoices must be created through Oracle (with the exception of student/patient receivables and sponsored projects-clinical trials which go through SPARCM and Oracle).

Please do not create your own invoices as it does not provide a means to match payments once received.

~~~

Once a user has determined that the PPM process is the best means of generating invoices, multiple steps must be completed before submitting the final invoice.

• A customer account must be established in Oracle (if one is not found, a new one must be created in CIPERB [you must have appropriate user roles to access application - please reference this Blink page for clarification])
• A project and corresponding task must be established in Oracle (if one does not exist, a new one must be created in PADUA)
• Once the customer & project are verified, the contract process can begin

The following links provide information for Oracle Customer Accounts:

1. KB0032171 - Customer Accounts in Oracle
2. Submit a request to Create New Oracle Customer
3. Submit a request to Edit Existing Oracle Customer
4. KB0035096 - How To Use The CIPERB Application For Customer Accounts in Oracle
5. KB0032971 - How to Search for a Customer

**The process of submitting the Create New Oracle Customer form and Edit Existing Oracle Customer form will be phased out by July 1, 2024**

The newly launched CIPERB: Customers, Invoices, Project Expenses Report & Billing application is replacing the current ticket system of requesting new/amended customer accounts.  Please attend a future training session for CIPERB to ask questions and receive guidance on this new application.

Register for one of the following sessions on the CIPERB blink page. 

Launch CIPERB: Customers, Invoices, Project Expenses Report & Billing

The following links provide information for Oracle Projects:

1. KB0033288 - Overview of Project Portfolio Management (PPM) with Attached PPM User Guide
2. KB0033940 - How to Update Project & Award Data Using PADUA
3. Submit an Oracle and Concur Role Request Form - UCSD PPM PADUA Write User JR

The following links provide information for Oracle PPM Contracts:

1. KB0032314 - How to Create a PPM Contract in Order to Bill External Customers
2. KB0033764 - How to Request PPM Project Budget and Contract Manager JR Role
3. KB0033755 - How to Request Roles for Billing Customers in PPM or AR (Standard Roles)
4. KB0033600 - How to Resolve PPM Contract Creation Error Messages (OKC-195742 and OKC-196156)
5. KB0033499 - PPM Contract Amendments

Events

The following links provide information for Oracle Contract Events:

1. KB0032314 - How to Create a PPM Contract in Order to Bill External Customers (Procedure B: Create an Event)
2. KB0032793 - How to Create a Project Portfolio Management (PPM) Billing Invoice in Oracle (Creating an Event)
3. KB0033499 - PPM Contract Amendments

Invoices

The following links provide information for Oracle Contract Invoices:

1. KB0033947 - How to Run the Generate Invoices Job
2. KB0032314 - How to Create a PPM Contract in Order to Bill External Customers (Procedure C: Invoicing)
3. KB0032793 - How to Create a Project Portfolio Management (PPM) Billing Invoice in Oracle (Creating an Invoice)
4. KB0033818 - Correcting Rejected Invoices
5. KB0033271 - Creating Credit Memo in Project and Portfolio Management (PPM) Invoice
6. KB0032208 - How to Claim Unidentified Payments (wires, ACHs & checks

Additional resources are available to ensure contracts are created with the correct data needed for proper accounting practices.

• Chart of Accounts Panorama in the BAH is designed to help you explore the UCSD Chart of Accounts and hierarchies:
  • COA Information
  • Entity
  • Standard Fund Hierarchy
  • FinU (Financial Unit)**
  • Standard Account Hierarchy
  • Function
  • Program
  • Location
  • Project
  • Activity
  • Interentity
  • Managerial Reporting Account Hierarchy
  • Managerial Reporting Fund Hierarchy

• KBA KB0034333: Accounts Receivable (AR) and Revenue Matrix for the Non-SP AR and PPM COA Billing Exception Reports
  • The Simplified AR and Revenue Matrix file linked from this article references which Unbilled and Billed accounts correspond to the correct Revenue account.

NOTE: When contracts are incorrectly setup, departments are required to go through the following steps to correct any COA mistakes on the contract

Contract Amendments/COA Corrections [MUST BE DONE IN ORDER]:

1. In CIPERB, switch customer account to "Paper" for preferred invoice delivery method
2. Issue credit memos for all invoices (get them submitted and approved), support portal KB0033271
3. Amend the contract with the necessary changes and get it approved (if the Revenue, Fund, Customer Account, and/or Contract Owning Organization [Financial Unit] needs to be corrected, this will require a NEW contract to be created in order to maintain one chartstring per contract*)  - Support Portal KB0033499
4. Generate new invoices to mirror old ones by creating new events (get them submitted and approved) - Support Portal KB0032793
5. Submit S&S ticket and provide a list if there are any payments received on old invoices to be transferred against newly created invoice/invoices
6. When all of the above have been completed, switch the customer account back to "Email" for preferred invoice delivery method in CIPERB
7. Continue to invoice for the contract as usual
   • KB0033271 : Creating Credit Memo in Project and Portfolio Management (PPM) Invoice
   • KB0033499 : PPM Contract Amendments
   • KB0032793 : How to Create a Project Portfolio Management (PPM) Billing Invoice in Oracle

 

*Contracts require an exclusive charstring to flow through all invoices on a single contract.

• The negative downstream impacts of amending chartstring elements (Revenue, Fund, Customer Account, Financial Unit/Organization) to contracts which cause more than one chartstring to be issued on a single contract cause multiple accounting issues and complicated cleanup projects.
• If new PPM invoices need to reflect a change in any of the chartstring segments, you can duplicate the existing contract, change the necessary elements, and create the new invoices as necessary to prevent further accounting issues.
• When submitting contract amendments, please note the reason in the Comments section to prevent amendment requests from being rejected.

PPM Contract/Event/Invoice Creation

Contract and Invoice Creation Recording 05.3.2023

Contract and Invoice Creation Recording 02.28.2024

Contract and Invoice Creation Recording 05.29.2024

Contract and Invoice Creation Recording 08.28.2024