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,006 Replies

7035 Topics

H
Hero (Partner)
Hans AndersenHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Lookup local check-out path in SQL block

Hi all, Is it possible lookup the local check-out path inside a SQL block?  

6
Mathias Dahl
Superhero (Employee)
4 years ago
ntaylor
Sidekick (Customer)
ntaylorSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Migration Job - Updating Price List

Hi all (me again!)   Off the back of my previous topic and @RavinduS help I have managed to import my price list however I have hit a different issue.  If I enter a sales price manually on the Sales Price List → Part Based tab (and press tab/save) it will auto populate the following fields. Calc Sales Price Sales Price Incl Tax Base Price Base Price Inc Tax When creating the migration job the following fields (with flag MIU) are required to have a value which normally are auto-populated off of the Sales Price being entered however if I don’t enter a default value the migration job error’s out demanding that the field has a value. ORA-20124: Error.NULLVALUE: Field [SALES_PRICE_INCL_TAX] is mandatory for Sales Price List Part and requires a value. For now I have entered ‘0’ into the default value field to get around the error for the following fields. BASE_PRICE BASE_PRICE_INCL_TAX PERCENTAGE_OFFSET AMOUNT_OFFSET SALES_PRICE SALES_PRICE_INCL_TAX The downside is that having a default val

5
JULIAN
Hero
4 years ago
Binura Dodangoda
Hero (Partner)
Binura DodangodaHero (Partner)
published in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Tip: Apps 10: Lesson learned: Missing of navigator entry for the ‘Quick Report Categories’ form and new features from UPD 6 onwards

The navigator entry for the ‘Quick Report Categories’ form has been removed from UPD 6 onwards. Before UPD 6, ‘Category’ is a mandatory field when creating a quick report. But from UPD 6 onwards ‘Category’ is a not a mandatory field when creating a quick report. Further, from UPD 6 onwards a new field called ‘Domain’ has been introduced in the ‘Create New Quick Report’ page. It is also not a mandatory field. Both ‘Category’ and ‘Domain’ fields are used for the filtering purpose and they are useful in Aurena. Since, the ‘Category’ field is not mandatory when creating a quick report from UPD 6 onwards, ‘Quick Report Categories’ navigator entry has been removed. But from UPD 6 onwards, two new forms have been introduced. They are ‘Report Category’ and ‘Report Domain’. ‘Report Category’ form can be used to create a new Report Category (for which you used ‘Quick Report Categories’ form before UPD 6) and the ‘Report Domain’ form can be used to create a new Report Domain which you can provide

3790
Binura Dodangoda
Hero (Partner)
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
dsj
Superhero (Partner)
dsjSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

PLSQL Routing - error message

Hi All, We use PLSQL routing for our inbound integrations and have a question regarding error handling. When using Error_SYS, it shows the error stack in the Error Text field instead of the error message. Is there a way to format the Error Text? App version: IFS 10 UPD 3 Eg:   Cheers! Damith  

2
dsj
Superhero (Partner)
4 years ago
M
Do Gooder (Partner)
maugerDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Object connection transformation

Hi, I was able to create  my first connection object and I had to create my own transformation method, following guidelines found in OpenIFS forum. When I tested it (with the Test transformation option ) , I got a successful status. But it does not work on the target LU. What is the best way to debug this problem ? Haven’t found anything in the Debug console.   Thanks   Michael

30
Mathias Dahl
Superhero (Employee)
3 years ago
L
Do Gooder (Customer)
lemantDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Slowness in Loading Start Pages Apps 10.4.7.0

We have been receiving many reports of issues with Start Pages in 10.4.7.0 that have queries taking long times to load after the session has not been active from anywhere from 5 to 12 minutes. We have tried increasing the page cache (doubling or tripling) but that had no effect.  The queries have been optimized for Apps 10 as well. Currently there is a case entered, but thought we would reach out here as well. The screen below is a start page that takes 4-5 minutes to load after it has been idle for 6 minutes. Thanks in advance.

5
N
Sidekick
2 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Quick Report - Crystal Report includes Sub Reports Question

If I have a Crystal Report that contains sub-reports, do I have to add CR_WEB_INIT to the sub-reports as well as the main report?

2
ChanakaAmarasekara
Hero (Employee)
4 years 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)
2 years ago
R
Do Gooder (Partner)
RandyDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick Report - Crystal Report Via URL Custom Menu Action, Parameter Question

