Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Does anyone have a decoder ring for database objects as to what the symbols and colors mean? Some text is blue, some is black, some have a diamond that isn’t filled and others it’s filled. My assumption is that it means either granted or only granted query, but it would be nice to know for sure what it all means. Thanks!

Hi Team, We are creating order reports , but instead of PDF the data should go into excel and send over the mail… Can anyone help with the solution Thanks, Srini

Hi all After installing one extended server in Linux Apps10 upd 6 oracle database 19c. I have realized plsqlap access provider is not working well due to one oracle acl problem. I was trying to create new acls but the problems is not solved. I got this error ORA-24247: network access denied by access control list (ACL). Any help about how create the acls. I thought recreating the instance of the extended server will resolve the problem but not. Any help will be welcome? Regards

Hello Community, after installation of IFS, the processes will start all correctly (startifsAPPS10.bat). The website will shown https://HOSTNAME:48080 correctly. But when I start EE it will be get an 404 Error. There is no service under https://HOSTNAME:48080/main/default/clientgateway Does anyone have an idea?

How to make make in report designer simple condition/rule what to show value from another field if one is empty. Two variables CV_PART_NO SO_PART_NO I’d like to get one field condition that if CV_PART_NO have value, use that, other wise SO_PART_NO like in plsql NVL(CV_PART_NO,SO_PART_NO)

I have the following code, that updates the required date on Project Navigator Demand based on a custom field. It runs fine as a custom menu, but when i run it as an event on creation of a new demand line, it crashes with a mutating trigger error. I believe it’s because I’m selecting info from the table I’m trying to update. Whats the best way to get this to work? TIA. PROCEDURE Update_ProjMiscDem_ReqdDate(MATR_SEQ_NO_ IN VARCHAR2) IS attr_ VARCHAR2(1000); info_ VARCHAR2(1000); offset_ NUMBER; objid_ VARCHAR2(1000); objversion_ VARCHAR2(1000); CURSOR get_parts IS SELECT p.objid, p.objversion, p.activity_seq FROM project_misc_procurement p WHERE p.matr_seq_no = matr_seq_no_; BEGIN info_ := NULL; OPEN get_parts; FETCH get_parts INTO objid_, objversion_; CLOSE get_parts; offset_ := work_time_calendar_api.Get_Work_Days_Between('*', activity_cfp.Get_Cf$_Receive_Parts_By(activity_cfp.Get_Objkey(activity_seq_)), activity_api.Get_Early_Finish(activity_seq_)); CLIENT_SYS.CLEAR_ATTR(attr_); CLIE

I have created a fairly simple query here selecting all order lines in a “Planned” or “Released” status, where Part No is like “-”, and any value in part description. I then sum the Sales Qty for the Part No that is grouped. Our issue is our Part Description is not unique so I really do not need to separate by part description, but if I do not group with it the field does not return values. As you can see for Part No 100-ST50 we have a description of Diamond 20# and a description of Diamond 20lb, I simply need the first description shown for a reference and need the subtotal for part no to include all entries so the subtotal for part no 100-ST50 should be 950. I do not know how to have SQL simply return the first distinct value for part description.

when creating an IFS user how to select an oracle profile, by default it is selecting the oracle default profile, I have created an oracle profile to use password verification function. when I create a new IFS user I would like to select the oracle profile I have created instead of the default Oracle profile

Hi, I am doing some Report Designer changes to a layout and struggling adding a new table. I want to add a table in between existing two tables, but new table always goes to end of the Page Body. How can I move the new table where I want? Appreciate your comments. Thank you.

I would like to create a custom menu RMB to issue material passing the PART_NO and WORK_CENTER display the related detail from the SINGLE_MANUAL_ISSUE_SO view. AND on displaying the detail prompt the user for the enter the LOT_BATCH_NO. Is this possible? Normally, I would use the frame but

I tried a function ‘Amounts to words’ in report designer and I used like below ‘vldtmath:amountToWords(tns:NET_CURR_AMOUNT,'ar',tns:CURRENCY)’. When I used for german language code or other language codes its translating and showing in mentioned languages but when I tried in Arabic or Korean languages its is not translating in the report. if currency is 1000 means output for ar/ko : One thousands. Please suggest any solution or give me reason why its not coming in report.

