Receipts Workbench: Error Encountered When Click Apply Button in Receipt Form - The Query Must Return One Row and One Column (Doc ID 1572937.1)

Last updated on SEPTEMBER 03, 2013

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Attempting to click on the Apply button in the Receipts Workbench and receive the following error:

The query must return one row and one column
(STRING==select to_char(zlv.tax_amt) from ZX_LINES_V zlv
where zlv.trx_number = : APP_FOLDER. TRX_NUMBER
and zlv. application_id = 222
and zlv. entuty_code = 'TRANSACTIONS'
and zlv. event_class_code = 'INVOICE'
and zlv. internal_orgnization_id = fnd_global. org_id

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