Solved

Is there documentation on APPS9 performance tuning?Specifically when it comes to optimizing database tasks & db tuning?Any documents on best practices?Our IFS env are VMs running Windows 2012 server R2. We are running Oracle 12.1 with 3 prod db instances on the same server. We are considering an oracle upgrade to 19, but first I need to apply IFS UD17, although UD16 is only required,I felt I may as well update to the latest version. Anyone have any bad experiences with UD17? I had several issues with UD14 applying and ended up with a fresh build from IFS.With the recent lag in performance, I have reservations regarding applying updates.Much appreciate the feedback.

Hi,I know its so simple question but i am missing something idk. I want to open logs for FND_CLIENT_LOGON_TAB, so i found logical unit instead of the table at history page, but when i tried to click link, nothing happened.FND_CLIENT_LOGON_TAB look like deleted from the database i am not sure.Can you tell me how can i open the FND_CLIENT_LOGON_TAB hist logs, step by step?I wonder the root cause of the problem btw, is it about APP v10?Best regards. 

Hi all,How do I copy an Aurena Page. Or In this case override context ‘global’ with ‘hja’? 

Hello,Within PSO and the Schedule Assistance function, is there anyway to view the information on a map from within that screen?Looking at the data below, I can see a specific resource has space in the afternoon, but I would like to visually see his location, and then location of the activities being offered in the bottom section.I don’t think this is possible in the ‘Mapping’ screen, as I cannot get the activities filtered to only show certain types. Just wondering if anyone uses this and is able to plot data onto a map? RegardsAdy

Can someone please explain the usage of Audit and Extract feature available in FSM with any available document and Real case scenarios.A quick response is appreciated.

Hi Community,While updating multiple records using insert SQL command to the tab level, We are not able to generate multiple sequence(design_id ) which is the primary key and getting below error.  Can anyone suggest what is the best way we can generate sequence for multiple records through SQL command.  Thanks,Ramya

Hi all,We use the “Inventory Part Original Tracing” window in IEE when we need to trace customer order components back to the suppliers. But if the CO is an Invent order it does not show up. Customer order line: I was expected to find it here, but it is not (I know It originate from 115181):Anyone know why is it not there and how we then trace invent CO?

Hi, Anybody know where you can find back the supplier bank account a supplier payment was paid to?With payment method and payment address id I can go and check on supplier payment details but this could have changed in the meantime so would like to find the account used when payment was made (account included in payment file). Thanks,/Anna

On the Time Search Screen, the calendar lookups for Work Date field are not in the baseline screen, so the customer wanted to add them in UI designer. The option for the calendar lookup is not available. Would this be an enhancement request? 

Hi,Is there any functionality within Aurena, similar to IEE ‘Send to colleague’? If not, is there any plans to implement something similar? Our customer is in Apps10 UPD9 and have requested UPD10 and they were wondering :-)Thank you in advance.Best Regards,Dinesha Velivitiya

Anyone know how to change or edit the Email message format before send out ? Thank you so much in advance 

Hi all,I have made a custom menu on a custom page. But the menu is not showing.It is working fine on Apps10.We are on Apps9 upg6. Do you have to do something special or was there a bug?

We have a custom field ‘Salesman’ in IEE that we would like to use as a search field on the Business Opportunity.  I have tried to add this using the page designer but I am not having any luck on how to add it to this list to be chosen as a Search field.  Any guidance would be greatly appreciated.  

Hello,We are converting Database Processes to Scheduled database Tasks, IFS8.I have few tasks that checks batch log and send emails accordingly, when i created in schedule database tasks, its sending same info again and again… how do i check the logs in Database Tasks or in Background Jobs , if any to accomplish this task. the query to modify is following, or any other way to achieve same resultSELECT lag(actual_start_date,1) over (order by actual_start_date) last_date   FROM batch_job bj, batch_job_log bjl   WHERE action = 'Temporay_API.Generate_Report'   and bj.job_id = bjl.job_id   and bjl.status = 'SUCCEEDED'   order by actual_start_date desc; Thanks. 

Hi,I am trying to configure the new .NET based Print Agent and the Connection Status is showing Disconnected.Here are the steps I followed:Unzipped latest Print Agent 64-bit install files from the Middleware directory Ran IFSPrintAgent.exe to launch the Console RMB on the Tray Item to Configure the connection Upon prompt, updated IFSPRINT user password and saved the changes Updated Id to Instance ID and Server Name (neither seem to be working) RMB on the Tray Item to Monitor the connection and it shows Disconnected.ConfigureMonitorQuestions:Is there any missing setup to get the PA to work? What goes in the ID field - Server (host) name or IFS Instance ID? What else can I do to troubleshoot why the PA isn’t connecting?TIA, Sri

We just updated our TST environment to Update 9 of Apps 10.  In doing some testing, we noticed the Characteristics tab on the Inventory Part screen is no longer available, but the Inventory Part Characteristics screen and the Find Inventory Part by Characteristics Assistant is still available.  Wondering if anyone else has seen this when updating?

Hello, i need help.  We start logging from SSO. Currently, we can log in via AD to IFS by entering credentials, e.g. user @ local and password. When we run SSO, we get error 400 when logging in. Attached is a screenshot with the error. Where to look for the cause?

We have some high value Service Orders with some of our biggest customers where the payment terms include paying 30% on order acceptance and the remaining 70% when the work is completed.Is there a way to part invoice in this way? Thanks, we are using V14.5

HI  As of know that in IEE , we can login multiple user into ifs iee in same browser.  Any option in Aurena that we can login multiple users in browser.I am using Aurena upd8.

I have a customer that has a customer agreement for a part in Apps10:  Part Min QTY Price 1 0 200 1 5 100 1 10 50  If a customer order is placed with three line items each with seperate Wanted Delivery Dates or Addresses with a quantity of 10 shouldn’t the system give them the $50 price?  Customer Order Lines: Part QTY Date 1 5 2/1/2021 1 5 3/1/2021  Right now the system is giving each line item the 100 price instead of the 50 price. 

Is it possible to have an expected payment date anywhere when analysing aged debt? for example we might show £xm as overdue today but we know from customers payment runs that won’t receive payment until 5 days later?

Does anyone know a way to create many new sites in of IFS at once or to quickly create/copy sites?We need this for a legal entity reorganization project. It will take several months of work to set up 88 sites if we do this manually, one at a time. 

I want to automatically print a label whenever an Arrival Report gets printed.  I have the labeled setup to use the same ARRIVAL_REPORT_REP view but I dont know the best method to link the two.  Is it through a plsql event or a report rule?  I dont know how to pass the result key from the Arrival Report to my label report to automatically print label.  Also for some reason when I independently print the label I setup as an operational report through IFS the barcode will not print.  But the barcode with print as a Quick report.   Any help would be greatly appreciated.

Hi all, On IFS10, we are trying to load PAIN002 message (response from Bank on Payments made), however we are getting the error “No API to call...”When we check the standard File Template (PaymentStatusFile), there is no API configured. Who knows where we go wrong?

How do i update GL, is this done automatically or can you force update it?I’m getting a fault: ="There is at least one project transaction that is posted and which has not been transferred to financials."when trying to close a project in and getting an error about unfinished work, i run the “generate unfinished work items” and get this line :)