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

Could someone advise what my expectations should be as to under what circumstances I can simply click into a field and can edit it vs having to click the ‘pencil’/edit icon first before being able to edit, please?EG Receive Inventory Part - click in field and can edit Customer Order Lines - have to click ‘pencil’/edit to change quantity It would be useful to have an explanation to pass on to users.Thanks!Linda 

CustomerOrderInvHeadSet doesnt seem to work? {    "error": {        "code": "DATABASE_ERROR",        "message": "Database error occurred. Contact administrator.",        "details": [            {                "code": 904,                "message": "ORA-00904: \"DEBIT_INVOICE_ID\": invalid identifier"            }        ]    }}

Hi everyone,Current IFS version: IFS apps 9 EETarget IFS version: IFS cloud 23R2 (hosted on prem by us) Today in IFS9 we have several applications (built by us) that are connecting to our database directly to “interface” with IFS. We have several oracle users that handle these connections, created as IFS fnd users. These users are granted access to the database API package methods via permission sets, and are set as inactive in the IFS application as they never actually log into the app and the oracle user handles everything.Example: User logs into non-IFS app and enters information about a purchase order. That application connects to the database hosting IFS as an appropriate oracle user, calls {app_owner}.purchase_order_api.new and creates the purchase order. We are in the process of upgrading to IFS cloud. In IFS cloud this presents us with two issues: Oracle users backing IFS fnd users are removed and permission sets are no longer mapped to oracle roles. We attempted to remove the

Hello, how can I join two tables together if they dont have common column and they dont have the same number of columns? 

Hello.I made a custom LU / Page, the page works well for the IFSAPP user, but for another user, when they update data, the error message “object xxx has been removed by another user” pops up.What’s the meaning of this error? Is that a privilege issue? ThanksIFS App 10 UPD 5

Hello,I am facing an issue in the lobby while including the date parameter. The data is not populating in the lobby.Cloud version - 23R1 (Note - We need the date as a datatype to get the calendar below to pick the desired date from the calendar) In the main view, the date (balance_date) is formatted as “DD-MON-YY”The page parameter uses the format “YYYY-MM-DD”.Subquery’s date (balance_date) is also formatted as “DD-MON-YY”.The picture below shows the format as “DD/MM/YYYY”, but in reality, it is using the format “YYYY-MM-DD”.Page Parameter Lobby PageThe below is the condition in data source designer. Data Source where conditionWhen i tried running the same condition by hardcoding all parameter in sql developer, the query runs successfully. SS of Sql developerCan someone please help me with a solution. 

Hello, I want to add some number in attachments section as a new CF in some entity, but in SQL i dont find this number, how can I solve this problem? For some part no I have in attachments section CO Number.

Hello, I created Custom Field in this entity, but when I open my SQL view, it is not there, what should I do?Should I switch on toggle List Of Values for this CF, or there is other option?Thanks   

Hello Everyone, We are working on an integration between IFS and our customers bank to send Payment Files from IFS to the bank to carry out supplier payments. The bank requested PGP encryption for file encryption, and this was handled through a java transformer custom built by our technical team member. This worked successfully where bank was able to decrypt files sent through IFS. We implemented a file naming convention to ensure the required name is captured on the outgoing file and the received file by the bank.  Now the bank is informing us that the file sent cannot be decrypted due to an error message they receive while attempting to decrypt the file (error text was not shared at the time of writing this). The feedback received from the bank is that the file naming convention is causing the error. Has anyone faced a similar issue while decrypting from the banks end? If so, appreciate your thoughts/ feedback/ Solution. Thank you.  Best RegardsAkila

Hi All,Anyone implemented a PGP (Pretty Good Privacy) encryption for our standard SFTP senders via any means? Banking systems requires PGP encryption onto of SFTP for extra security so any implementation of PGP is appreciates even with external tools.Thanks and kind regards,/Tharindu 

Hello,When I am trying to export all rows under assigned tasks in dispatch console in IFS Cloud the following error is popping up. Can anyone guide regarding what is the issue with this? 

Hi,I would like to know what is the condition to enter for a field that is boolean betwen true or false.No custom values I’ve used already existing parameteres like EXCLUDE_FROM_AS_BUILT in the product structure.If the value is True I want to trigger the action. I tried with = or LIKE and also with ‘True’ ; True ; 1. But nothing seems to be working …And the same thing for BOM_TYPE. I want to trigger the action while BOM_TYPE is equal to Manufactured.Can you help me ?Thank You 

