How to Create a PPM Contract in Order to Bill External Customers


Overview

This article demonstrates how to create a PPM Contract in order to bill external customers.

Essential Information

Next Steps 

Procedure A: Set up a Contract

  1. Log into Oracle Financials Cloud (OFC) using single sign-on.
  2. Select Projects and Awards, then click on Contracts.
  3. On the right-hand side, click on the Tasks icon for the drop-down menu, under Contracts, select Manage Contract Templates.
  4. To create a Service Agreement, which is for department use.
    1. Search using the following method:
      1. in Template Number, enter "Service" and then click Search.
    2. Under Search Results, highlight the Service Agreement line.
    3. Click on Actions and select Create Contract from Template.
    4. In the Create Contract from Template dialog box, open the Primary Party drop-down and select Search.
    5. Enter the customer Name or Party Number and select Search, highlight the desired customer and select OK.
    6. Start Date will default to today’s date, change it as needed.
    7. Enter an End Date, even though it is not required with an asterisk *
      1. You will get an error if an End Date is not entered.
      2. If this is available in the contract, it must be entered into the system.
    8. Click OK
  5. Navigate to the Overview tab.
    1. The Name will default to Service Agreements.
    2. Under Additional Information, enter the Revenue Account that the Contract should collect Revenue on and the Fund Number that the contract revenue should post to; if unknown, use the Search function from the drop-down.
      1. Gifts revenue 480000 should NOT be used.
      2. Gifts funds (beginS with an alphanumeric) should NOT be used i.e. E4500, J5070, L5147.
      3. The following Funds will also be rejected: 13991, 13992, 20000, 20400, 20700.
    3. Click Save on the top.
  6. Navigate to the Billing tab.
    1. Enter the Contract Organization, which is the UCSD department.
    2. In Transaction Type, enter PA Invoice, you will have to search for the words "PA Invoice."
    3. If a recurring PO Number is provided by the customer that is to be stated on every customer Invoice, enter PO Number.
    4. Under the Bill Plans section, a default Bill Plan will already be created, complete the following segments:
      1. Bill Plan
        1. Name (rename if desired)
        2. Method Name: Amount Based Invoice
        3. Invoice Method Classification: Amount Based
      2. Customer Information
        1. Bill-to Account Number
        2. Bill-to Contact (required to prevent contract exceptions)
        3. Bill-to Site
      3. Invoice Information
        1. Billing Cycle (almost always select Immediate to generate invoices immediately upon creation)
        2. Payment Terms
      4. Invoice Grouping Options
        1. Invoice Grouping: Associated project (required to make the proper Event Types available in Events [Milestone, Fee, Other])
      5. Invoice Summarization Options
        1. Labor Format: UCSD Labor
        2. Nonlabor Format: UCSD Nonlabor
        3. Event Format: UCSD Events
        4. Save
      6. Associated Contract Lines
        1. Select + Sign
        2. Search, then highlight the Bill Plan Number at the bottom
        3. Select Submit
      7. Save and Close
    5. Under the Revenue Plans section, a default Revenue Plan will already be created, complete the following segments:
      1. Revenue Plan
        1. Name (rename if desired)
        2. Method Name: Amount Based Revenue
        3. Revenue Method Classification: Amount Based
        4. Press Save
      2. Associated Contract Lines
        1. Select + Sign
        2. Search, then highlight the Revenue Plan Number at the bottom
        3. Select Submit
      3. Save and Close
    6. DO NOT add any Billing Resources to the Billing Controls segment.
    7. Click on Save
  7. Navigate to the Lines tab.
    1. Navigate to the Overview mini-tab.
      1. Update Line Name as desired.
      2. Enter Line Amount, Estimated Variable Consideration Amount, and Standalone Selling Price with the dollar amount of the Contract.
      3. Contracts may NOT have a $0.00 line amount.
      4. Click on Save
    2. Navigate to the Billing mini-tab.
      1. Confirm that Bill Plan and Revenue Plan fields are populated and accurate (if not, add them from the drop-down menus).
      2. (Enter the same PO Number if entered in the Billing main tab).
      3. DO NOT add any Billing Resources to the Billing Controls segment.
      4. To add Sales Tax under Tax Control section, select the necessary code under Classification Code drop-down (separate Contract Lines will be required if there are taxable and non-taxable Events). The corresponding sales and use tax rates to use throughout San Diego County and city exceptions* are as follows:
      5. San Diego County tax rate 7.75% - US775
      6. Vista and El Cajon tax rate 8.5% - US825
      7. La Mesa tax rate 8.50% - US850
        1. National City tax rate 8.75% - US875

          * For example, if services are rendered or goods are picked up in the city of El Cajon, the local tax rate of 8.25% applies.

    3. Navigate to the Associated Projects mini-tab.
      1. Click on the + sign, then enter the following:
        1. Project Name which will auto-populate Project Number.
        2. Task Name
        3. Funded Amount
  8. Navigate to the Parties tab.
    1. Confirm your Customer and Supplier names.
    2. In the Accounts section, complete the following which is required even though they do not have an asterisk *
      1. Bill-to Account Number
      2. Bill-to Site
      3. Ship-to Account Number (search by Bill-to Account number)
      4. Ship-to Site
      5. Click on Update Lines
      6. Enter a Bill-to Contact if the field is empty, then click the Update button.
  9. Click on Save, then Submit.
    1. Submit to Approvers
    2. If there are no validation errors, click Next to continue.
    3. If the option to click Next is not available or if you can not move forward, recheck that all required fields above are populated.
    4. Use the drop-down to Save and Close.
  10. Make a note of generated Contract Number which is needed to create Event and Invoice.

