U.S. Sales Tax Report Errors With ORA-01008 not all variables bound (Doc ID 330871.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version: 11.5.8
This problem can occur on 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


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