Solved

Hello,Does anyone know where to change translations for Report Designer? And is it possible to translate the strings we add?Thanks!Best regards,

This quick report’s subquery that has FETCH FIRST 1 ROWS ONLY to pull the first PO is only returning one row for the entire report; not for each part#:SA-807 has a qualifying row as well; we should see a Next Supply Qty and Next Supply Date as we ll as SA-811.  selectip.contract,ip.part_no,ip.type_code_db,ip.part_product_code as Product_Code,ip.type_designation,sp.catalog_group as Sales_Group,ipp.safety_stock,ipcp.qty_available as Available_Inventory,ipp.safety_stock - ipcp.qty_available as Over_Short,( SELECTosd.qty_supply as Next_Supply_Qtyfrom ORDER_SUPP_DEM_EXT_TMP_VIEW osd where osd.contract = ip.contract and osd.part_no = ip.part_no and ( osd.order_supply_demand_type = 'Shop Order' and osd.status_Desc in ('Planned', 'Started', 'Released')or osd.order_supply_demand_type = 'Purch Order' and osd.status_Desc in ('Planned', 'Released', 'Received') ) order by osd.date_requiredFETCH FIRST 1 ROWS ONLY ) as Next_Supply_Qty,( SELECTosd.date_required as Next_Supply_Datefrom ORDER_SUPP_

Hi,We are having an issue when printing customer invoices.Here are the steps:Go to customer invoice screen. RMB Header → Reprint Modified Select Invoice Original and click ok. ​​​For ouput: select send email and enter address. Click OK.When this is completed, it send the invoice to the email address that you entered. The subject of that email is “PDF file for invoice report for result key xxxxxx is ready.” with a pdf attachement of the invoice. It also fires off PDF_REPORT_CREATED and sends a copy of the invoice to the customer contact. Is there a way to stop PDF_REPORT_CREATED from firing? We just installed UPD9, I think this may be related to that. I don’t believe this was happening before. Thanks for your help,Mike  

Hi All, I frequently manually run Generate Inventory Part Availability Exceptions throughout the day. It typically took about 2 minutes to run the process as a background job. Recently we patched Oracle and the process has increased to 8+ minutes. Has anyone run into this issue and is there a fix or setting that we’ve overlooked? Any suggestions would be appreciated.

Hi There,I am using Attached  excel Data migration tool,After Copying data from Excel, unable to paste in IFS (no Option to paste). it was working fine before OS Upgradation on my DESKTOP. Can somebody help me out please. Warm Regards,Abid 

Hi,   Any have document about functionality enhancement from IFS 2004 to IFS 10.   Like which year released ,structure, layer architecture etc.IFS 2003--> IFS 2004→ IFS 7.5→ IFS 8 → IFS 9 → IFS 10

In Apps 10 - How can I define the ageing buckets in Customer Credit Analysis adn show these as the headers (rather than bucket 1, 2, 3 etc)

How to handle the following warning when you set account to “currency balance” = yes when this account already has postings:“Account xxx already has balances in internal/general ledger. Manual adjustement might be necessary in order to get the currency balances to correspond to the accounting /parallel currency balances. Do you want to continue?” How to make the required “manual adjustements” in order th have this account properly revaluated ? 

Hello,I created a new JAVA transformer in APPS8. When I try to compile it(without any changes), it throws an error saying some JAR files(Dependencies) are missing. As per E-Learning, I provided added below information in generated-pom.xml to download the dependencies JAR files but Developer studio says “Unknown host gbglcrd10 ”. Please let me know if the URL to download dependencies has been changed. If so, Does anyone know the new URL or how can I resolve this issue?     <repositories>        <repository>            <id>ifs-public</id>            <url>http://gbglcrd10:8082/nexus/content/repositories/public/</url>        </repository>    </repositories>    <pluginRepositories>        <pluginRepository>            <id>ifs-public</id>            <url>http://gbglcrd10:8082/nexus/content/repositories/public/</url>        </pluginRepository>   </pluginRepositories> Best Regards.

In Apps8 environment trying to run a report for an annual audit to show all financial transactions from Oct to Dec 2020. The report path is Operational Reporting > Order Report > General Ledger Report With Counter Account. Running the report is very slow, and November could not be run successfully even after waiting 3 hours with the process running in the backgrounds. There is another way to run an excel based download of all journals through the “GL Voucher Analysis” function. This returned 102,237 records which took about 4 hours to extract to excel, but  that excel file only has 100,000 rows of data implying some are missing due to output channels maximum no of row limitation. Can you advise the best , most efficient way to get these reports run for auditing?

