Replies posted by durette
Putting all our nonproduction Oracle Database instances on the same Oracle Home has caused us problems when it came time to apply a patch. After upgrading the Oracle Database software and instance, if uplifting the database files requires additional work, then every environment will be down until that fix is applied to every environment’s database. Staging these upgrades to different environments allows us to figure out solutions for such issues in a less-critical environment (like DEV) while user training and process development can continue to happen in a semi-critical environment (like TEST or QA).You can run multiple Oracle Homes on the same server, but this gets quite tricky because you’ll have to be extra mindful of how you manage the environment variables ORACLE_BASE, ORACLE_HOME, ORACLE_SID, and PATH.
Bump.I need this because I’m trying to rebuild a version of Sticky Notes using custom objects.I migrated the data into a Custom Logical Unit. I created a Custom Tab to it.but the key filtering isn’t working However, a “search in context” works on the tab.That “search in context” brings up what I want to happen automatically:and since this is for our upgrade where stickies are going away, I really need it for Aurena.
We use FTP currently, but FTP isn’t encrypted, and that’s why I’m here. I’m working on an upgrade and am hoping to improve our security posture in our new version. Shared storage isn’t feasible in a global HTTPS scenario where not everyone is inside our network. Database storage has many drawbacks:It hides the document files from format-aware antimalware protection, leaving us less protected from dangerous files that might get checked in by the end users. It slows down backups, and should recovery be needed, it leads to longer downtime. It slows down nonproduction copies. It slows down upgrades, increasing downtime during the go-live. It increases the cost of hosting nonproduction environments. Migration work is inconvenient now that direct database calls are discouraged. Cached LOB access competes for space in the buffer cache. It leaves us with a bigger upgrade should IFS ever decide to move away from Oracle. I guess we’re stuck with FTP. It would be nice if the middleware could read
And, at least initially it’s only for managed cloud customers I think That’s disappointing.IFS Cloud | Global Enterprise Software Solution | IFSChoose from:Cloud—deployed and managed by IFS Remote in one of your own datacentersWhatever your choice, you get exactly the same functionality and intelligent capabilities.I think I can understand the technical reasons, though.
You want to use a calendaring expression.https://docs.oracle.com/database/121/ARPLS/d_sched.htm#ARPLS72235I believe this will give you what you want:FREQ=HOURLY; BYDAY=TUE,WED,THU,FRI; BYMINUTE=0; BYSECOND=0;Using SQL*Plus, here’s how to check to see what a particular schedule expression will do. This code shows the next 50 occurrences of a schedule string starting from right now.ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';ALTER SESSION SET NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SS.FF';SET SERVEROUTPUT ON SIZE UNLIMITEDDECLARE start_date TIMESTAMP; return_date_after TIMESTAMP; next_run_date TIMESTAMP; calendaring_expression_ VARCHAR2(32767) := 'FREQ=HOURLY; BYDAY=TUE,WED,THU,FRI; BYMINUTE=0; BYSECOND=0;';BEGIN start_date := SYSTIMESTAMP; return_date_after := start_date; FOR i IN 1..50 LOOP dbms_scheduler.evaluate_calendar_string( calendaring_expression_, start_date, return_date_after, next_run_date);
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.
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
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)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.