- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
Search

Replies posted by carlosfmendes

30 Replies

Oldest first

Newest first

carlosfmendesSidekick (Customer)

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

Inventory Part Revision on Product Structure Revision

Hi @carlosfmendes , I’m assuming by the mutating error you are referring to the ORA-04091 error. In that case, the possible cause would be that you are trying to both select and update the IFSAPP.PART_REVISION table in a row level trigger. You could maybe try using a compound DML trigger and see if it works.https://docs.oracle.com/database/121/LNPLS/triggers.htm#LNPLS99888 Hope this helps! Regards, Malindu Hi Malindu,Yes, you are correct, however the error is on top of a Custom Event in IFS, as I am not doing anything directly on the Oracle database.This is why I ask, if there is a workaround within IFS?Thanks,Mendes

carlosfmendesSidekick (Customer)

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

Inventory Part Revision on Product Structure Revision

Hi @carlosfmendes , I believe the below post might contain the answer you are looking for: Can you try your custom event again by utilizing PRAGMA AUTONOMOUS_TRANSACTION; ? Regards, Malindu If I understand correctly, this makes an autonomous and asynchronous transaction, correct?I can see this might work, as the trigger is AFTER creation, and not on any CHANGE or REMOVAL.So I need the new row created, to then update the fields on this newly created row. However at the moment, I have the problem that I need to get the OBJID and OBJVERSION of the recently created row at the beginning of the custom event, however the SELECT statement returns no OBJID and OBJVERSION, so I assume it is not yet created, even though the custom event is for AFTER creation.Does this have anything to do with this change, to do put PRAGMA AUTONOMOUS_TRANSACTION?

carlosfmendesSidekick (Customer)

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

Inventory Part Revision on Product Structure Revision

Hi @carlosfmendes , You can make you sql into a string and the execute it as a background job. See this: https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/how-to-create-a-defered-job-to-execute-modify-1757 Hi @Hans Andersen,Thanks for the tip.It worked like a charm!

carlosfmendesSidekick (Customer)

asked in Finance (Financials)

Instant Invoice Tax Code

For some reason the creation of the post generated 161 attachments, when I only added 3…

carlosfmendesSidekick (Customer)

asked in Finance (Financials)

Instant Invoice Tax Code

Hi @Narmada , We have no value in that tab for any address for this customer.We do have values in the Tax Free Tax Codes, however they are also not the ones that appear by default (attached image). So where exactly does IFS choose the Tax Code from?I tested removing the “Taxable” check box from the Sales Object, and with that, the tax code from the Sales Object is correctly selected. Now my doubt is, if not taxable, how exactly would that influence the calculations, if the tax code’s percentage is not Zero? Is this possible, for the Sales Object to be not taxable, but with a tax code having a percentage different from 0? Thanks in advance,Carlos Mendes

carlosfmendesSidekick (Customer)

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

Cancelled Order Lines

Thank you @madusankadasanayake and @NickPorter for your replies.I will research your suggestions further and test them.

carlosfmendesSidekick (Customer)

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

Payment Term in Customer Agreement

Hi @Bhagya Wickramasinghe , I used a reference to create the Payment Term custom field (images below).The problem is, that this way I can’t filter payment terms by the company of the customer agreement, it shows all payment terms of all companies, and I would like to avoid this to prevent errors.

carlosfmendesSidekick (Customer)

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

Payment Term in Customer Agreement

@Tracy Norwillo , I clicked the Best answer instead of Like. Tried the solution, however the “Use Saved Search” is greyed out.Any reason why?

carlosfmendesSidekick (Customer)

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

Payment Term in Customer Agreement

@carlosfmendes In your Payment Term (Com - PayTerm) window, to the right of the Saved Searches: can you see the Saved Search you created? In your screen-shot it’s currently showing “[Previous Search]” Ah yes... I wasn’t thinking that I had to create a saved search myself, for it to appear in the properties window.Created it, changed the where clause and its working like a charm, fantastic!Thanks for the help!Have a nice weekend!

carlosfmendesSidekick (Customer)

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

Script to email almost expired IFS password

@Sajith D , thank you very much for your help and suggestion!I ended up doing what you said, only changing the background job that launches the event, as Heavy Cleanup runs 3 times a day in our case, so I ended up using a background job we created for a quick report, that runs daily. Just a question, will this action be a problem when we get updates or deliveries, considering it runs on a standard event, and not a custom event?Could it be deleted upon updates?

carlosfmendesSidekick (Customer)

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

Script to email almost expired IFS password

@Sajith D , I’m not worried about the event, but with the “custom” actions” I will associate with the event over time.However, like you say, I don’t see any problems, however I keep a copy of all code, so no problem. Thanks for your help!Cheers

carlosfmendesSidekick (Customer)

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

Limit IFS options box permissions

Hi @carlosfmendes , Please try revoking the “GUI Settins - Theme configuration in options dialog” permission for this. You can find this permission under “IFS Base Functionality” node in Presentation Objects by Module tab, which can be found in New Permission set window. Hope this helps! Hi @Charith Epitawatta, Thanks for your help!Was exactly what was needed and even ended up changing some other accesses in the Options Tab. Cheers,Carlos Mendes

carlosfmendesSidekick (Customer)

asked in Finance (Financials)

Customer Document Tax Supply Country

Hi @Ralph Gericke, First of all, thanks for the explanation! I understand the logic you wrote, and can now see an example for having different delivery countries for the same address and therefore have different tax numbers, if we consider the document address is only to receive the document and the invoicing is to be done on the delivery country. However, I still don’t understand how we can have different supply countries for the same address and have the possibility to have different tax numbers? Are you able to think of an example? Thanks in advance,Carlos Mendes

carlosfmendesSidekick (Customer)

asked in Finance (Financials)

Customer Document Tax Supply Country

Yes, we have different sites in different countries, so I understand the concept of having different supply countries. What I don’t understand is, if we supply to one delivery address, is it possible for the tax number of the customer to change, depending on supply country?That for me doesn’t make sense, however that is what I assume the tab allows as a possibility? Or are you saying that the only example, is when the vat number is mandatory, or not, depending on the supply country and the delivery address?

carlosfmendesSidekick (Customer)

asked in Finance (Financials)

Customer Document Tax Supply Country

Hi @Ralph Gericke, Thanks for your help! Cheers,Carlos Mendes

carlosfmendesSidekick (Customer)

asked in Finance (Financials)

Error with M30 posting

Hi @cperdue and @Adam Bereda, Thanks for your input. I added that is was an non inventory part, because I could see that it could be relevant.We don’t always want to use preposting, it is only for specific cases of non inventory parts.Inventory Parts are all configured in Posting Control without preposting. What I don’t understand, and from what you wrote Adam, is that even though I put values in preposting, those values need to exist in the M30 posting rule? Did I understand correctly?If so, what is the purpose of having preposting, if you then need those values to exist in the posting rules anyway?I apologize if I misunderstood. Thanks in advance,Carlos Mendes

carlosfmendesSidekick (Customer)

asked in Finance (Financials)

Error with M30 posting

Thanks once again for your input @Adam Bereda and @cperdue. The last answer from Adam is what worked, as with a default value when no control type value exists, it uses the value from preposting, if it exists. If no value from preposting exists, and there is no match in the details of the posting, it uses the default value when no control type value exists. Thank you very much for your help!

carlosfmendesSidekick (Customer)

asked in Finance (Financials)

Instant Invoice Tax Code

Ok, was able to understand what IFS does.If the Instant Invoice Tax Liability is: Exempt Checks the taxable field of Sales Part Taxable (different from Tax Liability) Gets the Tax Code from Customer / Address / Delivery Tax Information / Supply Country / Taxes. Non Taxable (same as Tax Liability) Gets the Tax Code from the Sales Part. Tax Checks the taxable field of Sales Part Taxable (same as Tax Liability) Gets the Tax Code from the Sales Part. Non Taxable (different from Tax Liability) Gets the Tax Code from Customer / Address / Delivery Tax Information / Supply Country / Tax Free Tax Codes.

carlosfmendesSidekick (Customer)

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

Application Messages Errors - Scheduling System Data USERS

Unless you use the PSO function of the system, this is not needed and can remain disabled. In recent IFS versions this seems to be enabled by default even when you don’t use it and haven’t configured it, which is the error you are seeing with the URL. Nick @NickPorter , thanks for the feedback. And how do I avoid error #2?What more do I need to disable, besides the Routing Rule?

carlosfmendesSidekick (Customer)

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

Application Messages Errors - Scheduling System Data USERS

You just need to disable the Scheduled System Task for the PSO job, which will be something like “PSO Integration [USERS]”. If it doesn’t run then it doesn’t matter what the routing rules etc are configured like (or not configured) Nick For some reason I wasn’t finding anything in the tasks with %PSO%, but now I have found it and disabled it.Hopefully after the weekend , we can already see some results, with very few errors!Thanks very much for you help!

carlosfmendesSidekick (Customer)

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

Could not load file or assembly

Thank you to all for your feedback.Clearing the 2.0 folder it is! 😁

carlosfmendesSidekick (Customer)

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

Database access

Thanks @Sajith D for your suggestion. I created the new permission set, but didn’t give FND_RUNTIME.Gave access through DB permissions and all is working so far.

carlosfmendesSidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

Track a lot when issued

Solved with a custom field on Lot Batch Master, which saves the user email.When the lot is issued, a custom event is triggered which then sends an email if the above field is inserted.

carlosfmendesSidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

Track a lot when issued

Thanks for coming back and letting us know! No problem.I think its important for a community like this one to share problems and solutions, when encountered.

carlosfmendesSidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

Track a lot when issued

@carlosfmendes if you wanted to do this using standard functionality and no custom fields, could you use a subscription on the Inventory Part in Stock line? Hi @AntOlivFr, I don’t know the answer, as that is why I created this thread. 😊However, aren’t subscriptions for oracle objects within IFS?Not sure, but from what I know this is the case, correct? 🤔In this instance, what I want to do is track a certain value of a certain field in a certain table, not an object itself.Just a correction, if the subscription actually works in this case, it couldn’t be on Inventory Part In Stock, because I need to know the transaction code, as I only want to know when a lot is issued.Thanks for your feedback!

1
2

Page 1 / 2

Badges

carlbhas earned the badge 1st Topic
mghahas earned the badge 1st Topic
VirajWhas earned the badge 5th Reply
Yasanthy Kanagarajhas earned the badge 1st Topic
BETDANBhas earned the badge 1st Topic

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login as an IFS Employee

or

Username (Do not use your email as a username.) *

Email Address (Use your work email address.) *

Name *

Company *

Account Number

(Private)

Only you and moderators can see this information

Job Title *

Member Type *

IFS Employee IFS Partner IFS Customer Just Visiting

Products Used

(Private)

Only you and moderators can see this information

IFS Cloud IFS Applications FSM PSO Maintenix Fleet Planner Alliance FieldCentrix assyst MWM Other

Country

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login as an IFS Employee

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK