My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2024

Applies to:

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


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

*** connecting as AXF schema user ***
Connected as <User_Name>
*** 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".




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

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