My Oracle Support Banner

R12: AP: Upgrade AP.AP_CHECKS_ALL Command Encounters an Error ORA-00987: missing or invalid username(s) (Doc ID 3018418.1)

Last updated on MAY 13, 2024

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Post R12 upgrade enabling online patching script ADZDEXRPT.sql reports error for some objects:

ERROR
----------------------

ORA-00987: missing or invalid username(s) ERROR at line 1:

Note: The user "99999999" is a CUSTOM user having grants on APPS Schema.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:



Changes

 Upgrade from 12.1.3 to R12.2.11

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
References


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