Hi all!I must have missed RMB Show Foundation1 Component. I simply couldn’t find the table. But now it’s all up and running. Thank you!
Hi again!I’ve activated the FND_USER_ROLE_TAB in history log for all Insert, Update and Delete on ROLE column. I’ve also pressed save, but for some reason the test changes I make are not logged. When checking the actual table, changes are made in ROLE column:But history log dos not show any logs from the table. I’ve successfully activated other tables for history logging, and I can’t remember that there was anything else I needed to to in order to activate them. Am I missing something?
Hi @ELJO the logs are reoported in the table history_log_tab. Thank you! I can see the changes in this table, but should they not be visible also in IEE View History Log?
Ok, thank you! At least I can track changes now. :)
Hi, it all depends on how you’d like to handle the possibility of 1:many relation between the Business Opportunities view and Opportunity Channel tab. If there were to be several rows in Opportunity Channel tab, belonging to one Business Opportunity, how would you like the data to be presented?
Hi,first step is to know how to create custom fields. I may be able to provide you with the code for the fields but I can’t set them up in detail for you. Without a basic understanding for custom objects it will be hard for you to apply a solution in you environment. Here’s the IFS documentation for Custom Field creation:IFS Cloud Technical DocumentationYou should try out some of the instructions in a Test environment to create an understanding of the functions.
Hi, first step is to know how to create custom fields. I may be able to provide you with the code for the fields but I can’t set them up in detail for you. Without a basic understanding for custom objects it will be hard for you to apply a solution in you environment. Here’s the IFS documentation for Custom Field creation:IFS Cloud Technical Documentation You should try out some of the instructions in a Test environment to create an understanding of the functions. Thanks, your link is very helpful, Sorry, Would you please share an exact link for Custom Field creation? I gonna read it and if for you possible I’ll ask my questions and problems. Wish the best Hi, Sorry, I thought I gave you a link leading straight to the custom field chapter, but it seems you cannot share exact URLs. To navigate to instructions for creating custom fields - look at this screen shot:
Hi, Thank you for your response, it means a lot to us!We have tried doing exactly what you describe, but somehow the invoice is not generated although we have invoiceable sales lines. I just created this invoice preview in a new test. It says “Transferred” on the Invoice Preview sales line, but no customer order is created and connected: If this is not how it should work, then could there be a bug?
Alright! Finally a logical pattern! :)The thing is, we don’t have that RMB available. I’m super user with all permissions, so there seems to be a system parameter making this choice unavailable.
Oh, I see. I just realized we have not installed 10.17 in this test environment. I will perform the same tests in another test environment with the correct version. Thank you so much for taking the time to help us!
Hi,We have performed new tests in an environment with the correct IEE version (10.17) and this Revenue setting is doing exactly what we wanted. Thank you so much for your assistance!
Hi,this is, like you say, a temporary view and the view name is the one you have found. It is generated when you search for a specific part and holds the data for a limited time. Data is fetched and calculated from several other views.If you check the debugger, the select for the in tab All looks like this:SELECT date_required, order_supply_demand_type, status_desc, qty_supply, qty_demand, qty_reserved, qty_pegged, qty_short, NULL, &ao.order_supply_demand_api.get_qty_plannable_fast_tmp__(:p0, :p1, :p2, :p3, trunc(date_required), :p4, :p5, '
Hi, no unfortunately I have not yet found a solution to this issue. Do you see any patterns for when it works and when it doesn’t? I still have only had black backgrounds in all of my tests.
Hi @Technical Toby!Thank you for helping, it’s much appreciated!I’ve downloaded and saved the BLOB. When saving you can decide what file format to use. I’ve saved one version of the signature as .jpg and one as .png. Both versions become transparent in the background when previewing them in Windows Photo. It seems the original file format for the signatures is .png. At least it says “data:image/png;base64” in column MOB_SIGNATURE_CLOB, table JT_TASK_SIGNATURE. Regarding the Media Item (coffee machine) I’m not sure what file format it was originally and I can’t seem to find this information in the database. I’ve saved also this image as .png and as .jpg. I’ve emailed you all four images and versions. I hope it helps, let me know if there’s any other data you need to investigate further.
Hi! Order-to-Cash and Production planning Process are two very big processes. To be able to help with the table names I think it would be necessary for you to tell what views you are interested in and what data you need from those views. Is it possible for you to access Ifs and mention a few of the views you need data from?
Hi,I recently saw a documentation for this matter in the support portal. Is this something you can access?Customer Service - IFS Applications 9 & 10 Environment Cloning ServicesThis contains some information about the clone process and also the schemas/tables to exclude while cloning.
Hi Tobias!I greatly appreciate your response. It’s very helpful to know I cannot change this via configurations. Thanks again for taking time to look into this.
Hi,in our test environment this works fine with local, persistent and also reference custom field. At first I could not make it work, but after reloading configurations several times and then restarting the session it seems fine.Have you also restarted and checked again? Let me know how it goes. :)
Hi, May I ask what view this is in and what tab you are applying this conditional formatting in? I may be able to help if I’m able to do some tests in our environment. :)
Already have an account? Login
No account yet? Create an account
Enter your 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.
