Canceling Some Orders Errors: ORA-01843: not a valid month in Package OE_Header_Util Procedure Query_Row
Last updated on SEPTEMBER 20, 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***
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.
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
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