IFS Solutions

Q&A Discussion of IFS Solutions for our IFS Employees, Partners and Customers

27362 Topics

R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Database sessions ORA-00026 missing or invalid session id

In Database Sessions we have a long running session related to Business Reporter scheduled report that we wish to kill.The session id in Database Sessions is 642:  However, on RMB > Kill Session we receive the following error: I cannot see the session in Monitor Sessions in SQL Developer but can see the session when doing select from v$session : select * from v$session where sid = '642'  ;Using the SID and SERIAL#  I tried to kill the session:ALTER SYSTEM KILL SESSION '642,12109'I receive the following error:Error report -ORA-00026: missing or invalid session ID00026. 00000 -  "missing or invalid session ID"*Cause:    Missing or invalid session ID string for the current operation.*Action:   Retry with a valid session ID.Obviously, can see the session in FND_SESSION_RUNTIME How can I kill this session when it isn’t reported in Monitor Sessions and any attempt to kill the session report in the missing or invalid session id? 

1
R
Superhero (Partner)
2 years ago
dsj
Superhero (Partner)
dsjSuperhero (Partner)
published in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Tip: Using POSTMAN to test IFS Webservices

Postman is popular as a REST client but it works really well with SOAP requests as well and can be used to test IFS Web Services/BizApi requests.Hope following guide will help if anyone is interest in using Postman as a SOAP client for IFS integrations.Postman can be freely download from here.Following steps show how to make SOAP requests using Postman:1. Create a new RequestGive the SOAP endpoint as the request URLApps 10: https://<APP_SERVER_URL>:<PORT>/int/soapgateway Previous IFS versions: http(s)://<APP_SERVER_URL>:<PORT>/fndext/soapgatewaySet the request method to POST. 2.Set Auth HeaderGo to the Auth Tab,Select Type as Basic AuthType IFS username and password to be used for the integration 3.Set SOAPAction HeaderNext step to add the SOAPActin header, which is required by IFS SOAP Gateway to identify incoming message as a SOAP requestKey = SOAPAction Value =Synchronous:urn:soap_access_provider:<BizAPI_Name>orurn:soap_access_provider:<Handler_Name&

45908
dsj
Superhero (Partner)
1 year ago
S
Sidekick (Customer)
SORBJAHAUSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Last Login for user

I want to have access to our users last login date for IFS10. There is a column in ORACLE_ACCOUNT (dba_users), but this doesn’t seem to log Logins to the Application, only PL/SQL, BAES and other stuff. Earlier we created a trigger to fetch logins from active sessions, but this caused problems. Anyone knows how to get hold of this Login information? We want to use it for license control. 

21
R
Do Gooder (Employee)
7 months ago
M
Do Gooder (Customer)
magnum80Do Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Oracle 'Bad Depth Indicator' error in IFS10

Hi, We have started getting an Oracle ‘Bad depth indicator’ error when calling ‘Error_Sys.Record_General’ function from a custom event.   We have reported this to IFS support who in turn have raised this with Oracle support. Please see the long response from them below. In short they have concluded that it is intermittent and that they don’t know how to re create it. They have given us a workaround which is to re compile the affected packages.   Has anyone else seen this error? “ This was the full error stack we extracted when you were getting the error within purchase order lines.  ORA-64610: bad depth indicator ORA-06512: at line 16 ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 2186 ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 2304 ORA-06512: at "IFSAPP.ERROR_SYS", line 128 ORA-06512: at "SYS.UTL_CALL_STACK", line 99 ORA-06512: at "IFSAPP.ERROR_SYS", line 113 ORA-06512: at "IFSAPP.ERROR_SYS", line 119 ORA-06512: at "IFSAPP.ERROR_SYS", line 337 ORA-06512: at line 3 ORA-06512:

17
SAKUIN
Do Gooder (Customer)
2 years ago
H
Do Gooder (Employee)
HAANSEDo Gooder (Employee)
asked in Products (Manufacturing, Products, Engineering)

Label printing

Hi, i am looking for experiences using either IFS built in report tool or 3P products for creating labels. Labels used for handling units (multiple level) and products. Labels using Odette standards and/or GS1 (GTIN) of extra interest. BR Håkan

18
J
Do Gooder
7 months ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Reprt Export to Excel removes leading zeros

