Exporting Payment Application Codes

Users can export a payment application codes file from the system. This allows users of large Work Breakdowns (WB) to assign codes in an Excel spreadsheet and import those codes back to the system. Once a file is imported, the codes are associated with the correct budget line and item number.

To export payment application codes from the Grouping tab of the Assign Payment Application Codes page:

  1. Navigate to the Assign Payment Application Codes Page
  2. Select the Download new XLS file button.

    A dialogue box displays the name of the file.

  3. From the dialogue box, select the Open With Microsoft Excel (default) option, and select the OK button.
  4. In the open file, ensure each Work Breakdown (WB) line of the project includes:
    • Item Code
    • Item Code Description
    • Total Budget Amount
    • Assigned Codes.

    The file displays a column for each type of payment application code set up in the project:

    • Payment Application codes
    • Handling codes
    • Breakout codes.

      Missing an expected code type? 

      • Make sure you set up the payment application codes or breakout codes you need.
      • Remember, the ability to set up payment application codes depends on which documents you chose under Document Settings when you chose your project settings.

        Contact Oracle Support if you need help with this setting.

  5. Assign codes that are set up in the system:
    • Payment Application codes
    • Handling codes
    • Breakout codes.

Tips