My Oracle Support Banner

Null Pointer Exception While Creating An Pre-Pack In Order Due To CONSIGN_CONCESSION_IND as Y (Doc ID 2815547.1)

Last updated on OCTOBER 20, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.


When Creating a Purchase Order and selecting to create a Pre Pack in the order, the Order creation is failing due to the Item Supplier Country record being incorrectly created as it is not populating the PURCHASE_TYPE field with any values, and the process tries to create the  ITEM_SUPP_COUNTRY_LOC  record (based on the ITEM_SUPP_COUNTRY) and it fails because it is expecting a value and there is no value on that field.

This problem is due to the new functionality for concessions and consignments as it can have 2 behaviors: - Control the Concession / Consignment flag at the Department level only (already existing functionality CONSIGN_CONCESSION_IND='D') - Control the Concession and Consignment functionality at the ITEM_SUPP_COUNTRY and ITEM_SUPP_COUNTRY_LOC level (new functionality and system_options.CONSIGN_CONCESSION_IND = 'Y')

Steps to recreate:

  1.  Create Order and Popullate the necessary fields
  2.  Click Ok and Select "Order by Prepack"
  3.  Click Details
  4.  Add Item
  5.  Select "Prepack" in Dropdown
  6.  Select a Style that has Differentiator Group and that the Style does NOT have all the differentiators created for that Differentiator Group
  7.  Select Vendor Pack
  8.  Add Differentiators - Select differentiator that is still not created under that Style
  9. Click Build Cost
  10. Save and Close
  11. Click Yes to the message
  12. Select Location for Location distribution
  13. Select a warehouse and insert the distribution percentage equal 100%
  14. Click Save and Close
  15. Say Yes to the warning
  16. Error Appears : "Unexpected exception caught: java.lang.NullPointerException, msg=null"
  17.  If you go to Database and "select * from ITEM_SUPP_COUNTRY where purchase_type is NULL;" you will see that there is that record that is wrong and the ITEM_SUPP_COUNTRY_LOC was not created due to that
  18.  Cannot close tab with error


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.