Hello! We’re trying to call Crystal Web Services via the URL Custom Menu Action in IFS 8. Currently I can render the report using the following URL syntax: “http://CWS_SERVER_NAME/qrn/cr1.aspx?rpt=report_name.rpt” The custom menu operates as expected, but we would like to grab a field value off of the IFS form and pass it along to Crystal Web Services, much like we would with a PL/SQL action or otherwise. Does the (I assume) IFS developed CR1.ASPX page support the passing of parameters? If so, what is the syntax? Some syntax we’ve tried with testing: “http://CWS_SERVER_NAME/qrn/cr1.aspx?rpt=report_name.rpt?ORDER_NO=12345” “http://CWS_SERVER_NAME/qrn/cr1.aspx?rpt=report_name.rpt&ORDER_NO=12345” “http://CWS_SERVER_NAME/qrn/cr1.aspx?rpt=report_name.rpt&lsSORDER_NO=12345” Any help or information about the capabilities of the ASP.NET page CR1.aspx would be most appreciated! Thanks in advance. -Randy

2
ZTC ZTC JGOTA
Hero (Customer)
2 years ago
I
Do Gooder (Customer)
iwatagrDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Handling custom exceptions within events

Hello, I have made an event that throws an error message to the user, using the error_sys.record_general function, based on some criteria set in the event, which triggers on a change in the status of the object.  error_sys.record_general( 'SomeLogicUnit', 'SOMEERRORMSG: this is an error message'); I am in the process of creating another event that will change the status of the object, but I am wondering if it is possible to catch the exception raised in the other event, and handle it separately?  Without handling the event, and running the event manually in a DBMS, the procedure completes, but returns ORA-20110: SomeLogicUnit.SOMEERRORMSG: this is an error message   My event would look something like this: BEGIN --change status on object, which may cause an error to be raised in the other eventEXCEPTION WHEN ... THEN -- handle the exception raised from the other eventEND; If I specify “EXCEPTION WHEN others THEN … “ I will catch the error raised in the other event, but I won’t know t

1
Mathias Dahl
Superhero (Employee)
4 years ago
NickPorter
Superhero (Customer)
NickPorterSuperhero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Aurena minimum and recommended specs?

As a customer I am unable to access wis.ifsworld.com, which is the place where I should be able to see minimum and/or recommended platform specs for running the Aurena client. Fundamentally, I’m looking to identify specs for low-end tablets that would work well enough to be functional IFS Aurena clients. Can anyone either provide an alternative location to find this information or provide it directly here?  Any specific recommendations for cheap but viable tablets would also be appreciated if anyone has implemented any. Thanks, Nick 

5
Kasun Balasooriya
Superhero (Employee)
4 years ago
M
Sidekick (Customer)
MatthewSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IMPERSONATE USER

Hi,   We are looking into System Privileges and wondering what the IMPERSONATE USER privilege does and how to use it.  Using Apps 9 UPD 14. Many thanks,   Matthew

5
NickPorter
Superhero (Customer)
4 years ago
K
Do Gooder (Partner)
karim.garraouiDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Aurena authentification and Token

I have a question about WEBSERVICES and Token : how it works, what is the process to achieve the value transported. For example : Indeed, we encounter the authentication problem Error 401--Unauthorized on the following webservice: https://assystem-test.ifs.cloud:48080/main/ifsapplications/projection/v1/TimeRegistrationHandling.svc Maybe the webservice uses a token to authenticate itself despite the use of a basic IFS Aurena login/password authentication.       We used Postman to perform our requests (GET,POST,PUT). Can you please tell us what are the access parameters of this webservice as well as the descriptions of these different methods.  

13
K
Do Gooder (Partner)
2 years ago
ntaylor
Sidekick (Customer)
ntaylorSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Migration Job - Custom Field

Hi all, I am currently in the middle of creating a simple migration job to update a Price List. I have created a .csv file that contains the 5 columns of data required for the import. This currently works fine.   The second migration job takes care of the copy from the custom table containing the data from the 5 columns and imports into the sales_price_list_part table. It is here that I am having trouble. 1 of the 5 columns is data destined for a custom field within the sales_price_list_part table. Because of this I have selected the custom field view in my method list. By default it selects the standard (non custom) version of the API. In this instance I only want to import new rows.   When I navigate to Source Mapping it has now auto-populated the available fields from the CFV.   As you can see I have all the relevant defaults added etc as well as the source columns linked. Importantly please note that Pos 260 contains the CF$_CUST_LEAD_TIME field which I have linked to LEAD_TIME.

5
V
Do Gooder (Customer)
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)
3 years ago
SORSITEL
Sidekick (Customer)
SORSITELSidekick (Customer)
posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Lesson learned - How to resolve error "install_fndmws.xml:214: Failed to install Middelware Server!"

Hi, So I struggled for several hours trying to reinstall IFS_HOME on a particular server. When trying to install the new IFS_HOME I got the error: ...\build_home\server\install_fndmws.xml:214: Failed to install Middelware Server! Error is: Exception when installing IFS Middleware Home: ...\ifs_home\tmp\as\resources6277372277239962574\install_fndmws.xml:480: Failed to install Middleware Server. Error is: Which is really helpful *sarcasm*   The issue turned out to be a rogue inventory.lock file in C:\Program Files\Oracle\Inventory\locks. What really happened was that the installer was waiting for “the other process” to “finish their business” with Oracle Inventory. When in reality, this lock file was left behind due to the way I uninstalled the previous version of middleware server. So if you’re looking to reinstall IFS_HOME, make sure you check this if the installer fails with the empty error message.

