I have created a permission set for grant selection only for all while RMB on
but when i am query accouting tables , the data doesnt show up in table only header is visible
Best answer by Link
View originalI have created a permission set for grant selection only for all while RMB on
but when i am query accouting tables , the data doesnt show up in table only header is visible
Best answer by Link
View originalwhere is data being saved for GL dump ?
where i can get underlying table/view structure for modules ?
such as i am looking tables/views for customer ageing reports?
You can start it as follows:
i dont see file menu , how to get it?
thanks but that doesn’t work on order report menu
You can start it as follows:
i dont see file menu , how to get it?
You can start the debug console and execute the report. Then you can check the code in the debug console. I don’t know if you will find the right information.
what is the key for starting the debug console ?
You can start the debug console and execute the report. Then you can check the code in the debug console. I don’t know if you will find the right information.
Hi
of course. In IEE you can do the follwing step.
Go to Quick Reports and click with RMB on Show Details:
The details screen will show you the sql code.
thanks .
what about order reports ? for exmple customer_legder_age_analysis sql query ?
Hi
of course. In IEE you can do the follwing step.
Go to Quick Reports and click with RMB on Show Details:
The details screen will show you the sql code.
is it possible to see the sql query behind quick reports?
Hi
could you check the authorize classes?
If they are missing you can’t see the GL vouchers.
Hi
what kind of details do you need and what do you mean by GL and TB?
I am trying to access the table through SQL developer using the Read-only user that I have created following above
IFS GL Voucher rows screen shows a View that i am trying to query from database but it is coming empty
OK, I see.
But why do you need a query?
You can grant the permissions directly in IFS:
the user i have created with this procedure has limited access to views/tables while logging into DB from DB tool
where i can get details if GL and TB views/tables?
So you want execute a sql query to assign a company and site?
Then you need to create a query to insert new rows in the tables.
Here the views:
Select * from ifsapp.USER_FINANCE
Select * from ifsapp.USER_ALLOWED_SITE
thanks a lot
So you want execute a sql query to assign a company and site?
Then you need to create a query to insert new rows in the tables.
Here the views:
Select * from ifsapp.USER_FINANCE
Select * from ifsapp.USER_ALLOWED_SITE
yes, thanks a lot for that i understood by your previous reply.
but i am also looking from the DB side any hint on that?
OK, I see.
But why do you need a query?
You can grant the permissions directly in IFS:
i have a DB user who is having same issues,this user is read-only access to all database
but whenever i am accessing any transaction tables/views, there is no data coming up.
so i believe this user needs to be granted access to companies and site as you have suggested for the user that is created on IFS front end.
now i am looking for a query that can give access to companies and site to the user that i have created in DB.
Hi
great to read that.
I am afraid I didn’t catch your last question. Could you be more specify, please?
You have a user for DB only. Now you want to grant him (DB user) database permissions?
I think that might be it, I have done it from front end and it seems to be working fine
now I have another user that is only DB user, how can I give the same right from the database side?
thanks a lot
The permission set should be correct. Did you grant company and site in user?
Something in user isn’t complete.
in this case, any table/view that has a transaction is not showing any data
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.