Performance Issue Calling API AR_INVOICE_API_PUB Due to Lock Contention in Table ZX_TRANSACTION_LINES (Doc ID 1945151.1)

Last updated on MAY 31, 2017

Applies to:

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

Symptoms

Unable to run API AR_INVOICE_API_PUB in parallel, due to lock contention in table ZX_TRANSACTION_LINES.

Each session has to wait for the other one due to the lock contention.

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