U.S. Sales Tax Report Errors With ORA-01008 not all variables bound

(Doc ID 330871.1)

Last updated on FEBRUARY 08, 2018

Applies to:

Oracle Receivables - Version 11.5.8 to 11.5.10.3 [Release 11.5.8 to 11.5.10]
Information in this document applies to any platform.
REPORT:ARXSTR.RDF - U.S. Sales Tax Report

Symptoms

The U.S. Sales Tax Report errors with the following:

ORA-01008: not all variables bound
S ==> ELECT /*+ ordered index(su hz_cust_site_uses_all_pk)   use_hash(trx,dist) */ trx . invoice_currency_code C_CURRENCY , cy . precision C_PRECISION , cy . minimum_accountable_unit C_MINIMUM_ACCOUNTABLE_UNIT , loc . state C_STATE , decode ( : p_detail_l

 

Changes

 

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