My Oracle Support Banner

Accessing ATP Details Form Resulting in ORA-01423 and ORA-01722 Errors (Doc ID 2098848.1)

Last updated on NOVEMBER 14, 2018

Applies to:

Oracle Global Order Promising - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, ATP Inquiry (ATP Details form)

While looking at the ATP Details for an item from the Sales Order form, see the following error:

ERROR
-----------------------
ORA-01423: error encountered while checking for extra rows in exact fetch
ORA-01722: invalid number

Details
ORA-01423: error encountered while checking for extra rows in exact fetch
ORA-01722: invalid number
-------------------------
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01423

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to schedule a sales order line
2. Look at the ATP Details form
3. Error occurs.

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.