@zuhaib thanx for reply. “download packages on users where Lov data is not shown.” I didn’t understand. Couldu you share a picture of the interface where I can do this?
Thank you very much for the information you provided. You were right. Dear Sahango, The Project Groups table is Company Specific. If there are more entries in your PL SQL query you should try to find the Company column. I bet you have more than one Company in your database. /Jonas
As far as I understand, you are saying that I can enter new data from the PROJECT_GROUP table. But when I call the datas of the table in PL/SQL with select * from PROJECT_GROUP query, different table with more columns comes up.. I mean they are not same exactly. Specifically, any table that has the suffix LOV is a List Of Values, i.e. basic data can be entered by the user directly into the basic data that the List Of Values refer to. In your case the view PROJECT_GROUP_LOV is pointing to the window Project Groups where you can enter your new data. /Jonas
I opened the permisson set but where i will enter the table name and it will show/navigate me to the interface. I would be grateful if you share a picture. @sahango to know in which interface a table is used in IFS, I would find that from permission sets .
Actually i find the table in PL/SQL. I want to add new record from IFS Interface. Hi @sahango for view table use PLSQL after that you see the table in the red color highlight it is view in IFS. For view table open PLSQL use select query Select * From PROJECT_GROUP After RMD then view on check table snap is attached for your reference. Thanks & Regards, Zuhaib IFS Consultant https://www.linkedin.com/feed/
@sahango There is no setting to enable/ disable this function for users other than the permission sets. The menu items are enabled/ disabled based on the following logic though. If Available Qty = 0 Transfer to Project Inventory… (disabled) Transfer to Standard Inventory… (disabled) If Available Qty > 0 and Activity Sequence = 0 Transfer to Project Inventory… (enabled)Transfer to Standard Inventory… (disabled) If Available Qty > 0 and Activity Sequence > 0 Transfer to Project Inventory… (enabled) Transfer to Standard Inventory… (enabled) Hope this helps ! Sorry for the late reply. But i shared picture below that shows two different user and menu status. Same part, same activity and same available qty. But one of is disabled, another is enabled.
A database specialist should be able to help you import or create the indexes you need. Table indexes are the database tools used to create fast table searches and connections between tables. You seem not to have any. Table indexes are what is picked up by the application to show the user what search criteria is better and which are not so good to use for a search, in short search tips. If you use the Advanced Search screen, like you have in your screenshot, then to the very left there is a column that should show arrows pointing diagonally up or down, green arrows pointing up to the right and red pointing down to the right. The green arrows indicates that search on that field gives a fast response. Searching on combinations of fields with green arrows will make your search even faster. Searching on fields with red arrows slows down your search. On looking at the screenshot from the original entry I see no green arrows pointing up to the right on the left column, only red arrows poin
@sahango The time taken depends on many things, 80k records should not be a big issue (not sure the degree of slowness you experience here). If these records were migrated, please check the indexes and etc in place. If these records are not required, consider deleting the shop orders. Manufacturing\Shop Order\Order\Mass Delete Closed Shop Orders and Clockings AFAIK, it is not possible to deactivate the SOs but you can archive the records in the database following the general database data archive. Hope this helps ! Deleting old records worked. But you said “If these records were migrated, please check the indexes and etc in place”. Can you give more details or share images on this subject?
@sahango Sorry about it, trial and error in APP8 :) Can you please check if the employee is added to a Manufacturing Labor Class. Sorry I dont have access to APP8 environment right now to provide a screen capture. But you can find the window in the navigator and then add the employee, I assume. Actually, I'm sorry for wasting your time :-) .I checked. There are no users added to that list. I guess it's not about that either.
@sahango I assume Current Team Employee can be used. Can you please check that? I checked it but the table is empty.
@sahango That is not an issue, please refer to the following. Try comparing with the data for the copied user’s employee. Hope this works ! We are using IFSAPP8 and there is no menu named Shop Floor Employees.
Thanx for answer. Obviously, I'm a little new to IFS. Could you share a picture of the interface where I can do this set up?
hI @sahango, Can u check this screen? and search for tbwOperationStatistics? Can you compare grantees of this one with the other Presentation object which could be seen as standart user? Many thanx. I fixed it.
@sahango Please check if the relevant presentation object for the window is granted for a permission set connected to the user. Any insight on it? Thanx for attention. but how can check this. Can you share a picture of the interface where I can do this control?
While you have the page open open options as above and click “use Current”. Then the next time they log in it should go direct to the page. Thanx for quick response.
We are on APPs 10 UPD 17. I am familiar with this error as it happened to use twice during our upgrade from UPD 8. From what I understand this is because there is a bug that is breaking their reference logic. The LU doesn’t have a base table anymore so that is why you get the (“” is non existing table) error. You’ll have to create a Case with IFS and have them send you a delivery to fix the bug. Thanx for information. I ii send report.
Hi Sahango, pls check if the user who should have access to the data migration job is already listed in the Data Migration Basic Data - Authorized User / Pr user and the mentiond migration job is added to the objects of the user. (not 100% sure about the name of the basic data tab, bc I currently don’t have access to Apps 8). Edit: Found a screenshot in the community. Pls check user & pr user.: BR /Florian Thank you, the problem has been solved.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
