E1: 42: Sales Order Batch Price/Cost Update Ends in Error When Called from Print Invoice (R42565) Using Specific Data Selection (Doc ID 2265503.1)

Last updated on JUNE 06, 2017

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When running the Sales Invoice Print (R42565) calling Sales Price/Cost Update (R42950) using specific data selection the R42950 ends in error. The issue only occurs in TR 9.1.5.10 and does not occur in 9.1.4.7 using the same application code and data selection.

The errors seen in the logs are as follows:

Entering JDB_SelectKeyed (hRequest 0B903AA0)
ODBC:S DBInitRequest(new) req=0BB3A128 con=0801EAE8 env=01318B80 dbc=0131D758
spid=187 EPDEVDB1 A (JDEUSER@EPDEVDB1)
SQL0000050 - Invalid operator for Null Value
SQL0000019 - Process WHERE failed
SQL0000033 - Build where failed
ODB0000080 - BuildString failed.
ODB0000028 - JDBODBC_Select failed.
JDB9900168 - Failed to initialize db request
JDB9909007 - Unable to obtain driver request handle
Exiting JDB_SelectKeyed with Failure

Additional Information

The R42950 uses a Tools BSFN UseReportDataSelection (B0000196) to copy the data selection from the calling UBE. There are no reported issues with this BSFN. The API used is called ubeSection_UseDataSelection. The issue occurs with this in the data selection:

AND StatusCodeNext (F4211)(NXTR)[String] >= DS szStatusCodeFrom
AND StatusCodeNext (F4211)(NXTR)[String] <= DS szStatusCodeTo

If the data selection is revised to remove the data selection shown below, the UBE processes successfully:

AND StatusCodeNext (F4211)(NXTR)[String] >= DS szStatusCodeFrom
AND StatusCodeNext (F4211)(NXTR)[String] <= DS szStatusCodeTo

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