FutureRetailRollupBatch Does Not Use Correct Logical Unit Of Work

(Doc ID 2320370.1)

Last updated on OCTOBER 26, 2017

Applies to:

Oracle Retail Price Management - Version 14.0.1 and later
Information in this document applies to any platform.

Symptoms


The FutureRetailRollupBatch reads and prints out the values for number of threads and logic unit of work for the parameter in RPM_BATCH_CONTROL for "com.retek.rpm.batch.FutureRetailRollupBatch" however,it does not correctly use it.

Steps to reproduce :

  1. Set a distinctive value for program_name = 'com.retek.rpm.batch.FutureRetailRollupBatch'
    • UPDATE RPM_BATCH_CONTROL SET THREAD_LUW_COUNT=7 WHERE program_name = 'com.retek.rpm.batch.FutureRetailRollupBatch'
  2. Run FutureRetailRollupBatch.Observe the program prints out the value used:
    • Attempting to execute using 10 threads with 7 units
  3. Observe the number of threads used in the database for the bulk cc id .
    • select max(thread_number) from rpm_bulk_cc_pe_item where bulk_cc_pe_id = "ID"
    • Example result: 7,749
  4. Change the THREAD_LUW to a dramatically different value.
    • UPDATE RPM_BATCH_CONTROL SET THREAD_LUW_COUNT=987654 WHERE program_name = 'com.retek.rpm.batch.FutureRetailRollupBatch'
  5.  Observe the program prints out the value used:
    • Attempting to execute using 10 threads with 987654 units
  6.  Observe the number of threads used in the database did not change.
    • select max(thread_number) from rpm_bulk_cc_pe_item where bulk_cc_pe_id = "ID"
    • Example result: 7,749
  7. Change the THREAD_LUW value for the wrong program "com.retek.rpm.app.bulkcc.service.BulkConflictCheckAppService":
    • UPDATE RPM_BATCH_CONTROL SET THREAD_LUW_COUNT=999999 WHERE program_name = 'com.retek.rpm.app.bulkcc.service.BulkConflictCheckAppService'
  8. Observe the program prints out the value used:
    • Attempting to execute using 10 threads with 987654 units.
  9. Observe the number of threads used in the database is now changed.
    • select max(thread_number) from rpm_bulk_cc_pe_item where bulk_cc_pe_id = "ID"
      Example result: 12

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms