My Oracle Support Banner

Order Detail Expenses Screen Raises an Error when Attempting to Open (Doc ID 2739125.1)

Last updated on DECEMBER 24, 2020

Applies to:

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


Within the order detail screens, at order item location level, when the user attempt to open the expenses screen an error is raised:

Error message:
SQL error during statement preparation
". Statement: SELECT a.ITEM, (select ITEM_DESC from v_item_master_tl tl where tl.item = a.item) ITEM_DESC, a.cost_zone_group_id ZoneGroup_ID, b.description ZoneGroup_Desc, c.zone_id Zone_ID, c.loc_type, (SELECT PURCHASE_TYPE FROM ORDHEAD WHERE ORDER_NO = :bindOrder) purchase_type, (SELECT DESCRIPTION FROM V_COST_ZONE_TL WHERE ZONE_ID=c.zone_id) AS ZONE_DESC, CASE WHEN ((SELECT 1 FROM STORE WHERE STORE = c.location) = 1) THEN (SELECT STORE_NAME FROM V_STORE_TL WHERE STORE = c.location) ELSE (SELECT WH_NAME FROM V_WH_TL WHERE WH = c.location) END AS LOC_DESC FROM item_master a, v_cost_zone_group_tl b, cost_zone_group_loc c WHERE a.item = :bindItem AND b.zone_group_id = a.cost_zone_group_id AND a.cost_zone_group_id = c.zone_group_id AND c.location = :bindLoc"

Steps to replicate the issue:

  1. Confirm that multiple zone groups exists and that the same zone id exists in both.
  2. Assign a zone cost component to an item, against the same zone id from step 1.
  3. Create and approve an order for that item, to be delivered on a location from zone on step 1.
  4. Open the order and navigate to order details, and attempt to open the expenses for the selected item and location.
  5. Error is shown.



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.