1. Implementing Channel Revenue Management
  2. Time Zones in Channel Revenue Management

Time Zones in Channel Revenue Management

Here you will understand how to configure time zones in Channel Revenue Management.

The channel application takes into consideration these time zones:

  • Server time zone: The time zone configured on the application server. In the case of cloud servers, this time zone is set as Coordinated Universal Time (UTC).

  • Legal entity time zone: The time zone in which the business unit's legal entity exists. This is defined as part of the legal address linked to the legal entity. If you want the transactions to be accounted for in this time zone, you must select the legal entity time zone check box in the legal entity definition.

All dates in Channel Revenue Management use the legal entity time zone for the business unit. If the legal entity time zone is not set, then the application uses the UTC (Coordinated Universal Time).

Important Considerations

Before commencing enablement for the legal entity time zone feature, there are implementation considerations that need to be taken into account. Consider if your server time zone is different than your legal entity time zone.

Note: Existing dates in channel programs, claims, adjustments and transactions will remain unchanged after the upgrade. The dates in existing programs, claims, adjustments and transactions will be treated as being in the legal entity time zone. Hence, a supplier claim may have older accruals with accrual date in the server time zone and newer accruals in the legal entity time zone.

For Deductions and Settlement:

  • Existing dates stamped in server time zone by Channel in existing claims and set ups will be treated as in the legal entity time zone.
  • New claims and their processing are treated in the legal entity time zone.

For Supplier Channel Management:

  • Existing dates stamped in server time zone by Channel in existing programs, accruals, adjustments and claims will be treated as in the legal entity time zone.
  • New inbound transactions and new processing are treated in the legal entity time zone, including CSV uploads. So consider the business processes around the preparation of inbound transactions, as imported dates will be treated in the legal entity time zone.
  • There are 2 exceptions for purchase order related dates:
    • Requested Delivery Date and Requested Ship Date are displayed in Channel, as they were entered in the PO. Purchase Order does not capture a time zone for these dates. Channel will process these dates as is without any conversions.
    • The processing of the dates within the eligibility service REST will be in the legal entity time zone. However, all dates returned by the eligibility service REST are in Coordinated Universal Time (UTC).

Set Up Legal Entity Time Zones

To enable legal entity time zone, perform the following steps.

  1. With roles having the required access, Opt-in to the Use the Legal Entity Time Zone in Channel Revenue Management feature.
    Note: Currently, this opt-in feature is a temporary opt-in. The opt-in will become mandatory from Release 22D.
  2. With roles having the required access, navigate to the Setup and Maintenance work area. Click Tasks and search for the Manage Administrator Profile Values task. In the Profile Option Code field, query for the option XLE_ENABLE_LEGAL_ENTITY_TIMEZONE with Enable Legal Entity Time Zone as the Profile Option Display Name.
  3. In the Profile Values record, add a new row, and enter the following information:
    • Profile Level - Set the profile level to Site. Don't use any other level because it would result in inconsistent data in Channel Revenue Management.
    • Profile Value - Set the profile value to Yes to enable the legal entity time zone in Channel Revenue Management.
    Note: It is recommended that you don't update the profile option once you have set it to Yes.
  4. With roles having the required access, navigate to the Setup and Maintenance work area:
    • Offering: Order Management
    • Functional Area: Legal Structures
    • Task: Manage Legal Entity
  5. On the Scope dialog box, select Search Legal Entities, and click Apply and Go to Task.
  6. On the Manage Legal Entities page, search for and select the legal entity you require, and select Edit from the Actions menu.
  7. In the Legal Entity Addresses section on the Edit Legal Entity page, select the Primary address. Select Edit address from the Actions menu, and in the Edit Address dialog, select the Time Zone for the primary legal entity.

Channel Revenue Time Zones

This table describes how Channel handles and processes various dates in the application.

How Channel Uses Dates From Displayed and Processed as LETZ Additional Information
Programs, Accruals, Claims, and Adjustments User Interface Yes All user enterable dates are in the legal entity time zone. By default, the current date with time is converted to the legal entity time zone.
REST (except eligibility) Yes All dates passed to the REST are assumed to be in the LE time zone. By default, the current date with time is converted to the legal entity time zone. All functional dates returned by REST should be in LE time zone. WHO column dates should be in the server time zone.
ESS Scheduled Processes
  • Create Accruals Scheduled Process
  • Create Accruals for Channel Batch Scheduled Process
  • Create Accruals for Volume Programs Scheduled Process
  • Generate Supplier Claims Scheduled Process
  • Settle Supplier Claims Scheduled Process
  • Mass Settle Scheduled Process
 Yes By default, the current date with time is converted to the legal entity time zone.
WHO Columns No WHO column dates always use the server time zone.
Descriptive Flexfield Attributes No No conversion is applicable to date and datetime attributes.
FSM UI No For FSM UI using the Reference Set, the start and end dates must be in reference to the respective transaction using it. WHO columns continue to use the server time zone. There is no impact on the following items:
  1. User Statuses
  2. Program Types
  3. Adjustment Types
  4. Claim Types
  5. Claim Reasons
  6. Claim Sources
All dates in CSVs Yes
Order Management:

  • Ordered Date

  • Requested Ship Date

 Yes The Ordered Date and the Requested Ship Date are datetime attributes and they are in UTC. Channel converts these dates to the legal entity time zone and passes this information to the eligibility service.
Procurement

  • Purchase Order Date

  • Requested Delivery Date

  • Requested Ship Date

 Yes The Purchase Order Date, the Requested Delivery Date, and the Requested Ship Date are datetime attributes and they are in UTC. Channel converts these dates to the legal entity time zone and passes this information to the eligibility service.
Inventory Management

  • Receipt Transaction Date

  • Shipped Date

 Yes The Receipt Transaction Date and the Shipped Date are datetime attributes and they are in UTC. Channel converts these dates to the legal entity time zone and passes this information to the eligibility service.