Solved

Hi community,Could you please explain how Trigger Type in Control Plan - Manufacturing (Sample Frequency tab) work, How to use it? and Is it possible to add or manage Trigger Type?Thank you in advance.  

i am trying to install the test server from the original build, installation is done properly but when i am trying to log in using app owner i am getting Operation time out error. What will be the issue. We are using apps 9.

Hello,Does anyone know if it is possible to configure the row height to fit more rows on the screen? 

I would like to specific destination email that relate with customer of each customer order.For exampleI created the event action and it’s work already. and would like to specific the receiver.I would like to specific “To” (Email receiver) to below delivery address that is registered email. (No.3)  The registered email is in below picture.  

Can someone please tell me how can I enable this media attachment option in another window?Example: This is now available in NCR window. I want make it visible in PO window.  Where will these media files be saved in the application? Is it in the same DocMan repository or somewhere else? Thanks in advanceNimesh

On the Purchase order Change order - What is the filter condition behind “Show Only New/Changed Lines”  

I am using Apps 10 and there is a view called “Employee” that when I select everything from it in Oracle it does not return a lot of Employees that are in IFS. Some users who are visible  in all the relevant screens in IFS are not returned when I select from this view.I cant find any logical unit that is linked to this view. I need to know what screen in IFS is linked to this view so I can see why these users are not displaying in the select statement.Hopefully someone can help.

Hi,On the pers_related view there is a column called Related_id, does anyone know if this field should be incremental or not as I am unable to work out the logic.Thank you.Nikki

We have noticed in Aurena that currency format does not come through in aurena. It shows up as just a raw # with no , deliminators. Is this on the roadmap to address? This is an issue for us as we look at Currency Based data it’s very hard to understand what the values we are entering are.Thanks,Carrie

Hi everybodyIs there any way to see which view has which permission sets?(like object security report) I want to see all of them. Is there any quick way Thank you  

Hi,We’re trying to upload attachments to IFS using oData.‘We’ve tried mimicing the Aurena behavior found when inspecting the page and sniffing the HTTP traffic. Projection: DocumentHome.svcCreateAndConnect work fine but can’t send the file data.The FileData steps just returns an HTTP 500 , internal server error. A second approach we’ve tried is through the CreateAndImportDocument Projection.I’ve tried all kinds of formating for the FileData property but won’t accept any of it. Below is a Base64 encoded binary string. Since documentation is almost non existing I’m a bit stuck. Has anyone managed to use oData for attachment upload and can provide som working examples? Would be much apricated ! thx!

Does anyone know if a document attachment in IFS can be added to a report or automated email?  Here is our situation, but the applications are many.  We have approval drawings attached to parts in IFS.  If the part is entered on a Business Opportunity or Customer Order, we want that approval drawing as part of the Quotation Document generated by the Business Op or the Order Acknowledgement. btw - we are on Apps 10.

Hi expert,I create the report layout by EXCEL layout but print dialog can’t preview.Please suggest me how to fix this problem.on APPS10 it working fine.This is my  plugin-class ifs.application.reportingservices.impl.extendedformatter.excelplugin.ExcelPlugin     

I created a Persistent Text custom field with the Clickable Hyperlink attribute checked. I then set the field to be visible on the page in IEE. After putting a URL in the field the text displays blue with a line under it and ctrl + clicking will launch the browser and navigate to the URL. This is the behavior I would like to see in Aurena as well. In Aurena when I add the field to the page the URL displays as text without looking like a link. Is there a way to make it look and act like a clickable hyperlink?

What is the quickest way to make specific columns read-only for all users. User Profiles?

