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.

  • 5,571 Topics
  • 17,857 Replies

5571 Topics

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

Custom menu type "PL/SQL Block" with window transfer

I would like to perform an action in one custom menu and then move to another window.A simple but not user-friendly solution is to create two custom menus:First: action type: “PL / SQL Block” - execute code (create a new row in the table), Second: action type: “Create window with transfer” - go to window.Is it possible to switch to another window in the “PL / SQL block” (run procedure / function)?

15
durette
Superhero (Customer)
3 years ago
T
Sidekick (Partner)
TecSunilNSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Excel output from Order Report

Can we create an excel output from Order report? If yes, how is this achieved.

20
T
Sidekick (Customer)
2 years ago
H
Hero (Partner)
Hans AndersenHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Solutions for the mutating problem

Hi all, I constantly have to deal with the mutating table error when creating events. Usually I need to: Save (F12) Run some PLSQL in an custom change event (mutating if same table involved) The only solution I know, is to start a background job. However, for some scenarios I need the code to run “online” or lock the UI until the job has executed.   Does anyone has some solutions for this?  

20
madlad
Sidekick (Customer)
2 years ago
Curious_User
Sidekick (Customer)
Curious_User
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Excel Add on tool

Hello Everyone,  I have been working with the IFS software for the past 7 years and our team does a lot of data entry manually. E.g. 5 users 100 lines per Customer order and with a minimum of 5 orders a day. Consultants have asked us why we are not using the IFS Excel Add-in (Also called the Excel migration Tool). Which is a excellent question which imitatively raised major concerns from IT due to the tool being called a migration and accessing IFS directly from Excel (read/write/delete?) . I was wondering if any users in this forum have some stories on how it helped their company and what some of the downsides of the tool are. Successfully implementations To which extend is the Excel Migration tool being used (simple/complex jobs/ Data repair?) Restrictions of the tool Security concerns (e.g.can users destroy the tables of the database using this tool) IFS User feedback (greatly increased process and or productivity or used as a last resort due to time crunch)  Looking forward to the

7
pwlm
Hero (Partner)
2 years ago
Charith Epasinghe
Superhero (Employee)
Charith EpasingheSuperhero (Employee)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Optimum value for job queue processes parameter

Sometimes we have noticed performance drawbacks due to the value set for the "job queue processes” parameter in the oracle database. What is the correct formula for the set this value correctly and what are the things that need to consider?  

4
ToBeNL
Hero (Employee)
3 years ago
krestensb
Sidekick (Customer)
krestensbSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Are you using UTL_HTTP in PL/SQL to call external REST API's

Hi, Are you using PL/SQL to send dato to external REST API ? Will you share your experience with that?   BR Kresten

4
Anushka Rathnasiri
Do Gooder (Customer)
2 months ago
P
Do Gooder (Employee)
Pawel LenczewskiDo Gooder (Employee)
published in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Tip: Collecting Application Server diagnostic information

This topic explains some techniques that can be used to find out what is causing problems with your middle-tier, for instance Connect message problems, security issues, slow running system, etc.It has been created mainly for IFS Applications 8 with IFS Middleware Server  but it should be possible to apply techniques listed here to IFS Applications 9 as well. Some of the areas like Monitoring Console could look differently or have more functionality. Log files should be stored in similar locations as well.In general, in order to figure out where to look for problems, you have to understand which part of the system is involved. Is the middle-tier involved at all? The process where you have problems, is it a background job (Batch server involved) or a synchronous call? Is the client doing a direct call to the middle-tier or is the database invoking methods in the middle-tier (using the PL/SQL Access Provider)?In addition to the tools described here, IFS Solution Manager can also be used t

28771
N
Sidekick (Partner)
11 months ago
Yasuda
Do Gooder (Partner)
YasudaDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

ORA-20000: Oracle Text error: DRG-50857: oracle error in drvddl.IndexSync ORA-06508: PL/SQL: could not find program unit being called ORA-06512

