My Oracle Support Banner

"Number format exception" While Trying to Extract Promotions Having Transaction Items with Differentiators (Doc ID 2308199.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 16.0 and later
Information in this document applies to any platform.


In Retail Store Inventory Management, promotion extraction fails for transaction level items with differentiators.

Steps To Recreate:

  1. Create a Level 1 Tran Level 2 Item with Differentiators and create its children in Retail Merchandising System ( RMS )
  2. Range the item to locations and approve the item and its children
  3. Execute NewItemLoc batch in Retail Price Management ( RPM ).
  4. Create a simple promotion for one or more Transaction level items created in step 1.
  5. Approve the promotion
  6. Run PromotionPublish batch and export batches to generate files successfully.
  7. Run SIM batch jobs by placing RPM files on promotions.
  8. Notice, the batch fails with ‘Number format exception’ at the promotions due to file read on Promotion Item Selling retail record ( TPISR ).




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.