My Oracle Support Banner

Applied Receipts Register Failed After Upgrade To R12.2, ORA-01008: not all variables bound (Doc ID 2240350.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

On : 12.2.6 version, AR Reports Issues

Applied Receipts Register fails after upgrade to R12.2.6 from R12.1.3.

When entering report parameters:

If Reporting Level = 'Operating Unit' user cannot generate report. Will have error in log file.
If Reporting Level = 'Ledger' the report completes successfully.

ERROR
-----------------------
Log file for RX-only: Applied Receipts Register:

**Starts**DD-MON-YEAR HH:MM:SS
**Ends**DD-MON-YEAR HH:MM:SS
ORA-01008: not all variables bound


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Applied Receipts Register
  a. Run with Reporting Level = 'Ledger'
      Report completes
  b. Run with Reporting Level = 'Operating Unit'
      Cannot generate report

Changes

 Upgraded to R12.2.6 from R12.1.3

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.