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

This will include the questions related to Foundation1 and Technology, Infrastructure, Cloud, Integration, Developer Tools, Data and IOT, and Platform.

  • 7,035 Topics
  • 22,007 Replies

7035 Topics

L
Do Gooder (Customer)
lgerstnerDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Formatting in reports

Hi All, We are using IFS 9 and we have the following problem with reports:   In much description-fields the text will be formatted by the user using tab key. These descriptions are "unreadable" in reports designed with IFS Report Designer or Crystal Reports:     The C#-forms shows us probably more spaces for a char(9) as the database? How can I show a "nice" formatted text in the report? Can anybody help me?   Best regards Lucie

8
L
Do Gooder (Customer)
4 years ago
S
Do Gooder
shewaDo Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

WHERE clause in Custom Field

Hi, I have created a custom LU and one of fields requires LOV. LOV view is a standard view and I want to pass a WHERE clause. In this case, view is DISCRETE_CHARAC_VALUE and I always want to get records in LOV WHERE CHARACTERISTIC_CODE = ‘ABC’. How can I get this done?   Appreciate your response. Thank you.  

13
R
Do Gooder (Partner)
4 years ago
SORSITEL
Sidekick (Customer)
SORSITELSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Rolling updates, zero downtime, clustering and load balancing

Hi, I would like to know if Enterprise Explorer would handle rolling updates in this scenario: Cluster of 2+ nodes NGINX load balancer   The process for applying updates would be: Take down 1 node Does Enterprise Explorer switch over to a new node seamlessly without crashing and kicking the user out? Apply the client delivery to that node Bring the node back up Repeat the process for all nodes… Profit? Is this scenario possible without EE crashing?   NOTE: We only deliver client updates using the installer. Database changes are done manually to prevent downtime. This also cuts the delivery process to a couple of minutes, instead of hours.  

3
SORSITEL
Sidekick (Customer)
4 years ago
E
Do Gooder (Partner)
envpankamDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to know the IFS user password in Apps9

HI all,   I forget of my ifs user password and without of this am never stop and start the application. Please suggest how can i know the password.   Regards Pankaj

6
MikeArbon
Hero (Customer)
4 years ago
eqbstal
Superhero (Partner)
eqbstalSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Extending the size of a char field

Hello, A customer of mine has asked to extend one of the fields in IFS9. My immediate answer was: no go. Don't do it. The change is relatively simple when looking at the table itself, but the remaining things? What is your opinion on this? Regards, Steve

6
eqbstal
Superhero (Partner)
4 years ago
E
Sidekick (Partner)
EqAbAl
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

autofill cell: IF country of Cust = X, THEN region of BO = A

how can I autofill a cell with a value, based on the value of another cell; in concreto:   country of Customer is “FRANCE”; customer is used in Business Opportunity; the field “Region” should be filled with A (rule: if France, then A):  

4
eqbstal
Superhero (Partner)
4 years ago
R
Do Gooder (Customer)
riberm1Do Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Use of TLS 1.0/1.1

TLS 1.0/1.1 will reach end of support by Microsoft by end of June, 2020. At our company we run IFS 9 UPD 1. We are using IFS functionality to send emails via IFSCONNECT mail sender, we don´t have right now TLS checked We want to understand: The impact in the email sending functionality from IFS, we don´t know if Office365 will be blocking this feature or we will have any change when current TLS versions become unsupported If we can install TLS 1.2 in our current version Thank you, Mariola

1
Savinda Suvimal
Hero (Employee)
4 years ago
J
Sidekick (Customer)
jhooperyanSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to Setup Connection for Word Macro

We are in Apps10 UPD6 and looking at using the Word Macro functionality (that came out in UPD4) to create our proposal documents for Business Opportunity. Right now - the GET call is prompting us for a database user ID and password.  We actually use ADFS for our user validation, so users don’t have DB IDs. Does anyone know how to set this up for system to system authentication so the user running the macro does not have to login?   The VB code in the Word macro is below    ' Make a request for the URL.    Set objXmlHttp = New MSXML2.XMLHTTP60    objXmlHttp.Open "GET", strUrl, False   Thanks

