R12: System Hangs when doing Online Validation for Offset Tax Invoices. Cancelling and Requerying Invoice Results in Lock APP-SQLAP-10771 (Doc ID 470400.1)

Last updated on FEBRUARY 24, 2011

Applies to:

Oracle Payables - Version: 12.0.0 to 12.0.6 - Release: 12.0 to 12.0
Information in this document applies to any platform.
zxdioffsettxpkgb.pls
APXINWKB.fmb - Invoice Workbench
APPRVL - Invoice Validation

Symptoms

Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.

 

-- Problem Description
Unable to perform online validation (APPRVL) of an Invoice with Offset Tax

Performance is unacceptable and system appears to hang
This process takes over 90 minutes to complete and validate the invoice.

If session is terminated, and Invoice is requeried the following error occurs:

APP-SQLAP-10771: Could not reserve record

-- Steps to Reproduce

1.  Invoices>Entry>Invoices>Query Invoice>Actions>Validate
2.  Terminate the session and requery the invoice generates error
APP-SQLAP-10771: Could not reserve record

-- Business Impact

Performance of validation is affected and system has to be killed causing the locking condition.

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