Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

As I create custom fields, I would like the column header text to word wrap to preserve page width. I see that IFS does this natively for some of the column headers. Is there a character I can place in the column prompt that will word wrap to two lines?

I have created a custom page with different tabs and View Page option shows data correctly.Then I added this page to navigator using Navigator Configuration, saved and published. But when viewing the page from the navigator, it gives an error. How can I fix this?Thank you. 

Rather than using the Forward option or manually selecting report distribution group when ordering a report, is there any way of automatically making a report available to pre-defined distribution groups? (Something similar to user access control in Doc Mgt perhaps)

I have been asked to display an information message to give a reminder to users where there are attached documents. The user will be in Shipment Lines and will RMB on a Shipment Line and open the associated Shipment.  When the Shipment opens, if there are attached documents an Information Message is required to be displayed as a gentle prompt to users. As there is not a trigger at this point, how do I go about firing the custom event? At the moment the custom event is as follows: Custom Attributes:Name:    ATTACHED_DOC_NO Server Method PL/SQL: IFSAPP.Doc_Reference_Object_API.Get_Object_Connection_Count__('Shipment','SHIPMENT_ID='||'&OLD:SHIPMENT_ID'||'^')Data Type: Number Conditions for performing action:ATTACHED_DOC_NO > 0 Action Details:BEGIN     Client_SYS.Add_Info('Shipment', 'ATTACHED_DOCUMENT:  This Shipment has Attached Documents.');END;  Thanks.

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.

Hi,I would like to share some useful SQL codes of mine. You can share yours in the comments.  Remove DECLARE info_ VARCHAR2(2000);BEGIN ifsapp.language_sys.set_language('en'); FOR rec_ IN (SELECT * FROM /*Table*/ p /*WHERE p.*/) LOOP ifsapp./*Api*/.remove__(info_, rec_.objid, rec_.objversion, 'DO'); END LOOP;END;New DECLARE info_ VARCHAR2(32000) := NULL; objid_ VARCHAR2(32000) := NULL; objversion_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000) := '';BEGIN ifsapp.language_sys.set_language('en'); FOR rec IN (SELECT * FROM /*Table*/ t /*where*/) LOOP BEGIN attr_ := 'ORDER_NO' || chr(31) || rec.order_no || chr(30); --Fill the attr ifsapp./*Api*/.new__(info_, objid_, objversion_, attr_, 'DO'); END; END LOOP;END;ModifyDECLARE order_no_ VARCHAR2(32000) := 'I1510'; line_no_ VARCHAR2(32000) := '1'; rel_no_ VARCHAR2(32000) := '1'; line_item_no_ VARCHAR2(32000) := '0'; ne

I have simple migration job on customs_statistics_number view. Simply insert and modify three fields of this view. When I ran the job it inserts all fields to table successfully. However when existing row is updated, the migration job do not update Description field. This seems very weird as insert works but update of this particular field does not happens. All other fields are updated without any problems. Has anyone experience this issue in apps 9 before I raise this as a bug with IFS?  

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   

I would like to be able to embed a map or video in a Lobby Web Element.  At the moment I can load a page but it loads the entire page which is very cumbersome in a lobby element.  It would be great to be able to just load the embed codes that you get from video hosting or map sites.  

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.  

We are looking to out source &  integrate our AP & AR functions with a third party like SAP/Concur.  I would be interested to know if any other IFS customers have done this.  If so, who did you use as your provider, what kind of experience did you have and how hard was it to integrate the communication with IFS.  Did you use FTP? Import & exporting of data?  Integration with some type of Web Services?  Any insight would be greatly appreciated. Thanks,Mark

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,I am Creating Custom Field in IFS8, I have Complete Wizard and Approve , Published and Synchronized.but it’s Raise Error :Illegal SQL rejected: ifs.fnd.services.plsqlserver.service.security.RejectedSqlException: Illegal column CF$_MACHINE_NAME Please help me.ThanksShekhar

We are new on Apps10 update 7 as of Nov. 30th.  I have received complaints from the shop floor production areas and QA that people are receiving this error in various screens and they are immediately kicked out.  We have noticed this in creating an MRB case from a shop order and then others have said simply using the shop floor workbench.  I noticed another post stating it might be tied to the IFS Time Clock, which we do use also. Our DBA thought it was related to our security checkpoint setups but none of the screens where this occurred have security checkpoint enabled.  Has anyone else experienced this? Could this be related to our idle timeout value?  I’m wondering what it’s trying to re-authenticate.

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

