Hi @philipv,It looks interesting and i guess i am out of ideas. :)Maybe some technical problem or there is some kind of modification on this in your system. I am not sure.Servet
Hi again,I guess The Customer Order Number 10001 is already occupied. Can you try to put on Customer Order No in your setup something greater than your last Customer Order Number like 10000000 ? I guess it can clarify that we only have one sequence for Customer Order.Regardsservet
Hi @philipv ,I guess now i got your problem.As i know IFS is using same sequence for all Coordinator Groups. That is why whatever you do you get the same number with different prefix. That is why we did something like this in our configuration: As you can see we created some kind of starting number for each coordinator group in the same sequence. Since they are using the same sequence. I hope this works for your scenario too.RegardsServet
Hi @philipv ,Are they using the same prefix? Can you show your Coordinator Groups settings?Servet
Hi,I guess you can have the information that you need in the Shop Order /History tab. As you know there is a material Transaction History tab there and you can see all scrap cause and shop order/operation information. The DB view is called MATERIAL_HISTORY Regards servet
Hello Ozgun,Why you need to use Alias? If you query one view and not join two or more views/tables, you dont have to use alias. But if you cant do it you can create a view or an IAL instead. Regards.Servet
Hi Barış, What is Your Oracle “Verification Function”? Or You use One? And can you share your Oracle profile ? Regards.
Hi @dsj I can guess the problem with the query is about the base view of purch req line. Thank you for the information.Servet
Hi OğuzYou can try to set the column’s data type as currency in lobby data source; Regards Servet
Hi Karin, There is a function to get op description ;ifsapp.shop_order_operation_api.Get_Operation_Description(order_no,release_no,sequence_no,operation_no)You can define it to purch req line with these variables;ifsapp.shop_order_operation_api.Get_Operation_Description(DEMAND_ORDER_NO,DEMAND_RELEASE,DEMAND_SEQUENCE_NO,DEMAND_OPERATION_NO) Like This;RegardsServet
Hi I am not sure about this problem but;Can You try expression with shop_order_operation_api.Get_Operation_Description function It needs 4 parameters and all is available on purchase requisition line. I hope it helps. Regardsservet
Hi,Is it a subreport or the report itself?If it is the report itself you just have to create a query with the right “where” clause. If it is a subreport you can use the subreport link option.RegardsServet
Hi,Actually we did think about an automatic processs. But we couldnt decide in which condition we should add this line to the shipment. so it was a manuel decision in our situation. And it was shipment department’s responsibility but they were coordinating with sales of course. (sales were suggesting that with specific order lines and these non-inventory lines will be invoiced together)But if you you can give a specific rule (For example; connecting an inventory order line of the customer order, non-inventory line will be automaticly added to shipment or something like this. ), so it is very easy to automate this with an event as Paul suggests.Regards.
Hi,We had this issue and we solved it with adding the non-inventory customer order line as a shipment line.So we had it in the same invoice. And in our delivery_note we excluded non-inventory order lines.In IFS we shipped inventory and non-inventory lines.In paper we only have inventory line.In invoice we have both lines.Just a suggestion. have a nice day.servet
Hiyou can define this for all new users. Go to create user screen and use right mouse menu and click the settings.You can select the “Set Password Expired For New Users” selection. Then every user you create will have expired oracle passwords. You just give your temp password to new user and in first login user has to change password.Note; You can also define custom password for new users or just choose same as user name, so you wont need to create passwords for all new users.Another Note: You can also force users to change their passwords in given time (For example once in 3 months). You can do this on oracle profile screen. I hope it helps.RegardsServet
Hi DeepakFirst step: You can use one of the grouping on the inventory part and all parts you want to restrict for specific users you can define a group. I dont know which one, you can choose one which suits your config.Second step: I suggest you to create a permisson set and assign to users who “can” create shop orders to all partsThird Step: Create an event action to shop_ord_tab and raise an error if part_no has defined grouping and fnd_user does not have the permission set you defined.I think with doing this way; you can have some parametric configuration.I hope this helps.regardsservet
Hi Savaş, You have to create a supplier for that customer first. And chose the customer_id at supplier’s Purchase tab: Regards, servet.
Hi I guess after IFS 8 There is an option in Document Class Management which allows you to let some specific users see document classes. Did you check this regarding to your problem? Document Management\Basic Data\Document Class Management - “Persons and groups Tab” Regards. Servet That feature controls who can create documents of that class. If no users are listed there, everyone can create documents of that class. Hi Mathias, I know that, and i got from the question that the problem was: “Some of the users can’t even see that doc class as an option while creating a new document” That is why i suggested this, because this is what happens when you try to use this feature. If some groups or person is added to this tab other users can not see that document class to choose while creating new documents. Servet.
Hi I guess after IFS 8 There is an option in Document Class Management which allows you to let some specific users see document classes. Did you check this regarding to your problem? Document Management\Basic Data\Document Class Management - “Persons and groups Tab” Regards. Servet
Hi Mattis This can also work as a on clause: on 'PART_NO=' || pc.part_no || '^' = tor.key_ref Regards
Hi; As @Rusiru told before your url must contain the correct “frm” name. “ifsapf:frmWorkOrderPrepareTab?COMPANY=KP” If it is customized probably it is changed. You can check it from system information tab of your customized screen: Regards. Servet
Hi Callum, may be “command_sys.mail” need an “ifsapp.” ? I am not sure but i guess it worths to try. regards
Hi pankaj, Can you try to change the passwords on Oracle User screen in APP9? I mean Maybe Password of ifsmon? Regards.
Hi Pankaj I guess You just have to ask for a password reset to your system administrator. Because After 11g Oracle DB does not store clear passwords and it keeps them hashed. If you forgot your password it must be changed. Regards
Hi @baris.halici , You should use system defined “Run application Server Task” as the Database Task. Like This: And you should pass the application_message_id parameter of your report formatter. Regards.
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.
