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,328 Topics
  • 22,847 Replies

7328 Topics

X
Do Gooder (Partner)
XitThariKDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Using ampersand , “&” in plsql as a character

Hi,I want to write a plsql script for a quick report with using ampersand symbol, “&”, as a character in the where clause in the code. But when run the report it gives me the error “Invalid member name.”  How can I solve  it? Thanks You 

9
Minoshini Fonseka
Superhero (Employee)
2 years ago
ADNAN
Sidekick
ADNANSidekick
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Command_SYS.Mail(

 Our company moved to office 365 and the mail port and protocol changed. I adjusted the mails sent from the events tab in IFS. I cannot run mails sent from PLSQL. Where can I change the settings? With the following settings, mails sent from the events tab work.    Working mail is not working for the example procedure below.PROCEDURE SISTEM_BILGISIISparameter_attr_    VARCHAR2(2000);      result_key_        NUMBER;      report_attr_       VARCHAR2(2000);      msg_               VARCHAR2(32000);       print_job_id_      NUMBER;      attr_              VARCHAR2(4000);      date_              DATE;      attach_            VARCHAR2(2000);      text_              VARCHAR2(32766);      subject_           VARCHAR2(2000);      deger_           VARCHAR2(2000);         BEGIN       IFSAPP.Log_SYS.Init_Debug_Session_('en');               Command_SYS.Mail(            from_user_name_ => 'IFSAPP',            to_user_name_ => 'ayilmaz@sefine.com.tr',          ---  cc_ => 'ayilmaz@sefine.com.tr

13
A
Do Gooder
3 years ago
R
Do Gooder (Customer)
RicReedDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Customer Portal

Hello,Can someone tell me how I can reset my password for the IFS Customer Support Portal?Thanks,Ric Reed

10
Kanishka Wasalagedara
Sidekick (Employee)
2 years ago
J
Do Gooder (Customer)
jchristyDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Error: Maximum of 148 enabled roles exceeded

I’m running into an issue where, for employees that need access to many different areas of the system, I receive an error message “maximum of 148 enabled roles exceeded” after assigning additional permission sets to the user account.  This is primarily for a few executive positions in our organization.I thought if I recreated a new permission set with all of my functional roles attached to the end user role, that would take care of the problem but it did not. What’s the best way to handle giving a user account access to the various areas of the system, without using IFSAPP_FULL?

3
J
Do Gooder (Customer)
3 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)
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)
3 years ago
Srikanth
Superhero (Partner)
SrikanthSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Change Password

Hi, I am trying to change a standard IFS user’s password using Change password option on IEE and running into an issue:   Error message  This works fine if I change IFSAPP’s password but not for any other user granted FND_CONNECT. Has anyone come across this issue before? Do we need to enable any parameters to make Change password work? Version: IFS Apps 10 UPD8   TIA!

13
M
Sidekick (Customer)
3 years ago
S
Hero
sutekh137Hero
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to get the PDF from an IFS-generated report?

Hello,I would like to be able to print one of the “main” IFS reports to PDF and be able to access the PDF -- from outside of IFS. For example, I would like to be able to print a Purchase Order and have access to the generated PDF, from a custom-build .NET program (C#).I turned on the debugger in IEE, and after the popup comes up to print, preview, or email the Purchase Order, there is no output in the debugger. So, I cannot tell what is being called to generate the PDF. But the Windows IEE client must be telling Oracle what to do in order for the PDF to be created, no?The bottom line is that I would like to use Oracle package method calls to generate and access the PDF representing a document such as this. I don’t want to re-create the whole purchase order report outside of IFS when the default P.O. is already a good start, and the PDF format is acceptable.How to I generate a PDF and access it from outside IFS via Oracle API calls? Thanks,Joe Kaufman

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

Documentation for the parameters in the PDF_REPORT_CREATED event

Hi all,I am trying to activate an event action that send the report “Customer Statement of Account” to the customers email address. But I am having a hard time getting it to work. All the parameters starting with pdf_ are blank. Is there any documentation for the parameters?

11
D
Sidekick (Customer)
2 years ago
krestensb
Sidekick (Customer)
krestensbSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to create a defered job to execute .modify__() ?

Hi, If I want to change a customer order line I use this function: Customer_Order_Line_API.Modify__()   Some times I need to do it it in a background job. Then I would create a new procedure that executes Customer_Order_Line_API.Modify__() and then start that new procedure with Transaction_SYS.Deferred_Call() from an event.   Is there any way to perform this directly without the custom procedure?   Best regards Kresten

10
PhillBronson
Sidekick (Customer)
1 year 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)
3 years ago
P
Do Gooder (Customer)
PareshDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

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

Hi,I am having an issue when importing an extremally large ACP package that holds a number of Aurena Page configuration for multiple context.  When I try to open the ACP package IFS runs a validation that throws the following error message.  ORA-06502: PL/SQL: numeric or value error: character string buffer too smallFailed executing statement (ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at line 11ORA-06512: at "NORT1APP.MESSAGE_SYS", line 138ORA-06512: at "NORT1APP.APP_CONFIG_ITEM_IMPORT_API", line 2200ORA-06512: at "NORT1APP.APP_CONFIG_ITEM_IMPORT_API", line 2212ORA-06512: at "NORT1APP.APP_CONFIG_ITEM_IMPORT_API", line 2536ORA-06512: at "NORT1APP.APP_CONFIG_ITEM_IMPORT_API", line 2557ORA-06512: at "NORT1APP.APP_CONFIG_ITEM_IMPORT_API", line 1913ORA-06512: at "NORT1APP.APP_CONFIG_ITEM_IMPORT_API", line 1918ORA-06512: at "NORT1APP.APP_CONFIG_IMPORT_API", line 2200ORA-06512: at "NORT1APP.APP_CONFIG_IMPORT_API", line 2205ORA-06512: at line 6) The

13
M
Sidekick
1 year 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)
3 years ago
D
Do Gooder (Customer)
DOlsenDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Forms and Table or View List

Somewhere in IFS 10, each window knows which table or view it’s based on.  And, the navigator knows what to display in it’s list and which window to display when the user clicks an item.  How do I get a list of all the windows named in the navigator, the tables or views they’re based on,  and their Object relations?For instance, someone created a custom menu in window “frmPriceInquiryAnswer” and I need to verify it works (for migration to IFS 10).  Searching the navigator for something like that gets me to “Price Query” and it doesn’t have a custom menu.  Multiply this by a list of 300 custom menus, and you see my problem.In advance, thanks so very much!

7
D
Do Gooder (Customer)
4 years ago
T
Do Gooder (Customer)
Tim OliverDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Crystal Reports runtime dlls

Version - IFS2003 We have a user who often exports Quick Report Navigator Crystal Reports to excel using the Export icon. On his old laptop, he has the option to export to MS Excel 97-2000 whereas the new client build only has older options (Excel 5.0, Excel 7.0, Excel 8.0). 97-2000 gives better formatting of data into Excel. We know that the F1 Runtime part of a client install loads Crystal runtime components onto the client and we think we have installed something else on is old laptop in the past to give him the 97-2000 option but don’t know what. We have compared like with like and cannot see a difference. Any ideas where the dlls might be that give him the option for Excel 97-2000? Thanks in advance.​   What we want:   What we get when we install IFS:  

3
ChanakaAmarasekara
Hero (Employee)
4 years ago
KristenGastaldo
Superhero (Employee)
KristenGastaldoSuperhero (Employee)
published in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Primavera Integration (PROJX)

Primavera Integration (PROJX) This document describes how to install the IFS-Primavera Project integration. Use this document when an integration is installed or configured. Deployment Overview Step 1: Install Primavera Software Prerequisite Prior to running the setup, Oracle Web Logic Server and Database (Oracle or SQL Server) should be setup. Please refer relevant Primavera documentation for additional information (Web logic and database versions should be supported by Primavera)   Primavera Installation Relative location of the installation is "Primavera P6 Enterprise Project Portfolio Management (18.8 or 17.9) for Microsoft Windows x64 (64-bit)\(P6_R179)\Disk1\install\setup.exe". Start the setup and proceed. Make sure (P6 17.9/18.8 and P6 Integration API 17.9.0.0/18.8) is checked. The integration API will be installed in Remote Mode by default. Primavera Integration API Installer will invoke the Database Configuration window and permission to use the database will be requested.

25333
C
Do Gooder
3 years ago
S
Hero (Customer)
SHAUN_KERSLAKEHero (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)
4 years ago
ascheeka12
Sidekick (Customer)
ascheeka12Sidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Oracle User account locked(timed) frequently after few minutes

Dear Team,I need your help OR suggestion for the subjected topic. since yesterday one IFS user account frequently getting locked(timed) in oracle user management. user is already active but don’t know the exact problem with user account.really appreciate for quick support on this.  Regards,

4
ascheeka12
Sidekick (Customer)
2 years ago
CallumW
Superhero (Partner)
CallumWSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Excel Input (Paste Object) Tool

Hi,   Does anyone have a copy of the Excel Input tool they could upload where you copy an object out of IFS - run a macro and then can paste the objects back into IFS? This tool is very handy for adding in new records into an overview form   Thanks in advance

10
S
Sidekick (Customer)
2 years ago
VivekNR
Sidekick (Partner)
VivekNRSidekick (Partner)
posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to reset F1 user "IFS" Password

Hi All,   How to reset F1 user "IFS" Password. Share procedure, if screen shot highly appreciated.   Please advise.   Reagrds, Vivek NR.

16
R
Do Gooder (Partner)
1 year ago
C
Do Gooder (Customer)
clint1028Do Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Aurena Lobby Element

I am using IFS10 Update 7. I have been able to design a lobby element that pulls back data in Enterprise Explorer but doesn’t work when viewed in Aurena.   Aurena:     Enterprise Explorer:    

26
A
Sidekick (Customer)
1 year ago
Nimesh Kasun
Hero (Employee)
Nimesh KasunHero (Employee)
posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Wildcard SSL/TLS Certificate Verification Error in App10

If you're getting the following error while trying to import a SSL certificate to IFS Application, this article may help solve your issue. Parameter Error: Certificate verification failed. Path does not chain with any of the trust anchors.  Solution If you're trying to protect a *.corpnet.ifsworld.com internal service or *.ifsworld.com internal service, you must be using one of the following example certificates within the installer which can give the above mentioned error.wildcard_corpnet_ifsworld_com_2023-06-02.pfx wildcard_ifsworld_com_2023-06-02.pfx If you had selected one of the certificates like above certificates (Date of the certificate name may subject to update), use the one of the following certificates where the certificate name ends with _kcc.pfx and try again.wildcard_corpnet_ifsworld_com_2023-06-02_kcc.pfx wildcard_ifsworld_com_2023-06-02_kcc.pfx Providing one of the certificates like above example certificates (Date of the certificate name may subject to update) will so

1
Bhanuka Senevirathne
Sidekick (Employee)
3 years ago
N
Do Gooder (Customer)
NIBDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Needed architecture for IFS AND Power BI

Hello IFS community !I'm looking for information about my following problem: My company uses the IFS ERP and would like to be able to connect a dashboard tool like POWERBI and I would like to get some advice on all the elements needed for the architecture. SQL SERVER  ?  SSIS ? IFS prepackaged analysis models ? IFS REPORTING & Analysis ? etc.. ? ThanksKinds regards  

5
I
Do Gooder (Customer)
3 years ago
N
Do Gooder
NikitaVelapure19Do Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to enable AD authentication on REST API? is there any documentation for this?

How to enable AD authentication on REST API? is there any documentation for this?

7
T
Do Gooder (Customer)
10 months ago
A
Do Gooder (Former Employee)
Anton PereraDo Gooder (Former Employee)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Oracle SqL Query stuck time to time

Hi All, I am trying to replicate customer issue internally with the customer db dump. Program sends series of sql statements to the database ( i.e inserts ,updates delete ). If the program completed successfully, I just refresh the tables with customer db dump and started testing again. I have completed couple of test runs yesterday successfully.(it takes around 10 mins to complete all sql statements ) When I ran test today, it stuck on particular statement (even after 10 mins that particular sql statement didn’t get completed ), where as yesterdays run it took less than one minute to complete and sends back results to the program, on same data. I am testing the program each time on exact the same data. No changes in database, data, and no time outs , no network issues, noted. No deadlocs or table blocks observed. Why the oracle sometimes takes long time (some times no response at all ) on sql statements which sends results quickly on previous tests, exactly on same data)?  Not c

1
S
Superhero (Employee)
4 years ago

Badges

Show all badges
Terms & ConditionsCookie settings