Hi,I wanted to pass parameter value in continuation with Message_Sys.Add_Atribute method in dialogboxMessage_Sys.Add_Attribute(Valriable_, Name_, Value_);then it’s contain value like ‘$VARIABLE=VALUE’ but i wanted to like ‘-$VARIBALE=VALUE’‘-$’ this symbol indicate value with continuation and i wanted it.  c_ VARCHAR2(32000) := '!OBJ_VAL_CHANGE$B=!-$COMPANY=COM01-$OBJECT_ID=XYZ-$BOOK_ID=ABC-$EVENT_DATE=2015-03-31-00.00.00-$RETROACT_DATE=2015-03-31-00.00.00-$VOUCHER_DATE=2020-03-31-00.00.00-$VOUCHER_TYPE=A-$USER_GROUP=AC-$VALUE=-6000.00-$IS_AMOUNT=TRUE-$OBJECT_TRANSACTION_TYPE=11-$USER_ID=IFSAPP-$METHOD_ID=LMP-X10-$TRANSACTION_REASON=DEFAULT-'; --p2 ThanksShekhar 

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

Hello, i had a talk today with IFS stuff and got the information, that for creating “external supplier invoices - with load information” one should RECEIVE_SUPPLIER_INVOICE, as it is a financial module and RECEIVE_SUPPLIER_INVOICE was called a part of logistics. Can anyone confirm or deny if the RECEIVE_SUPPLIER_INVOICE is capable of creating “external supplier invoices - with load information” like E-Invoice does ? ThanksMichael

Is there a better documentation of how to setup Developer Studio than the Techdochs at docs.ifs.com ?Here are some detailed questions:Developer Studio What should be inside Build Home ? Does Build Home have to reside inside the folder where the instance is running or can it be a separate folder ? Are there any specific files i can check for knowing where Build Home is ? Application Form Designer Do i need a specific version for the APF to get running ? I’m reading Vis Studio 2010 for IFS 8, is this correct ? Does it need the Professional version or is a 2010 C# Express sufficient ? Do i need Vis Studio 2010 for IFS 8 or could i use 2013 as the installer for IFS 8 seemed to create the addins for 2013 as well What are additional parameters i need to set like System variables ? How to link APF to a specific IFS instance and how to debug / push changes made into this instance ? Same question are asked for IFS 8 and IFS 10. Os is Win 10 Pro 64 bit and it seems to me, that a p

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

Hello Is it possible to have a different base profile for each site or company set up in our IFS Apps9, or is this not possible? Thanks Sarah

HelloIFS8 -Can anyone assist me with using filter in the page ‘Grant Permission Set to User’, how can get multiple columns (Permissions sets).I tried semi  colon and comma to separate them but that’s not working. which separator should i use to filter my columns.Thanks

We applied the July WebLogic corrections to eliminate the critical vulnerability and after that install we have multiple users being disconnected from the application server throughout the day. They receive a message saying that there is a problem connecting to the application server and that the user is not allowed access. It also says that the most likely causes are user is not set to active or user is not granted connect privileges. Has anyone experienced this issue?

Hi All, Given the metadata wihtin the database I would think it would be possible to query the Lobby names, their underlying page elements and finally the datasources involved. i am using ifsapp.composite_page_element as the source for my query This gives me the lobby elements and their corresponding datasources.What I am actually looking for are the parents, the lobby name. Probably this is a page so I thoug querying ifsapp.composite_page which does exist would give page names with id's but querying this table gives no record. Do you have a hint to get the accompanying lobby name for the elements?  

Hi,I have Created a SEQUENCE and wanted to use within CUSTOM MENU with PL/SQL Block, but it’s raise Error:“Illegal SQL rejected: ifs.fnd.services.plsqlserver.service.security.RejectedSqlException: Illegal column IFSAPP.MY_SEQUENCE_ID.NEXTVAL” when i execute command using Custom Menu.Kindly help me to solve this issue.IFS Application 8Thnaks