Canceling Some Orders Errors: ORA-01843: not a valid month in Package OE_Header_Util Procedure Query_Row (Doc ID 1165415.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Order Management - Version 12.1.2 and later
Information in this document applies to any platform.
***checked for relevance 03-June-2013***

Symptoms

When attempting to cancel some orders or lines in the Sales Orders form,
the following error occurs:
ORA-01843: not a valid month in Package OE_Header_Util Procedure Query_Row


The credit card information is missing in the order header:
Card Brand, Card Holder, Credit card Number, Card Expiration Date.

The HTMomse12i.sql for order shows:
HEADER PROCESSING MESSAGES:
WARNING HEADER_ID MSG_SOURCE ACTIVITY REQUEST_ID DESCRIPTION MESSAGE_TEXT
2 538659 W=Workflow Close ORA-01843: not a valid month in Package OE_Header_Util Procedure Query_Row
2 538659 W=Workflow Close User-Defined Exception in Package OE_Header_Util Procedure Lock_Row

Copying the orders to new a sales order process successfully.

Steps taken:
Using Order Management responsibility:
1. Create credit card order
2. Book and ship the partial order.
3. Remain lines in the orders are back ordered.
4. Try to cancel the backordered lines and get error
5. See that Credit Card info is now missing on the header

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