Solved

Dear Code experts, Currently we have granted all sites access to our spare part users in order to see the available stock in each site.  I have a requirement from business that this authorization must be controlled as below; we have to divide all stock Clerk into 2 groups;Group 1 : they can only maintain their default site’s inventory Group 2 : They can maintain their default site’s inventory + other sites inventory    In order to achieve this,  I created a custom event on Inventory_part_in_stock_tab,below is the code and it works for group 1. but for group 2 event doesn’t allowed to do transaction.I am not a developer so Am I missing something in below code ?    DECLAREDEF_ VARCHAR2(10);MULTI_ VARCHAR2(100);CURSOR C_ALLOW_multi_  IS SELECT CONTRACT  from USER_ALLOWED_SITE_CFV where userid = '&FND_USER' AND CF$_ALLOW_MULTI_SITE_DB = 'Y';BEGINOPEN  C_ALLOW_multi_;FETCH  C_ALLOW_multi_ INTO MULTI_;CLOSE  C_ALLOW_multi_;IF ( '&NEW:CONTRACT' <> '&DEF_USER' ) OR ( '&NE

Hi, I don't fully understand the date logic in the time-phased supply proposals created by IFS for an end-item (in an engineer-to-order setting). Can you outline the key types of dates (or 'offsetting inputs') that figure within scheduling. From specifying when the user desires said item, to all the subsequent dates that are generated after BoM explosion. The 'tools' at are disposal are IFS Apps 10, namely, MRP that executes 'Infinite Scheduler' and 'APB' (our method to CBS schedule items to reflect 'live' capacity constraints such as the current load at a given work centre). I'll provide a brief description of our current practice and raise questions alongside that. If there's any misuse, do say so. Overview: A 'Required Date' is specified when demand is created, used to say when project 'X' is desired. Does this input need to be constrained by a lead time, whether plausible or not? For instance, can you specify the Required Date for X as 1/1/15? I'm not asking whether the system has

Scheduled process not running ?We have configured the scheduled process in a new environment. But the scheduled process is not running . The same schedule process in running in other environments.Kindly need your support to resolve the issue. 

Working with the existing LU EngPartRevision, we added some custom fields to extend the LU in a centralized testing environment.  After standing up a new development environment, we created the custom fields by exporting an Application Configuration Package (ACP) and importing it into the new environment.  The fields validated and imported into an Approved state.  When I attempt to publish and synchronize the custom fields, I receive the error “COMPILE_ERROR2:  Error during compilation of LU [EngPartRevision]” that looks like it is related to extended the custom view (CFV).    

Hello, Is it possible to have a template PO with lines that can be used to create PO’s? We are wanting to do this for the ordering of stationary, cleaning products etc. The template can then be brought up, easily change the qty required and send to the supplier.Thanks Sarah

We are having issues with users trying to change their password. We in Apps 10 and we were asked by IFS to navigate to the database object “Change_Password_Dbip_” and grant that to our base functionality permission set. When I go there and try and grant it I RMB and there is no option to grant this. Does anyone know why this is happening?  

Is there a way in Apps8 to create one customer order from different sales quotations  ?

Hi, I’m testing the oData REST API to download/upload attachments in FSM, but I’m facing some issues.I can get the attahcment info (but the “attachment@data.mediaReadLink” attribute). However I don’t get anything, while trying to retrieve the binary data (prints attached) Additionally, I’m not able to change the stored flag for manually added attachments. Thank you,João Oliveira 

There is a separate screen called Shipment Grouping Rules.Can anyone tell me where to use this Shipment Grouping Rules once we create a new Shipment Grouping Rule?

Dear All,     Could we add some columns in Default LOV in IFS 10 like   In purchase order have Supplier column and data comes from LOV ( IFS LOV).   I want to add column in this LOV.  Is this possible , If Yes, then how can add columns.   Kindly assist us. Thanks in advance.

If purchase requisition of one item abut 50 quantities.After the authorization, I create a request for order quotation. In which I want to split 50 quantities in to two parts.If I change the quantity in the request for order quotation window and isert 25 quantity and remaining25 quantity in other new line inserted by me in order equation window. then It will ok.but in back end new line create by me in order quotation window have no purchase requisition number.Please guide me perfect way of order spliting.

I am trying to insert the history row to customer order while inserting the date is converting wrong. I tried many ways but still the same. How should I write? SELECT client_sys.attr_value_to_date(to_date(SYSDATE)) FROM dualSELECT client_sys.attr_value_to_date(to_date(SYSDATE, 'dd/mm/yy HH:MI:SS')) FROM dual   

Maybe a simple question, I want to transfer a database task from our test environment to the production environment. An export file (.ins) has been created.Should this be deployed via PL SQL and if so with which command?This is the 1st time I have to do this.  

I would like to complete this RMA, but am unable to.The 1st line allows receipt, but the second line says ‘0’ - I have tried to receive that into stock but the RMA pop up just resets the value to spaces and am unable to change the status - any thoughts?? Any thoughts how I can complete/close this RMA?

full context: were looking at giving the users the ability to create a request from the place screen.This would either be by clicking a button that redirects them to the request screen or having a tab on the lower pane that will have the new request related fields. My question is, how can i auto-populate the “Place ID” on the Request, to that of the Place record they’re currently displaying? I wouldn't think a business rule would do this so perhaps a new button with a xml message in it? Not sure what that would look like to reference to the current place record but hoping i can be helped here.

How do I reverse a supplier offset that has been processed in a previous period?

I cannot seem to create a PM that automatically generates a work order based on dates.  Can you assist?

How can I disable the following options on the Inventory Part In Stock search window: Show All FieldsAdvanced Configure   Thanking  you.

Am seeing the following error in the DB alert log when the event fires. -4091: ORA-04091: table IFSAPP.FNDCN_APPLICATION_MESSAGE_TAB is mutating, trigger/function may not see itORA-04091: table IFSAPP.FNDCN_APPLICATION_MESSAGE_TAB is mutating, trigger/function may not see itI have seen people getting around this with an autonomous pragma - but cant insert as am not executing an SQL block but sending an email. Any ideas? 

Hi Is there a way of adding additional information to Application Defined Events?  For instance, could we call an API to retrieve data to be included in the body of the email that is sent. An example scenario, is the Approval Routing events which send emails when approval routing step is approved. The application defined event uses basic information but the business wants the Document title to be displayed instead of Doc No and the Document class description instead of Doc No. We are using Apps 8. Please provide guidance and suggestions how to implement this. Regards Shaun

We will be able to report reverse tax on our supplier invoices. We have created a separate Tax Code for that. Since we need to report both Tax Disbursed and Tax Received I suppose this will be calculated tax.There will not be any tax on the invoice (net amount) but we need to add that on two tax-accounts (disbursed and received) when we post the invoice. Off-course we want this to be an automatic posting on the voucher. Which Posting Control will we need to configure? For example: Supplier InvoicePrice: 1000Reverse Tax is demanded We would like the voucher to look like this:Account 4010: 1000Account: 2617: -250Account: 2647: 250  

Is it possible to add text to the service report (Work Report) in the Mobile Work Order touch app? Is it possible to add my company logo?

Hi ALL,Does the function ‘Change Global Company’ exist in AURENA ?Thanks   

hello,we have an error when trying to authenticate users through Azure AD.Directory ID of user is UserPrincipalName (sync through LDAP)See attached error file. In french it says: object reference is not defined to an instance of an object.thanks a lot

I have problem installing IFS 10 on Remote Desktop on Windows Server 2016. After installation, I have the error below when logging in to IFS