Create Accruals for Channel Batch

Use the Create Accruals for Channel Batch scheduled process to check eligibility of the channel document transactions and creates channel program accrual entries for the eligible transactions.

A supply chain application administrator can create the channel accruals on demand or schedule it as a batch process on a periodic basis.

Supplier Rebate Transactions

If the channel setting Event for Triggering Supplier Rebate Accrual is Receiving Transaction, then if the batch line is eligible, then creates accruals.

If the channel setting Event for Triggering Supplier Rebate Accrual is Supplier Invoice, then Channel receives the supplier invoices directly from Payables, or are imported using CSV files.

  • If the batch line is eligible but not invoiced, then creates open accruals.
  • If eligible and invoiced, then creates earned accruals.

For example, a receiving transaction for a quantity of 10 units can be invoiced for a quantity of 8 units. Here, open accruals will be recorded for a quantity of 2 units and earned accruals will be recorded for 8 units.

Customer Rebate Transactions:

It creates earned accruals for eligible sales invoices imported using CSV files.

When to Use

Use the Create Accruals for Channel Batch process to create accruals for supplier rebate programs and customer rebate programs.

Batches for processing of supplier rebate transactions are created by either of the following:

  • Receiving transactions from Oracle Receiving or supplier invoices from Oracle Payables, loaded into Channel Revenue Management using the Load Transactions process. Each successful run of the Load Transactions process creates a new batch.
  • Supplier invoices imported into Channel Revenue Management using CSV files. Each successful import creates a new batch.

Batches for processing of customer rebate transactions are created by the following:

  • Sales invoices imported into Channel Revenue Management using CSV files. Each successful import creates a new batch.

Privileges Required

  • Create Accruals for Channel Batch (CJM_CREATE_ACCRUALS_FOR_CHANNEL_BATCH_PRIV)

Specifications

Use these specifications when you run the scheduled process.

Specification Description
Job Type Scheduled
Frequency You are encouraged to schedule the process to run once per day. The frequency of scheduling should be determined by how often you load transactions or import transaction data.
Time of Day Any time, even though it is recommended to run this process during off-peak hours.
Duration Varies depending on parameters selected and the volume of data to be processed.
Compatibility There should be only one instance of the job running at any point of time for a specific business unit.

Parameters

Parameter Optional or Required Description Parameter Value Special Combinations Required Notes
Business Unit Required The business unit for filtering the channel document transactions. Business units to which the user has access. None N/A
Batch Transaction Type Optional

The transaction type for which you're creating accruals.

  • Oracle Fusion Receiving Transaction To create accruals from receiving transactions through direct integration with Oracle Fusion Receiving. The transactions are first loaded into Channel Revenue Management using the Load Transactions process.
  • Supplier Invoice: To create accruals from supplier invoices imported into Channel Revenue Management using CSV files.
  • Sales Order: To create accruals from sales invoices imported into Channel Revenue Management using CSV files.
  • Oracle Fusion Invoiced Sales Order: To load data from Receivables and Order Management for sell side flows.
Oracle Fusion Receiving Transaction

Supplier Invoice

Sales Order

None N/A
Batch Number Optional The batch number from the Load Transactions process or the CSV import, which loaded the channel transaction documents. You can also view this on the Manage Batches page. You can use the Batch Name and Batch Date to find the Batch Number. N/A None N/A
Number of Processes Optional The number of child processes. If it isn't specified, it defaults to 2 child processes. N/A N/A N/A

Troubleshooting Information

  • You can view the status of the Create Accruals for Channel Batch process in the Scheduled Processes work area.
  • The validation errors and warning messages are displayed in the error log.
  • Any interactive warning validations are NOT performed.
  • When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes work area.