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

Last updated on JUNE 30, 2016

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

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