Just noticed the same issue happening in 23R1 too. It will spin around for good 20 mins until it gives up.
Hi Asanka, Great work this could save us a lot of time, I work with Linda in technical and I tried to run the script. When I run in PLSQL I get clob_to_blob not declaired: ifsapp.edm_file_storage_api.write_blob_data(objversion_, objid_, clob_to_blob(rec.text)); Am I doing something wrong or could this be because we are using 22.2? Thanks, Alex Sorry, mate. My bad. Forgot that it indeed needed a custom function deployed prior to work (as there is no standard clob to blob conversion as far as I know). Please deploy the attached before running the script. If you prefer not to create any database objects, you may add this function in the script as well. I’ve dug up this function from the Internet, but works fine for what we’re after.
Would it be possible for R n D to develop script so we could at least extract the data on Sticky Notes? We use them extensively - things like flagging up an issue on a customer accout so anyone dealing with the customer either in Sales or Finance instantly sees the issue. Not everyone looks for or has the will to seek out a text box or even look for a checkbox and then have to RMB to Notes to view the comments. We are making the move from Apps9 to Cloud and it’s one of the things users have mourned the loss of quite heavily. In Cloud we are thinking of adding a custom notes field and have it conditionally formatted and/or visible if there is any text in the field - to give the users that instant ‘in your face’ notification … as and when conditional formatting makes a return, of course. In readiness, it would be helpful if we could identify where those sticky notes are and what the text is so we can replicate. Hi Linda,I used the attached script, which will recreate all s
Hi @Lakshan Thiranagama We are discussing the move to MSO in our environment. We do have APB, but the last I used was 10 years ago in an implementation. I believe APB might have improved since.In your opinion, what are the pro’s and con’s of using MSO vs APB apart from the price point? We are after least amount of manual intervention with scheduling to reduce the admin time - so I reckon MSO is better in this perspective as I believe it can do automatic optimization in the background? Could APB come close if we automate the loading and scheduling, say, each day at 8am? How is the general feel for the user with MSO as opposed to APB?Cheers mate
Can confirm IALs are available with full functionality in 22R2.
If you can’t get a “short-enough” url that accepts custom parameters and will link directly to your desired window, possibly another approach is using a lobby. Create a lobby and an element that accepts input like buyer id with a parameter BuyerID. If the element type is Link, it would be able to take you to the approproate reminder by clicking on it. Then you can generate the URL to the lobby like below via the custom event: ifswin:Ifs.Fnd.CompositePageRenderer.PageContainer?page_id=e7c5ab46-fcfd-4f77-8eba-09e24f692b69&BuyerID=FUKMA
Generally, having SOs open for a long time is not a wise idea. For better costing, and inventory optimizations, reckon the SOs should be completed as soon as possible. Your accounting department will always appreciate having less value in WIP components. For your environment, you may consider the following options and more: Using lot sizing rules to have many shop orders with smaller quantities, rather than one big shop order with larger quantity that stays open for a long time Introduce extra levels in the BOM, so that you can receive partially completed products as semi finished goods and keep it in inventory rather than WIP.
If the images are hosted on a shared path (i.e. not in the database), you can show them in CR as follows:Modify the IAL to something similar to get the path and filename Add image in CR and link the path like below If the image is the database, you can pick the image data from the blob directly and add to CR
Have you played around with the Printer Definitions window by changing the Report User Printer and/or User Printer tabs? Do you have a central way of reporting in IFS whenever a user’s assignment of a truck changes? For instance, it could be the remote warehouse assignment. If you’re handy with a bit of custom events, the system can automatically change the default printer assignment to the user; else, it will need to be done manually when the truck assignment changes.
Go to inventory part, zoom in on Part Status column. Once you are in the basic data, if there isn’t any, create a new part status for P - Phase Out. Set it as supplies not allowed, but allow on hand and demands. Update your inventory parts with this part status - which will allow to consume parts, but not create any supplies like purchase reqs.
You could use a custom event to issue out the parts when they are reserved.For the shortage handling to work, a reservation must be attempted on the demanding orders (ex. shop orders). If this attempt is not made, the system won’t create a shortage alert, even if the parts are actually in short. Therefore there is a chance you would likely miss out on get alerted about the shortage parts. A more sure way is using auto reservation using a scheduled background job. See the suggested steps below:The stores will receive the parts as usual and put they away at the default store locations. The system runs a background job, say every 2 hours, and reserve parts to demanding orders based on a custom priority order (ex. international customer orders first, then local customer orders, then top level shop orders, then component level shop orders, etc.) The system generates pick lists based on new reservations, say every 4 hours and optionally prints to a printer A new lobby item can be set up as
Hi Malik :) We were also planning on using survey answers to display on the mWO, though we are yet to get to it.I’d use the custom field avenue which you have already explored with some changes. Instead of using many custom fields, why not use one custom field? The idea is to combine both questions and answers into a single field with a plain-text format like below, using special characters and tab for indentation for easier readability. Since the number of questions are known, and there are no free-text open answers, you might be able to find out beforehand if the total character length does exceed 4k limit allocated for a single custom field. If it does, you could add maybe 2 or 3 custom fields instead, based on the category of the question.
One option is to change the logic of the custom field, or a second custom field based on the original, so that the shown value is suppressed depending on the value of Project Category.Add something like below to the logic of the c/field:-- (Case when <proj_category> = 'ABC' then <value> else '***value suppressed***' end)-
You could get this info with a quick report if you are handy with abit of SQL. You will need to set up history logging for the field Asset Class. The system then would be able to track the historical value of the Asset Class on a given date. A quick report then can be based of your historical inventory value screen, and then combine with the historical values of the Asset Class to get the info you need.
Good points from @Björn Hultgren. If the parts are to be sent in a truck from main warehouse to the shop floor, and the transportation time is long enough to consider, I would use a transport task in this instance and not a pick list. Executing a pick list would show up as WIP in the SO immediately, but the truck may not have left the warehouse, and might be a few hours or days away from even starting the physical manufacturing process. It just might create a significant disjoint between the system’s representation and the actual process. I’d use a pick list if the warehouse is pretty much in the same/close vicinity as the shop floor inbound location. With a transport task, you can execute the parts so it gets in to the transit location before it is acknowledged and receipted at the shop floor inbound location - this gives an extra level of granularity of tracing for the parts. Since the receipted parts are still showing up in inventory (as they should), you can, if you wish, perform q
If it’s an advanced search can’t you use IN clause to pass multiple values to the search box? Something like below in the where condition: part_no in (select part_no from inventory_part_in_stock i where i.qty_onhand> 0)
Hi, How do I get the IAL to take the lobby parameter Supplier_ID? I want only the data for the specific supplier to be visible. Can the IAL take a parameter in the definition, $SUPPLIER_ID$? In which case, the IAL needs to include Supplier_No column too. It could look like below:Then in the lobby config, you can retrieve data related to your supplier by adding the condition Supplier_No = $SUPPLIER_ID$
You’d need to create an IAL using your query so it has two columns - Information and Value. Then sort the data rows so it represents exactly how you have illustrated above. Then simply create a list element sourcing data from the IAL. See your IFS documentation on information about creating an IAL.
Has anyone ever enabled a Custom Field in their WADACO configuration? We have a custom field we want to add into our Transport Task configuration in WADACO but have not done this before. Using Apps 10 UPD 10. While custom fields are not supported, if you post what field/data you are after, perhaps there might be a work around.
Agree with what @durette has mentioned. You will need an OCR software to rename the file so that it has a match to IFS part name. I have many processes set up that are utilizing Oracle’s utl_file package to read external files and write their content back to IFS, so reckon you could use something similar.The only drawback is as it cannot read the file listing as @durette has indicated. Utl_file.fopen() procedure requires you pass a specific file name to read. What you can do is try something similar to an old school brute forcing. Its effectiveness will largely depending on the number of parts in your system and the performance impact.I’d loop through a cursor having a select of all parts applicable, and construct a dynamic file name, such as <part_no>.jpg, and then use utl_file package to check if this file exists. If it doesn’t, move to the next part. If the file exists, then attach the file to a business object in IFS using standard IFS method. See snippet below: FOR rec1 IN
Are you merely inserting data to tables bypassing IFS methods (e.g. using statements like INSERT INTO instead of SUPPLIER_INFO_GENERAL_API.NEW__)?
Think the best means to achieve no.2 is using an info card. It can be moved to a desired place and will keep displaying read-only info. The info card is pretty easy to set up, and can fetch data from a custom field set up on the supplier.
Not sure about the exact context around the objects or reasoning, but if there is any relationship at all, the period character was the cause of many headaches while fixing CBS issues back in the day (probably about 12 years ago). The period character was in primary keys (I think it was in the part number), and CBS was playing up with strange errors that were difficult to decipher. You might be able to dig up some more info in the knowledge search. There is a system parameter - “Define the characters which should not appear in Key Fields”, which has the period key added in as default to possibly avoid these issues.
To implement a fix without changing anything else, use a good old custom event to trigger an error message when they try to report to an operation that they shouldn’t.
A query is taking more than 1 minute to execute.as a result lobby element is showing a timeout error(as shown below), is there any possibility to increase the refresh timing of IFS lobby page? If yes.. please guide me.. Thanks in advance. note: IFS 9 -lobby The setting is in Ifs.Fnd.Explorer.appsettings file. Look for Ifs.Fnd.Explorer.appsettings_sample in the installation directory and modify its content and then rename it to Ifs.Fnd.Explorer.appsettings. We have lobbies that run complex calculations, and with many optimizations and offline data tables, it still can clock closer to 60 seconds, but in your case it might be possible to tweak a few things and get the results to display in a shorter amount time. This is always the best option than increasing the timeout delay. Check if you can use IAL views with snapshot data, and using more efficient joins instead of PL/SQL functions.
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.
