My Oracle Support Banner

Subscription To RMSSUB_ASNIN.CONSUME Interface Fails With ORA-01861 Error (Doc ID 1395104.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.1.4 and later
Information in this document applies to any platform.

Symptoms

If subscribe to RMSSUB_ASNIN.CONSUME  with NLS_DATE_FORMAT different then DD-MON-YYYY then , subscription fails with  ORA-01861 error returned by program unit ASN_SQL.VALIDATE_ORDER.

Steps To Recreate:

1. Change the NLS_DATE_FORMAT to a different one, let say, YYMMDD.
2. Call RMSSUB_ASNIN.CONSUME with correct parameters. Following error is returned.

Error ORA-01861: literal does not match format string returned by program unit ASN_SQL.VALIDATE_ORDER.



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.