Error "ORA-01031: insufficient privileges" When Running OFR-AP-EBS-Views.sql Script
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.
The following error is received after running the OFR-AP_EBS.sql script:
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".
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