We have quick report that takes excessively long to execute and return results. Any ideas on increasing performance?There’s only 5 rows in the result set (see below).select pm.Part_Main_Group as Trademark,l1p.contract,l1p.part_no,ip.description,l1f.ms_set as MS_Set,trunc(l1f.ms_date) as Forecast_Date,extract( MONTH from to_date(l1f.ms_date)) as Month,to_char(l1f.ms_date,'yyyymm') as YearMonth,l1f.forecast_lev0 as Forecast_Qty,NVL((select sum(rega1app.Customer_Order_API.Get_Ord_Gross_Amount(ORDER_NO))from rega1app.customer_info_cfv cicleft join rega1app.cust_ord_invo_stat col on l1p.contract = col.contract and l1p.part_no = col.part_no and cic.customer_id = col.customer_no and ( extract( YEAR from to_date(col.invoice_date)) = extract( YEAR from to_date(l1f.ms_date)) ) and ( extract( MONTH from to_date(col.invoice_date)) = extract( MONTH from to_date(l1f.ms_date)) ) where ( l1p.contract = 'W' and l1f.ms_set = cic.cf$_ms_set or l1p.

We upgraded to Apps 10 last October.  I have a user using sticky notes on Time Card Day.  Now in 10 the note will appear and you can type in it, etc…, but when you leave the page the note is gone.  I do not believe it is a permissions isssue as she can use the notes on other screens and the same thing happens when I am logged in as App Owner.  Any one else run into this?

Hello, I am looking for a way to determine what user created an Inventory Part. There doesn’t appear to be a history tab or any obvious field where this information is captured. I believe I could turn on History Logging and set the PART_NO field to record all inserts, but I’m hoping there is an easier way in the system to tell which user created any IP. Any help would be greatly appreciated. Thank you.

When I prepare an Inventory Control Plan, I have to enter a site. Once done I want to activate it. System comes back with error message that I have to set existing control plan to InactiveCurrently it looks like the above. Notice the fact that there is no Site/Contract in the selection list.Opening the active Control Plan shows:The one that I want to set active looks like:So part is the same. The site however is different.My logic tells me that The control plans differ, however IFS tells me, via the error message, that control plans are cross site to be set up. Why is the site there and what usage is the site if I can’t  activate it per site.Regards,Steve

Hi,Which Presentation Objects need to be granted to grant access to CRM Panel or Outlook Add-in in APPS 10?We are able to access everything as IFSAPP user but things don’t work for regular users who have been granted IFS_FULL permission set (gives access to all screens in IFS).We ensured the following objects have been checked for IFS_FULL: Thanks!

Could someone explain to me the difference in the values found in the various Part Cost Bucket tables? part_cost_bucket_tab part_cost_bucket_one_tab part_cost_bucket_history_tabI am attempting to construct a Bill of Materials for a data warehouse, and these three tables seem to carry slightly different values.  For the purposes of demand calculations in the data warehouse, I need to be able to leverage a Bill of Materials as of any point in time, so I was hopeful that the history table would include everything I need -- but there are some examples of Part associations in the other two tables not available there.I could perform a simple union of these tables in my SQL query in order to handle for any missing data -- but that feels like a weak solution that could generate more confusion than it alleviates.Any guidance others could provide me on the nuances between these tables would be greatly appreciated.  Thanks!

We have a report rule that emails invoices to customers.  I want to include a web address that includes the invoice number and invoice amount.  An example below where CD1234 is the invoice number and 200 is the invoice amount.  I am using variables for these values.  My problem is when I try to build the below string the = and & characters are a problem.   It does not include anything after a = or & character.  I have tried wrapping it with single and double quotes with no luck.  Any suggestions?  https://www.xxx.com/invoice/?invoice_number=CD1234&amount=200App8sp1+

Hello, Has anyone created new entity with sequence in IFS Developer Studio ? I want to create sequence for keys of my table.I could create index and sequences in PLSQL Developer but i guess it is made in .storage file in Developer Studio.How can I create .storage file of the entity to define INDEX or SEQUENCE ?  Or maybe i need another way to define them. Could anyone please help ? Thanks & Best Regards

Hi,We’ve installed FSM 5.7 and 6.7 on the same server. We’ve noticed that the report viewer is used to display reports in the 5.7 version. In the 6.7 version, some of the reports are getting errors when we try to print them, and no reports are linked to the report viewer. Do you know how to setup the reports in 6.7 to use the FSM report viewer? Example when trying to print the standard OOTB (out of the box) “Pick List” report:We get no errors in the 5.7 versionBut in the version 6.7 it tries to open the “yourreporterserver” web page.The app params between 5.7 and 6.7 are the same.CLIENT_REPORTS_PATH = http://macroifs.macrointegrations.com/MacroFSM/ClientReports/CustomReports;http://macroifs.macrointegrations.com/MacroFSM/ClientReports/BaselineReportsENABLE_CLIENT_REPORTS = YREPORT_ROW_COUNT_THRESHOLD = 1000REPORT_SERVER_URI_CRYSTAL = http://YourCrystalReportServer/CrystalViewer.aspx?%2fcrystalReportsPath=path to crystal report file\REPORT_SERVER_URI_SSRS = http://YourReportServer/YourR

I am trying to add a history record via events to customer orders when a variable area changes. But the date which I send as a sysdate is inserting wrong. I tried to format the date but it did not work. What is the correct format? Wrong Date​​