I am using Apps 10 and there is a view called “Employee” that when I select everything from it in Oracle it does not return a lot of Employees that are in IFS. Some users who are visible in all the relevant screens in IFS are not returned when I select from this view.
I cant find any logical unit that is linked to this view. I need to know what screen in IFS is linked to this view so I can see why these users are not displaying in the select statement.
Hopefully someone can help.
Best answer by william.klotz
HI
Basically the “Employee” view returns employees setup as Maintenance employees.
The “Employee” view uses the the following tables to extract data.
The employees returned by the “Employee” view you’ll find listed under the Maintenance Employee.
What are you trying to accomplish?
Are you trying to get a list of employees for a company?
Regards,
William Klotz
+21HI
Basically the “Employee” view returns employees setup as Maintenance employees.
The “Employee” view uses the the following tables to extract data.
The employees returned by the “Employee” view you’ll find listed under the Maintenance Employee.
What are you trying to accomplish?
Are you trying to get a list of employees for a company?
Regards,
William Klotz
The view that is the data source of that screen is not EMPLOYEE, it is MAINT_EMPOLYEE_UIV but it is near enough to it so thank you. I don’t think the EMPLOYEE view is used as a source of any screen. There isn’t the option to add a row to that screen so it must be dependent on another screen.
I want a list of mobile users but some are missing from that screen. They need to be in a view called MOBILE_USER also which is the source of the Explore Mobile Users screen.
The view I am selecting from is a combination of those two views still not giving back what I want but I think it could be an uppercase/lowercase issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
