5Integrating with Oracle Receivables

Oracle Receivables Integration Overview

You can configure Public Sector Compliance and Regulation to integrate with Oracle Receivables.

This enables your agency to generate miscellaneous receipts for payments received and handled by Public Sector Compliance and Regulation (PSCR), and send them to Oracle Receivables. In future releases, invoicing will be available through the integration between PSCR and Oracle Receivables.

Oracle Receivables Setup

Your Oracle Receivables setup determines the values that you’ll use when defining receivables options for PSCR. For more information on setting up Oracle Receivables, see Implementing Receivables Credit to Cash

Public Sector Compliance and Regulation Setup

You configure the integration within PSCR at three levels:

1. Agency

   Enable the integration with Oracle Receivables at the agency level. You add receivable receipt options to establish receipt methods and remittance names for the payment methods that your agency accepts. In addition, you define an agency-level receivable activity name. For more information on the agency-level setup, see Setting Up Agency Receivable Options.

2. Record Type

   Define the record type-level receivable activity name. For more information on the record type-level setup, see Setting Up Record Type Receivable Options.

3. Fee Item

   Define the fee item-level receivable activity name. For more information on the fee item-level setup, see Setting Up Fee Item Receivable Options.

Miscellaneous Receipt Creation

When the integration is enabled at the agency level, PSCR automatically generates a miscellaneous receipt for each payment line associated with a processed payment and sends it to Oracle Receivables.

Note: PSCR will not create miscellaneous receipts for any migrated payment data or payments processed before the integration was enabled.

PSCR assigns a receipt method and remittance name to each receipt based on the receipt options defined for each payment method at the agency level. It assigns a receivable activity name based on the following hierarchy:

1. If a receivable activity name is defined for a fee item and record type then PSCR assigns that value when creating miscellaneous receipts for all payment history lines that have the same fee item and record type. It ignores receivable activity names defined at the record type or agency level.

2. If a receivable activity name is defined for a fee item and all record types then PSCR assigns that value when creating miscellaneous receipts for all payment history lines that have the same fee item. It ignores receivable activity names defined at the record type or agency level.

3. If a receivable activity name is defined for a record type then PSCR assigns that value when creating miscellaneous receipts for all payment history lines that have same record type. It ignores receivable activity names defined at the agency level.

4. The receivable activity name defined for an agency is the default value that PSCR assigns to payment history lines that don’t match receivable options defined at the record type or fee item level.

PSCR uses the payment reference ID to create the miscellaneous receipt numbers that it passes to Oracle Receivables. It strips out the four-letter and underscore prefix, and appends an underscore and number for each payment history line associated with the payment reference ID. For example, for the payment reference ID DRCD_20201029T143300767Z640574, which includes two payment history lines, PSCR would pass two receipt numbers: 20201029T143300767Z640574_1 and 20201029T143300767Z640574_2.

If there’s a problem with your integration setup for a payment, PSCR gives it a Receivables Receipt Statusof Error. Once you correct the source of the error, you can go to the Payment History Details page for the payment and generate the miscellaneous receipt manually. For more information, see Viewing Payment History.

Setting Up Agency Receivable Options

Define how your agency integrates with Oracle Receivables using the Receivable Options for Agency page..

Define Agency Level Receivable Options

1. Select Billing Setup > Agency Receivable Options.

2. Select the row for your agency.

   This example shows the Receivable Options for Agency page.

   

3. Enter values for the following fields:

   Page Element	Description
   Receivables System	Select your Oracle Receivables system.
   Organization ID	Enter the Oracle Receivables organization ID associated with your agency.
   Payment Term, Invoice Transaction Type, Credit Memo Transaction Type, Memo Line Identifier	Enter your invoicing information. Note: These fields are required even though invoicing integration is not currently available.
   Enabled	Turn on this switch to enable the integration between PSCR and Oracles Receivables. When this switch is off, PSCR processes all received payments using normal accounting.
   Receivable Activity Name	Enter the default receivable activity name that PSCR assigns to payments that don’t match receivable options defined at the record type or fee item level. Make sure that this value matches the value defined in Oracle Receivables exactly.
   On Account Receivable Activity Name	Enter the receivable activity name that PSCR assigns to overpayments. All overpayments for the agency are assigned the same receivable activity name and do not have receivable options set at the record type or fee item level.
   Refund Receivable Activity	Enter the receivable activity name that PSCR assigns to refunds. All refunds for the agency are assigned the same receivable activity name and do not have receivable options set at the record type or fee item level. Note: PSCR generates negative miscellaneous receipts for refunds.

4. Add receivable receipt options for your payment methods.

5. Click Save.

Adding Receivable Receipt Options

Define a set of receivable receipt options for each payment method that your agency supports.

1. On the Receivable Options for Agency page, click Add.

   This example shows the Receivable Receipt Options page.

   

