Solved

Hi all,I have question if it is possible to add column “TEXT” from GL Voucher Row Analysis to Supplier Analysis? I have created SQL which works in ORACLE SQL and return me a propper data but when i want to add it as custom field system shows me error that there is somekind of issue with my reference. I wanted to connect it by voucher_no. Also when I was checking it by querries creator it showed me that there is no references between those projections. I am using IFS CLOUD.

I see this problem repeated, but I haven’t found any with a solution relevant to me. [Tue Jan 23 18:08:58 UTC 2024] - SEVERE: failed post-install: job failed: BackoffLimitExceeded[Tue Jan 23 18:08:58 UTC 2024] - SEVERE: Failed to install ifs-cloud[Tue Jan 23 18:08:58 UTC 2024] - INFO: ifs-db-init log:Container initiated at Tue Jan 23 18:06:45 UTC 2024SECRETIMAGE_VERSION=Tue Mar 21 05:25:29 UTC 2023 1.0.6ALPINE_VERSION=Tue Mar 21 05:25:29 UTC 2023 3.16.3BASEIMAGE_VERSION=Tue Mar 21 05:25:29 UTC 2023 1.0.44CERTIFICATE_HANDLER_VERSION=Tue Mar 21 05:27:05 UTC 2023 1.0.8JAVAIMAGE_VERSION=Tue Mar 21 05:27:05 UTC 2023 1.0.53DRIVER_VERSION=Tue Mar 21 06:42:06 UTC 2023 22.2.7.0.0DBINITIMAGE_VERSION=Tue Mar 21 06:42:06 UTC 2023 22.2.7.0.0Using API to fetch certificates/opt/ifs/get_certs.sh: line 50: $(sed -e 's/^"//' -e 's/"$//' <<< "$(echo -e "${split[0]}" | tr -d '[:space:]')"): ambiguous redirectNo certificates are loaded for database-certs ..Using API to fetch certificatesNo certifi

Hello, I am currently attempting to update a Customer Order Line planned due date variable via a workflow projection call. Please see below for the call. I have formatted the date to the correct syntax.I get the following error when trying to update the Planned Due Date“ ORA-20120: CustomerOrderLine.UPD_TIME_ONLY: You may only change the time for [PLANNED_DUE_DATE]! ORA-06512: at "IFSAPP.ERROR_SYS", line 140 ORA-06512: at "IFSAPP.ERROR_SYS", line 702 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_LINE_API", line 24230 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_LINE_API", line 25290 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_LINE_API", line 19070 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_LINE_API", line 19125 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_LINE_API", line 19138 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_HANDLING_SVC", line 40640 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_HANDLING_SVC", line 40680 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_HANDLING_SVC", line 40684 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_HANDLING_SVC", line 13

Hi Team, Can Anyone help me on below issue   

In Cloud, is there a way to move a group of serial objects that belong to the same functional object to a new functional object as well as:Replace the current party assigned to the serial objects with the part assigned to the new functional object. Change the Owner on the serial objects/part serials to be the party assigned to the new functional object?

 HI,We have a use case with 3 PM schedule maintenance  for a same product: 1/  Maintenance 1 :  each 6 weeks   problem code  A2/  Maintenance 2 : each 3 months problem code B3/ Maintenance 3 : 1 per Year  Problem code CEach of them have the own pace, they are not linked in cycle.For the Maintenance 1 : For example : I have this shedule : 02/01/24,  15/02/24,  etc each 6 weeks.If for this planned date (02/01) , I finally run the MP the 15/01, i would like to automatically posponed the second date : 15/02 to 28/02.We tried this PM Schedule maintenance, but it doesn’t work. After the first MP Done, the second PM date, still at the same planned date. What can be the best way to design this PM schedule ?Why we cannot use the “Floating PM” with a schedule “Alone” ?Thanks and Regardsanthony

When an absence is reported in Time Card page, the Edit and Delete buttons are not visible in the Time Registration - Calendar view.Register Absence for Jan 15th using Time Card - Grid and for Jan 16th using Time Card - Details pages.Check the outcome in the Time Registration - Edit and Delete buttons are missing in Jan 16th 

Community,We have bunch of products that are returned from customer. they are being repaired/replaced/scrapped and stocked later on.our question is, what is the best practice to have them costed differently under the same part no? basically they have the same part no as the brand new product,  currently in our system, the standard cost cannot be split.thinking of using condition code? will that work? Thank you.

How to tell if a permission granted to an object is full or read only? I have checked through the help pages for permission sets and not found this mentioned. What do the other symbols and colours mean next to a presentation object, eg tbwShopOrd

As i know, agreements are only for inventory parts, is there any possibility to have the same for non-inventory parts?A customer is also working hard from the Group Procurement with Capex, Spare parts for molds & machines.

Hi All!Here is an issue on person view (PERSON_INFO_ALL). The name value is replaced by other field value only on a specifica date ¼/2023. FIRST NAME become TITLE and LAST NAME become (Another field value).How it is possible that the two fields (Title and another) may slip in mass to FIRST NAME and LAST NAME FIELD?Thanks to any insight on this subject. 

Hello,I have the following syntax in a procedure, but it is failing to compile with the following : Can anyone tell me what I am doing wrong please ?  

A customer has have group suppliers (same company, different VAT nrs, different ID's, but the total consumption is into the same contract. What is the best way to connect all Supplier ID's into the same agreement / contract. With the current setup of the supplier agreement, only one (1) supplier can be linked per agreement.

Hi .. I was trying to set-up new migration job to update CUSTOMER_INFO_ADDRESS View for changes in address and postcode values. This supposed to update around 17000+ records so i choose to use Procedure “INSERT_OR_UPDATE” from csv file.As soon as i run the job i am getting below error. I did investigated further into this and noticed actual issue is - Address column value holds multiple comma seperators, which seems to be root cause of this. Is there any way i can mitigate this issue without removing extra commas from address value ? if i add double quotes around this column value, do you think this will insert double quotes also in data ?double quotes  Start time - 19-JAN-2024 11:13:18   CS_SJCB_POSTCODE_CHANGE_MIG - Execution No 0 Insert into CUSTOMER_INFO_ADDRESS_TAB failed - ORA-20111: CustomerInfo.FND_RECORD_NOT_EXIST: The Customer Info does not exist. (Error caused by line: 2)File Path: DATAMIG (F:/DATAMIG2)File Name: CS_SJCB_POSTCODE_CHANGE_test2.csvFile Location: OnServerChar S

Hello Community!I have the following Code-- In this block we perform the actual change.DECLARE PARTTYPEERROR EXCEPTION; [SOME_OTHER_VARIABLES]BEGIN FOR sale_part_to_update_rec IN ( [SOME_SQL_TO_PERFORM_LOOP] ) LOOP p0_ := NULL; p1_ := sale_part_to_update_rec.OBJID; p2_ := sale_part_to_update_rec.OBJVERSION; client_sys.add_to_attr(name_ => 'SOURCING_OPTION', value_ => sale_part_to_update_rec.SOURCING_OPTION, attr_ => p3_); client_sys.add_to_attr(name_ => 'RULE_ID', value_ => '', attr_ => p3_); p4_ := 'DO'; BEGIN IFSAPP.SALES_PART_API.MODIFY__( p0_ , p1_ , p2_ , p3_ , p4_ ); COMMIT; EXCEPTION WHEN PARTTYPEERROR THEN [MY_ERROR_HANDLING_CODE] END; END LOOP;END;I have noticed that even when the IFSAPP.SALES_PART_API.MODIFY code I execute results in an PARTTYPEERROR Exception...… The block to handle that type of errors is never invoked. The exception

Good day, Is it possible on IFS to have more than one approver on a cost center by adding a requisitioner on purchase requisition authorization rules? Depending on the requisitoner ID being used on the PR, the authorization rules of that specific requisitioner will be triggered. I hope I am making sense. RegardsSimon

Hi, Guys,I’m wondering whether there is an out-of-box solution for NCNR (Non-cancelable, no-returnable) order in IFS order module.  Basically I just want to add some extra control over an order lifecycle, blocking normal customer orders to be changed or cancelled, rejecting RMA automatically... Searching IFS documentation, it seems no such terminology yet…  I know we could have a customized solution by twisting the order flow logic, but really prefer to utilize an standardized solution from IFS if possible.  Thanks a lot in advance!Best,David Cheng  

Hi,Need expert help on US 1099 Tax reporting.No data showing up in the print preview of the report though I have setup all the basic data. I have checked the tax transactions and found data are available for the reporting period. Any idea what’s need to check? Thanks in advance

Hello,We want to do IFRS reporting for the first time in our company.How can I use the Internal Ledger to do IFRS reporting? At what stage and activity can I use Parallel Currency?Is there a document about this?The general ledger we keep in the country and the ledger we keep for ifrs will be separate for now.However, if we provide sufficient conditions in the future, we will be able to make IFRS reporting within the country. Can we keep a single ledger by removing the distinction between general ledger and internal ledger in the future?Asking for IFS 10 Apps

When you create a document attachment and link it to a business object of the inventory item type, for example, you want to display it in a list view. Next, we limit the number of displayed columns. We write the whole thing down. When you want to open this view again, the settings are not saved, because the default view is displayed. 

Hi All,I have a query regarding currency revaluation. Below are few basic setups which are important with my question. Revaluation posting method has been set as Original to port with original account.Below is the voucher is created once I run the revaluation process. Application connects Industry and Location code parts with credit entry. My requirement is to connect Industry and Location with GP11/GP10 entry as well. Is it possible?Below are the available control types when I try to set Industry and Location code parts in posting controls. I don't think any of these options does not fit with my requirement. Any alternative way to fulfil my requirement.Regards,MalinG.

Hi!I used to access AQS using the url https://open.ifsworld.com/wiki/Wiki%20Pages/AQS%20Overview%20and%20Content.aspx but since the portal went offline I no longer have access to it.I suppose the new location for that information is somewhere here in IFS Community but I can`t find it anywhere.Anyone knows where it was moved to and how I can find it? PS: in case that wiki was split in many documents, I`m specially interested in the development topics (coding, naming and commenting standards, stuff like that). I already checked F1Docs and I couldn`t find that info out there except for some IEE topics that does not contain the same content that was available in AQS.   

Hi, Can anyone please elaborate me on how to generate carryforward absence limits for more than one year?For example, employee A got 20 unused days of earned leaves in 2021 and another 20 unused earned leaves in 2022. When we are generating Carry forward absence limits for 2023, I would expect to see (20+20) = 40. However, system shows me 20 days (that is the CF balance from 2022 only). 

Dears,I have a quick question about supplier set up:in purchase tab -General:what these choices mean? and what the affect if we make it approved or not?Thanks.

Hi all,,kindly provide your thoughts on the below scenario.When adding a person to a resource group, what is the requirement to be fulfilled to automatically fetch the calendar information as shown in the image? Thanks and regards,Hasani Aparna