Skip to main content
Question

getting "insufficient privileges" when creating a Quick Report against the table gen_led_voucher_tab

  • November 20, 2025
  • 1 reply
  • 24 views

Forum|alt.badge.img+2

Hello IFS Community, 

we are trying to create a fairly simple Quick Report for our accounting department that includes a few views and tables, one of them is the one called “gen_led_voucher_tab” but when we try to run the report we get the following: 

 

{"code":1031,"message":"ORA-01031: insufficient privileges"}

 

even if we try to run something as simple as :

select *
FROM gen_led_voucher_tab

 

we have even tried to run this report using an admin user with what we believe it has all the permissions, but we are still getting the same error, so we are clearly missing a permission somewhere??

 

anybody has any idea what are we missing ?

 

we are running IFS Cloud 24R2

 

your help will be truly appreciated !

1 reply

Forum|alt.badge.img+12
  • Hero (Customer)
  • November 22, 2025

The IFS Model is as such that tables are not accessible to users, typically, only to the Schema owner (IFSAPP) and possibly some DB Read Only such as IFSINFO.

 

This is a because row level security is typically handled through WHERE conditions on views, and as such, the typical user is only granted SELECT from Views and not their underlying tables. As such, all Entities get their tables projected to a Base View.

 

Why can you not simply run  select * FROM gen_led_voucher, which is the Base view for the GenLedVoucher Entity?

 

 

CREATE OR REPLACE VIEW GEN_LED_VOUCHER AS
SELECT
company company,
voucher_type voucher_type,
accounting_year accounting_year,
voucher_no voucher_no,
internal_seq_number internal_seq_number,
voucher_date voucher_date,
date_reg date_reg,
accounting_period accounting_period,
userid userid,
'N' correction,
accounting_text_id accounting_text_id,
0 balance_voucher,
transfer_id transfer_id,
jou_no jou_no,
user_group user_group,
voucher_type_reference voucher_type_reference,
accounting_year_reference accounting_year_reference,
voucher_no_reference voucher_no_reference,
Finance_Yes_No_API.Decode(interim_voucher) interim_voucher,
interim_voucher interim_voucher_db,
voucher_text voucher_text,
voucher_text2 voucher_text2,
entered_by_user_group entered_by_user_group,
approval_date approval_date,
approved_by_userid approved_by_userid,
approved_by_user_group approved_by_user_group,
second_approval_date second_approval_date,
second_approver_id second_approver_id,
second_approver_user_group second_approver_user_group,
multi_company_id multi_company_id,
decode(nvl(multi_company_id,' '),' ','FALSE','TRUE') is_multi_company_voucher,
function_group function_group,
simulation_voucher simulation_voucher,
status_cancelled status_cancelled,
transferred transferred,
rowkey objkey,
to_char(rowversion,'YYYYMMDDHH24MISS') objversion,
rowid objid
FROM gen_led_voucher_tab
WHERE EXISTS (SELECT 1 FROM user_finance_auth_pub WHERE gen_led_voucher_tab.company = company)
WITH READ ONLY;