Defining an Offset Request Type

Prerequisites

To define an offset request type, you should have:

  • Offset request type business objects defined in the application

  • Offset request business objects defined in the application

  • Adjustment types defined in the application (where the A/P Request Type Code field is not set to REFUND)

  • Default offset amount algorithm defined using the C1-OFST-AMT algorithm type

  • Required To Do role assigned to the C1-OFSRQ and C1-OFSSB To Do types in the application

  • Required match type entity specified in the Match Type Entity (Valid Values: BILL, BSEG, SA) parameter of the C1-OFST-DIST algorithm

Procedure

To define an offset request type:

  1. Click the Admin link in the Application toolbar.
    A list appears.
  2. From the Admin menu, select O and then click Offset Request Type.
    A sub-menu appears.
  3. Click the Add option from the Offset Request Type sub-menu.

    The Offset Request Type screen appears. It contains the following sections:

    • Main - Used to specify basic details about the offset request type.

    • Characteristics - Used to define the characteristics for the offset request type.

    The Main section contains the following fields:

    Field Name Field Description Mandatory (Yes or No)
    Offset Request Type Used to specify the offset request type. Yes
    Business Object Indicates the business object using which you are defining the offset request type. Not applicable
    Description Used to specify the description for the offset request type. Yes
    Offset Request Business Object Used to indicate the business object using which you want to create the respective offset request. Yes
    Detailed Description Used to specify additional information about the offset request type. No
    Status Used to indicate the status of the offset request type. The valid values are:

    • Active

    • Inactive

    Note: You cannot change the status of an offset request type to Inactive when the corresponding offset request is in a status other than Processed, Rejected, or Unapplied Offset.
    		 Yes
    Offset Category Used to indicate the category of the offset request type. The valid values are:

    • Auto Maintenance - The auto maintenance offset requests are automatic offset requests. You can create an auto maintenance offset request using an offset request type where the offset category is set to Auto Maintenance.

    • Regular - The regular or traditional offset requests are manual offset requests. You can create a manual offset request using an offset request type where the offset category is set to Regular.

    Note: By default, the Regular option is selected.
    		 Yes
    Adjustment Type Used to indicate the adjustment type using which transfer or offset adjustments should be created. By default, the specified adjustment type appears when you create an offset request. You can then change the adjustment type, if required, while editing an offset request.
    Note:

    The Search (The Search Icon) icon appears corresponding to the Adjustment Type field. On clicking the Search icon, the Adjustment Type Search window appears.

    On specifying the adjustment type, the description of the adjustment type appears corresponding to the Adjustment Type field.

    You can only specify an adjustment type where the A/P Request Type Code field is not set to REFUND.

    		 Yes
    Default Offset Amount Algorithm Used to attach an algorithm using which you want to calculate default offset amount while adding a bill in an offset request.
    Note:

    The Search (The Search Icon) icon appears corresponding to the Default Offset Amount Algorithm field. On clicking the Search icon, the Algorithm Search window appears.

    On specifying the algorithm, the description of the algorithm appears corresponding to the Default Offset Amount Algorithm field.

    You must specify an algorithm which is created using the C1-OFST-AMT algorithm type in the Default Offset Amount Algorithm field.

    		 Yes
    Defer Processing FT Count Used to indicate whether an offset request must be processed in the deferred mode or in real time (i.e. immediately). If the number of financial transactions created for the bills which are selected in the offset request exceeds the defer processing count, the system will process the offset request in the deferred mode. However, if the number of financial transactions created for the bills which are selected in the offset request does not exceed the defer processing count, the system will process the offset request in real time (i.e. immediately).
    Note:

    You cannot specify a negative value in this field.

    Deferred mode means in the background when the Offset Request Periodic Monitor (C1-OFSRQ) batch is invoked. You can configure the Offset Request Periodic Monitor (C1-OFSRQ) batch such that it is executed at regular intervals. For more information about the Offset Request Periodic Monitor (C1-OFSRQ) batch, refer to Oracle Revenue Management and Billing Batch Guide.

    If you set the defer processing count to zero (0), the system resets the default value to 50.

    		 No
    Approval Required Used to indicate whether approval is required while offsetting bills through an offset request. No
    Approval To Do Type Used to indicate that To Do entry of the specified To Do type must be created when you submit an offset request for approval.
    Note:

    The Search (The Search Icon) icon appears corresponding to the Approval To Do Type field. On clicking the Search icon, the To Do Type Search window appears.

    On specifying the To Do type, the description of the To Do type appears corresponding to the Approval To Do Type field.

    This field appears when the Approval Required option is selected.

    The C1-OFSRQ To Do type is shipped with the product. You can use the C1-OFSRQ To Do type or a custom To Do type, if required.

    		 Yes (Conditional)
    Note: This field is required when the Approval Required option is selected.
    Approval To Do Role Used to indicate that users with the specified To Do role can only approve an offset request submitted for approval.
    Note:

    The list includes only those To Do roles which are associated with the approval To Do type.

    This field appears when the Approval Required option is selected.

    		 Yes (Conditional)
    Note: This field is required when the Approval Required option is selected.
    Submitter To Do Type At present, the submitter To Do type is not used to create To Do entry when the approver rejects an offset request. It is only used to fetch the roles associated with the submitter To Do type.
    Note:

    The Search (The Search Icon) icon appears corresponding to the Submitter To Do Type field. On clicking the Search icon, the To Do Type Search window appears.

    On specifying the To Do type, the description of the To Do type appears corresponding to the Submitter To Do Type field.

    The C1-OFSSB To Do type is shipped with the product. You can use the C1-OFSSB To Do type or a custom To Do type, if required.

    		 Yes (Conditional)
    Note: This field is required when the Approval Required option is selected.
    Submitter To Do Role Used to indicate that users with the specified To Do role cannot approve an offset request submitted for approval.
    Note: The list includes only those To Do roles which are associated with the submitter To Do type.
    		 Yes (Conditional)
    Note: This field is required when the Approval Required option is selected.
    Bill Search Period Used to specify the maximum search period (in days) that you want to allow while searching bills in an offset request.
    Note:

    If you do not specify any value, by default, it is set to 30.

    If you specify a date range that exceeds the maximum search period, the system will not you to search and add bills in the offset request.

    		 No
    Transfer Adjustment Used to indicate whether transfer adjustments should be created while offsetting bills through an offset request.
    Note:

    By default, the Transfer Adjustment option is selected.

    This impacts the system performance when the match type entity is set to BSEG and volume of bill segments in the selected bills is high. Alternatively, the system enables you to create offset adjustments while offsetting bills through an offset request whenever the volume of bill segments in the selected bills is high. To create the offset adjustments while offsetting bills through an offset request, you need to ensure that the Transfer Adjustment option is not selected in the respective offset request type.

    		 No
    Bill Line Items Level Offset Used to indicate the following:

    • Whether a debit bill with a credit line item as a credit bill should be considered while offsetting through an offset request

    • Whether a bill with zero balance having debit and credit line items should be created in an offset request

    Note: If you select the Bill Line Items Level Offset option, you need to ensure that Match Type Entity (Valid Values: BILL, BSEG, SA) parameter in the C1-OFST-DIST algorithm (which is attached to the Creating Adjustment status in the lifecycle of the C1-OffsetRequest business object) is set to BSEG.
    		 No
    Tip: Alternatively, you can access the Select Business Object screen by clicking the Add button in the Page Title area of the Offset Request Type screen.
  4. Enter the required details in the Main section.
  5. Define characteristics for the offset request type, if required.
  6. Click Save.
    The offset request type is defined.

Related Topics

For more information on... See...
Offset Request Type screen Offset Request Type
How to define a characteristic for an offset request type Defining a Characteristic for an Offset Request Type
C1-OFST-AMT algorithm C1-OFST-AMT