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

Has anyone had success in using date arithmetic to control visibility of page elements through Page Designer?Cloud - 23.1.10We can see value, for example, in not allowing  ‘Closed’ shop orders to be re-opened after a certain amount of time - say 1 year. In Page Designer on the Manufacturing > Shop Order > Order > Shop Orders page, I can use a hard coded comparison date on the Shop Orders Open command, Visible condition as such: record.CloseDate >= ‘2023-03-14’ to limit the appearance of the button to only orders closed within the last year. However, I’ve not been able to come up with a way to use a dynamically generated “year ago” date to compare.The variables understood by the page search function don’t stand up to a syntax check. [ #TODAY# -1Y]System and DB functions like these fail as well:sysdate to_date() date()Thanks,Dan

Currently in Aurena (23R1) we can condition fields in page desginer  as shown in Index - Technical Documentation For IFS CloudIs there to condition a field based on the connected user?for exemple : using fnd_session_api.get_fnd_user()like putting api.get_fnd_user() = ‘XXX’ in the visible option of a field  or is there a way to find where the api.[Function] are stored?Condition Syntax - Technical Documentation For IFS Cloud  Kind regards

I am trying to import Lobby page from test environment to stage environment but in Stage environment I don’t see Import page button. Could anyone advice me why? If it is permission issue how I should do it? I couldn’t find Projection name on Lobbies overview page.  *The below picture is in test env. which you see the Import page button but I don’t see it in Stage enviroment. 

Hi,I have installed the latest version of IFS Report Designer.When I try to open a layout available on my computer, I get this error:What should I do?Thank you for your help.Best regards.

Hi. We are experiencing an issue with the attachment pane in Purchase Order screen. When we click in the header and then open the Attachment pane an error is presented. It does this only when we click in the header before opening the pane and when there are no documents attached to the PO.Can anyone shed any light on this?Thanks, Andrew

Hi All,I would like to get SELECT query to find ENTITIES from the cloud database. It should be a base view from the Aurena cloud. Since i want it to create List of Values(LOV), there view alone can be used.I have tried with DICTIONARY_SYS_VIEW .But it did not work.Is there any way to find a solution ?Thanks in advance.    

Hello to the community,  I am using MHS to send customer invoice to my customer in an intercompany scenario; both supplier and customer company are on IFS. I am getting this error message when sending the customer invoice Do you know by any chance what does it mean and what can be done to tackle it?  ThanksTanya

The background job Generate Authority for User has started failing with the following, can anyone help me identify what the actual issue is please ?ORA-04098: trigger 'IFSAPP.LOG_DATAFILE_CREATION' is invalid and failed re-validationORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5588ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5580ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5405ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 2652ORA-06512: at "IFSAPP.DATABASE_SYS", line 2252ORA-06512: at "IFSAPP.DATABASE_SYS", line 5012ORA-06512: at "IFSAPP.DATABASE_SYS", line 4511ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3917ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3922ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3705ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3785ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 2523ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 2537ORA-06512: at line 1ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1831ORA-06512: at "IFSAPP.TRANSACTION_SY

Hi, So I struggled for several hours trying to reinstall IFS_HOME on a particular server. When trying to install the new IFS_HOME I got the error: ...\build_home\server\install_fndmws.xml:214: Failed to install Middelware Server! Error is: Exception when installing IFS Middleware Home: ...\ifs_home\tmp\as\resources6277372277239962574\install_fndmws.xml:480: Failed to install Middleware Server. Error is: Which is really helpful *sarcasm*   The issue turned out to be a rogue inventory.lock file in C:\Program Files\Oracle\Inventory\locks. What really happened was that the installer was waiting for “the other process” to “finish their business” with Oracle Inventory. When in reality, this lock file was left behind due to the way I uninstalled the previous version of middleware server. So if you’re looking to reinstall IFS_HOME, make sure you check this if the installer fails with the empty error message.

dear all,i want to create new field in ifs10. how can i revised below query for read only select expression, SELECT ipis.QTY_ONHAND - ipis.QTY_RESERVED eldeki_miktar fROM PURCHASE_ORDER_LINE_ALL pola RIGHT JOIN INVENTORY_PART_IN_STOCK_UIV ipis ON ipis.project_id = pola.:project_id AND ipis.part_no = pola.:part_no and ipis.activity_seq=pola.:ACTIVITY_SEQ and ipis.CONTRACT=pola.:CONTRACT  ps: Below is the screen where I will make this development.

Hello,On Application IFS9Is it possbile to have application configured with 2 URL’s. One with Https and other with http.Please suggest RegardsPankaj

Hi All, We have implemented APEX with IFS and are looking into creating an authentication scheme in APEX that will allow users to access an application with their IFS details, has anybody implemented this and could help with in terms of an API or different method on how to do it? Thanks,

A customer has asked whether it is possible to change the title of a document when it’s generated and the printed document is downloaded (e.g. a customer invoice, PO order confirmation etc.). The customer is trying to get IFS to use e.g. the invoice number, PO number etc. in the document title so that it’s easily searchable and it’s clear which document is what.  Has anyone come across this requirement or seen a way to do this?

One of our customers is having some the below issue with aurena agent,The prebuild package for Aurena Agent IFS are providing on the landing-page is for single user, to install on their clients by themselves, and it works if you have the security parameter “native messaging hosts” sat to enabled. Found this in IFS Community an article that describes the same issue, https://community.ifs.com/document-management-docman-248/aurena-agent-will-not-enable-in-edge-browser-but-does-in-chrom-39986 The conclusion according to this article is:"We have found that the issue was due to a security setting that was disabled in our GPO which as a result, did not permit the Aurena extension in Edge to communicate with the Aurena Agent on the computer. It was “Allow user-level native messaging hosts (installed without admin permissions) “To correct, we needed to enable that setting." customers got the below answer from their security technician:This setting is the issue: Allow user-level native messaging

Anyone can tell me what the Aurena projection is for Printing the Purchase order and setting preposting?

Hello.I was asked to add an approval process on the work center screen (link : ifsapf:frmWorkCenter ) but I don’t know well how IFS works on that. Is that possible to make an approval process on such a screen? By clicking on attachments, I can only see “media” 

In a report rule, in order to format a link into the email message I would need to use a semicolon.It seems this is not possible in the report rule? Any workarounds for this?Report rule setup The messages field needs to include a formatted url to the customer order so I tried thisI even tried to add in stead of ; this [&SELECT CHR(59) AS result FROM dual] but that results in the same problem that the report rule engine is splitting up after the semicolon?Would there be a workaround for this as this is quite a problem if you want to add links from IFS as all the urls in ifs contains semicolons… if you want to filter.I also tried to use Form%3B%24filter=  but that also did not work.So is there a way to “escape” semicolons in the report rule?I saw @dsj had a similar thing with semicolon on the attachments but that was not a solution in this case

Hi everyone,I'm encountering an issue with a command group that serves as a navigation link from a customer address listing page to individual customer address info pages. The problem arises when I attempt to navigate from the listing to a specific address info page: only the data from the first record I select loads correctly. However, when I return to the listing and select a different record, the data displayed still corresponds to the first one.I've already tried creating another command group to address the issue, but unfortunately, the problem persists on the new command group as well.Interestingly, if I copy the URL and load it in a new tab, the correct data displays. The issue seems to be isolated to the current tab, where the data isn't updating as expected.Any insights or guidance on how to address this would be greatly appreciated!Thanks in advance. UPDATE: i keep testing and if the navigationlink points to the customer form and i only pass the customerID it works as expecte

Dear colleagues,we have an issue with receiving lot-tracked parts in Receive Inventoty Part page (Transaction Code=NREC). When the part is being received, a quantity, a lot batch no and an expiration date is entered and the record is saved.After saving the record in Receive Inventory Part page, the receiving transaction can be viewed in Inventory Transaction History (Part No, Lot Batch No, Quantity Transaction Code=NREC, Expiration Date, etc).Unfortunately, the lot batch no record is not displayed in Part Lot Batch page.I do not understand why the lot batch record is not dispayed here as well.Please, can anybody help me?Thank you very much Best RegardsAntonin 

Our environment is IFS Application 10 Update 8.   When our standard users run the SetupAurenaAgent.msi they receive the Interrupted error message every time.  If the SetupAurenaAgent.msi is run as a local administrator it succeeds but the installation is done under the local administrators account so its useless to the standard user.   Standard users have full access to their AppData directory and they are able to install the IEE Agent successfully.   We suspect maybe the installer is trying to modify some registry keys that require administrator access.   Regards,William Klotz

Hello, I need give permission to db for user, which in application has permission only to one company - in instalation is a lat of companies. And next question, how I can give him permissions to view procedures in pl/sql developerRegardsPaulina

Filtering of Custom Attributes Links is not supported. The $filter is missing when a custom field attribute as a link is used. This is a very known issue and it is documented as a known limitation ( Document could be accessed through the below link ).Known Limitations - Technical Documentation For IFS CloudHowever,  the customer seeks for a solution and to solve this issue. Business Impact: This malfunction treats us to work with two tabs and always copy and paste the desired value in the filter line of the new tab. This is a lot of clicking and the usability suffers dramatically.

IFS Cloud offers Page Configuration to (mainly) hide tabs, sections and fields not relevant for a customer. This Page Configuration can be stored in an ACP and exported to be saved outside IFS as a backup and to deploy to other environments. It would however be good if this backup would also be available in a readable format, to be able to re-apply the Page Configurations when running into issues (for example after SU/RU and rebasing). Anyone who knows how to convert the ACP export format (XML/JSON?) to Excel?

IFS Self-Hosted Advanced Analyticswhat Power BI capacity is needed for the below...- Add the new group to the list of groups that are allowed to use the Power BI APIs- Create a new Power BI Workspace- Give the Service Principal Access to the WorkspaceThis information is missing from online documentation.https://docs.ifs.com/techdocs/23r2/050_reporting/450_self_hosted_bi_int/080_create_aa_azure_resources/Create Azure Resources for Self-Hosted BI - Technical Documentation For IFS CloudProduct Version: 23.1.2Business Impact: cannot run IFS Self-Hosted Advanced Analytics

We are a public company.  Our auditors are requiring the following reports:IFS Operations Success and Management Cloud Service SOC 1 Microsoft Subservice Organization SOC 1 (For IFS)And obtaining from Todd Williams requires frequent follow up emails to chase after the documentation.  Where is this information published so that we can self-serve without sending lots of emails?Thank you!