Project Administration will Review and Approve, approval could be up to 72 hours, once approved, it will become an active Contract. If you encounter any error messages during the contract creation process, please refer to KBA KB0033600: How to Resolve PPM Contract Creation Error Message (OKC-195742 and OKC 196156).

Procedure B: Create an Event

In order to create an Invoice, an Event must be first created. An Event can not be put on multiple Invoices, but an Invoice can have multiple Events.

  1. Select Projects and Awards, then click on Contract Invoices.
  2. On the right-hand side, click on the Tasks icon for the drop-down menu, in Review and Adjust, select Manage Events.
  3. In the Search Results, click on the + sign to create a new Event, enter the following:
    1. Business Unit with "UCSD Campus"
    2. Contract Number
    3. Contract Line
    4. Event Number is automatically assigned.
    5. Event Type must be:
      1. Milestone -  Event to invoice and recognize revenue for a specified amount based on a milestone.
      2. Fee - Event to invoice and recognize revenue for fees earned.
      3. Other - Event to invoice and recognize revenue for a specified amount.
    6. Description amend description as needed.
      1. To create multiple Invoice Lines, each Event Description must be unique; otherwise, multiple Events with the same Description will generate under ONE Invoice line.
        1. Event 1 Description: Testing for nail growth in mice.
        2. Event 2 Description: Testing for nail growth in hamsters.
    7. Completion Date
      1. If a future date is entered, the invoice will not generate until that date
      2. Completion date must be within the contract start/end dates in order for an invoice to generate
    8. Amount in Bill Transaction Currency is the amount of the Invoice.
    9. Project Name
    10. Project Number
    11. Transaction Task Name
    12. Transaction Task Number and Associated Task Name: populates from Task Name.
    13. In the Additional Information section, multiple services can be entered to display on the final invoice (the following fields are all optional).
      1. Customer PO
      2. Customer Contact
      3. UOM (Unit of Measurement) i.e. EA, box, pound, etc. or can be left blank.
      4. Quantity (the Quantity x Unit Price must match the Amount in Bill Transaction Currency as the system will not auto check the calculations, which may result in sending incorrect invoices to the customer).
      5. Unit Price (this field allows up to 4 decimal digits to be referenced to provide more granularity in the AR invoice i.e. 306.1979).
  4. Click Save and Close > Done
  5. From here, a Draft Invoice is created 3x a day at 6:00am, 10:00am, and 2:00pm during business hours or users have the option to run the KB0033947: Generate Invoices Job (referenced in the next section).

Procedure C: Invoicing

System Generated Invoices

  1. Retrieve the Draft Invoice
    1. Click on the Contract Invoices module, which opens to the Overview tab.
    2. Under the Invoice Processing Status section, click on the Draft Invoices tab (see screenshot below).
    3. Click on the Filter icon, and you can search by entering the Contract Number to find the Draft Invoice.
    4. Select the desired Draft Invoice hyperlink.
    5. On the Invoice Overview tab, review and make changes as needed, make sure to click on Save when making changes.
    6. To add attachments to the Invoice, select Show More.
      1. Next to Attachments None, select the + sign, and add the desired documents on the popup screen, and select OK.
  2. Submit the Invoice for Approval, the status will stay in draft until it is submitted to Project Administration for Review/Approval.

Invoice Status is Submit

What to expect after you submit an invoice

FAQ's

Q: When is Revenue generated/shows on the ledger?

A: Revenue is generated if the Event's Completion Date is within the Contract Start & End dates, and the Revenue Plan is set to "Amount Based"

Q: How do I know if the system (Oracle) has sent the customer the invoice?

A:

  1. There is a report stating when the invoice is "accepted" and then sent
  2. To know if Oracle "Sent" the invoice form the UI, the following "Delivery Method" components of the report should be:

Supplemental Guides

Questions?

If you need any additional assistance, please submit a ticket here.