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,078 Topics
  • 22,108 Replies

7078 Topics

hhy38
Hero (Customer)
hhy38Hero (Customer)
posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Sharing Useful Scripts-Snippets-Queries

Hi,I would like to share some useful SQL codes of mine. You can share yours in the comments.  Remove DECLARE info_ VARCHAR2(2000);BEGIN ifsapp.language_sys.set_language('en'); FOR rec_ IN (SELECT * FROM /*Table*/ p /*WHERE p.*/) LOOP ifsapp./*Api*/.remove__(info_, rec_.objid, rec_.objversion, 'DO'); END LOOP;END;New DECLARE info_ VARCHAR2(32000) := NULL; objid_ VARCHAR2(32000) := NULL; objversion_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000) := '';BEGIN ifsapp.language_sys.set_language('en'); FOR rec IN (SELECT * FROM /*Table*/ t /*where*/) LOOP BEGIN attr_ := 'ORDER_NO' || chr(31) || rec.order_no || chr(30); --Fill the attr ifsapp./*Api*/.new__(info_, objid_, objversion_, attr_, 'DO'); END; END LOOP;END;ModifyDECLARE order_no_ VARCHAR2(32000) := 'I1510'; line_no_ VARCHAR2(32000) := '1'; rel_no_ VARCHAR2(32000) := '1'; line_item_no_ VARCHAR2(32000) := '0'; ne

2
M
Hero (Employee)
3 years ago
Joy
Sidekick (Customer)
JoySidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Crystal Report Print dialog box defaults to neither Windows default printer or IFS default printer

Hoping someone can shed some light on this situation. I have a user that brought this up - whenever they are trying to print a Crystal report, the Print dialog box always default selects “Microsoft Print to PDF”, instead of the Windows default printer (shown as “Front Office” with green default checkmark below). Her IFS Printer Definition settings are also set to default to this office printer. I even checked on our IFS Print Agent server - and the default printer is another office device.  Does anyone know what might be the reason for this, and whether it can be changed?  

3
Joy
Sidekick (Customer)
3 years ago
mzislam
Sidekick (Customer)
mzislamSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Send Email Setup

Who will be Default Mail sender in above email setup window, it is showing “Default Mail Address 'null' is not specified or is not valid” in Applications Messages window

4
R
Hero (Partner)
2 years ago
C
Do Gooder (Employee)
chinthanaDo Gooder (Employee)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Aurena User Profile

Do you know how to hide fields, tabs & buttons in Aurena and save it to a user/role profile. I was trying to search for some documentation on Aurena Base Profile configurations but couldn’t find any. If any available documentation, please share as well

2
Yasas Kasthuriarachchi
Superhero (Employee)
3 years ago
B
Do Gooder (Partner)
BeaLioneRDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Access to API calls, and Explorer documentation?

Hi, Currently using IFS APP10 with UPD8 and higher for customer purpose.  1/According to you guys, what are the required standard permission sets to allow a user to call REST APIs from outside IFS? e.g. create or modify a client from CustomersHandling API. So far, we used permission sets such as: FND_ADMIN, FND_CONNECT, and a custom kind of “superuser”, and it won’t let us call the APIs. 2/Some API documentations for a given method are unavailable. For example, whenever we want to generate the CustomerHandling doc (see link below), we have an error. I noticed it occurs from time to time for specific methods.Does this mean there is actually no available documentation for the given method? Or is this an error we should be able to handle?https://<customername>-dev.ifs.cloud:48080/main/ifsapplications/apidocs/?openApiUrl=https://<customername>-dev.ifs.cloud:48080/main/ifsapplications/projection/v1/CustomerHandling.svc/$openapi?V3  Many thanks to the community!Best regards, 

7
B
Do Gooder (Partner)
3 years ago
chfredmanm
Do Gooder (Customer)
chfredmanmDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Aurena Page Designer training

Does IFS offer any training for using the Aurena Page Designer?  I’ve found the documentation for the process, but we are thinking training from IFS in how you should make changes and customizations would hopefully allow better management of these changes and prevent issues and headaches in the future.  Also, overview of how changes might come into play with security in Aurena.        

13
1
Sidekick (Partner)
2 years ago
K
Sidekick (Customer)
KasiaSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Using PL/SQL procedure to save a file to SharePoint

Hey community, Wondering if anyone has ever written or used a procedure to auto save a file to SharePoint. Team and myself have successfully written a few procedures that run data extracts from IFS DB that save a file to a chosen path on different drives + using scheduled database tasks to execute them at specific times/dates, but not cloud. Would love to hear what route you’ve taken if you’ve completed something like this before? I’m on Apps9, 12c Oracle DB. Thanks,Kasia 

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

Custom Fields and Standard Fields in the same event

Hello, I have been asked to set up a Custom Event that should notify or stop the user (info message / error message) when they try to save a new object based on the values in one custom field, and another standard IFS field. Both exist in separate tables, as you would expect (e.g. NCR_TAB and NCR_CFT).  I get this to work on existing objects, either through querying the field directly in the event action, or through the custom attributes in the event.    However, in this case I want the event to be triggered when the new object is created, which means that the row does not yet exist in either table / view. Upon testing this this is what I’ve observed: If it is a new object (row), I get no value from the custom attribute If it is NOT a new object, and I have changed the CF$_SOME_FIELD value, I get the previous value If it is NOT a new object, and I have NOT changed the CF$_SOME_FIELD value, I get the correct one It makes sense to me that it works like this, but I am just wonderin

4
D
Hero (Customer)
3 years ago
C
Sidekick (Partner)
ChaMylesCSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Cannot Update or Delete records on tables made from Custom LUs thought API calls using the Modify__ or Remove__ methods.

When trying to update a record using the API for any Custom LU (_CLT table in IFS), we get this error. ERROR: MODIFIED2: The ‘LU Name’ object has been modified by another user. Please refresh the object and reenter your changes. The error is saying that a record can't be updated because it is already being updated, which is not the case. This happens regardless of which table the triggering action is coming from. The update method that is called using the API is 'PackageName'_CLP.Modify__( ). This modify method is auto generated when the Custom LU is made. We have verified that the New__ API call for inserting a record does work correctly for Custom LU tables, but the Modify__ or Remove__ API calls do not.To be clear, we are able to call the API methods to Update, Insert, and Delete records from IFS standard tables, (tables ending in _TAB), as well as custom field tables, (tables ending in _CFT) but we are having this issue with the tables made from Custom Logical Units, (tables ending

10
C
Sidekick (Partner)
3 years ago
C
Superhero (Customer)
cjohnsonSuperhero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Event Action condition setup

Hello, I’m attempting to trigger a Streams notice on a failed background job. I’ve gotten the event to trigger, however, I am trying to further filter notification by adding a condition for the event based on the site the error occurred at. I’ve noticed that in the Argument field, the actual site name is contained and I thought that I could use wildcards to trigger when that value is present. However, it appears I do not have it configured correctly. I was attempting to use the LIKE condition with wildcards, and I also attempted to use the “=” condition with no luck. The syntax used for both is below:  The argument field contain a long string of text, but the contract site does appear in the string. I’m hoping that I’m using the condition and wildcards incorrectly. Any help would be greatly appreciated. 

5
C
Superhero (Customer)
3 years ago
R
Do Gooder (Customer)
Renz RazonDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Creating a Checkbox Custom Field

Hi everyone,I’m trying to create a persistent custom field checkbox (boolean) to be used for a report layout. for some reason I cannot finish the final step of adding the custom enumeration. The view does not show anything and the search is also disabled. Following the documentation, I should be able to add our custom enumeration from here. Other formats such as Normal and Multi work fine, but boolean does not. Is there something I’m missing to proceed?  

6
R
Do Gooder (Customer)
2 years ago
S
Hero
sutekh137Hero
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Error trying to upload document via RESTful API

