My Oracle Support Banner

Unable to Cancel Order Error ORA-01843: Not A Valid Month In Package OE_Header_Util Procedure Query_Row (Doc ID 2768753.1)

Last updated on MAY 23, 2021

Applies to:

Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Getting error while trying to cancel the order.

ERROR
-----------------------
ORA-01843: not a valid month in Package OE_Header_Util Procedure Query_Row



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. open sales order form.
2. cancel the order

==

Log File is showing following:

PROCEDURE PROCESS_CANCEL_ORDER
No of IDS1
INSTR5926633
Entering OE_HEADER_UTIL.LOCK_ROW
Entering OE_HEADER_UTIL.QUERY_ROW
Calling query card details...
Entering Query Card Details....
Entering Get_Payment_Trxn_Info...
Get_Payment_Trxn_Info error....others
After call to Get_Payment_Trxn_Info
Result code
trx ErrorORA-01422: exact fetch returns more than requested number of rows
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
Success in get payment trxn info...
LEAVING OE_MSG_PUB.ADD
others in lock_header
LEAVING OE_MSG_PUB.ADD
LEAVING OE_MSG_PUB.COUNT_AND_GET 2
GET_MSG_TBL STARTED , COUNT : 0
 m1 : 1
 m1 : 2

==
Sales order Analyzer is showing Workflow error:

ORA-20001: OE_Order_WF.Book_Order(OEOH, <SOheaderID>, 9999, RUN)
Wf_Engine_Util.Function_Call(OE_BOOK_WF.BOOK_ORDER, OEOH, <SOheaderID>, 99999, RUN)

 Order lines section from Sales order Analyzer is showing:
no line associated with the 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.