2. Enter values for the following fields:

   Page Element	Description
   Receivables System	Select your Oracle Receivables system.
   Payment Method	Select the payment method you are defining receipt options for.
   Receipt Method Name and Receipt Account Name	Enter the receipt method name and receipt account name passed to Oracle Receivables for the selected payment method. Note: Make sure that the values you enter match the values defined in Oracle Receivables exactly.

3. Click Save.

Modifying Receivable Receipt Options

1. On the Receivable Options for Agency page, select the row that you want to modify.

2. On the Receivable Receipt Options page you can:

   • Edit the receivable receipt options fields.

   • Delete the receipt options. You will be prompted to confirm the permanent deletion.

3. Click Save.

Deleting Receivable Receipt Options

1. On the Receivable Options for Agency page, click Select Multiple.

2. Select the check boxes next to all the rows that you want to delete.

3. Click Delete. You will be prompted to confirm the permanent deletion.

Setting Up Record Type Receivable Options

Configure your integration with Oracle Receivables at the record type level.

Use the Receivable Options for Record Types page to define the receivable information that Public Sector Compliance and Regulation (PSCR) assigns to specific record types. For more information on the hierarchy used to determine the receivable activity name for payment history lines, see Oracle Receivables Integration Overview.

To access this page select Billing Setup > Record Type Receivable Options.

Adding Receivable Options for a Record Type

1. On the Receivable Options for Record Types page, click Add.

   This example shows the Receivable Options for Record Types details page.

   

2. Enter values for the following fields:

   Page Element	Description
   Classification	Select the offering that the record type receivable options apply to. Values may include: LIC (Business Licenses) PMT (Permits) PZ (Planning and Zoning) CE (Code Enforcement)
   Record Type	Select the specific record type to which these receivable options apply.
   Payment Term and Memo Line Identifier	Enter an invoicing payment term and memo line identifier. Note: These fields are required even though invoicing integration is not currently available.
   Receivable Activity Name	Enter the receivable activity name that PSCR assigns to payments with the selected record type when sending information to Oracle Receivables. Make sure that this value matches the value defined in Oracle Receivables exactly.

3. Click Save.

Modifying Receivable Options for a Record Type

1. On the Receivable Options for Record Types page, select the record type receivable options that you want to modify.

2. On the Receivable Options for Record Types details page you can:

   • Edit the receivable options fields.

     Note: You cannot change the value of the Classification and Record Type fields.

   • Delete the receivable options defined for the record type. You will be prompted to confirm the permanent deletion.

3. Click Save.

Deleting Receivable Options for a Record Type

1. On the Receivable Options for Record Types page, click Select Multiple.

2. Select the check boxes next to all the rows that you want to delete.

3. Click Delete. You will be prompted to confirm the permanent deletion.

Setting Up Fee Item Receivable Options

Configure your integration with Oracle Receivables at the fee item level.

Use the Receivable Options for Fee Items page to define the receivable information that Public Sector Compliance and Regulation (PSCR) assigns to specific fee items. For more information on the hierarchy used to determine the receivable activity name for payment history lines, see Oracle Receivables Integration Overview.

To access this page select Billing Setup > Fee Item Receivable Options.

Adding Receivable Options for a Fee Item

1. On the Receivable Options for Fee Items page, click Add.

   This example shows the Receivable Options for Fee Items details page.

   

2. Enter values for the following fields:

   Page Element	Description
   Classification	Select the offering that the fee item receivable options apply to. Values may include: LIC (Business Licenses) PMT (Permits) PZ (Planning and Zoning) CE (Code Enforcement)
   All Record Types	Turn this switch on to apply the receivable options to this fee item for all record types.
   Record Type	Select the specific record type to which these fee item receivable options apply. This field is unavailable if you turn on the All Records Types switch.
   Fee Item ID	Select the fee item to which the receivable options apply.
   Memo Line Identifier	Enter an invoicing memo line identifier. Note: This field is required even though invoicing integration is not currently available.
   Receivable Activity Name	Enter the receivable activity name that PSCR assigns to payments with the selected fee item when sending information to Oracle Receivables. Make sure that this value matches the value defined in Oracle Receivables exactly.

3. Click Save.

Modifying Receivable Options for a Fee Item

1. On the Receivable Options for Fee Items page, select the fee item receivable options that you want to modify.

2. On the Receivable Options for Fee Items details page you can:

   • Edit the receivable options fields.

     Note: You cannot change the value of the Classification field.

   • Delete the receivable options defined for the fee item. You will be prompted to confirm the permanent deletion.

3. Click Save.

Deleting Receivable Options for a Fee Item

1. On the Receivable Options for Fee Items page, click Select Multiple.

2. Select the check boxes next to all the rows that you want to delete.

3. Click Delete. You will be prompted to confirm the permanent deletion.