My Oracle Support Banner

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 MARCH 12, 2019

Applies to:

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


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


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. 


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.