Dear Sirs; Newly implementation IFS 10UPD8 being started at new customer.  The following error message is showed at backgroud job detail. “ORA-20000: Oracle Text error: DRG-50857: oracle error in drvddl.IndexSync ORA-06508: PL/SQL: could not find program unit being called ORA-06512” It seems like to be Oracle setup issue, but NOT IFS. Please anyone advice me to solve. Regards; Susumu

5
T
Superhero (Employee)
1 year ago
J
Do Gooder (Customer)
jquinteiroDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Lobby Filter Parameters

Hi,   I am building some lobbies in IFS 10 and I would like to know if it is possible to use a predefined list of values to use in the lobby filter parameter. For example, if you want to filter by site, you would get a LOV on the parameter filter with the available sites in the system.  Another interesting filter at the lobby level would be to have the calendar option available, whenever you wish to filter a parameter by date. Does anyone know how to do this or if it’s possible?

8
A
Superhero (Employee)
1 year ago
P
Sidekick (Customer)
PROAHARSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Performance issues and background jobs (default queue)

Hi, Over the last few months we have been having performance issues in Apps 9 that have been very difficult to narrow down to a specific cause. We have plenty of overhead in both the database and middleware servers so I don’t think it is a hardware or database performance issue. What I have been able to determine is that when we get really severe performance issues that we have a large job queue (default - 0) of waiting jobs usually caused by a custom job taking longer than normal to process - say 20mins during which time 6 x 10 Invoice posting jobs enter the queue and wait to be processed, this then prevents other jobs from running and they get added to the queue compounding the problem (sometimes upto 900 in waiting state). During this time the system becomes unusable from logging on to simple queries.  So I guess I’m asking: Has anyone else experienced these type of issue? We have 10 batch queues all set to processes:1 and the majority of jobs are all in 0 - default. Should we have

15
SNAVIS
Do Gooder (Customer)
2 years ago
Joy
Sidekick (Customer)
JoySidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

ORA-20112 error on Incoming Customer Orders

We are experiencing a large number of stopped Incoming Customer Orders during our scheduled file import each morning, across multiple customers with the error message:  ORA-20112: CustomerOrder.EXIST2: The Customer Order object already exists. These orders do not already exist, and if the user RMB > Approves the order from Incoming Customer Order, it will approve the error without any prior action needed.  We have previously submitted this issue to IFS, and they were not able to recreate in their environment - leaving us without answers.  I was able to recreate this error in our TEST environment, using our incoming prod orders from today, and I resubmitted a case to IFS - but looking to see if anyone else has experienced this error? 

9
GPIE
Hero (Customer)
2 years ago
C
Do Gooder (Partner)
ChaFerrellCDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

In IFS 10/Aurena on the Change Request Form we had 8 custom bulk/multiline fields set to 500 characters each. Submitting a change request with these filled to that limit was not a problem.It was then requested to increase these to the max allowed, and after looking around, it seemed to be 4000 characters is what we needed to set, due to limits in PL/SQL. Each Custom Field was changed to a 4000 character multiline and when synchronized the database was showing Varchar2(4000) as expected for each.When filling out a new Change Request, and using just 2000 characters in each of the custom fields, an error was thrown and the Aurena debug log window shows the following: 09:49:52 TRACE - DATABASE {"origin":"DB","indentation":"11","time":"94786019","category":"FRAMEWORK","level":"ERROR","type":"Framework","text":"ORA-06502: PL/SQL: numeric or value error: character string buffer too small"}09:49:52 ERROR - PL/SQL: (Server Error) numeric or value error: character string buffer too small Databas

4
Yasas Kasthuriarachchi
Superhero (Employee)
2 years ago
Rajith
Sidekick (Partner)
RajithSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Document Macros

Hi All, few questions from a colleague, re Document Macros   I guess you know, there is a standard functionality in “DMS” that allow to fill a Word document automatically with fields in IFS (Macro – VBA). I’m looking for answers about those questions and it is not easy to find : Are those fields able to come from different Views or is it necessary all fields should come from the same one ? o Exemple : I have a file in GED with macro, connected to the View "Purchase.Order". In the file I would like to get the "Manager" field coming from the LU Project. Do I need to add a customfield read only to bring the manager in the View "Purchase.Order" ? Can we put a value in the Word document, depending on condition ? o Exemple : If a field in IFS is “YES” then the Macro populate a field in a certain value in the Word document. If “NO” then the Macro populate the same field with an other value ? The answer should be somewhere in the screen “Macro basic” but it’s too technical for me. Thank you,

