Last updated on JULY 26, 2017
Applies to:Oracle Order Management - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.
On : 12.1.3 version, Transactions Related
When attempting to query "Today's Orders" via the Order Organizer Sales Form the following error occurs.
This error did not occur in Release 126.96.36.199. Company recently upgraded from Release 11i to Rel 12.1.3.
Able to isolate the issue strictly to the using the "Today's Order" ONLY>
Customer said he only sees this error in Order Management Organizer Form ONLY when he clicks on "Today's Orders"
Customer indicated if he queries all the orders for today, he gets the error using "Today's Order" only.
If he queries orders from last week he does not see the error.
If customer queries on one order at a time, he does NOT see the error message.
Had customer query on TO and FROM Order Date 03-Nov-2014 >>> Can NOT see error message.
"User exit 'CURRENCY_INFO' was called with invalid arguments"
ORA-00936: missing expression.
FRM-40505: ORACLE error: unable to perform query.
1. Responsibility: Order Management Super User
2. Order Organizer > Query "Today's Orders"
3. Now Click on the "Lines" Tab and observe error(s)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms