IFS Solutions

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

27678 Topics

FPayab
Sidekick (Partner)
FPayabSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Failed executing query (ORA-01031: insufficient privileges)

User not able to access Quick Report. Access already given to the User for the quick report (Grant Query)Grant select to user on the ViewsBut still user receive the error.Failed executing query (ORA-01031: insufficient privileges) 

10
FPayab
Sidekick (Partner)
3 years ago
MikeArbon
Hero (Customer)
MikeArbonHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Post Upd16: Print Manager Error: No PDF report returned from Crystal Web Service

We are on Appsv9, and have just applied update 16. We have noticed that on occasions, Print Manager is erroring with ‘No PDF report returned from Crystal Web Service’. Obviously this is only on documents that are generated via Crystal Web Service. We have 3 x Crystal Web Services running and as far as I can remember, we have not seen this issue in Apps v9 before. The error in the Crystal Web Service log is: 18/03/2020 15:23:06[IFSCRWebSetupIFS9Lb]-[GetSavedPDFReport] The web instance is busy. The request will be forwarded to the next available instance. Has anyone else had this? has anyone seen this behaviour after an update? (we were on update 12). My guess would be to create a couple more Web services, but i suspect something somewhere has changed, for this to become a problem now. I believe we are only seeing this when the system is busy. Thanks all Mike

8
RanukaSerasinghe
Hero (Partner)
7 months ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Custom Event Advice

I would like to create a custom event on the Order Quotation that triggers when the user attempts to release the quotation.Condition for the Event Action:  NEW:ROWSTATE = Released I have created a custom field on the Order Quotation that is a calculation to display the margin percentage. On clicking Release the event needs to check to see if this field is below a certain number.  If it is below the defined number then a message needs to pop up informing the user that they cannot release the order due to the margin percentage being too low. I have tried creating a custom attribute on the custom event that uses an api call to retrieve the custom field value:ifsapp.order_quotation_cfp.get_cf$_margin_percent(&NEW:QUOTATION_NO) And in the Event Action tried something like:BEGINIF '&MARGIN_PERCENT' < '30' THEN                Error_SYS.Record_General('OrderQuotation', 'CHECKMARGIN: *ERR* The Sales Quotation Margin % is less than 40%.' );END IF;END; However, I keep receiving:table I

5
tobese
Hero (Employee)
3 years ago
T
Sidekick
TatKhandMSidekick
asked in Service (Touch Apps, MWO, MRO)

How to create a user with unlimited password expiry?

How to create a user with unlimited password expiry?     I want to create a user ,whose password should not be expired.    

7
A
Superhero (Employee)
3 years ago
P
Do Gooder (Partner)
ProSriniADo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Sizing Guide

I would like to know the Cloud architecture considerations when 21R1 is hosted on customer owned Azure environment? Where do I get the Hardware Sizing guide when Customer wants to install 21R1 on-premise?

2
Yasas Kasthuriarachchi
Superhero (Employee)
3 years ago
dgralek
Do Gooder (Customer)
dgralekDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Streams 503 error (Notifications)

Hello. Today I had a new issue with my application server. I’ve noticed that my notification area showed a warning sign. After some troubleshooting I’ve found error 503 in debug, and entries in access_log: [07/Jan/2020:10:18:40 +0100] "GET /websocket/notifications HTTP/1.1" 503 211 0 Another step was http_server log, this time different record: [2020-01-07T15:57:33.1390+01:00] [ohs] [ERROR:32] [OH99999] [weblogic] [client_id: *****] [host_id: *****] [host_addr: *****] [pid: 3092] [tid: 5496] [user: SYSTEM] [VirtualHost: ********] <3092157840903686> *******Exception type [CONNECTION_REFUSED] (apr_socket_connect call failed with error=730061, host=::1, port=58100 ) raised at line 1692 of URL.cpp and: [2020-01-07T15:55:56.0807+01:00] [ohs] [ERROR:32] [OH99999] [weblogic] [client_id: *****] [host_id: ****] [host_addr: *****] [pid: 2664] [tid: 3548] [user: SYSTEM] [VirtualHost: *****:58080] Active Websocket Connection Limit Reached: 4294967295 After some more investigation I’ve found

3
KamuranCanakli
Sidekick (Customer)
2 years ago
N
Do Gooder (Customer)
nkiphuthDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

REST API Post Integration from SQL