1
Savinda Suvimal
Hero (Employee)
4 years ago
baris.halici
Hero (Customer)
baris.haliciHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Global Variable Usage to Overtake and Override on IFS Dev Studio

Hi, I want to make changes api procedure(overtake). But, I get an error because of the global variable(Customer_Tax_Info_API.lu_name_). Kind regards.

3
Savinda Suvimal
Hero (Employee)
4 years ago
D
Sidekick (Customer)
david.harmerSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Created Date / Time on Order Report always server time

Dear IFS Community   We have found that when users run “Order Reports” or other Built In reports, the “Created” data/time is always the server time, not the time representing the users locale. Where is this set to change the Report time to the users time zone? Thanks. David.  

1
ChanakaAmarasekara
Hero (Employee)
4 years ago
M
Sidekick (Customer)
MatthewSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

RMB for API Call on Navigator

Hi,   Does anyone know in APPS9 if you can add an option to the navigator which would perform an API call when a dialog box appears.   I am looking at a quicker way - for me - to reopen a work order so looking to make thew recreate_work_order call from Historic Work Order which is a RMB on the table.   Many thanks,   Matthew

3
Harley
Hero (Customer)
4 years ago
J
Do Gooder (Customer)
JuanFranDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Deferred Call with several parameters

Hello,   I want to park an order when a condition in the shop order operation is happening. Execute it directly generates a a mutation issue, so I need to execute the park action n the background.   For that, I have created the following code in a custom event: declare p0_ VARCHAR2(32000) := NULL; p1_ VARCHAR2(32000) := NULL; p2_ VARCHAR2(32000) := NULL; p3_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000) := NULL;begin p0_ := '&NEW:ORDER_NO';p1_ := '&NEW:RELEASE_NO';p2_ := '&NEW:SEQUENCE_NO';p3_ := 'PARK_REASON'||chr(31)||'QUALITY'||chr(30)||'PARK_MRB_NO'||chr(31)||''||chr(30)||'PARK_CHANGE_ORD_NO'||chr(31)||''||chr(30)||'PARK_ORG_CODE'||chr(31)||''||chr(30)||'PARK_PERSON_ID'||chr(31)|| '#USER_ID#'||chr(30)||'PARK_LOCATION_NO'||chr(31)||''||chr(30)||'PARK_NOTE'||chr(31)||'Nota'||chr(30);Client_SYS.Clear_Attr(attr_);CLIENT_SYS.ADD_TO_ATTR('ORDER_NO_', p0_, attr_);CLIENT_SYS.ADD_TO_ATTR('RELEASE_NO_', p1_, attr_);CLIENT_SYS.ADD_TO_ATTR('SEQUENCE_NO_', p2_, attr_);CLIENT_SYS.AD

8
J
Do Gooder (Customer)
4 years ago
H
Hero (Partner)
Hans AndersenHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Shortcut to specific tab

Hi, How do I make a shortcut to a specific tab. E.g. instead of going here:  I need to go here (same address):  

2
H
Hero (Partner)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Reprt Export to Excel removes leading zeros

Hello, The problem is when a user export report to excel 1- lost leading zero’s from Check # 2- Formatting is off: Excel shows 2.0031E+13 while actual value in report is 020031003282756   I tried to_number but it gives me error ‘ORA-01426:Numeric Overlfow’   any work around options here. Thanks

11
O
Sidekick (Customer)
4 years ago
karllinder
Sidekick (Customer)
karllinderSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS 2020 R1

Hi   Have read the relased IFS Roadmap for IFS Products, one question that I don´t get a clear answer on is this: Is IFS 2020 R1 a new core release or should we see that as an “update” on IFS 10 ?   /Karl

4
J
Do Gooder (Customer)
4 years ago
Dineshy7
Sidekick (Partner)
Dineshy7Sidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Displaying signature within crystal reports

Wondering if it’s possible to display signature image in Crystal report (held under attachment of an particular screen or Document Revision within IFS)? If yes, please share details. Thanks

2
servetsc
Do Gooder
4 years ago
HOOJAGR
Do Gooder (Customer)
HOOJAGRDo Gooder (Customer)
posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to incorporate or transfer these Custom Fields in the Standard View

I have made Custom Enumeration. This can be seen on the Sales Part and on the Overview Sales Parts. Every thing is working and can also be queried. However if I want to select a column in the data Source Designer, I can’t see these custom columns. This also applies when I want to use the Event action field. Question: How to incorporate or transfer these Custom Fields (&AO.W_I_B_R_PERS_CFP) in the Standard View Sales Parts (%AO.SALES_PART)  

2
HOOJAGR
Do Gooder (Customer)
4 years ago
J
Sidekick (Customer)
jhooperyanSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

SSRS as a Lobby Element

In Apps8 - there was an option to display SSRS reports in the Analysis pane at the bottom of the screen.  In Apps10 - the Analysis pane is now the Lobby pane.  Does anyone know if there is a way to use an SSRS report as a Lobby element there?  For our purchasing - we get PO status / update information from suppliers in a SQL server.  Currently users get that data through an SSRS report in another window.  Ideally, I’d like to display the report data in the lobby pane so it’s automatically all there for the current PO. I’m trying to not have to create new tables / LUs in Oracle and then replicate the data from SQL to Oracle.

3
J
Hero (Customer)
4 years ago
HOOJAGR
Do Gooder (Customer)
HOOJAGRDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Event with stream action

We have created an event, it will be triggered when the name of the user changes, the mentioned user in the custom field gets an Stream. This works, but we have one issue: What we want is, that the user, who gets the stream, immediately could go to the salespart mentioned in the stream (via the link in the stream). We think we could arrange this in the screen below, but we are not sure. Anyone who knows?   At this moment, when we got to the stream, we get an empty salespart field.   Thanks in advance

4
HOOJAGR
Do Gooder (Customer)
4 years ago
baris.halici
Hero (Customer)
baris.haliciHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to add Lobby Element Icon?

Hi, How to add Lobby Element Icon as pictured?   The example I want it to be  

2
Sandun Madola
Hero (Employee)
4 years ago
I
Sidekick
imharshit003
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to hide/unhide the screen from Navigator in IFS Aurena

Dear All,   Does somebody know how to hide/unhide the screen from Navigator in IFS Aurena.    Thanks in advance!   BR, HA

5
Rusiru Dharmadasa
Superhero (Employee)
4 years ago
jbernardo
Hero (Partner)
jbernardoHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Business rule Alert - Previous Service History

i’m really stumped on how to put together this business rule. basically if a piece of equipment has been service more than 3 times within the last 30 days, we want a pop up alert to notify the user of these details. This would be before insert of a request (or after if that works best)   It would be similar to how when you create a request for a place that has existing service calls  

0
jbernardo
Hero (Partner)
4 years ago
D
Hero (Customer)
dmanueleHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Track User Activity

I am interested in tracking user activity in my IFS8/Oracle 12c system. The type of information I am interested in is: When was a module or transaction last used? Which users are using which modules or executing which programs? What are the most frequently used modules or transactions? What modules have the highest CPU usage? When I query gv$session I can see the current users and what they are executing, but I am looking for historic data. I know this information might be available from Oracle OEM, but due to separation of duties, I do not have access to this tool.

2
Charith Epasinghe
Superhero (Employee)
4 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Print Agent log file

Query regarding the Print Agent log files. Does this file get archived and cleared down? What would you recommend?  

2
ChanakaAmarasekara
Hero (Employee)
4 years ago
Y
Do Gooder (Customer)
YezdiJKayDo Gooder (Customer)
posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Automated testing

Hi.. I’m Looking for recommendations / suggestions, on test automation software... I am working on IFS 10 and am looking to develop an automation framework around the E2E test scenarios. I was thinking of either Selenium or Katolan. If anybody has experience of these id appreciate some guidance and suggestions. How successful has it been, and is it worth the effort involved. Any suggestions helpful.… thanks.. YK

0
Y
Do Gooder (Customer)
4 years ago

Badges

Show all badges
Terms & ConditionsCookie settings