Hi @ascheeka12, Could you please check on the following as well? Check if the relevant columns are visible here and they are checked. Cheers !Dhananjaya.
Hi @ascheeka12, Could you check if the LOV option enabled for the relevant attributes in your MetalCostCode custom logical unit? Further, you could try to reset the columns in your LOV by RMB on the column header as below, Cheers !Dhananjaya.
Hi @jonm, Hi Are these the API projection names as I am receiving the below error for Projection: SupplierHandling “Unable to browse connector: Projection not found, or not Included in Compatibility Application Type” If you are trying to perform an integration, you might want to include the SupplierHandling projection as a compatibility application type.Navigate to "API Explorer" page (App10 UPD8 upwards) and perform the following, Cheers !Dhananjaya.
Hi @KanishkaLK,I agree with @Mathias Dahl on the fact that Technical Classes are actually a quite big data model.You might be able to re-use the below query with a few modifications,SELECT NVL(tst.value_text, tst.value_no) valueFROM &AO.technical_object_reference tor, &AO.technical_specification_tab tst, &AO.technical_attrib_both tabWHERE tor.technical_spec_no = tst.technical_spec_noAND tor.technical_class = tab.technical_classAND tst.attribute = tab.attributeAND tab.description = 'Valve Body Model' --Recommended to use tab.attribute instead of tab.descriptionAND tor.lu_name = 'EquipmentObject'AND tor.key_ref = (SELECT &AO.Client_SYS.Get_Key_Reference_From_Objkey(lu_name_ => tor.lu_name, objkey_ => Equipment_Object_API.Get_Objkey(contract_ => '&SITE',
Hi @Hans Andersen, Unfortunately, this is not possible.However, you could have 2 custom menus as a workaround.1. To execute a PL/SQL block with the logic to create the record if it does not exists.2. To navigate to the custom page with a data transfer. Second workaround is to have a custom event on the LU connected to frmEstimateOperation and write a PL/SQL event action to create a record on your custom LU for every new record entered on the LU connected to frmEstimateOperation. Cheers !Dhananjaya.
Hi @GTGes, As per the documentation,PLSQL Package procedures are not supported.PLSQL Package procedures are not supported by the IFS reporting framework. Instead one can use Oracle Stored Procedures. If an Oracle stored procedure is used in the report, the necessary permission should be granted. Cheers !Dhananjaya.
Hi @cjohnson, You could try the below approach to schedule the execution of a custom script. Cheers !Dhananjaya.
Hi @Magnus Karlsson, You need to find the report method to drill down to the underlying logic.SELECT t.method --Output: OUTSIDE_OP_DELIVERY_NOTE_RPI.Execute_ReportFROM report_sys_tab tWHERE t.report_id = 'OUTSIDE_OP_DELIVERY_NOTE_REP' --Report ID as per "Report Definitions" window; Thereafter you could view spec and body of the above extracted package (OUTSIDE_OP_DELIVERY_NOTE_RPI) and navigate to the PROCEDURE (Execute_Report) to find the logic. Cheers !Dhananjaya.
Hi @WSHAH, You could have a look at the below resolution which is caused due the dictionary being corrupted, Cheers !Dhananjaya.
Hi @WSHAH, This might normally occur if your dictionary is corrupted.Have a look at the below article, Cheers !Dhananjaya.
Hi @Srikanth, Alternatively you could use the following scripts to achieve the same, Grant all to IFS_ALL role,BEGIN Database_SYS.Grant_All('IFS_ALL'); COMMIT;END; Grant all projections to IFS_ALL role,DECLARE CURSOR get IS SELECT t.projection_name projection_name FROM fnd_projection_tab t ;BEGIN FOR rec_ IN get LOOP Fnd_Projection_Grant_API.Grant_All(rec_.projection_name, 'IFS_ALL'); COMMIT; END LOOP;END; Cheers !Dhananjaya.
Hi @johnw66,You are welcome and I'm happy to help 😊Cheers !Dhananjaya.
Hi @cjohnson,Could you try using the following?Context_Substitution_Var_API.Get_Client_Value__('START_OF_NEXT_WEEK')Context_Substitution_Var_API.Get_Client_Value__('END_OF_NEXT_WEEK')Cheers !Dhananjaya.
Hi @johnw66, Could you check if the System Parameters are updated to reflect the TEST Crystal Server Application Directory? Cheers !Dhananjaya.
Hi @johnw66, Yes, you could change the password by going to Crystal Server Application Directory and reflecting the changes in the ifs-crystal-config.xml file.C:\inetpub\wwwroot\<YOUR_CRYSTAL_INSTANCE>\ifs-crystal-config.xml<?xml version="1.0" encoding="utf-8"?><CRYSTAL_REPORT> <DB_USER>ifssys</DB_USER> <DB_PASSWORD>YOUR_ENCRYPTED_IFSSYS_PASSWORD_HERE</DB_PASSWORD> <PRINT_USER>IFSPRINT</PRINT_USER> <PRINT_PASSWORD>YOUR_ENCRYPTED_IFSPRINT_PASSWORD_HERE</PRINT_PASSWORD> <ORACLE_TNS>YOUR_TNS_NAME_HERE</ORACLE_TNS> <APP_OWNER>IFSAPP</APP_OWNER> <IAL_OWNER>IFSINFO</IAL_OWNER> <FAILOVER_RETRIES>10</FAILOVER_RETRIES> <LOGS>FALSE</LOGS> <LOG_LEVEL>HIGH</LOG_LEVEL> <LOG_FILE_NAME>C:\inetpub\wwwroot\IFSCRWebSetup\logs\IFSCRWebSetup_logs.log</LOG_FILE_NAME></CRYSTAL_REPORT> You can get the encrypted passwords from the configuration.
Hi @hazelms,I guess you are referring to the History Logging function?I suggest you to have a look at the below reply by @Yasas_AK.Cheers !Dhananjaya.
Hi @PRODQ, Yes, @dhlelk we had customised it to be Material tab. Sorry I didn’t make that clear. Thanks for your confirmation. Could anyone advise how we set “Material” as the tab that is seen when Shop Order screen is opened rather than “Operation” Hence, to answer to your initial question,You could achieve this via a customization, since as per my knowledge, we are unable to change the default tab in configuration level. Hope this helps Cheers !Dhananjaya.
Hi @cjohnson,I have checked from the code level in App10 and following are the conditions need to enable the "Electronic Payment Addresses" RMB.1. Only one row should be selected in the table.2. In the current context, there shouldn't be any edits or deletes to be saved (the save button should be disabled).3. If Payment Method's Format ID = ISO20022, the user should have permission to access the "frmIso20022PaymentAddresses" form.4. If Payment Method's Format ID <> ISO20022 4.1. SELECT &AO.CLIENT_MAPPING_PAY_FORM_API.Get_Address_Mapping_Type(<YOUR_COMPANY_ID>, <YOUR_PAYMENT_METHOD_ID>) FROM Dual -- should return a value. 4.2. The user should have permission to access the "tbwPaymentAddresses" form.Cheers !Dhananjaya.
Hi @AkilaR, I also agree with @dhlelk. Default focus is set in Application form level(Form Development) and you required to have development access to change this. Correct me If I’m wrong @dhlelk. Yes you are correct, as per my knowledge, we are unable to change the default tab in configuration level. Hi @PRODQ, Yes, we know it was as a result of an update. The Shop Order screen has been replaced and we know it was a change we had in our environment previously. Thanks, anyway @dhlelk and @AkilaR You are welcome and I'm happy to help 😊However, as I remember the standard default tab of the Shop Order window is the "Details" tab (if navigated directly from the navigator path).Hence, I feel like you had already customized it to be set to "Material" tab and now it has been again changed to "Operations" tab. Cheers !Dhananjaya.
Hi Akula We had this in place prior to some updates recently and it has disappeared. Do you know the Code level change? Linda Hi @PRODQ,If you suspect if this was changed as a result of the recent updates, I would suggest you to raise a support ticket.Further, you might want to re-validate it on an environment where the updates were not applied to confirm.Cheers !Dhananjaya.
Hello, Dhananjaya Thank you for your helping! I can do it with your advice. It’s worked!!! Regards, Onjira Hi @Onjira,You are welcome and I'm happy to help 😊Cheers !Dhananjaya.
Hi @Onjira,CSV files doesn't support line breaks, you could check this by opening the .csv file from notepad.Hence you could use a workaround to replace the new line character with a placeholder text like "#NEW_LINE#" when uploading and then replace it back to the new line character when migrating data to the source columns.Check this link for steps on how to find and replace the new line character in excel.Thereafter you could replace the placeholder text "#NEW_LINE#" back to the new line character on your source migration job.REPLACE(<YOUR_COLUMN_NAME_HERE>, '#NEW_LINE#', CHR(13) || CHR(10))Cheers !Dhananjaya.
Hi Dhananjaya, The solution that worked is your point #3 : try removing the “If-Match” parameter from the header. After removing it, the Update operation worked correctly. Thank you for the help. Michel Hi @MicLabElmo,You are welcome and I'm happy to help 😊However, I would suggest you to try out to set "If-Match" parameter value to "*" as well.Cheers !Dhananjaya.
Hi @hien.nguyen,As far as I remember, it was hardcoded to default it to "Auto Close" in App9.Therefore, you might need to do a customization to change this behavior.However, in App10 this can be controlled from the Site window,Cheers !Dhananjaya.
Hi @johnw66, We have a custom event already that is triggered when the customer order is ‘Released’ that effectively credit checks the Customer/Customer Order. Now I am trying to add another Custom Event that also triggers on ‘Release’ of the Customer Order. This one is to check whether a custom field ‘EORI’ has been populated. Could you try adding a new "Custom Event Action" to the same "Custom Event" which you have already created for the credit checks on the Customer Order? Cheers !Dhananjaya.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
