Skip to main content
Solved

Internal data source for Demand Planner base flow

  • March 14, 2022
  • 1 reply
  • 104 views

Forum|alt.badge.img+5

Hello, 

I am trying to write SQL to capture internal data source via base flow assistance, but I am getting error with the statement. Can someone help me understand table internal data source is capturing and how can I resolve the issue?

 

 

Best answer by Charana Udugama

Hi Ravi,

The ORA-01031: "insufficient privileges" error occurs when you attempt to execute a program or function for which you have not been granted the appropriate privileges. 

This error can be avoided by signing on as the appowner(ifsapp) or with any other user who has the appropriate privileges. 

Also you can simply grant the privileges to the user you are currently using. 

Thank you,
Charana

This topic has been closed for replies.

1 reply

Charana Udugama
Superhero (Employee)
Forum|alt.badge.img+12
  • Superhero (Employee)
  • Answer
  • March 14, 2022

Hi Ravi,

The ORA-01031: "insufficient privileges" error occurs when you attempt to execute a program or function for which you have not been granted the appropriate privileges. 

This error can be avoided by signing on as the appowner(ifsapp) or with any other user who has the appropriate privileges. 

Also you can simply grant the privileges to the user you are currently using. 

Thank you,
Charana