E1: 42S: Cache Error when Entering SD/OD in CSS Order Entry

(Doc ID 2150736.1)

Last updated on JULY 31, 2017

Applies to:

JD Edwards EnterpriseOne Customer Self Service - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

********************
E1 Release: 9.1
Program ID: P4210
Tools Release: 9.1
***************************

When entering a Direct Ship Order (SD/OD) through the CSS Web portal and when using the visual assist to look up an item and bring the item into the sales
order then error Open cursor for cache B4302180G264143 failed is issued. This only happens when Visual Assist is used and when P41829W - Item Word
Search is set up for Customer Self Service which triggers the P40ITMM3 to be displayed as well.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Set up P4210, ZJDE0010 to create SD/OD
2) Processing options P41829W, ZJDE0002 Make sure Customer Self Service is activated
3) Run Shopping cart, P4210
4) Enter quantity and take visual assist for item number
5) In P41829W Find item and click Select
6) P40ITM3 is displayed
7) View Shopping cart after adding this item and click Add to Shopping Cart
8) In Shopping cart drop off line and receive error "Open cursor for cache B4302180G264143 failed"
9) Note: When P41829W processing options for Customer Self Service is not activated the P40ITM3 is not displayed and the order can be completed without error

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