XTSF Message Having Multiple Items Ranged To A Store Is Failing With ‘Error ORA-06511: PL/SQL: Cursor Already Open Returned By Program Unit RMSSUB_XTSF_VALIDATE’ (Doc ID 2042147.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1 to 14.1.2 [Release 14.1]
Information in this document applies to any platform.

Symptoms

When attempting to Process External Transfer (XTSF) store to store message with multiple items ranged to store locations,the following error occurs:

ERROR:


Steps To Recreate:

1. Select 2 items which are ranged to store locations.
2. Publish a Intercompany(IC) store to store XTSF message for the multiple items with TSF_TYPE as NULL.
3. Retail Merchandising System(RMS) fails to consume the message with the above 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