Question, if you’re receiving customer schedule forecasts from Customers but they are for parts that are not Master Scheduled, where does that schedule go after releasing the schedule.  I see the Demand Line in Inventory Part Availability Planning with a status Planned.  But how do I clear that?  MRP is planning for this.  Typically when I import that into Master Scheduling, I no longer see the demand type of Customer Schedule Forecast, but for this case where I am not MS’ing this part, how do I clear that?

Hi,We would like to connect several NRC’s to one CAPA - do you know is that possible? We’re using 9.14.Thanks for your assistance. Miia

We recently upgraded from Apps 10 UPD4 to Apps 10 UPD7 and it seems like there was a change in behavior in the Create Project Wizard.  The “Copy Existing Project” box is now checked by default and we haven’t been able to figure out where to turn it off.  Does anyone know if this can be unchecked by default?  And if so, where?Thank you,Joann RMB in the left side of the navigator window or the bottom area of the window.  Select Create New Project  At the bottom of the the window 1/7 the Copy Existing Project box is checked by default 

What is the reason for the Print Queue in below status 

Hi, What’s the use of Internal Code Part Function? any example? Thanks!

in our company , we have IFS9, and crystal report XI;in registry what is the required to add the crystal report RPT file to the system ? 

On an Aurnea Custom page, I’m having an issue getting the selected reference field to display after it’s selected, saved and the browser is refreshed. This field is in a group, and after the user selects the desired entry from the lookup, it should display the entry as a link to another IFS page. However once I refresh the page, the link/displayed text disappears, but I can still click the blank field and it takes me to the other IFS page. I’m not sure why the field goes blank.Is there a way to get the text to remain on this field?lookup fieldAfter save Blank after browser is reloaded 

Hello All, I have setup and configured condition based PM Actions for my assets. However, I am still required to run the Condition Generation background job on a regular basis for my PMs to be created.I have been looking in the system to find a way to schedule this to simply run as a database task/scheduled job, but I have not found a way to do this. Any help would be greatly appreciated!

We currently have a quick report that has 12 monthly columns, one for each month: I’ve hard-coded each of the 12 months as noted below. Now they would like the months to dynamically start based on the selected Starting Date, so if they enter 5/1/2020 it’ll load the 12 months starting with June-JUN  JUL  AUG  SEPT  NOV  DEC  JAN  FEB  MAR  APR   MAYis that possible with quick report SQL?(the RW_FORECAST_BY_MONTH is an IAL that contains the extracted Month column and is ordered by Date; the quick report’s SQL groups it into the months)   

HiHow can i create a business rule to run when a request is created between 5pm and 7am.Is there is an expression i can use?For example something like request.created_dttm <17:00 + <07:00Thanks

Can anyone suggest how to capture Response in FSM from a external system/foreign system while doing outbound integration.In short i am trying to send outbound data  from FSM to ERP. when i send(FSM) purchase requisition they are(ERP) sending some responses but that response i am not able to capture in FSM. Please help me what are the settings or configuration i need to do to capture the responses.

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,

Within IFS it is possible to use #TODAY#, #END_OF_LAST_MONTH#, #PERSON_ID# etc in SQL statements.They can be used in searches and in lobbys. But I cannot use them in the PL/SQL developer connecting to the database. What are they?What should I use them for / not use them for?Is there a complete list of these somewhere?

We’re experiencing some difficulties with developing new functionality on mWorkOrder Windows revision.The new entity was added to resource library, which then was successfully deployed to TAS.We see the new entity in IFS IEE and the new entity’ table in local database on mobile as well.All the data was received in local database for new entity, too.Further, our new entity contains the Temporary Client Key.In our case, mobile framework successfully generated this key.But when we try to send the new data record for mentioned entity from mobile client to server we have the problem with “real” server-side key replacement on sync.We’ve got the failed transaction with error ORA-20124: Error.NULLVALUE.Maybe we’re doing something wrong?Or maybe we don’t complete some action in development process (for example, on server side)?

We have recently begun using Aurena, and we have an issue with a lobby not showing dataThese are 8 lobby elements in a course calendar lobby in Aurena, that show no data. But in the IEE there is plenty of data, as shown below. We are using IFS 10.8The elements are using sql data sourcesWhat could we be doing wrong?