Skip to main content
Solved

Customer Analysis - Invalid Table Name for Specific User

  • January 19, 2023
  • 3 replies
  • 361 views

Forum|alt.badge.img+1

When a specific user tries to load customers on the customer analysis screen, they receive the error “Invalid Table Name. Failed executing query (ORA-00903: invalid table name)”.

This issue only affects this user who has all the permissions that seem necessary and on a test database can access this fine.

When I look at the query being ran that throws the error, for the user the table name “ledger_item_cu_det_qry_cfv” is missing. For any other user this table name is present in the query and they can load customers on this screen. Any ideas?

Best answer by Pawel Dworzynski


Hello,
This could be lack of privileges to the view “ledger_item_cu_det_qry_cfv” to this user.
Try to run this command as ifsapp
grant select on ledger_item_cu_det_qry_cfv to user
where user should be the real name of this user who has the error message.
Best Regards,
Pawel

View original
Did this topic help you find an answer to your question?

3 replies


Hello,
This could be lack of privileges to the view “ledger_item_cu_det_qry_cfv” to this user.
Try to run this command as ifsapp
grant select on ledger_item_cu_det_qry_cfv to user
where user should be the real name of this user who has the error message.
Best Regards,
Pawel


Forum|alt.badge.img+10
  • Hero (Customer)
  • 108 replies
  • January 23, 2023

Hello,

Do you have a custom field in test as well as production?   Was it published in production and granted accordingly?  Did they “reload configuration” in the customer analysis form?  looks to me it relates to a custom field.  I would review the difference in set up of test vs prod.

Best regards


Forum|alt.badge.img
  • Do Gooder (Partner)
  • 1 reply
  • April 17, 2024

Is this issue resolved? I tried all the ways suggested here, but still facing the same issue for only 1 user.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings