What parameters are you passing in to the custom menu? Have you put any of them in quotation marks turning them into characters?
If you have the Database Task ‘Aggregate Inventory Transactions per Period’ scheduled you can go back to the end of the previous financial period (usually month) by looking in the screen ‘Inventory Value per Period’.If you have a recurring requirement to look back at stock positions on a more granular level I would create an IAL which you schedule to ‘Copy Only New Data’ at a frequency that suits your needs.
My guess would be that you are not passing in a date value into the method you are calling. Have you managed to run through the code in SQL developer successfully?
Hi Srikanth,Thank you for your answer. I’m afraid I am still a little bit confused as this is all new to me. Are you saying that I need to run the ‘IFS Applications Installer’ to check if I have SSL certificates installed? And if I understand you correctly I need either a celf-signed or SSL cert for all the interfaces in your illustration?Thank you in advance.
The only thing that helped us in the end was to upgrade to Oracle 19.
In the first instant I have let’s say the following assignment. I log in as USER7 and get the error message.Funct Role PC_SUP_INV_SA → End User Role PC_TEST_EUR2 → User USER7 Without changing any details of the functional role I change to thisFunct Role PC_SUP_INV_SA → End User Role PC_TEST_EUR4 → User USER5 When I log in as USER5 i no longer get the error message.The end user roles doen’t have any database objects or presentation objects granted to them. The end users only have FND_CONNECT and the Test end user roles assigned.
I am using specific test end users which have nothing but FND_CONNECT and the test end user role assigned. They definitely don’t have the API granted through something else...
Thanks for your reply GPIE. The thing with the errors we are getting is that they are false. We have verified that all relevant API’s and methods are granted. This is proven by the fact that the permission set works without error by simply assigning it to another end user role and user. We don’t have to make any amendments to the functional permission set.
Hi Julian, Thanks for your response. We have only just tried the re compilation so to early to say if it has offered a permanent fix. Up until now it has been intermittently been appearing over a period of 6 months across 3 different databases… We are soon planning to upgrade to Oracle 19, maybe that will help.
Hi Savinda, Thanks for your reply. What version of Oracle are you using? Regards, Erik
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.