7
R
Sidekick (Partner)
1 month ago
I
Sidekick (Customer)
IFS_ShekharSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Error during Document Attachment

Hi, I want to attache a file into Voucher Entry interface but it showing error “Bad Request” in IFS Application 9

1
Kasun Balasooriya
Superhero (Employee)
4 years ago
I
Sidekick (Customer)
IFS_ShekharSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFSAPP grant access to Page

Hi, I have Install fresh build for new Application and follow all steps and instruction which is given into Help Document and it has been installed successful.But have noticed, there are some interfaces are not in Navigation e.g Supplier, Customer, Company etc, so i use to add new item and select unused interface then it showing error “You are not authorized to view the information or perform activities on this page” “User IFSAPP has not been granted access to the page frmSupplierInfo_Ext”    

6
R
Sidekick
4 years ago
NickPorter
Superhero (Customer)
NickPorterSuperhero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to Open Debug Console in Apps7?

My brain has apparently stopped working today… can someone remind me what the magic key-press is to open the Debug Console in Apps7 (and prior)? Perhaps I’ll earn an “I’m having a dumb day” badge for this one … :) Nick

2
NickPorter
Superhero (Customer)
4 years ago
C
Do Gooder (Customer)
Corc22Do Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Failed to Report. Please contact your sys admin

‘Failed to retrieve Report’   Hello Community,    We’ve having an issue on our test environment, receiving the ‘Failed to retrieve Report’  message (Apps 9 UDP7) when running a CR quick report. Everything fine in IFSL The database has been refreshed from Live a few months ago, but to list the numerous things we have tried with no luck. Checked reports work through Crystal. Can confirm yes Checked credentials of all sys, print, ifssys, ifsapp accounts. Can log in to all  Performed a middleware reconfig Report is in the correct <HOME>Layout folder System parameters updated Host where CRWeb is installed Virtual Directory given to CRWeb services Updated logos value Checked Inetpub/wwwroot IFSCRWebSetup XML config files to ensure they are using TNS to correct DB Restarted IIS Restarted ‘All Servers’ bin files  Restarted windows services Restarted Extended server Removed anything other than standard views I am using the CR_WEB_INIT\ with correct linking Using IFSPRINT as the user to c

5
ChanakaAmarasekara
Hero (Employee)
4 years ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Aurena Notify Me 10 Invalid redirect URL

Setup:  IFS Applications 10 UPD 6   On trying to run IFS Aurena Notify Me 10 we are receiving the following error: Something went wrong!   Reference:  IDP-U5Mvq0wrYt6A Code:  IDP_PROTOCOL_FLAW Message:  Request failed to fulfil protocol requirements. Information:  Invalid redirect URL   I know in the past we have had to open IFS Middleware Server Admin Console > Security > Database Identity Provider > External Redirect URls and added the Redirect URl for the application that is displaying the error.    My problem is where do I locate the Redirect URl so that I can add this?   Can anyone please advise?      

4
R
Sidekick (Partner)
18 days ago
J
Sidekick (Customer)
jrauhSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Custom Field with Enumeration truncates at 30 characters

We have some custom fields that are truncating at 30 characters after they have been selected and saved.  The enumeration drop down shows the full text value, but once saved and the screen refreshed it will re-display it showing only the first 30 characters.  We are using Apps10 (upd5) on IEE.  I’m opening a case with IFS, seeing if anyone else is seeing the same thing or knows about this and if a solution exists.  

1
Rusiru Dharmadasa
Superhero (Employee)
4 years ago
D
Sidekick (Customer)
DevBobSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

SQL GroupBy YYYYMM over IAL fails with '(full) year must be netween -4713 and +9999 and not be 0'

We’re creating a QuickReport where we want transaction data by month going across the row. We created an accumulating IAL grouped by YYYYMM which works great. Then creating a 2nd IAL over the first to total each YYYYMM’s Qty into it’s own month column (January, February, March, etc) and when we run that in SQL Query Tool it fails with this error:   We’ve ensured all rows have valid dates.      

5
CallumW
Superhero (Partner)
4 years ago
S
Do Gooder (Customer)
SPierpointDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Error when ordering a Business Reporter report through IFS

When trying to order a Business reporter report through IFS, and then selecting ‘view executed report’, I receive an error due to the ‘file format or file extension is not valid’. Excel is trying to open an .xlsx file when the report contains macros so its saved as .xlsm.   We are new to using IFS, therefore I hope there is someone more experienced out there to assist us with this error. I tried to attach the screen shots but it is erroring on this page. Thanks  

4
P
Do Gooder (Employee)
4 years ago

Badges

Show all badges
Terms & ConditionsCookie settings