27
N
Hero (Customer)
2 years ago
N
Do Gooder (Customer)
NerakYakDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Connect Oracle Client 12 to Crystal Reports 2016

I’m attempting to set up Crystal Reports 2016 so I can connect to the IFS Oracle database (Apps 9). I’m using Oracle Client 12. Firstly, I have not seen anyplace where it is specified the normal tnsnames.org file location for Oracle Client 12. Everything says “ORACLE_HOME” (which I understand means whatever the home  directory is not a directory literally named “ORACLE_HOME”) /network/admin. There is no network OR admin folder in the Oracle directory. To use SQL Developer, I don’t need that anyway, because I can just directly load a tnsnames.ora file. But then Crystal reports… I have googled seven ways from Sunday and cannot figure out how the heck to associate the TNS file with Crystal Reports. When I go to “Database Expert”, I have an option for “Oracle Server”, but no matter what values I use (and I know they’re the correct values b/c I can connect with them in SQL Developer), I can’t connect.   No one here is very savvy at this so there is no one I can ask. Help! Thank you! 

5
N
Do Gooder (Customer)
2 years ago
D
Sidekick (Customer)
DevBobSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick Report: UNION SQL: Total SELECT join SUM() Not Working

I have a Quick Report that Groups By dollar columns, then does a UNION to total those $$$ columns. It has a join column from another table (btl.amount), keying on primary keys/columns.The challenge I’m running into is that, on the UNION SQL, I’m joining to a table to get that single $$$ column’s total (SUM(btl.amount)). Since the join is not at the detail level of each main table’s rows, it’s overstating the SUM() total $$$. (kind of hard to explain). SELECT t.reporting_date "Reporting Date", t.district_code "BU Code", t.district_desc "BU Desc", t.contract "Site", to_char( SUM(t.Daily_Order_Entry), '99,999,999.99') "Daily Order Entry", to_char( SUM(t.MTD_Order_Entry), '99,999,999.99') "MTD Order Entry", to_char( SUM(t.Daily_Billings), '99,999,999.99') "Daily Billings", to_char( SUM(t.MTD_Billings), '99,999,999.99') "MTD Billings", to_char( MAX(btl.amount), '99,999,999.99') "Forecast", to_char( SUM(t.Past_Open_Orders), '99,999,999.99') "Past Open Orders", to_char( SUM(t.Curr_

6
T
Do Gooder (Partner)
2 months ago
GPIE
Hero (Customer)
GPIEHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

"[file] has a different computed hash than specified in manifest"

Hi all, We have been working with IFS on this issue for several days but without success, and I am losing faith. I have asked for escalation but in the meantime, I wonder if anyone has ideas on what is going on here. Issues: If we try to Download All Packages, we see the first error We see errors 2 and 3 shown below with any Employee/Person form This issue occurs on our Live, Test and Dev instances (Live and Test/Dev are on different physical servers) We do not know exactly when the issue occurred as we do not add new employees often Attempted Fixes: Used F1Mage.exe to recreate signed application Reconfigured server Restored to backup of “instance” Uninstalled .NET update and restarted servers Deleted “C:\Users\[username]\AppData\Local\Apps\2.0” folder Run “rundll32 dfshim CleanOnlineAppCache” on client PC Nothing works! Thanks in advance for any suggestions.

5
GPIE
Hero (Customer)
3 years ago
B
Sidekick (Customer)
bhaveshSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Yes / No Dialog Box

Is there any way to show Yes/No dialog box in a custom event and perform operation based on user’s response? 

13
Mathias Dahl
Superhero (Employee)
2 years ago
J
Hero (Customer)
JurHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Upload document via CreateAndImportDocument.svc/EdmFileSet

Hi,I’m trying to upload a file via an Aurena REST API. However I can’t figure out what I should use as in the FileData. I’m getting a message “Invalid value for property 'FileData'”. I’ve tried several encoding methods but I have had no luck yet. Image of the input and error. 

21
J
Hero (Customer)
2 years ago
M
Sidekick (Customer)
MatthewSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Lobby Link to Excel Quick Report

Is it possible to create a link on a lobby tile that will export a quick report to excel. We can link to the quick report and then export to excel, but looking for a one step process. Using Apps 9.   Many thanks,

13
samuelandlopes
Hero (Former Employee)
2 years ago
M
Do Gooder (Customer)
mpillundeDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS links and the new edge browser

Our company would like to be able to open IFS Enterprise Explorer  links to documents or other objects,  (purchase Reqs, etc)  when the default windows browser is the new version of Microsoft Edge.  This is Version 83.0.478.61 (Official build) (64-bit).   We are running IFS10  update 6.    If IFS is currently open, the links work properly but if IFS is not open, then the link starts IFS and after logging in  takes you to the start page only. With the Chrome browser, we had to install the IFS chrome extension to get these links to work properly,   after installing that extension when IFS Chrome is the default browser the links work all the time.    Is there a similar extension for Edge?    Anyone else run into this issue and come up with  a fix for it?     

4
Mathias Dahl
Superhero (Employee)
2 years ago
S
Sidekick (Customer)
SHAUN_KERSLAKESidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Error previewing Crystal Report in IFS

Crystal report developed and executes successfully outside of IFS. Report is using a custom developed IAL as its data source (access granted to appropriate permission sets) When copy Crystal Report to server and try to preview in IFS an error is presented: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object.    at Ifs_ReportService.GetSavedPDFReport(String FileName, String ParameterValues, String LangCode) in c:\inetpub\wwwroot\IFSCRWebSetupIFST_3\App_Code\Service.cs:line 244    --- End of inner exception stack trace ---  No actions were executed. Other Crystal reports work fine which would rule out issues with the IFS Crystal Web Service. Does anyone have any suggestions to overcome this error?  Thanks in advance Shaun  

12
durette
Superhero (Customer)
3 years ago
B
Do Gooder (Customer)
Berway72Do Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Aurena User Guide - Tip & Tricks

Has anyone found or developed an IFS Aurena user guide? We are upgrading to IFS Apps 10 next year and I would like my Core team to demo (using the RACE database) the Aurena client.

8
Yasas Kasthuriarachchi
Superhero (Employee)
1 year ago
B
Sidekick (Employee)
Banuka PereraSidekick (Employee)
posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Restful API testing with postman along with Aurena

 This is how I'm using the POSTMAN tool to check restful methods (POST, GET, PATCH, DELETE). (I'll proceed with this testing using the 'Inventory Part Maint Info' page in Aurena) The first step should be finding the SOAP gateway. To find that there are two ways.In Aurena Search for the API Explorer-> search for required projection. (In this case, I'm searching for the 'MaintInventoryPartHandling' projection). Open the debug console→ Server invoke → Click API Explorer→  click Open in API Explorer. (This would be the easiest way to open it). Afterward, check the ' Include in Compatibility Application Type'  is 'Yes' or 'No'. If it is No, change it to Yes by RMB on the line and click the 'Include in Compatibility Application Type' option. Then, you can open the API Doc by RMB on the line → Documentation →  API Doc [Compatibility Application Type (Int)].  Provide the credentials which are used to log into Aurena. By opening Debug console in Aurena, if you refresh the page you can get th

1
Udara.Hasantha
Hero (Employee)
1 year ago
cwright
Do Gooder (Customer)
cwrightDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

3rd Party API with IFS Connect

Hi, I was hoping someone could help with setting up IFS Connect to send time registration to a 3rd party api. I have created a test custom event where new or changed time registration information is submitted to IFS. My 3rd part company has an API for create time sheet eg https://api.company.com/createtimesheet . So I need to send the API key and respective time-sheet data from IFS. I am just ensure of the routing address/application message setup part. Would appreciate some screen shots of working example if possible

15
dsj
Superhero (Partner)
2 years ago
T
Sidekick (Partner)
TierajengSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Certification

What is the significance of IFS specialization certification? Do we get any new features or product update after certification. 

8
cbelardo
Sidekick (Former Employee)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings