On every customer order you end up with this What is “this”? Are you getting too many decimals?
I’ve seen this issue at multiple companies and have yet to see a cleaner solution than creating multiple supplier IDs.Depending on your industry, you might lose quantity-sensitive pricing if you don’t buy centrally. Also, depending on your industry, you might end up creating duplicate part numbers if your engineering isn’t centralized.
Hi, Yes of course. When you create the RMA for the CO line, RMA will have multiple lines for each Components. However, when the CO was delivered, you should have your components in the Package Part Structure. Package structures create extra lines on the original order (with LINE_ITEM_NO not equal to zero), but manufactured structures don’t do this. All the IFS customers for which I’ve worked have wanted to do component-level RMAs for manufactured parts at some point.
You might try a custom field to record the status less officially.
First, clear your personal profile--just yours, in a nonproduction environment. (This is to make your profile less cluttered so you can find individual branches.)Then, log in as yourself and navigate to that screen.Enable the field in the layout if necessary.Go to any record. Go to your new field and hit List of Values. (I called my example custom field “User Responsible”.)Click the button on the right to do a search.If you use the FndUser example, here's an advanced search to find users granted a particular permission set: identity IN ( SELECT identity FROM ifsapp.fnd_user_role_runtime WHERE role = 'YOUR_PERMISSION_SET_HERE')Perhaps you only want active users.identity IN ( SELECT furr.identity FROM ifsapp.fnd_user_role_runtime furr JOIN ifsapp.fnd_user fu ON fu.identity = furr.identity WHERE fu.active = 'TRUE' AND furr.role = 'YOUR_PERMISSION_SET_HERE') Save that and then hit Search. I called my example “My Saved Search”.Now the top of the form will sh
It looks like the flush just fills in timestamp -- is that right? Because I was able to make a change in IEE then see the table affected in USER_TAB_MODIFICATIONS. It just had a null in timestamp. But when using am environment where no one else is in it, it still worked to find the table that got used, because everything else had timestamp filled in… Forcing a flush before and after narrows the time window and improves the signal-to-noise ratio. If your system isn’t getting hit by constant background jobs, then that could be an optional step.
Rather than use an Enumeration, you may want to use a Reference. My screenshots are from Apps 9. Then, in the List of Values dialog, you can use a saved search to narrow your options. In the base profile, you can make that saved search the default when the LOV pops up.
Hi “ThushAsanka”, But, as I can see, this option is available only in the IEE version of the Application and I am unable to trace any information, as my customer is currently using the Aurena client of Apps 10, upd 11. Do we have any similar functionality to keep track of the history logs of Purchase Requisition/Part Requisition Line/No Part Requisition Line as such, or anything equivalent to this in Aurena client? History logging happens inside the database, as an Oracle trigger. If you set up history logging for a logical unit inside IFS Enterprise Explorer, that setting will carry over to IFS Aurena. Hi Durette, I do agree with you on the same point. But, the concern here is the customer is using the IFS Aurena client, upd 11, which is currently not allowing them to view the complete history log information of the activities, at the front end part of the application, which I believe predominantly is not even visible in the Aurena client
loud and clear
Hi “ThushAsanka”, But, as I can see, this option is available only in the IEE version of the Application and I am unable to trace any information, as my customer is currently using the Aurena client of Apps 10, upd 11. Do we have any similar functionality to keep track of the history logs of Purchase Requisition/Part Requisition Line/No Part Requisition Line as such, or anything equivalent to this in Aurena client? History logging happens inside the database, as an Oracle trigger. If you set up history logging for a logical unit inside IFS Enterprise Explorer, that setting will carry over to IFS Aurena.
The correct suffix is a backslash \not a forward slash / If that’s already correct, ensure their workstation has the correct version of the Crystal runtime installed.Using _A and _I suffixes is less troublesome than \ and \\, since they doesn’t depend on registry settings for InvalidAliasCharList.
I’ve done something like this as a report, where the part numbers were six-digit integers. This returns the part numbers which are available to use within a given range. SELECT TO_CHAR(LEVEL + range_.min_ - 1, 'FM000000') AS part_no FROM (SELECT 100000 AS min_, 199999 AS max_ FROM DUAL) range_ CONNECT BY LEVEL <= range_.max_ - range_.min_ + 1 MINUS SELECT part_no FROM part_catalog MINUS SELECT part_no FROM eng_part_master MINUS SELECT part_no FROM inventory_part MINUS SELECT part_no FROM purchase_part ORDER BY part_no ASC
If you’re asking everyone to take their time to answer your question for free, it’s only fair to provide the same kind of help you’ve requested to some future person who might have the same question.Never mind, I fixed it! And here's how... : talesfromtechsupport (reddit.com)
20 may not be high enough. Check out Don Burleson’s test results here, as he increased the sequence cache size for parallel execution across nodes:Sequence cache and RAC (dba-oracle.com)
@durette there are no blockers or waiters and yes, it is RAC. I am waiting for the DBA people to check on the Doc ID 2097993.1 thing, they have a Oracle case open. So, right now that is where I am leaning for a best answer. I will update with more…. If that doesn’t work out, I have a hunch you’re waiting for the TRANSACTION_SYS_LOCAL_TAB table to get synchronized between your nodes.In IFS Enterprise Explorer, under Batch Queue Configuration, under Cluster Setup, there’s a field called “Attached to Node”. If you can afford the performance hit, moving all your background jobs to the same node might prevent any synchronization delay.Make sure your TRANSACTION_SYS_SEQ sequence has a healthy cache size. (I believe the default is 20.)
That’s a huge question, and there’s no way I can give a complete answer here.The modern way of interfacing with IFS is to use web service calls. If you’re new to IFS, I recommend learning Aurena as soon as you can. This is only available in IFS Applications 10 or IFS Cloud. This provides a separation layer, and database skills become less useful than an ability to make OData RESTful calls. In Apps 9, the best way to interact with the system is still through the Oracle database. (Others may disagree with me here.) My favorite tip for people learning Oracle is to start here:SELECT * FROM dictionary;The V$ and GV$ views are from the instance. The instance is the running process in memory.The USER_, ALL_, and DBA_ views are from the database. The database is the collection of files on disk.That means everything in the V$ views goes away when the database gets restarted. These are things like processes and sessions. If you’re doing business analyst or reporting work, these will be less usef
Hi @CheKazuAz, enabled any security scanner tool, which remove tmp files from the machine, once they are created. It is recommended to always have the security scanner tool disabled on the machine. running Anti Virus scan can lock files and halt the IFS Middleware Server installation process. It is recommended to always have the Anti Virus Protection disabled on the machine. What is the point of having antivirus software if you disable it for the most risky folders (like %TMP%) and at the most risky times (like software installation)? In such a situation, can you still legitimately tell your management that your machines are protected? This is like buying the strongest lock you can afford for your front door but then leaving the key taped to the door for the convenience of package delivery drivers.If a system is compromised after following this advice, I sincerely doubt IFS will accept responsibility and underwrite the loss.Instead, I recommend you point your IFS installer to its
Can you use the SQL expression SYSDATE? Even better, in a global environment, you might want to use the site date for the user’s default site:site_api.get_site_date(user_allowed_site_api.get_default_site)
If I’m understanding correctly, you have a persistent field on the LU BusinessLead. You want this persistent field to reference the LU CustomerInfoAddress. When your user pulls up the LOV selection, you want them to only be able to select addresses for that particular customer without having to filter again for that customer.If you already have a customer address from which to pick, it sounds like what you’re capturing are not leads but rather opportunities.Nevertheless, MitDenukN’s solution above should work, or you can reference this other post which includes examples in both IEE and Aurena:Filtering LoV in Aurena | IFS Community
While it’s stuck, are there any blocks?Is this a RAC environment?-- Show waitersSELECT * FROM gv$session WHERE final_blocking_session IS NOT NULL;-- Show blockers and waitersSELECT * FROM gv$session WHERE final_blocking_session IS NOT NULL OR sid IN (SELECT final_blocking_session FROM v$session);
Create a custom field on SalesPart called PACKAGE_QUANTITY, of type Number Create a Custom Event called VALIDATE_PACKAGE_QUANTITY, on LU CustomerOrderLine and table CUSTOMER_ORDER_LINE_TAB. Fire on new or changed objects, when BUY_QTY_DUE is changed. Expose the new values of BUY_QTY_DUE, CONTRACT, and CATALOG_NO. Create a new Event Action, of type “Execute Online SQL”.DECLARE package_quantity_ NUMBER;BEGIN BEGIN SELECT sp.cf$_package_quantity INTO package_quantity_ FROM sales_part_cfv sp WHERE sp.contract = '&NEW:CONTRACT' AND sp.catalog_no = '&NEW:CATALOG_NO'; EXCEPTION WHEN NO_DATA_FOUND THEN NULL; END; IF package_quantity_ IS NULL THEN RETURN; END IF; IF MOD(&NEW:BUY_QTY_DUE, package_quantity_) != 0 THEN error_sys.record_general( 'CustomerOrderLine', 'BADPACKAGEQTY: Part number :P1 must be sold in lots of :P2 per Acme business rules.', '&NEW:CATALOG_NO', package_quantity_)
BPA runs at the client side, right, inside the browser? That means it won’t have this issue.
The issue is, it is existing in all the customer environments as well. So, the same error will be appeared in customer environments as well. Also, I didn’t notice a script or anything that had added this. Also this doesn’t exist in R&D environments as well. I’m sending you a PM.
I’ve learned the hard way that custom event error messages should include breadcrumbs for IT so they can be debugged, even if it’s only the inclusion of your company name in the message to make it obvious it’s not standard.
The SELECT above could probably be removed. You can get the value using the &OLD/NEW syntax instead. Then I assume the UPDATE will go well since that is the custom field table, which is not what you are triggering on. What do you think, @Tomas Ruderfelt? Yes, something like this:BEGIN UPDATE jt_task_cft SET cf$_pri_plan_date = '&OLD:PLANNED_FINISH' WHERE rowkey = '&OLD:ROWKEY';END;
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.