Looking for a solution to call a POST REST API from Microsoft SQL. We are able to use the GET successfully, but the POST is giving us issues. Below is an example of trying to issue a part to a Maintenance Material Requisition. We get the correct response Status: 201 (Created), and JSON Response text...but it appears we’re missing a “COMMIT” of sorts.Any suggestions? DECLARE @authHeader NVARCHAR(64);DECLARE @contentType NVARCHAR(64);DECLARE @postData NVARCHAR(2000);DECLARE @responseText NVARCHAR(2000);DECLARE @responseXML NVARCHAR(2000);DECLARE @ret INT;DECLARE @status NVARCHAR(32);DECLARE @statusText NVARCHAR(32);DECLARE @token INT;DECLARE @url NVARCHAR(256);DECLARE @Authorization NVARCHAR(200);--set your post paramsSET @authHeader = 'Basic sampledata';SET @contentType = 'application/json;charset=utf-8'SET @postData = '{  "ParentObjkey": "27AAD84E36F344E0995DB764FC5F13A4",  "ObjCreatedBy": "",  "Rental": true,  "ToDefaultWarehouse": true,  "SpareId": "",  "PartDescription": "",  "Spare

2
N
Do Gooder (Customer)
1 year ago
SORSITEL
Sidekick (Customer)
SORSITELSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

HttpServer1.log consumes all storage space

Hi, We have an issue that the HttpServer1.log files grow rather quickly and doesn’t rotate/stop until they consume the whole disk. Where can we set the max size for HttpServer1 logs?   Their path is: <IFS_HOME>\wls_domain\<instance>\servers\HttpServer1\logs\HttpServer1-yyyymmddHHMMss.log

14
C
Do Gooder (Customer)
2 years ago
mhdion
Do Gooder (Customer)
mhdionDo Gooder (Customer)
asked in Service (Touch Apps, MWO, MRO)

How to show toolbar again?

Hi, I’m starting to use IFS Application. It’s a Windows Client running on Windows 10 Professional. I was reading the on line help and doing the excercises proposed on the e-learning page. When working with the toolbar, I used the contextual menu to hide diferent toolbars. Suddenly, I hided all the toolbars and I can not find the way to show the toolbar again. I’ve looked in every menu available, and tried with the secondary mouse button on the menu.   About info is: IFS APPLICATIONS 7 Copyright © 2006 IFS AB This program is protected by copyright laws and international treaties. Unauthorized duplication or distribution may result in severe criminal penalties, and will be prosecuted to the fullest extent possible by law.   System Info: Windows Environment: Systema Operativo:        Windows Server 2003 Versión Windows:        6.2 (build 9200) Nombre Ordenador:        GPEV-SSOP-C01 Procesador:        586 No Procesadores:        4 Memoria Libre:        2048 Mb Disco Disponib

5
Thilini Kumarasinghe
Superhero (Employee)
3 years ago
PRODQ
Hero (Customer)
PRODQHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

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

A user has created a Credit Invoice today (Apps 9) and on trying to RMB/Print the invoice in order to move from Prelim PR state to Posted encountered the following error: Server error messages:5a3bfedb-4342-43bd-b335-cab0d6e25802Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: 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 14I have previously come across this error when a customer or supplier name is particularly long but in this instance the customer name wasn’t that long (only 26 characters).   Some trial and error investigation uncovered the fact that there were four email addresses listed for this customer in the Comm Method tab, similar to below.  Names have been changed but there was a total of 116 charactersmaryj.smithyy@greenyellowyellowgr.com,an

5
PRODQ
Hero (Customer)
2 years ago
R
Superhero (Partner)
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  

10
Banu Liyanapathirana
Hero (Employee)
4 years ago
J
Do Gooder
JoherMDo Gooder
asked in Products (Manufacturing, Products, Engineering)

Definition of 'Project MRP' (pMRP)