Hello,I found a great document (by researching this Community) that summarizes the process for uploading a document via the RESTful API here:https://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/upload-document-via-createandimportdocument-svc-edmfileset-6284.Great stuff! I got started with Postman to test things out. Our IFS environment is APPS10, Update 9.I used Basic Authentication (App Owner credentials) and that stopped the authentication errors I was getting. Then I provided the following JSON as POST data to the CreateDocument entry point (<host>:<port>/int/ifsapplications/projection/v1/CreateAndImportDocument.svc/CreateDocument):{  "DocClass": "MAINT",  "DocNo": null,  "DocSheet": null,  "DocRev": null,  "Title": "Test Document",  "BookingList": null,  "Id1": null,  "Id2": null,  "CreateFileRef": "YES"}The above is straight from the example document linked at the top of this post, with DocClass changed to a valid class for our environment

1
S
Hero
2 years ago
eqbstal
Superhero (Partner)
eqbstalSuperhero (Partner)
published in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Tip: Using Excel Migration for multiple views

As I get a similar question multiple times, I thought to write a separate topic on how to use an Excel Migration Job for multiple views. As example I take the creation of a new part in Excel and adding a manufacturer. I know it is a simple example but it is the base for exploration of more functionality. Create a mig job with the following setting: Used views on parts entryOpen the tab Rules Create connection between two viewsThis rule value would be the same as if you prepare an SQL statement that will connect the two views. So if you have a view that has multiple fields to form the external key, all field combinations must be included using a regular ‘and’ construction. There are quite some fields on a master part general tab. I've removed the majority in the spreadsheet by removing the source column in tab Source Mapping: Leave in the fields with a default value. Clearing the Source Column for these fields (as in positions 40 and 60) will result in not showing these columns in Excel

12003
P
Do Gooder (Customer)
5 months ago
N
Sidekick (Partner)
NZCNESOSESidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

SSO and Azure AD authentication

Hi we are trying to set up Single Sign On SSO on environment that is authenticating against Azure AD.Azure AD authentication is working fine but when we try to set up SSO (check box “Use Single Sign-On” on login dialog) according to steps in IFS Online documentation we get error message.Launch the IFS Enterpris Explorer client using the IFS Applications landing page. While the application is opeing keep pressing the "Shift"  key. The following dialog will appear. Tick the tick box "Use Single Sign-On" and press OK. User's corporate email address will be used as the login hint and user will be seemlessly logged in to IFS Enterprise Exlporer. No login dialog to enter user id or password will appear. Error is: Ifs.Fnd.FndSystemException: Unable to cast object of type 'System.DirectoryServices.AccountManagement.GroupPrincipal' to type 'System.DirectoryServices.AccountManagement.UserPrincipal'.   at System.DirectoryServices.AccountManagement.UserPrincipal.FindByIdentity(PrincipalContext con

8
N
Sidekick (Partner)
3 years ago
B
Do Gooder
BsanghavDo Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

licensing cost in IFS10

What are different licensing cost in ifs10? Is it user based or employee based? What is best way to have minimum cost?

4
KristenGastaldo
Superhero (Employee)
3 years ago
A
Do Gooder
aykutyDo Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Unpredictable runtime error is caught. See the nested exception. Caused by: Java heap space

 When printing a report we get an error like “Unpredictable runtime error is caught. See the nested exception. Caused by: Java heap space” how can we increase Java heap space hen printing.we are using ifs app 10 update 12  

1
Charith Epasinghe
Superhero (Employee)
2 years ago
N
Sidekick
NarsiSidekick
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick Report - data between two parameter dates

Hi,In Quick Report, I have to get data FromDate to ToDate using a DateTime columnI used this:WHERE o.REAL_FINISHED BETWEEN TO_DATE('&From_dd/mm/yyyy','dd/mm/yyyy') AND TO_DATE('&To_dd/mm/yyyy','dd/mm/yyyy') I’m getting when we go to view report  It works fine When I export data I’m getting this error:  Excel Plugin Error: Undefined bind variable 'from_dd' in Excel fileAny idea how to sort this issue?

9
durette
Superhero (Customer)
3 years ago
Harley
Hero (Customer)
HarleyHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

ORA-06511: PL/SQL: cursor already open

Since Thursday we have started seeing a number of Oracle Errors in the Database Alert Log. This appears to be when a user queries a screen with an Object Connection to  DocReferenceObject If the Attachment pane is open on the users screen the error is show in the foreground, however if it is minimized it logs the error in the background and the user is unaware (fortunately) Given that it started just last week it would make sense that it is related to a change, new report, event, but i have searched and cannot find anything that might be causing it. I have a ticket open with support but in case others have experienced the same issue or have any ideas on how to troubleshoot. The following is the contents of the Database Alert Log --Text2--sample parameters--DocReferenceObject--CustomerOrder--ORDER_NO=N720488^BEGIN :1 := IFSAPP.OBJECT_CONNECTION_SYS.GET_CLIENT_HIT_COUNT (:2 ,:3 ,:4 ,:5 );END;--Text1ORA-06511: PL/SQL: cursor already openORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS",

4
jhainsworth
Do Gooder (Customer)
2 years ago
Q
Do Gooder (Customer)
QMPGREGCDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Business Reporter Basics

Is there a manual on setting up basic reports?Can I mix data sources? 

3
Nadeesh Herath
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)
26 days ago
P
Do Gooder (Customer)
pshieldsDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Custom event using online sql

This seems like it should be easy but I cannot figure it out.  I want to create a custom event for the purchase_order_line_tab using  the execute online sql action.  The goal is when a PO line is entered, use the value from one field, use that in a function to return a value and insert that value into another field for the same PO line.  For a test I can just hard code the value for now.  If I was just creating a trigger I would do something like below.  Any suggestion on what I need to do to get this to work. declare  a_ varchar2(20);begin  a_ := 'Test Result';  :NEW.part_revision := a_;end; ThanksPhil

4
P
Do Gooder (Customer)
3 years ago
N
Do Gooder (Customer)
nachzehnDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

pl/sql code to upload document

hello everyone,Please can someone provide me with the PL/SQL code to upload  a document  (pdf file) into IFS APP10. I plan to build an interface in excel; and file location and call pl sql code to upload in IFS.Thanks very much in advance.

2
S
Hero
2 years ago
H
Do Gooder (Employee)
HiroshanDo Gooder (Employee)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Aurena Lobby Navigation with Parameters

A customer needs to implement a lobby which navigates to another lobby. They need to pass a couple of fields from the first lobby to filter data in the second lobby. It appears that this functionality is not working in Aurena. Has anyone come across this scenario with another customer? Thanks

4
C
Sidekick (Partner)
3 years ago
H
Hero (Partner)
Hans AndersenHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Getting Outlook attachments into IFS with object connection

Hi all, If I need to get an file attachment from Outlook into IFS with an object connection to a sales part, I know of 2 ways: Drag the file to a file folder. Drag it into IFS explorer from there. Create the file through the IFS Outlook Add-in. Make the connect in IFS explorer afterwards. Both methods involves 2 steps. Is there a way to do it in 1 step. E.g. drag and drop from Outlook to IFS Explorer (not working)?   

12
Asela Munasinghe
Superhero (Customer)
2 years ago
VivekBhandiwad
Hero (Partner)
VivekBhandiwadHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Report PDF Inserts

HiCan some one guide us how to use the IFS PDF Inserts in a Order Report. We need to print few PDF documents mandatory with Purchase Order.  The document TEXT Phrases, is a bit of challenge to align the content as per the expectations.  Where are and how can we call a PDF insert in the report? Is this a configuration in the report designer tool, Or is it to be configured or updated in the solution manager /report definitions. RegardsVivek

4
Chamaka Wimalarathne
Hero (Partner)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings