@VsoMDjewPThanks for replying.Yes, we have at least one custom event in sales quotation.
It is possible to inactive an invalid identifier (non custom field) in the “Lobby Element Designer” to avoid the above mentioned error message?
This error may be due to some invalid report layouts exists in your environment. Please check below point: Go to report definition window Search by report id : CUSTOMER_ORDER_IVC_REP See whether there are report layouts with two extensions (.rdl and .xsl) .xsl is a obsolete type in app 9 and it can't be used in app 9 If so you need have the layout type with .rdl extension in the report definition window to print the report correctly. However I would advise you to raise a support case to IFS support and get the assistance to identify the exact issue behind this. Hi Anushka B,yes that is true. I received a similar response from IFS support. Thank you
Yes, we use Apps 9.OK, that is true. I have deleted the status. Now another one: at "IFSAPP.FND_EVENT_ACTION_API", line 2070ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 2075ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 1934ORA-06512: at "IFSAPP.FND_EVENT_ACTION_API", line 1954ORA-06512: at "IFSAPP.EVENT_SYS", line 199ORA-06512: at "IFSAPP.C_COPY_POSTING_TEXT_EVI", line 18ORA-04088: error during execution of trigger 'IFSAPP.C_COPY_POSTING_TEXT_EVI'
Hi @Link , Did you write your UPDATE STATEMENT inside a BEGIN END; section? If not, kindly try and let me know if the issue resolved. Yes I did.
HI @Link , I am really sorry. Unfortunately the given information is not enough to provide an explanation. As per the above call stack this is a general one, cannot get specific information as the error stack shows an exception has been occurred when executing your SQL statement. But I haven’t other error messages.
A common error to occur while using Oracle is the ORA-06502 error message. This is an error that results from a mistake in the arithmetic or the numeric value executed in a statement. ... For instance, say you successfully completed a procedure but when going to execute it the ORA-06502 error message springs up. Thank you. I could run it in PLSQL developer but not in IFS. Then I’ve changed the code.
Hi @Link , This error occurs when the SQL statement in your event action is wrong. Thus, kindly check if you have passed parameters properly. Hope this helps. Yes, thank you. The issue is solved.
I checked your profile and it lists Germany. If that’s the country of concern, core template (per my understanding) should work for Germany. We have many clients in Germany using ISO20022. Best regards, Thomas Hi Thomas,can I use this template (core) in Slovenia too, do you happen to know? Thanks and kind regars
Hi, It is not possible to create a file template as an end user without doing a modification/customization. Theoretically, you can configure (setup data) ISO20022 Core file template based on your bank requirement. But, the problem is some banks do not follow the original ISO20022 standard when they implement the format in their core banking system. For an example, EndToEndId is a prominent XML tag in ISO20022 CT payment in order to facilitate straight through processing of the payment. According to the UNIFI ISO 20022 standard, the standard allows 35 characters for this field. In IFS we have format the field to fetch Payment Date/Order ID/Installment ID (e.g. 2021-10-09/12344/1). IFS design is perfectly correct since the field allows 35 characters. But, for an example some payment types, HSBC only accept 15 characters for this field. This is fundamentally wrong. But, it is not easy (impossible in most cases) to change the bank system and the last resort is you have to adjust the IFS
Dear @Link You are able to achieve this with correct set of routing rules, as it fetch values automatically to system from designated location. Hi Fernando,and with an external file template is not possible, right?For example: Thank you
Hi, Did you try to export an application Configuration Package which contains a Custom Object with a prompt that starts with "=" character? If it is please check Bug ID 129116. Hi Udara,is that also valid for characters like “...”?I can’t find any description starts with “=”. Thank you
Go to search and look up part no '10096950'. Then, in the consists of tab, see if you have part no '10115187'. Hi Arunalu,yes, the part was missing. I put the part no 10115187 there.But I have still the same error message. Thank you for repyling. Best regards
Go to search and look up part no '10096950'. Then, in the consists of tab, see if you have part no '10115187'. Hi Arunalu, yes, the part was missing. I put the part no 10115187 there. But I have still the same error message. Thank you for repyling. Best regards Hi Link, Actually it shouldn't be there. Anyways, could you share a screenshot of the consists of tab for both these parts? That might help narrow it down. Regards, Arunalu Hi Arunalu,OK, I see. I’ve deleted the part: Kind regards
When you try to add part 10096950 rev E as a component of part 10115187 rev A you receive the circular reference error, correct? The first reply from @Arunalu was simply to see if part 10115187 rev A was already a component of 10096950 rev E. As it was not already a component, then the circular reference was not occurring at the first component level of 10096950 rev E. The circular reference, though, is likely present at a lower level in the multi-level BOM of 10096950 rev E. In Engineering Part Revision, search for part 10096950 rev E. Examine the Multilevel tab and check if 10115187 rev A is listed anywhere in the Sub Part column. If it is, this is why the circular reference error is generated. Hi Matt,yes, that is true. The part 10115187 wasn’t a component of 10096950. I investigated the tab “Mulilevel” also and didn’t find the part 10115187 there. Thank you and kind regards
Back to the original error message. In Engineering Part Revision search for 10096950 revision E and include a screenshot of the Where Used tab. Hi Matt,here it is:
Does anyone know how to make a parameter mandatory? By default they are all optional. Also, is there a way to set a default value for a parameter? Lastly, is there IFS documentation or a manual on details like this? I’ve seen IFS pages that have general info, but nothing on technical details like the above or what else is doable/possible. As we start to develop our company’s custom reports I’m getting ideas and would like to know the capabilities and what’s possible with QuickReports. It is interesting.Is it possible to use this in lobbies?For example:
Hi @Link , Just try below statements. Tables: SELECT * FROM company_tab; SELECT * FROM site_tab; Views: SELECT * FROM company; SELECT * FROM site; Best Regards, Thiwanka Hi Thiwanka,I need the table or view with all users, companies and sites.If I activeate these checkboxes the user must be saved in a table. I am I right?Thank you a lot. Kind regards
You are looking for User_Allowed_Site and User_Finance which is a child table to Company_Finance. Yes, that is true.Thank your very much.
Hi, When you creating list of values for a custom field you have based it on a single view. Instead of that you can create new view as a join of two other views and base your custom field on the new one. Best Regards, Pawel Hi Pawel,I am afraid I didn’t catch that. Do you have an example to clarify it? Thank you and kind regards
Yes, it should be possible to fetch the data in PLSQL Developer, and to use it in an event. The issue here is that from the pictures it looks like you are on payment address on Supplier or Customer maybe? (Both ends up in the same table: payment_address_tab) If so the data in the columns in the underlying table are dynamic, depending of the payment format you use. So if you want to create an event you will probably need to limit your validation to a certain format via the payment method. You can see here which payment format it is connected to methods here: When you know which payment format you want to limit it is possible to find the connection between name in client and name in table here: If you have trouble finding it anyway, can you share which payment format you are using in your example? Hi Thomas,exactly. I am in Payment Address on Supplier: My goal is to limit the number of characters of column “Bank Address Line 2” for payment method ISO20022. Thank you a lot for ans
Hi @Link, You can write a trigger and check the length of the required column before insert. This will check the length and insert to the DB only if the certain condition is full filled. Regards, Dheynoshan Hi Nadaraja,but how can I compare the value from a text field?My current code:declarePRAGMA AUTONOMOUS_TRANSACTION;v_data8 String(120);beginselect pa.data8into v_data8from IFSAPP.PAYMENT_ADDRESS_TAB pawhere pa.identity = '&NEW:IDENTITY'and pa.company = '&NEW:COMPANY'and pa.way_id = '&NEW:WAY_ID'and pa.address_id = '&NEW:ADDRESS_ID'; If LENGTH(v_data8) > '35' Then Error_SYS.Record_General('Attention', ' Bankaddress Line 2 can only consists of 35 characters'); End If;COMMIT;end; Thank you and kind regards.
Hi, the use of parameters in Lobby elements are described in the Technical Documentation for IFS Cloud. https://docs.ifs.com/techdocs/21r2/060_tailoring/220_configuration/100_lobby_configurations/020_page/ I hope this helps. Hi,is that for IFS Cloud only? Thank you
No, similar concept is available in Apps 10 as well. I see. Thank you.
Hi @Link, Could you please let us know the use case? For an example, to create a custom field, event action etc. A little bit more details about what you are trying to do would help. Thanks! Hi Charith,yes, I want to create an custom event. With this event I want to prevent enter more than 35 characters in a text field. If a user want to enter more than 35 characters in a text field then the event should shows an error message while saving the object. Thank you and kind regards
Already have an account? Login
No account yet? Create an account
Enter your 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.
