My Oracle Support Banner

ORA-01861: Literal does not match format string in Package CSI_PARTY_RELATIONSHIPS_PUB Procedure UPDATE_INST_PARTY_RELATIONSHIP... Generated By RMA Receipt (Doc ID 1543223.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version,
Transaction generated IB error upon RMA receipt of IB trackable item. Reprocessed the IB error from the Transaction Errors Re-Processing form and the error cleared
Original IB item status = Initial Shipment.

ERROR
-----------------------
ORA-01861: literal does not match format string in Package CSI_PARTY_RELATIONSHIPS_PUB Procedure UPDATE_INST_PARTY_RELATIONSHIP

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create any RMA Receipt against an Install Base Item that has been shipped.
2. Error is in transaction details reprocessing form

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, IB update is not occuring until the records are reprocessed using IB Error Correction program

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!


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