Hello, The problem is when a user export report to excel 1- lost leading zero’s from Check # 2- Formatting is off: Excel shows 2.0031E+13 while actual value in report is 020031003282756   I tried to_number but it gives me error ‘ORA-01426:Numeric Overlfow’   any work around options here. Thanks

11
O
Sidekick (Customer)
4 years ago
A
Sidekick
AlanSSidekick
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Community Login

Can you please explain why each and every time I try to login to the community my current password is not recognized meaning that I have to send an email regarding a password change? Once I change the password the next time I login the system informs me that my credentials are invalid and I’m forced to repeat the password change process all over again.ThanksAlan

1
A
Superhero (Employee)
3 years ago
B
Sidekick (Customer)
bhaveshSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Unable to start Middleware Server

We just refreshed our test environment from live. Now used stop_all_servers.bat to stop all servers. All servers successfully stopped.   However upon restarting servers the script is stuck at Starting server ManagedServer1….   Any idea what could be the reason. Looking at the logs it shows  The server 'ManagedServer1' with process id 21880 is no longer alive; waiting for the process to die.

15
B
Sidekick (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
H
Hero (Partner)
Hans AndersenHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Solutions for the mutating problem

Hi all, I constantly have to deal with the mutating table error when creating events. Usually I need to: Save (F12) Run some PLSQL in an custom change event (mutating if same table involved) The only solution I know, is to start a background job. However, for some scenarios I need the code to run “online” or lock the UI until the job has executed.   Does anyone has some solutions for this?  

20
madlad
Sidekick (Customer)
3 years ago
S
Hero (Customer)
SHAUN_KERSLAKEHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Opening IFS with different browsers

Hi We are using IFS Apps 8, and when using IE browser IFS opens seamlessly, however with browsers like Chrome it will drop the application manifest file Ifs.Fnd.Explorer to the bottom of the screen and the user then needs to click on this to open IFS.  Is there a way to use newer browsers such as Chrome but ensure the manifest file isn’t downloaded but users are taken straight to the login page? Any guidance would be appreciated Regards Shaun

9
C
Do Gooder (Customer)
2 years ago
T
Sidekick (Partner)
TecSunilNSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Excel output from Order Report

Can we create an excel output from Order report? If yes, how is this achieved.

20
T
Sidekick (Customer)
3 years ago
J
Do Gooder
jeffersonmoreiraDo Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS APIs

There´s any documentation about IFS APIs?

3
S
Do Gooder (Customer)
1 year ago
M
Sidekick (Customer)
m.arifSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

CRP/RRP and MRP

Would like to know how each one works . Appreciate if someone can give me resource link or manual regarding how CRP/RRP AND MRP works in IFS.

5
M
Sidekick (Customer)
2 years ago
P
Do Gooder (Employee)
Pawel LenczewskiDo Gooder (Employee)
posted in Upgrades & Updates

Updates and Configuration Analyzer

With Updates becoming main vehicle for delivery of fixes and new functionality for IFS Applications there is a greater need for our Customers and Partners to be able to validate impact of merged Update on configurations they have developed. This has been made possible from Update 6 for Application 9 and RTM release of Applications 10. However up to very recently it involved help from IFS Global Update Team who could include export of configurations developed by Customer and/or Partner during Update Analysis and provide list of impacted areas. From second half of 2019 we have even better solution for dealing with Update impact analysis on developed configuration. IFS Product Development made it possible with IFS Configuration Analyzer. Now Customers and Partners can perform impact analysis at any point in time – before, during or after delivery of Update delivery. Tool will present impacted configuration in a list that shows type of impact and allows to export that information to Excel.

23
P
Do Gooder (Employee)
3 years ago
Amila Samarasinghe
Superhero (Partner)
Amila SamarasingheSuperhero (Partner)
asked in Document Management (DocMan)

Uploading larger files will give an error "Object reference not set to an instance of an object"

Sometimes when I upload large files via IFS DocMan I am getting the above error message. Any way to bypass this?

9
B
Do Gooder
3 years ago
MattiasLindahl
Sidekick (Customer)
MattiasLindahlSidekick (Customer)
asked in Upgrades & Updates

Upgrade from Oracle 12c to 19c

Can I find information about upgrading an IFS database from 12c to 19c? From november 20 2020 we should have upgraded to 19c due end of support from Oracle on 12c.

6
william.klotz
Superhero (Customer)
4 years ago
Charith Epasinghe
Superhero (Employee)
Charith EpasingheSuperhero (Employee)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Optimum value for job queue processes parameter

Sometimes we have noticed performance drawbacks due to the value set for the "job queue processes” parameter in the oracle database. What is the correct formula for the set this value correctly and what are the things that need to consider?  

4
ToBeNL
Hero (Employee)
3 years ago
Yasuda
Do Gooder (Partner)
YasudaDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

ORA-20000: Oracle Text error: DRG-50857: oracle error in drvddl.IndexSync ORA-06508: PL/SQL: could not find program unit being called ORA-06512

Dear Sirs; Newly implementation IFS 10UPD8 being started at new customer.  The following error message is showed at backgroud job detail. “ORA-20000: Oracle Text error: DRG-50857: oracle error in drvddl.IndexSync ORA-06508: PL/SQL: could not find program unit being called ORA-06512” It seems like to be Oracle setup issue, but NOT IFS. Please anyone advice me to solve. Regards; Susumu

6
sutoto
Sidekick (Partner)
6 months ago
J
Do Gooder (Customer)
JPysznyDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Custom menu type "PL/SQL Block" with window transfer

I would like to perform an action in one custom menu and then move to another window.A simple but not user-friendly solution is to create two custom menus:First: action type: “PL / SQL Block” - execute code (create a new row in the table), Second: action type: “Create window with transfer” - go to window.Is it possible to switch to another window in the “PL / SQL block” (run procedure / function)?

15
durette
Superhero (Customer)
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
P
Do Gooder (Employee)
Pawel LenczewskiDo Gooder (Employee)
published in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Tip: Collecting Application Server diagnostic information

This topic explains some techniques that can be used to find out what is causing problems with your middle-tier, for instance Connect message problems, security issues, slow running system, etc.It has been created mainly for IFS Applications 8 with IFS Middleware Server  but it should be possible to apply techniques listed here to IFS Applications 9 as well. Some of the areas like Monitoring Console could look differently or have more functionality. Log files should be stored in similar locations as well.In general, in order to figure out where to look for problems, you have to understand which part of the system is involved. Is the middle-tier involved at all? The process where you have problems, is it a background job (Batch server involved) or a synchronous call? Is the client doing a direct call to the middle-tier or is the database invoking methods in the middle-tier (using the PL/SQL Access Provider)?In addition to the tools described here, IFS Solution Manager can also be used t

35602
P
Do Gooder (Employee)
2 months ago
Asela Munasinghe
Superhero (Customer)
Asela MunasingheSuperhero (Customer)
posted in Upgrades & Updates

IFS 9 to Cloud Upgrade anyone?

Hello Can any IFS Customers, Partners or IFS Consultants in the Community elaborate on an upgrade you’ve made from IFS App9 to the Cloud?We are in App9 UPD14, we are debating to go through App10 or not. What do you think?We have quite a lot of customizations and configurations and maybe, only maybe, some of them will not be needed after the upgrade.  Thanks!

37
S
Do Gooder (Customer)
3 months ago
krestensb
Sidekick (Customer)
krestensbSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Are you using UTL_HTTP in PL/SQL to call external REST API's

Hi, Are you using PL/SQL to send dato to external REST API ? Will you share your experience with that?   BR Kresten

4
Anushka Rathnasiri
Do Gooder (Customer)
1 year ago
C
Sidekick (Customer)
courtney.engelSidekick (Customer)
asked in Distribution (CRM, Commerce)

Unreserving parts on a customer order pick list

We are using IFS 9 Patch 17 as of November. Recently I had an employee who created a quote to order situation for parts. They reserved the parts and then created the picklist. This area does not use Shipment so it was just a picklist. When they got out to the area the part was not there and cannot be fulfilled. In the past they thought they could still pull it off of the picklist (but no one remembers how they did it). I took the situation to our test environment and proved if the part did not make it to the pick list you can still unreserve it. Once on the pick list you cannot unreserve, you cannot change quantities, and I cannot seem to figure out how to report the line not picked. Anything I try to change on the line of the pick list just does not let us save. Could this be an issue in SP 17 or is there something I am missing when trying to help them out? 

1
J
Superhero (Employee)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings