Hi @Noriro2 

did you reloaded the configuration in the basic profile?

Is it available in the basic profile?

Permissions are not required.

Hi @Link,

Thank you for your reply.

Yes, i reloaded the configuration in the basic profile

and Yes, it is available in basic profile

i did everything on basic profile, the thing is users can see the custom fields but cannot see the data/value in them.

And you (not IFSAPP) can’t see these fields as well?

@Link  Only IFSAPP can see the data but others no they can’t see, i just found out even some users can't see the fields. To sum up, Clients (not IFSAPP) can’t see the data, and some of them can’t see the field as well, some weird things happening! i used “IFS Standart” base profile to set everything.

Edit 1: i opened user profile as i do for IFS Standart profile, reloaded configuration and bring the fields there and i saw the field and data (i am IFSAPP) i saved user profile and turn back to IFSAPP profile, ask user to login to IFS and check the field, user said no they can’t see the field and the data.

Edit 2: i give instructions to users to bring column on their account, they did bring the columns, but they cannot see the data.

Is pers_education_profile an IAL?

@Link i am sorry i was giving misinformation, only IFSAPP is available to see everything, even FND_FULL_ENDUSER role cannot see the data. 

What is IAL?

Edit: if this is what you mean, i dont see pers_education_profile in the list ;
 

Can you try this?

IFSAPP.pers_education_profile

SELECT 
education_level_name 
FROM ( SELECT education_level_name 
    FROM   IFSAPP.pers_education_profile 
    WHERE  person_id = :person_id 
    AND extract(YEAR FROM end_year) != 9999 
    ORDER BY end_year DESC, education_level_no DESC) 
WHERE  ROWNUM = 1

i did, but no it didn’t work, why was IFSAPP added?

Edit 1: Does it have anything related to “Approved Detail Views”;
 

Hi @Link 
Do you have any idea?

Hi @Noriro2 

this shouldn’t be the issue.

On which screen did you create the custom fields?

If you process the code (with your user) via pl/sql then you get values, right?

@Link  Thank you for reply, 

i created custom fields on “Role Assignment” tab on “Project” screen (Role Assignment on Project Screen),

if i run the query via pl/sql on “Oracle Sql Developer” or “DBeaver” with IFSAPP user query works and  i get the correct result. No other User has DB Access, so i can try only with IFSAPP on DB.

The view used, PERS_EDUCATION_PROFILE, is containing the HR security, so your user must have access to the employee connected to the person in at least one company.

Appowner IFSAPP can always see all lines or if your user is setup as HR Manager.

@Tomas Ruderfelt Thank you for reply, i was thinking the same, this is why i tried to give every possible permission, you can check on first post, but it seems the permissions i gave were insufficient, does it have to be HR manager? what can i do to achieve my goal without giving messy permissions. 
The people who need to see the data have nothing to do with HR.

Dear @Noriro2 

I recommend you to create an IAL to avoid the access.

The “HR Security” is actually a HR access that you do not setup with permission sets.

For example you have the position structure (the company structure) and then you connect your employees to it. Since the users does not work with HR they should not have HR manager access.

I’m not so good at HR so I can’t explain exactly how this is setup.

@Tomas Ruderfelt  Yes, You are right, we wont give HR manager access to use who doesn’t work in HR department, but there should be a work around  for this kind of things. thanks for trying to help.

@Link Can you help me to create an IAL, i have no idea what is IAL!.

@Link, seems like i created an IAL;
 

But i can’t use it, i can’t find PERS_EDUC_INFO_TEST1 and IFSAPP_REPORT_DATA on DB

How can i use it?

found it “ifsinfo.pers_educ_info_test1 “ i will try and let you guys know if it works.

Yes, that is true.

But at first you have to configure it in the permission sets.

There is a tab for IALs.

@Link thank you for your effort to helping me

@Tomas Ruderfelt Thank you for clarifying things for me

it worked, it may be the only way but i am not sure if this is right way, because it works depending on a schedule and i am not sure there will be no duplicates! 

https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/060_information_access_layer/020_create_ial/default.htm

here it says use “Index Columns” field for prevent duplicates but when i try it says use “Where Clause” field first, i don’t know how to use it!

And if i delete “IAL Configuration” i created, will it delete everything? i may create new one with same name.

Hi @Noriro2 

did you grant it to your permission set?

Hi @Noriro2 

did you grant it to your permission set?

 

Not yet, but i run the same test as i did before, it works. There is no problem so far, and i see the created IAL in IAL Objects in Permission sets, there will be no problems. I have different concerns about duplicates and being depending on a schedule and if i delete it to create new one, can i give same name to new one?

You can’t have any IAL duplicates.

But yes, if you delete it you can use the IAL name again.

I’ve created a IAL with your sql code and it works:

SELECT person_id, education_level_name,  education_field_name 
FROM IFSAPP.pers_education_profile 
WHERE  
extract(YEAR FROM end_year) != '9999' 
ORDER BY end_year DESC, education_level_no DESC

But we don’t use this HR module. 

SELECT person_id, education_level_name,  education_field_name 
FROM IFSAPP.pers_education_profile 
WHERE  
extract(YEAR FROM end_year) != '9999' 
ORDER BY end_year DESC, education_level_no DESC

Yes, it works thank you.
what i mean about duplicates is not IAL itself, i mean data in the created table. Later i found in the document in “Replicating Schedule” section IAL IAL Configuration (ifs.com) it says it drops the table and recreates it. 

The replication is performed by dropping the table, recreating the table with SELECT *, and then recreating the associated indexes as they were before. This also ensures good performance even when multiple indexes are used, and that rollback tablespace is not affected.

what i understand is data won't be duplicated.