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

Eva SchwartzSidekick (Employee)

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

Excel Add-in - How to easily convert values to uppercase? (Apps10)

A customer is considering using the Excel Add-in for creating supplier for purchase part records. We created an Excel migration job for this and during testing we received the following error for the field Supplier Part No:The value "SOOW 16/6 16 Gauge" has incorrect format for [VENDOR_PART_NO] in Purchase Part Supplier. Should be in uppercase.How can the value in the column easily be converted to uppercase without needing any adjustment by the user in Excel? We would like to handle this via setup in the migration job. If the job was of type MIGRATE_SOURCE_DATA we could simply use the Oracle function UPPER when mapping, but we cannot figure out how to handle this for migration type EXCEL_MIGRATION.

2472

4 years ago

HayleyGDo Gooder (Customer)

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

Adding a cloumn to the Risk Object Connection screen

We use the object connections quite heavily in Apps 8, especially on Project Navigator, and I was wondering if anyone has been able to add an additional column to these, particularly the Risks object connection. I am looking to include the status column which can be found if you RMB to the Risk Analysis Navigator, however the object connection screens do not give the option to create a custom field. Does anyone know of another way this can be done? TIA

963

4 years ago

tmurphyDo Gooder (Customer)

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

BA Reports for End Users are Blank

We have recently begun developing reports in BA. We have published several for our end users to run on demand, but when the reports open in Excel they are blank. This only happened for the end users without the BA Excel Add-in installed. No errors are received, they just get a blank excel spreadsheet. It was my understanding that the end users would only require the Execution Server and obviously be granted access through their permission sets to see the reports. Is there another piece to this that we’re missing that would cause everything generated for end users to be blank?

8169

4 years ago

SaraCrankSidekick (Customer)

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

User Cannot Run Quick Report - Granted Access

I have one specific user that cannot run a quick report. She has a permission set that was granted access. I confirmed under the Manage Grants that her permission set is there and she is listed under the Users. Other people in her group that have the exact same permission sets she has can run this report. Has anyone else ever ran into this?

12989

4 years ago

JohannesWittwerHero (Customer)

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

Custom RMB when source value is not a source column

Hello, Our users request a custom RMB from “register arrivals” to the related demand source of type “Shop order” (use case outside operations) in IFS 10 Update 6. This was already implemented in IFS 8 SP1. Due to changes in the view, required source columns are only referenced from the client, but don’t exist in view. in Form Register Arrivals, the relevant data is displayed. column Demand Order Ref1 is not a field in the view. it is a referenced value (...api.get...) Custom Menu definition requires a source column in the source view - which does not exist other approach could be: Idea 1: source Key Name could allow to use a bind variable of the column name of the form like: :tbwRegisterArrivals.colsDemandOrderRef1 Idea 2: source Key Name could allow to use a get-function of the format like: &AO.Receipt_Info_Manager_API.Get_Demand_Order_Ref1(SOURCE_REF1,SOURCE_REF2,SOURCE_REF3,SOURCE_REF4,SOURCE_REF_TYPE_DB) There is the same problem when defining a condition for Custom RMB. I

6953

4 years ago

MariaDo Gooder

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

Custom menu condition

I have created custom menus in several screens, and they are working. But for one custom menu I want it to display only there is a value in a specific field. Therefore, I used conditions. But seems the custom menu is not accepting the condition. I have tried most of the conditions in below site. https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements005.htm Ex: MINIMUM_QTY IS NOT NULL MINIMUM_QTY <> NULL MINIMUM_QTY != NULL MINIMUM_QTY = “” MINIMUM_QTY = ‘’ The custom menu when no value The custom menu with value If you have faced similar, please share your findings.

8662

4 years ago

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

4273

4 years ago

mrgriffDo Gooder (Customer)

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

Demand Planner on Windows 10

we have just moved to windows 10 for all users (from windows 7) - DP ran just fine on windows7 but on windows10 the screen font is so small you cannot read it and when you move a window around it leaves a trail of windows behind it filling the screen Anyone any experience of this and perhaps a fix? Thanks Steve G

1036

4 years ago

SaraCrankSidekick (Customer)

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

IFS 10 Shortcuts/Columns Disappearing

Has anyone experienced an issue where a user adds a shortcut to their navigator, save their profile and then upon their next login it disappears? I also have had users report that they’ll add a column to a table view of a screen, save their profile and that also disappears upon their next login.

14707

4 years ago

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?

5256

4 years ago

OrangeCloudSidekick (Customer)

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

Down Payment in IFS 8

Hello I want to know how IFS handles down payment. currently we are using IFS 8 and soon will be upgrading to IFS 10. At Present we are handling down payments manually and are not recorded in IFS. I would like to explore this. Please point me to some documents to read and explore this. Any helpful material will be appreciated. Thanks

1404

4 years ago

svrmhuebnerDo Gooder (Customer)

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

Document Class LU control

We are using document classes to categorize files that can be attached to several different LU’s. If there a standard functionality configuration where you can control what document classes can be used for certain screens/LU’s? We run into problems when a user attaches a file using a document class that should not be used for that screen. Example: We might have customer order whereby a user will add a document classified under “Supplier Contract”. We would never want this added to a customer order. Other than creating some kind of event action, is there standard functionality that can control this? We are on IFS Version 9, Update 8. Thanks!

138510

4 years ago

PortsmouthWaterUserDo Gooder (Customer)

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

"One time Vendor" functionality available in APPs 8 SP1 ...?

I’m hoping that someone may have a suggestion or two regarding the ability to place a PO on a supplier not uniquely set up in IFS. The scenario would be when we want to procure either product or service as a “one-off” with no expectations of using that supplier again. The objective would be to benefit from the control offered by use of a PO but without all the Supplier record data housekeeping effort. I am aware of the “IFS Supplier Template” facility, but wondered if: I have missed some existing suitable functionality This (or similar) does exist in IFS; but in later versions. Any additional help to justify a system upgrade would be welcomed! Thanks very much.

882

4 years ago

SHAUN_KERSLAKEHero (Customer)

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

Show Date and Time in Client

Hello, We are using Apps 8 and we have some users requesting to view the date AND time in specific date fields in IFS. When you query the view used by the screen in Oracle it holds the date and time in the field, but when you view via the client the time aspect is removed. Does anyone know how you can ensure the time is shown as well as the date to the users? Regards Shaun

2995

4 years ago

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

9145

4 years ago

AndreasIsengaardSidekick (Partner)

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

Using Aurena and ExternalNavigationLink without http or https

Currently, when adding a new button (within command groups in the page designer) it seems that the ExternalNavigationLink is being restricted to prefix with either http:// or https:// - is there any way of calling a custom scheme / protocol (class) registered on the PC? I have a local class that has been associated with a software in where I want to invoke it from Aurena. Is this even possible?

5116

4 years ago

clint1028Do Gooder (Customer)

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

Change Request auto create default value

When I create a new Change Request Record I would like to Auto Populate the “CR No:” with text like the following. ABC-0001 Where the 0001 would increment up as a sequence. So after creating 5 Change Request I would have the following “CR No:” in the system. CR No: ABC-0001 ABC-0002 ABC-0003 ABC-0004 ABC-0005 Any help would be greatly appreciated.

7242

4 years ago

Jason_bethDo Gooder

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?

6904

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

3182

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

7484

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

17541

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.

2503

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

3990

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?

2682

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

6815

4 years ago

Page 307 / 312

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

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded