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

Hi all,This following case statement is executing successfully in quick reports but it will not work in data source designer. When I preview the data source, it loads for awhile like it wants to run but then it fails.Any ideas? (SELECT CASE WHEN INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE='OESHIP' AND PART_CATALOG_CFV.PART_MAIN_GROUP='DOMESTIC FG' THEN  INVENTORY_TRANSACTION_HIST.QUANTITY * PART_CATALOG_CFV.CF$_PROOF_GALLONS WHEN INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE='OESHIP' AND PART_CATALOG_CFV.PART_MAIN_GROUP='EXPORT FG' THEN INVENTORY_TRANSACTION_HIST.QUANTITY * PART_CATALOG_CFV.CF$_PROOF_GALLONS WHEN INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE='SHIPTRAN' AND PART_CATALOG_CFV.PART_MAIN_GROUP='DOMESTIC FG' THEN INVENTORY_TRANSACTION_HIST.QUANTITY * PART_CATALOG_CFV.CF$_PROOF_GALLONS WHEN INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE='SHIPTRAN' AND PART_CATALOG_CFV.PART_MAIN_GROUP='EXPORT FG' THEN 0 END FROM INVENTORY_TRANSACTION_HIST, PART_CATALOG_CFV WHERE INVENTORY_TRANSACTION

How can I troubleshoot and diagnose the report formatter in IFS Cloud? I have Report Designer jobs stuck in Waiting status.

Hello all, Is there a way that we can somehow color indication equipment (both Functional Objects and Serial Objects) in the Equipment Object Navigator - Structure?We have equipment split in 3 categories; In Production (Green), Service Support (Yellow/Orange) and End of Life (Red). It would be nice to be able to see that clear when we look at the structure:Something in the line of below (either text - marker or high-lighted): We are currently in Apps9, would it maybe require an update to IFS Cloud?  Thank you,Michael

HiCustomer with IFSAPP9 Update 17 checked Web Client B2E in Safari on iOS. Some buttons are without text - screenshot 1.png, some not working - 5.mp4 Do you have experience with iOS? Should it work? Or is not compatible?

IFS print agent is not installed by IFS managed cloud. Can a 3rd party solution provider host the printing agent servers outside of customer network? And are there any prerequisites such as networking/whitelisting concerns?

Hi, We have a customer who is App Dynamics for monitoring. They want to use App Dynamics to monitor business transactions in Apps 10. Do we have any configuration document outlining steps of how to configure Apps 10 in App Dynamics? Attach is the documentation from App Dynamics. We are able to get the URL to monitor using debug console but not able to get the values. Regards,Vikas

I’d like to start using the customer-solution repository in the IFS Lifecycle Experience Portal to replace our current source control repository. This will include such extra things like…Crystal Reports SQL Quick Reports Custom APIs PowerShell infrastructure scripts (for database refreshes, integrations) ACPs Print Agent XMLs etc.What are the best practices around dumping such code and configuration items into Git that aren’t intended to be touched by a delivery installer?

In Cloud, I created a custom event action tied to existing event (PARTS_SUBMITTED_TO_MRB). My event action works and sends a streams message to A user. When I tried to add multiple users (assume User1 and User) via Receiver window, usernames are displayed with semicolon delimiter.Then when I go to trigger event, I get message:The Foundation1 user "User1;User2" does not exist.Does this mean I can only send a streams message to one user?

Hi!We are on IFS Cloud 22R1 SU12 and have performance problems in many parts of the system. We see issues in quite a lot of screens when searching for data. The volumes are not super big, but we have records from the 10 000 to 200 000, which from a database perspective is not huge. Has anyone tried out enabling the Oracle In-Memory capabilities for IFS and what approach have you taken when implementing it? /Per Chr 

I need to create a Custom Field that contains a formula to calculate a date based off some conditions.Is this possible and how do I achieve it? Thanks,

It appears that with 21R2, there are only 5 Lobby Element background colors available (if you include white as a color), and 1 Accent color that can be defined in the Appearance Designer. Is this correct? While no colors could be user-defined in 21R1, there were 18 options provided, making it easy to group common lobby elements by color.In the case of the pre-defined colors, white is a poor choice, and the other 4 are both commonly used indicator colors (red, yellow, green, etc.) and are such a low saturation as to make it difficult to see them against the default background color.Am I missing the ability to change Lobby Element background colors elsewhere, or to add additional colors to the available palette?If this is by design, what is the use case for this? 

Apps 10 - UPD14Is anybody aware of a way to setup the middleware to automatically remove ‘old logs files’ generated by the HTTP / MainServer / Integration Services?Currently we are handling this by manually deleting the old log files but thought I would ask on the community.  

Hi,I want to use line break for long texts. How can I break to row? I tried with “<br>” tag with “<p>”. It worked. Then I divide the text and I added “<br>”. It didn’t work with “<ifs-data>” tag. After that, I tried many thing to escape from tag. How can I break the line? <ifs-data ifs-data-field="ND.NOTE_TEXT" class="col-xs-12"></ifs-data> 

Hi, We are using serial objects which have maintenance aware and having lots of difficulty trying to find a way to change them after they have been receipted. I have tried the rename function but due to “maintenance aware” i cannot get this to process and receive an error  Is there a way to remove the maintenance aware temporarily or an alternative way to chnage the serial no. This is mostly occurring upon human error and the vast quantities of data entered. Many Thanks

I created a persistent boolean custom field for Purchase Requisition and Purchase Requisitions, then created a read-only boolean custom field for use on Purchase Requisition Lines. The custom field is  named Order_Complete (OC).The idea was to use OC to identify whether an order was closed or not. If I only type ‘+’ in the order_complete search field, the 6 records appear, as expected, and using ‘-’, on Purchase Requisition Lines ONLY, the read-only field returns orders NOT complete, as expected.On the other pages, the ‘+’ symbol work as expected but the ‘-’ has always yields a No Data Found error.I do not think I arrived at the correct query for the read-only field until I took care of the null values, for which I used NVL on Order Complete where null value defaults to FALSE..Anybody see anything obvious? 

I am  interested in exporting and importing lobby configuration files using the API or IFS Connect or even a combination of them.I have manged to export the lobby page using LobbyConfiguration.svc/GetPageDefinition(PageId='<Page ID>'). I actually used the followining command from the terminal (bash):curl -u "<username>:<password>" \https://<my-domain>/main/ifsapplications/projection/v1/ \LobbyConfiguration.svc/GetPageDefinition"(PageId='<Page ID>')" \>> export.page.xmlThis seems to work fine, and produces an XML file almost identical to when you export manually, it’s just needs some odata text removed and formatting which I made a python script for.My problem is I can’t see anyway of importing that file back in to IFS. I’ve looked through the API Explorer and can’t see anything. I also imported a lobby file manually, and paid attention to the server invokes both in the IFS Debug Console and the browser Dev Tools. This led me to try this URL using POS

Is there a way to import and export Lobbies and lobby elements using something similar to the Application Configuration Package? I am able to export the element and datasource file but not sure how I can move this to PROD easily.

Hi all,how can I allocate the following menus to the user in a permission set?  

Dear experts,for EDI mapping we need xsd files. I tried the “IFS Interface Browser” but the files are empty. For example the message SEND_INVOICE. Where can I get such files?

In IFSAPPS 10, we could grant a permission set to a user group But this is not possible in the IFS cloud. Is there any alternative to achieving the same? Is there an estimated date to have this in the IFS cloud? 

We have got an issue after and upgrade from 22r1 to 22r2. It seems to be a bug in the framework but as we don’t have access to any bug database I’ll try to raise the question here. We have an out bound message goin out true ifs connect with http sender and a soap action added wit : (ex urn:test:test2:tes3:v1/test) this was working fine in 22r1. In 22r2 it has been introduced new way of authenication in the http sender where you can use non,basic…. What we see is inside the table fndcn_address_label_tab and column address_data_2 the data has change inside here:In 22r1 it contains only the soap action like thisurn:test:test2:tes3:v1/testin 22r2 it has been added more data into this and now it looks like thisAuthenticationMethod=None:SoapAction=urn:test:test2:tes3:v1/test In 22r2 when ifs connect process the message we get this exceptionExecutionException from Sender threadCaused by: ifs.fnd.connect.senders.ConnectSender$TemporaryFailureException: Exception while sending dataCaused by: if

Hi, we have several columns not properly translated.ex: in Manual Supplier InvoiceWe want to change “Montant net” in “Montant HT”When i go to “Text Translation”:I searched for this logical unit, found what seems to be this column and translated. It did not work. So i lost patience, I searched for all “Montant net” within IFS without restriction and replaced all of them by “Montant HT”, I refreshed all the cache: Language, Dictionary, Reference … I restarted IFS, but nothing changed in the screen… What else has to be done ???I’m using APP10 upd13.

Hi, Could you please let me know whether below two requirements are possible…. ?Is it possible to move navigator menu items and change the position in the list ? For example: I want to move 'Training’ menu right under the 'My Administration’ menu  Is it possible to move navigator menu items inside to another menu item ? for example: I want to move 'Reporting’ menu inside the 'human capital management’, below 'feedback’ menu Kind regards,Yashodha.

We have been archiving some Application Messages to the Application Message Archive, using an example of Database Task Chains (‘Manage Application Messages’) that exists. That all works. At one point I thought there was an example of a Chain Step to purge data from the Application Message Archive, but all I find now are statistics and message cleanup tasks.I do not find table FNDCN_MSG_ARCHIVE_TAB referenced in ARCHIVE.API.   Is there a task or am I forced to go the Data Management / Data Archive approach? 

Hi all, After applied update 16, the check-marked option when opening posting proposals was changed from “I’m Next Authorizer”  to  “All”. Previously it worked fine. If anyone knows, Is there a way to set up this 'I’m Next Authorizor'  as default when opening the posting proposal window again?Is this code level change or function level change?  Thank you Sara