My Oracle Support Banner

Error "ORA-01031: insufficient privileges" When Running OFR-AP-EBS-Views.sql Script (Doc ID 1463278.1)

Last updated on AUGUST 31, 2018

Applies to:

Oracle WebCenter Forms Recognition - Version 10.1.3.5.0 and later
Information in this document applies to any platform.

Symptoms

The following error is received after running the OFR-AP_EBS.sql script:

*** connecting as AXF schema user ***
Connected as AXF@VAL6
*** Create synonyms for AXF schema user ***
create or replace synonym XX_OFR_INVOICES_V for APPS.XX_OFR_INVOICES_V
Error at line 219
ORA-01031: insufficient privileges

This appears after following the instruction in section 2.2.1 “Creating the AXF Oracle E-Business Suite Configuration Schema User (AXF)” in the document “Application Adapter Administrator Guide.pdf”.  The document specifies to assign the configuration schema user the following access privileges “Create public synonym".

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


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