Solved

Hello,Where can I download the IFS Report Designer for version 8.2 ?We did download new Report Designer version but this not supported our IFS SP2 version.

Hi Experts, I have a situation where I need to compare values in a specific column of a specific table to all the other tables which has the same column. This is a FSM database and I need to query the orphan data (Child values which doesn't have parent values) sometimes generated when upgrade scripts are run. As an example, imagine there is a table called "A" and in that table there is a column called "B".There are numerous other tables which has this same column "B". So table A's "B" column is the parent and all other "B" columns are child columns. So other tables' "B" column can't have values which are not in table "A"s "B" column. I need a query to do following things, 1. To know which other tables have this column "B"2. To know which of these columns have invalid values and to show what those invalid values are Can someone suggest a query to do that ?Best Regards,Atheeq

Hi All you lovely helpful folk, I’m trying to create a RMB menu from the shop order operation tool to the Quick Report In Work page in the service and maintenance module. All our manufacturing tools have a one to one relationship with a serial object and are named exactly the same, therefore the TOOL_ID always equals the MCH_CODE - so the user see’s no difference.However when I’ve created the below custom menu I get the following error message when trying to use it - is this just not possible in our Apps9 update 17 IFS or do I need to do something else?    

Hello,Our current version is Apps 10 Upd 9.I recently created two custom projections to be able to utilize REST to load data.  One of them worked flawlessly with no extra interaction.  The second one threw a ORA-6550 error.  Upon looking into this error I found this in the odp-default-log.log file:com.ifsworld.fnd.common.exceptions.DatabaseException: Failed to execute the generated database statement …. more stacktrace not displayed …..Caused by: java.sql.SQLException: ORA-06550: line 1, column 35:PLS-00302: component 'NEW__' must be declaredORA-06512: at "CHIE1APP.PROJECTION_CONFIG_UTIL_API", line 174ORA-06550: line 1, column 7:PL/SQL: Statement ignoredORA-06512: at "CHIE1APP.PROJECTION_CONFIG_UTIL_API", line 156ORA-06512: at "CHIE1APP.PROJECTION_CONFIG_UTIL_API", line 179.Investigating that API it is trying to call my logical unit _CLP.New__ method.  I have confirmed that the _CLP package is created and has the .New__ method.  There are no compile errors on the _CLP package or BODY. 

I am trying to see the total records remaining to count subtracting the records that have been received this year. below is the SQL i am using and i get the same number of  records with out excluding the records that were received this yearexample what i am seeing using my current SQL 21 records 6 received this year column should read 15 records but it is still reading 21 records SUM(CASE WHEN RECEIPT_DATE > to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' ) and LAST_COUNT_DATE > trunc(to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' )) + ( 1 - 1/ ( 60*60*24 ) )THEN '0' ELSE '1' END) Thank you for any help

Hi,I need some help in clearing a couple of customer invoices with errors:I have two invoices which have been processed at a different value to the payment plan, IFS rejects these differences, details below: Customer            Inv                          Order                    Invoice                 Plan                       Varx                     970023938           00026513             1776                       1633.32                 142.68y                    970023828           00015520            2051.45                 2031                       20.45 below is the error message on the 2nd line for customer Y ORA-20105: Invoice.ACCERROR1: Error (Payment plan amount (2031) should be equal to invoice amount (2051.45).) occurred while booking Invoice CD 970023828.

While processing the Customer direct debit , i am getting error message -- CD-1239999 is blocked for Direct debiting.we followed the steps.First I go to Customer Payment Proposal screen I right click and select Create Direct Debiting Proposal Fill  the details. Once I press OK the collection should process and create a file for me to Acknowledge and then create an order with Instead I get the below error message where I have to then block the mentioned invoice for collection but when checking each of the invoices they should all be allowed so I don’t get why they are being blocked by IFS??CD-1239999 is blocked for Direct debiting. 

I’m trying to print crystal report from ifs, it is customized report .what this error means. 

When working on Customer Contracts, you can expand the OOS (Objects of Services) in tree view and then zoom into a line to look at the details but when you return to the tree view, the lines always collapse back to level 1, so then you have to expand it again, so if you are working on a lot of lines, you spend a lot of time just expanding the OOS each time.  This is particularly difficult if working on a contract with over 100 lines because then you have to click on the “ignore retrieve limit” box and then confirm two dialog boxes before it will expand.Is there any option we can set to enable the tree view to remain expanded each time we return to it?

Hi All I created a Document class under which I plan to connect a certain set of documents to either PO header or line (or both) in the future. Now I need to give all IFS users in my organization ‘View Only’ access to this Doc Class. I read the following post and the answer by @Thilini Kumarasinghe and noticed that PO is not among the standard object types available for access control.   Can anybody guide me through the steps on how should I do this with regards to the access setup? Thank You

Hello, hope y’all are doing well.  When creating Purchase Orders and Invoices, there is a functionality called “Multiple Tax Lines”, that is selected if there is more than one tax code connected to the invoice line. The question is, if there are more than one VAT code connected, how to distinguish the tax basis of each code? Thanks in advance

HiI am trying to figure out how to print my Part Certificate in Aurena. I cannot find where to print it from, can anyone help me?I do not see any option on the line to - Print... Same window in IEE with - Print option... 

Has anyone had issues with Inter-Site orders stopping because of an error message that states the EDI Coordinator is missing for the customer?The customer has the EDI Coordinator filled in and when I RMB to Approve it, it defaults to the correct coordinator. We are on IFS10, UPD10

Hi all,I have an issue with a requisition to order for a purchase requisition. I’m receiving an error for no revision found for inventory part ‘******’ . An eng revision was added against the inventory part, yet still receiving an error. Does a new req need to be created or what could the cause be? I checked the API that relates to this error message and it checks for an eng revision using wanted receipt date (which the req has), part no and contract.Any ideas of what could be causing the error?Thanks,Robert

Is there a way to automatically get the current version on a a given FSM TESTinstance for a Managed Cloud customer? By automatic I mean, by an http request (eg api) that could be run by a script?

Hi all, We experience a slower performance on our Test Environment, and when looking into what could have caused this, we ran into below query: SELECT 1FROM (SELECT M.APPLICATION_MESSAGE_ID,XMLCAST(XMLQUERY('$mb/*:Envelope/*:Body/REPLICATION/SENDER_MESSAGE_ID' PASSING XMLTYPE(B.MESSAGE_VALUE, NLS_CHARSET_ID('AL32UTF8')) AS "mb" RETURNING CONTENT) AS NUMBER)SENDER_MESSAGE_ID FROM FNDCN_APPLICATION_MESSAGE_TAB M, FNDCN_MESSAGE_BODY_TAB B, FNDCN_APPLICATION_MESSAGE_TAB QWHERE M.STATE = :B2AND M.APPLICATION_MESSAGE_ID = B.APPLICATION_MESSAGE_IDAND Q.QUEUE = M.QUEUE AND Q.APPLICATION_MESSAGE_ID = :B1AND B.SEQ_NO = 1ORDER BY M.APPLICATION_MESSAGE_ID DESC FETCH FIRST 100 ROWS ONLY)WHERE SENDER_MESSAGE_ID = :B3 Anyone having any idea what this query is doing? We see this query on our two environments that have UPD9 installed, not on the environments that are still on UPD7. 

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

Is it possible to set the default “Renewal Option” to be rather than ?  We always use either “Not Renewable” or “Renewable even when Obsolete” and rarely use just “Renewable”, if ever.Currently we are changing that setting using an escalation overnight but it would be better if the default was correct in the first place.

Excuse my lack of knowledge here, its a bit specific for me so could use some help.We have a situation where someone is trying to allocate cash but they are unable to select the open invoice to offset the payment against. When we try to select the invoice its not appearing in the selection. I checked the invoice and it seems it was originally offset with a supplier invoice, but that transaction appears to have been rolled back: Any ideas how i can allocate the open payment to the open invoice? 

In the F1 helptext for Prepayment Based Invoice, we find below, But still, we can create a Prepayment Invoice for the CO. Yet when we print the invoice report, we notice some incorrect tax calculations. Invoice lines look like below,So maybe we are facing this tax calculation issue due to above mentioned prerequisite, but why?What is the idea behind above highlighted prerequisite on a functional stand point? 

 I have problem with a new report in quick report screen. the name of this report is credit note.this report is shown to some user and hidden to some user in quick report screen how can it be solved?

Hi, We have the event Document Ready for Approval, and one of our customer’s would like to exclude some users or group of user to receive mail from this Event. This works for one user if we define it under the conditions. The user will not get any mails. They would like to know how to exclude persons in a certain Document Group (Person group). Thanks and Best Regards,Thilini

Hello, Has anyone come across and resolved this issue?  Our user reported the following: I am creating a Custom Navigation Link to go from a Business Opportunity to the Customer - CRM page passing the Customer ID Parameter.  In UPD7, i had no issues with this because both sides of the equation were using the Aurena Field names Source and Destination parameters:  In UPD9, I am having an issue with it because on the destination side they are using the Oracle Field which does not pass correctly into Aurena. Unfortunately, when you leave the field like this, the search doesn't work for the new page.  Thank you,Joann

How I can define employee as purchase order Authorizer ?

employee number x is accountant and he will review the po and authorize it.how I can define him as authorizer ?