Hi, The business I'm employed by is considering the purchase of Project MRP (or pMRP) to compliment our existing packages (IFS Apps 10 and APB).   However, it's not entirely clear what additional features pMRP provides (and the problems this tackles that the 'stock' planning tools can't).   Can you please outline its key contributions to production planning or at least some information with respect to it. I can't find any detailed resources online for reference.   Many thanks, Jay    

7
L
Do Gooder (Customer)
11 days ago
I
Sidekick (Customer)
IFS_ShekharSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Scheduling Quick report for mail using Application Server Task

Hi, I used Application Server Task for mail Quick report and use reoccurring schedule patterns but it sent mail only once but Application Server Task status is still Waiting but not working. Please guide me for this issue.   Regards Shekhar

16
MORCXGUDLA
Do Gooder (Customer)
2 years ago
S
Hero (Customer)
SHAUN_KERSLAKEHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

List of Oracle Views

Good afternoon,Is anyone able to provide the database views/tables for those areas of the IFS system which are not visible through the System Info tab? These typically are screens within the Solution Manager folder.For example, Database tasks, Scheduled Database Tasks, Background Jobs etc.We are using Apps 8.Thanks in advanceRegardsShaun

7
durette
Superhero (Customer)
4 years ago
S
Do Gooder (Customer)
svrmhuebnerDo Gooder (Customer)
asked in Finance (Financials)

GL reversing entries

Hello to all the Accounting members, we are tying to configure IFS to automatically reverse a GL voucher entry after the first of the month.  This is the classic accrual type of GL entry whereby we make a GL voucher transaction entry in one month and auto reverse it the next month after the actual charges post to the balance sheet.  When creating a manual voucher entry, we do not see anywhere we can set a reversal.  We are on IFS APPS9, UPD16.  How can this be achieved in IFS?  There has to be a way as this is Accounting 101.Thanks!Mark

13
R
Hero (Customer)
2 years ago
C
Do Gooder (Customer)
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

5
ChanakaAmarasekara
Hero (Employee)
4 years ago
A
Do Gooder (Customer)
anuruddhabmDo Gooder (Customer)
asked in Assets (Asset Management)

The URI http://appserver:58080/fndext/clientgateway/ cannot be found. Error 404 - Not Found

I am getting above error when trying to login on app9. In the previous occurrence where I got the same error, I restored both APP and DB servers with an image backup. After restoring it worked for about 4 months and I am getting the error again.

3
H
Sidekick (Employee)
2 years ago
A
Sidekick (Employee)
avenashSidekick (Employee)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Serialization error during OData GET when one of the field value contains carriage return character

Hi all,While working with ProjectsHandling projection in Apps 10 environment I came across an issue with serialization when one of the field values contains carriage return character. <ERROR>{"error":{"code":"ODP_SERIALIZATION_ERROR","message":"Error while serializing contents."}}</ERROR>https://<host>:<port>/main/ifsapplications/projection/v1/ProjectsHandling.svc/ProjectsIn my case, the field which has the bad data is ‘BaselineRevisionComment’. Everything works okay if this field is not selected in the OData query. Aurena Client is also breaking when this particular Project having bad data is selected. Did anyone experience this before? Any workarounds?Thanks in advanceAvenash

8
A
Sidekick (Employee)
2 years ago
C
Do Gooder (Partner)
CSGarethFDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Filtering LoV in Aurena

HiIn EE it is possible to filter the fields in a LoV selector by a value in the main form using a SQL query search similar to the following:CUSTOMER_NO = i_hWndParent.frmOrderQuotation.dfsCustomerNoDoes anything like this functionality exist on Aurena yet?  The only way I have found is to click the Find button on the LoV and then search for the Quotation No in this example.  This is a number of extra clicks and will not be appreciated by our CustomersThanksGareth

9
BawTrishM
Sidekick (Partner)
1 year ago
DomCotton
Do Gooder (Customer)
DomCottonDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS 10 Rest API authentication

I am trying to use the Rest API in IFS 10.  Currently I am struggling with the authentication.  I have found various posts which some say you can use basic authentication, others say it must be oAuth.  However using basic I am constantly receiving a 401 Unauthorized, i can’t find any official documentation explaining how to authenticate using oAuth.Can anybody help?Thanks

3
Charith Epitawatta
Ultimate Hero (Employee)
2 years ago
STMVALENTINE
Sidekick (Customer)
STMVALENTINESidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Purchase Order - 'Email Order...' option from RMB menu

In Apps 9...I would like to know how and what criteria needs to be done to use this option from the RMB menu of a purchase order.  I know all about setting up an event action triggered off the PDF_REPORT_CREATED - but this is not what I want as that would be something that is triggered upon every PO printed and not just when I select the menu item while on a certain PO.  Has anyone used this feature and can help explain it a little to me? 

12
Z
Do Gooder
2 years ago
K
Do Gooder (Customer)
KezziaKDo Gooder (Customer)
asked in Distribution (CRM, Commerce)

Differences between Representatives, Coordinators and Salespersons?

We are in the final stages of Aurena Apps 10 implementation and I work in CRM and Call Center and I want to make sure we have all understood the sales roles correctly.  If I create a quote or an order, I think:  the coordinator creates the quote/order, but is not responsible for it  the representative is responsible for the quote/order the main representative is the representative’s senior and can override their work the salesperson can be internal (colleague) or external (e.g. reseller)Is this right? TIAKezzia

2
K
Do Gooder (Customer)
3 years ago
K
Do Gooder (Partner)
kadoryDo Gooder (Partner)
asked in Finance (Financials)

Payment methods

Hi, I’d like to create a new payment detail in Payment Methods, and in the Formad ID area there are only a few candidates I can pick up(Pic.1), while I’ve already copyed and created a new line in Payment Formats(Pic.2) What should I do in the next?Thanks!   Best Regards  

7
A
Hero (Customer)
3 years ago
N
Do Gooder (Customer)
NPIALEXLODo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

UCEERR_RENDERTHREADFAILURE(EXCEPTION from HRESULT: 0x88980406)

Unable to login to IFS APP10 and received error UCEERR_RENDERTHREADFAILURE(EXCEPTION from HRESULT: 0x88980406)

4
D
Sidekick (Customer)
9 months ago
H
Hero (Partner)
Hans AndersenHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Batch print Work Instructions for Shop Orders, IFS9

How do I print out multiple shop order works instructions. E.g. all instructions for shop orders created by ‘HA’ today? Preferable without any print dialogs.

18
H
Hero (Partner)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings