Solved

HI all (this is IFS2003 - I know, I know...) I recall someone long ago creating a Saved query that could be shared amongst our users, that looked for (say) Approvals for that user. The dynamic code meant it could be passed around without need to change the Advanced query.For instance, instead of USERID  = ‘BLOGGSF’,I thought we could use USERID = (select Ifsapp.fnd_session_api.get_fnd_user()from dual)but this generates the error “fnd_session_api is not a procedure or is undefined”How can I get this to work, or is there an alternative?Would be good to do this for PersonId too.  Thanks

Hi, We have a customer in Mexico and want to update UUID through Web Service. To update UUID in Manual Customer Invoice, did IFS Provide Standard Web Service to update UUID.  Regards, Kishore Nenwani

Hi using apps 10 and trying to set up auto reserve and issue of shop order material and have come across a material availability issue below. I have set the Reserve/ issue form location on the part structure and check to see there is available stock on hand but when i go to auto reserve the material I'm presented with the below error message. but when i check the available inventory on Inventory part in stock is shows 144L of part 116767 available in location 18694 which is Picking type. Why is the reserve and backflush visualization showing 0 available ?regardsJamie

Hello,problem with IFS 9  we want to trigger a label printout via event. We have created an event that only works when the label template is .rdl If the template is .rpl, it fails with an error : PluginExecute Failed . null   if we manually print a label (.rpl template) from the report archive, it works - does not only work for the PL SQL event my event:  DECLARE   report_id_           VARCHAR2(200) := 'INV_LABEL_REP'; --wskazanie raportu   report_attr_         VARCHAR2(2000);   parameter_attr_      VARCHAR2(2000);   message_attr_        VARCHAR2(2000);   archiving_attr_      VARCHAR2(2000);   msg_                 VARCHAR2(32000);   pallet_id_           VARCHAR2(32000):='1597';    layout_name_         VARCHAR2(32000):='test.rpl';    l_plsql_ VARCHAR2(32000);   parameter_attr_ VARCHAR2(32000);   a1_ VARCHAR2(1) := Chr(39);   BEGIN l_plsql_ :='DECLAREreport_id_ VARCHAR2(2000 ):= '':REPORT_ID___'';parameter_attr_ VARCHAR2(32000) := '':PARAMETER_ATTR___'';report_attr_ VARCHAR2(32000);tmp_a

FIFO is the recommended Inventory part Valuation Method for our organizational users by the Finance Department. However, we noticed that some of the part creators in IFS in the past have incorrectly created parts with Standard Cost with ‘Cost Per Part’  at Cost Level. There are already transactions in IFS with this incorrect valuation method. (There are couple of Parts with ‘Cost Per Lot Batch’ at Cost level as well) .  Now I need to change those parts’ Inventory valuation Method back to FIFO. What type of impact will it have if I change them directly in the Inventory Part window? (Plan is to have FIFO with ‘Cost Per Part’ for the majority of the parts and Weighted Average with ‘Cost Per Lot Batch’ for the rest)  One of the special scenarios we use is that we receive via ‘Receive Inventory Part’ the project leftover quantities (since they were previously paid by the project) at zero cost which reduces the inventory unit cost overall. But when we issue the same parts I guess the unit co

We are using the Service Quotation functionality. We are updating costs via the Operations and Other Demands tabs (within the Work Order tab).When performing updates which change the Cost or Selling price of a quotation, the ‘Calculation Required’ field should become ticked to indicate that the user should perform a RMB ‘Calculate Total Cost and Quoted Price’. However, there are certain actions that do not tick this box, even though the actions themselves will have an effect on the Cost and Selling price. I have noted below the instances of where this box does/doesn’t tick. The end result is that users can potentially proceed with a quote, without the totals in the ‘Quotation Totals’ tab being accurate. Does Tick Creating new line in Operations tab Deleting line in Operations tab Changing Sales Part in Operations tab Creating new line in Other Demands tab Deleting line in Other Demands  tab Changing the Cost field in Other Demands  tab  Doesn't Tick Changing Planned Hours in Operations

Hi,Custom field is not getting refreshed, Please see the date in the image below.What could be the reason?Thanks in advance  

“Receive” Dialog in Register Arrivals​​​​​Dear Community, I am trying to modify the “Receive” Dialog in Register Arrivals page using Aurena Page designer in Apps 10 Update 11.I have found the following article in the community , but unfortunately I am unable to access said dialog with the answer given there. Is this a bug or does anybody else have any additional ideas?

Dear all ,It is not allowed to use manufactured part to move within locations using transport task.  Do you have any views on this ?   Thanks in advance.

How to setup Single sign on with Azure , can anyone share document or steps to do it. 

I have developed a crytal report and i calling that using custom menu in Apps 9. i have included two BLOB columns to display the images of terms and condition in Purchase order document print. I am getting error  Memory full or Overflow error while rendering this image.

We have a new user in Service and Maintenance and when they go into Service and Maintenance > Work Management > Execution > My Work the Work Assignment Information nodes are missing….Please see below: Any ideas.

almighty community, anyone has experience using below option in Site MRP Calculation? we would like to know what system is trying to do if have this option on? also, any documentation in IFS regarding this option? Thank you.

Hi,I tried to create a custom field, in PLSQL developer value is getting correctly. But when I deploy the same in custom field, value is coming incorrectly. What could be the possible reason, Please help.Code- in back endSELECT c.order_no,c.BUY_QTY_DUE SalesQty,c.QTY_ASSIGNED ReservedQty, CASE WHEN c.QTY_ASSIGNED/*Reserved Qty*/ >= c.BUY_QTY_DUE/*Sales Qty*/ THEN 'Fully Reserved'WHEN c.QTY_ASSIGNED IN (NULL,0) THEN 'Released'WHEN c.QTY_ASSIGNED < c.BUY_QTY_DUE THEN 'partially Reserved'  END Status  FROM CUSTOMER_ORDER_LINE c,CUSTOMER_ORDER dWHERE c.order_no= '&order_no' AND c.order_no=d.order_noCorrect result for status in plsql developerCode- in custom field- (Read only field)SELECT CASE WHEN c.QTY_ASSIGNED >= c.BUY_QTY_DUETHEN 'Fully Reserved'WHEN c.QTY_ASSIGNED IN (NULL,0) THEN 'Released'WHEN c.QTY_ASSIGNED < c.BUY_QTY_DUE THEN 'partially Reserved'  END Status  FROM CUSTOMER_ORDER_LINE c,CUSTOMER_ORDER dWHERE c.order_no= :order_noAND c.order_no=d.order_noResulthere t

Hi all, We would like to connect documents to mixed payments in IFS, but when I look to “Document Basic: Object Types for Access Control” and I go to Object Type MixedPayments, then I don’t see “Get_Document_Access” available as method. Is that correct, or do I miss something here? thank you!Kurt

Hi,We are in the process of upgrading from Apps 7.5 to 10 and all the standard reports in Apps 10 are displaying the Standard IFS BW logo, post upgrade:How can we replace IFS logo with our custom logo?I uderstand this logo file IFSlogbw.gif is under D:\IFS\<instance>\repository\server\reports\stdlogo folder.We tried replacing but the new logo isn’t getting picked up, which may be due to the fact that the logo file resides in a database table - report_logos_tabQuestion - Do we need to replace the IFSlogbw.gif file with our custom logo and perform a reconfiguration to deploy the new file into the DB?Is this the right approach?Note: We dont have access to Report Designer and only looking for the custom logo to show up in Operational Reports instead of IFS logo.TIA!

In Apps 10 UPD 10, we use Create Consolidated Pick List for Shipment. it is grouped by Warehouse.  I see nothing in the app or in IFS documentation that would let us sort the picklist by part number or anything like that. If we can sort that way, it will assist the picker to see all of the same part together, especially relevant for large multi order shipments.  Am I just missing it? What order is a pick list sorted by, by default? it does not appear to be by location or by order # or by part #.Thanks

Hi,Kindly we are in need in SCM to have access permission at warehouse level within site, we have a branch which it is a site , the branch has 2 warehouses, how we control the access permissions per user per warehouse or location. I s there any way or workaround in IFS10 to have it.Thanks.

Hi,I would like to know if it’s possible to generate automatic transport task from Warehouse Navigator on IFS 9 ?We have 2 remote warehouse :Site A Remote warehouse 1 Remote warehouse 2I would like parts in warehouse 2 to be refiiled from warehouse 1.I went to Warehouse Navigator and saw there is two ways to refill our parts ( Stock or Buy).Refill as Buy is working well → generate PO But when we put Stock nothing happens → I would like Stock create a transport task, is it possible ? Maybe it’s not the right way to do it, if you have any solution I am open to suggestions  . 

Is there a way to invoice a Service Contract in IFS Apps 10, Upd 10 without going through a Customer order / Invoice?

Hi All, How to delete/ un-deploy a custom field in IFS 10? Thanks and regards,Hari  

I am trying to see if there is an easy way to copy a migration job to be able to import that job into another instance of IFS for testing etc.  Anyone….?

During the installation of our UPD8 delivery in the APPS10 DEV environment, the installer completed, but reported database errors. Where are these logs located (eg. server & folders locations)?

Hello, I am noticing a significantly slow performance and the application gets stuck when I browse through the Absences window in IFSAPP10. How am I to fix this problem?Best,Eka

Hi,  In EE we use this option to export EE navigator, passing by Permission Set   Is there the same option in Aurena, I need to export all content of aurena navigator in order to create access matrix.Thank you in advance Ouahiba