Hi All I’ve created a Custom Field in Document Management and ideally want it visible in the attachment view on the connected objects. Is this the view the ‘DOCUMENT_VIEW_ACCESS’? If yes how can a OBJKEY be made available as I can’t get this view approved. Or is this just not possible? If I expand to the ‘more’ option on the view the custom field is available. Thanks for reading

Is it possible to administrate the User Settings in Document Management Basic Data for all users rather than manage them individually from the user? I am not able to find these in profiles or user settings.

Hi I was trying some troubleshooting, and changed a setting I obviously shouldn’t have. Due to most users having the “Oracle Profile” of “Default”, I thought it would be fairly safe to change this setting in our test environment: Short after, our test environment crashed. Trying the MWS scripts, I get: A small snippet of the logs: <Feb 28, 2020 8:06:17 AM CST> <INFO> <EXPMIGR> <MainServer1> <The server 'MainServer1' with process id 12596 is no longer alive; waiting for the process to die.> <Feb 28, 2020 8:06:17 AM CST> <INFO> <EXPMIGR> <MainServer1> <Server failed during startup. It may be retried according to the auto restart configuration.> <Feb 28, 2020 8:06:17 AM CST> <INFO> <EXPMIGR> <MainServer1> <Server failed so attempting to restart (restart count = 1)> <Feb 28, 2020 8:06:17 AM CST> <INFO> <EXPMIGR> <MainServer1> <Starting WebLogic server with command line: C:\EXPMIGR\wls_domain\EXPMIGR\bin\ifsStart.cmd > <Feb 28, 2020 8:06:17 AM CST> <INFO> <EXPMIGR> <MainServer1> <Working di

Hi! When a custom LU and fields are added, IFS automatically creates a package to insert, modify and delete custom data. Is there a way to safely modify e.g. CF_NEW__ procedure in the custom package to add extra validations? I assume the CFP package will be overwritten when e.g. a new custom field is added or reinstalled and all changes will be lost, so it is probably not straightforwad. Any ideas? Thanks! Regards, Rafal

Hello Guys, Does anybody have a doc/PDF or know any external link regarding creating a new RMB and link a report or window ? Or If you can explain step by step also appreciated

Hi, when I scroll my mouse over a field in IFS, the field turns black. I can get the information back when I click on it again. Is anyone else having this issue? I am using IFS Version 8.

In my quick report I'd like to select a date range going back to the first of last year, so for today, 2/26/2020 it would select 1/1/2019 - today. date_entered between sub_months(trunc(sysdate, 'YEAR'), 12) and trunc(sysdate, 'YEAR')-1/24/60/60 I tried a sub_month but that didn’t work. I’m already using this format for going forward one year: OP_START_DATE between trunc(sysdate, 'YEAR') and add_months(trunc(sysdate, 'YEAR'), 12)-1/24/60/60

Dear All, Can we do the profile import/export of Aurena. If yes then how can we do the same. Thanks in advance! BR, HA

Hi, i have issue about customization deployment. After f1 mage, the IFS 10 application does not download automatically. advice please. Thanks.

Is Oracle VMWare supported by IFS for IFS 10?

Does anyone know if there is a way to create an outline around fields on a page? There is an existing outline on the page but we want to create a new one for some custom fields that have been added. This is an example of the out-of-the box outline. We’d like to add one or more new ones.

Hi, We are trying to create a report to get list of users and their last login time using the view ‘ORACLE_ACCOUNT’ and few other views. We noticed that users who login using webclient(b2e) do not have correct information in this table. Is it because webclient users some common oracle user (e.g ifswebconfig) for the oracle sessoin even though user login with his/her own user? Thank you Upekha

I am trying to create a business rule that does the following: When creating a task, look at the default brand on the request_unit and insert the correct template based on that model number. So if Default_Brand = FRANKE then put in FRANKE Task Template. I tried to do this Right now - its putting it on all tasks. I figured this is because i set the value table name and column under the input properties. Must be just matching off all the table values instead of the request unit. The model/request unit isnt put on the task until AFTER the task is inserted so thats why im trying to look back at the request. If it was on the task before insert then this rule wouldnt be so much trouble

Hi, A customer of mine has a database with a number of companies that have been sold. This data should be obfuscated. I’ve found another term used for this: data masking. So customer number might be the same, but the name is totally different. Does anyone have any experience with a tool that can perform this or has an idea how to start this from ground up (no problem if I need to prepare one, more or a lot of PLSQL APIs). Thanks in advance, Steve