My Oracle Support Banner

R12 AP: Upgrade Driver 6678700, Failed On apwuprl1.sql with ORA-20001: APP-SQLAP-10000: ORA-14411 (Doc ID 1539723.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2015***

Symptoms

On : 12.1.1 version,

While applying R12 upgrade driver 6678700 ( 12.1.1 : Upgrade Patch ),
adpatch failed on apwuprl1.sql (for all workers that were running that script).

Error in the adwork*.log:
------------------------
sqlplus -s APPS/***** @/disk2/apps/apps_st/appl/ap/12.0.0/patch/115/sql/apwuprl1.sql &un_ap 27 32
debug: Adding NOT NULL constraint to AP_EXPENSE_REPORT_LINES_ALL.REPORT_LINE_ID
column
DECLARE
*
ERROR at line 1:
ORA-20001: APP-SQLAP-10000: ORA-14411: The DDL cannot be run concurrently with
other DDLs occurred in
ExpenseReportLineIDNotNull
with parameters (&PARAMETERS)
while performing the following operation:
Adding NOT NULL constraint to AP_EXPENSE_REPORT_LINES_ALL.REPORT_LINE_ID column
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at line 40
ORA-06512: at line 45



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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.