For each set of a projection we can request something like:[YourServer]/v1/CurrencyRatesHandling.svc/CurrencyRateSetThis will give a list of all the currency rate sets. Great. One of the query parameters is $count (see [YourServer]main/ifsapplications/projection/v1/CurrencyRatesHandling.svc/$openapi?V3#tag/CurrencyRateSet).How do I use this on the URL as mentioned?This is my first step to understand how to implement retrieving the number of rows in a set retrieved via something like the following:It comes down to knowing in the end, are there zero or more rows. Based upon the count I can perform another step in the process.

We are on IFS Cloud 23R1 and we use business opportunities as our quotation mechanism and convert them to customer orders once won. IFS creates a link between the business opportunity and customer order, and the business opportunity is displayed on the header of the customer order. In some instances when “unchangable” information (order type, customer, site, etc) is entered incorrectly at time of order entry, the connected customer order must be cancelled, and a new one created. The new customer order is not connected to the business opportunity, which breaks the traceability chain from invoice back to quotation. Is there any way to manually “connect” the customer order back to a specific business opportunity? I tried setting the Business Opporunity field on the Customer Order to editable and manually changing, but i get an error that Business Opportunity may not be modified. We are considering manually modifying the database table in these instances, and i know that is not recommended

When trying to show details of a record in Application Monitoring Console, no records are ever shown. How does this Details page work? Is it not working in IFS Cloud anymore? 

Hi All,A user canot login after recreation of the user.Error :Url (parameters included) = https://<host>/main/ifsapplications/web/startError stack:Cannot convert undefined or null to objectTypeError: Cannot convert undefined or null to object    at Function.keys (<anonymous>)    at E.project (https://<host>/main/ifsapplications/web/main.4c91b256c916c18e.js:1:1083701)    at E._next (https://<host>/main/ifsapplications/web/main.4c91b256c916c18e.js:1:18005939)    at E.next (https://<host>/main/ifsapplications/web/main.4c91b256c916c18e.js:1:17983004)    at B.notifyNext (https://<host>/main/ifsapplications/web/main.4c91b256c916c18e.js:1:18014214)    at E._next (https://<host>/main/ifsapplications/web/main.4c91b256c916c18e.js:1:17987777)    at E.next (https://<host>/main/ifsapplications/web/main.4c91b256c916c18e.js:1:17983004)    at E._next (https://<host>/main/ifsapplications/web/main.4c91b256c916c18e.js:1:18004299)    at E.next (https:/

 About a year ago I started working on setting up a new interface for a customer.  The interface was with a pretty well-known company with a reputation for data integrity in its API.  As we got started, we learned that this integration was going to require OAuth 2.0 for Authentication as well as the use of SSL with security certificates.  In addition, this interface also required Mutual SSL.  With Mutual SSL both the client and the server must exchange signed certificates and verify each other’s trust chains before communication can begin.If you are unfamiliar with the whole process, I will give you some lessons learned, and some insights into Mutual SSL and (more importantly) using Mutual SSL with IFS Connect.  Mutual SSL is a hardened trust pattern for added levels of security. Establishing Trust In order for you to successfully communicate with mutual SSL you will need a few things first (even before even thinking about configuring IFS Connect.  These include:OpenSSL tool for encryp

Hi everyone,I'm having trouble getting a Permission Set Filter (PSF) to work correctly in IFS. I've followed the steps outlined in the documentation, but I'm still able to access records that should be filtered out.Here's what I've done:Created a PSF: I've defined a simple filter with the following WHERE clause: &AO.PART_NO <> '120150' This should restrict access to records in the ServiceEngApp >PartSerialCatalog entity where the PART_NO is not '120150'. Granted the PSF to an Activity: I've added the PSF to the relevant activity that grants access to the PartSerialCatalog entity. Assigned the Permission Set: I've created a permission set with this activity and assigned it to a user. Cleared Cache: I've cleared the security cache and reinitialized the client.Despite these steps, I can still see and access all records in PartSerialCatalog, including those with PART_NO '120150'.Has anyone else encountered this issue? Are there any common pitfalls or configuration settings I m

Hi TeamGreetingsCan we limit any user to pass entry as per the invoice amount in any screen in IFS when we create a user set-up?For Example: If we want to restrict user to pass entry in manual supplier invoice screen to pass the entry up to amount of 500,000 - whether it is possible?  

Hello.I would like to view the definitiion of an IAL but I can’t find it, not even via SQL developer, what’s the way the view the definition of an IAL?

Hi all. I have enabled SSO in TEST environment (IFSAPPS10 UPD17) and I can’t access the REST API Documentation. Compatibility Application Type (Int). Note: The Compatibility Application Type (Main) works fine. It prompts me to login but IFS does not accept my Oracle login neither SSo microsoft.Cloud someone help me with it? If a Cancel the sign in, get the error bellow.  

Hello, It is possible to retrieve in extra column in IFS cloud the difference in values ​​between two CFs? I have two Custom Fields, for example CF_12 and CF_11 and I want to display (CF_12 - CF_11) in extra column, how can I achieve it? Should I use in creating new column in this entity Custom Field - Select statement, Expression or Reference Value? Only CF_12 is located in SQL, CF_11 is not

HiIs it possible in IFS Cloud 22R1 and in MWO app to set up a Custom Field to store and display multiple lines of text ? And if it is possible how to do the set up ?Like it exists with standard field “Performed Work” on Work Task for instanceThanksKind regards,Lénaïc

When trying to do "Database Open" and "Reload", Advance Planning Board (APB) gets loaded to the stage "CBS Schedule Successful Loaded" then the Advance Planning Board gets crashed and closed down.Steps followed:Following steps were followed to load the “Shop Orders” in the APB.   When trying to reload from the database APB gets crashed and closed down after the following screens.  Version of the APB client: When checked the APB logs there were not any error entries.For further reference those logs were attached below. 

Hello,Is there a way on IFS to possibly receive a purchase order automatically when a purchase order is created?Actually,, we create a po on the po page, liberate the po and need to go to the register arrival page for reception. Our client wants to have an easier way to create the receipt (Exemple: register arrival page directly from the purchase order page). Thanking you for your feedback. BRLakshmi