My Oracle Support Banner

OAT Interface Status Manager Fails with "ORA-01031: insufficient privileges" (Doc ID 3062166.1)

Last updated on JANUARY 02, 2025

Applies to:

Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 24.1 and later
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 23.2 and later
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version 24.0 and later
Oracle Retail Demand Forecasting Cloud Service - Version 23.2 and later
Information in this document applies to any platform.

Symptoms

 OAT -> Submit New Admin Task -> Configured Batch Task -> Interface Status Manager -> Manager Interface Status -> Select status 'Ready' for any table, and task fails with:

13:02:55 : INFORMATION : oat_intf_status_mgr.sh[-] - Parameters: -i RSE_FCST_DEMAND_EXP -m -r 143 -s Ready
UPDATE RAP_INTF_RUN_STATUS set status = 'Ready' where intf_cfg_id = (select intf_cfg_id from rap_intf_cfg where intf_name = 'RSE_FCST_DEMAND_EXP') and run_id in (143);
*
ERROR at line 3:
ORA-06550: line 3, column 24:
PL/SQL: ORA-01031: insufficient privileges
ORA-06550: line 3, column 17:
PL/SQL: SQL Statement ignored

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!

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