My Oracle Support Banner

"ORA-01008: not all variables bound" Error Initiating Approval in Quoting (Doc ID 345044.1)

Last updated on MARCH 31, 2020

Applies to:

Oracle Quoting - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

 Trying to approve a quote and receive the following error after choosing Initiate Approval

Error

APP-236138: Error returned in ASO_APR_INT.GET_ALL_APPROVERS
APP-236139: ORA-01008: not all variables bound

Doing a test in Approvals Administrator, the same error is received.

- In Approvals Administrator, go to the Test Tab
- Choose 'View a real transaction's approval process.' and press Continue
- For the Transaction ID, enter the Quote Number that is generating the above error in Quoting
- Click on 'Fetch Attribute Values'

Changes

 

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

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