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

7215 Topics

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

List of value window shows duplicate columns

Hi IFS, I have created a custom field which accepts data from another custom field. The second custom field is a type of reference and it is in a custom logical unit. The first custom field gets data from the List of Values. I noticed same column is duplicated in the list of values window and it contains data which I have not entered. This behavior was not in the past. Any suggestions to avoid this?

4 years ago

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

4 years ago

SHAUN_KERSLAKEHero (Customer)

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

Application Defined Custom Event Variables

Hi Using the custom event STEP_READY_FOR_APPROVAL as part of the document management approval routing to send an email. Email subject is using the variable &MESSAGE_TEXT which as an example contains the following: “Document Class 3015, No 1678422, Sheet 1 , Rev REV00 is ready for your immediate approval” My questions is there a way to amend the content of this variable somewhere in IFS? We are using Apps 8. Thanks in advance Shaun

4 years ago

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

4 years ago

GPIEHero (Customer)

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

Capture API Output

Hi all, When using an API such as Purchase_Order_API.User_Requisition_Line_To_Order(), the first 3 attributes are the newly created Order_No, Line_No and Release_No - but how do I capture them for subsequent use in the same code block? Thanks in advance, Ged.

4 years ago

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

3860

4 years ago

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?

4 years ago

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

4 years ago

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

4 years ago

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”

4 years ago

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.

4 years ago

JurHero (Customer)

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

Post Deferred Call as other user

Hi, We'd like to be able to run Deferred Calls as a different user. I can't find anything to make this work. Is this possible?

4 years ago

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

4 years ago

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

4 years ago

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

4 years ago

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.

4 years ago

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 years ago

RutJWhalenSuperhero (Partner)

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

Quick Report (Crystal Report) Parameter Question

After getting my quick report (crystal report) to work by suffixing the views with _A I tried adding parameter(s). Unfortunately, this has provide errors: I have added the parameter IFS_ORDER_NO. So the Crystal Report Select Expert looks like: CUSTOMER_ORDER_A.ORDER_NO is equal to {?IFS_ORDER_NO} However, when running the Quick Report I am not prompted for the parameter value. My idea would be to create a custom menu on the Customer Order that runs the Quick Report and uses the current Customer Order No as the parameter value. Any ideas?

4 years ago

TERKRTISidekick (Customer)

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

Matrix lobby elements

Does anyone try to create a matrix lobby element? Mine are not working, despite using valid data sources. Turning on the debugger, reveals that there’s a sorting in all matrix lobby elements that I create: “order by MAX_PARTICIPANT desc”. That is disregarding the data source used. We’re on IFS10 update 3.

4 years ago

JoySidekick (Customer)

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

Can you create an Output channel in IFS that will open File Explorer, and allow you to save a file without having to open it in an application (like Excel) first?

I have a user that is trying to export query data from IFS, a large amount of query data, and he just needs the flat file (.csv). His Output channel is exporting the .csv file to Excel and trying to auto-open, and the export is taking a very long time - due to the many rows of data being downloaded to Excel. The user does not need to view this info in Excel, so is there a way to create an Output channel where it will just allow you to save the flat file to a local file folder without having to open in an application first?

4 years ago

RutJWhalenSuperhero (Partner)

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

Quick Report (Crystal Report) is not displaying any data

I have created a Quick Report (Crystal Report) that has a parameter @OrderNo. Next I created a custom menu on the Customer Order screen that maps the parameter: Source = ORDER_NO Destination: @OrderNo On doing RMB and selecting the custom menu the @OrderNo parameter is displaying the Order No for the Customer Order that was in view at the time which is what I expected. However, when the report is displayed no data is being displayed. If I run the report in Crystal Reports and enter the Order No the report displays data. I have tried selecting View on the Quick Report and entering the Order No in the parameter field and again no data is being displayed. Any ideas? John

4 years ago

Anonymous

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

Pictures pasted into yellow notes are not saved

We have problem on production database that pictures pasted into yellow note are not saved in the database. On test database they are saved. I have figured out that yellow notes are saved in TEXT column of type CLOB in the table FND_NOTE_PAGE_TAB. We are using IFS App 9 UPDATE 7. Any suggestions ?

4 years ago

RutJWhalenSuperhero (Partner)

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

Login Information requested when trying to run a Quick Report

I have set up a Quick Report to run a Crystal Report and this works fine except that I am being prompted for Login Information each time it is run. e.g. if the Crystal Report is accessing the CUSTOMER_ORDER_TAB I receive the following: Login Information for CUSTOMER_ORDER_TAB is requested prompting me to enter: Login: Password: DB Instance: Schema Owner: Can anyone please advise what I am missing.

4 years ago

Steve WintersgillDo Gooder (Customer)

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

'Refresh' list of views?

I have created a Custom Logical Unit in order to create a custom page. One of these fields has been setup as a referenced persistent field reading from SHOP_MATERIAL_ALLOC_CFV. There were a couple of custom fields in this view that have since been removed. When I try to bring up a list of values on the reference field I get an ‘invalid identifier’ error on one of the removed fields. Is there a way to ‘refresh’ or re-publish the list of views so the removed fields are excluded?

4 years ago

JouniSidekick (Partner)

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

Lobby from IAL not show columns

I have lobby data source pointing to IAL. Is there any other way to pick columns to use than write those manually? Data source ‘preview’ show data and columns even not selected any, but element designer can’t use sata source if not wrote needed columns to data source.

4 years ago

Page 285 / 289

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

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded