Me again! Hi!I’m not sure the best way to go about this. I tend to over-complicate things!As everyone is aware, app messages write to the FNDCN_Application_Message_TAB. For a very specific type of error, I need an email to go out and say “look at this record - it has an error”. I set up a custom API that writes those very specific messages to a new table. I can set up a scheduled task to run every hour to fill that table, and then set up an email to run when there are new records added, but that would mean getting one email per record, not per incident. One thing failing could affect dozens and dozens of records and write mass amounts of data to the table. I need a way to somehow send every message but not each in its own email.Thoughts?
I created a custom API that returns one of two values (let’s say ‘0’ and ‘1’). It needs to run every four hours. If the value is ‘0’, then an email needs to go out.While I don’t need help with creating the database task and scheduling it to run, I don’t know how to then get an email to send. Do I make an Event? If so, how do I tie it to the scheduled task? Do I do something else??Let’s assume the Scheduled Task is named “Neraks_Amazing_Task”.Thanks!
I’m attempting to set up Crystal Reports 2016 so I can connect to the IFS Oracle database (Apps 9). I’m using Oracle Client 12. Firstly, I have not seen anyplace where it is specified the normal tnsnames.org file location for Oracle Client 12. Everything says “ORACLE_HOME” (which I understand means whatever the home directory is not a directory literally named “ORACLE_HOME”) /network/admin. There is no network OR admin folder in the Oracle directory. To use SQL Developer, I don’t need that anyway, because I can just directly load a tnsnames.ora file. But then Crystal reports… I have googled seven ways from Sunday and cannot figure out how the heck to associate the TNS file with Crystal Reports. When I go to “Database Expert”, I have an option for “Oracle Server”, but no matter what values I use (and I know they’re the correct values b/c I can connect with them in SQL Developer), I can’t connect. No one here is very savvy at this so there is no one I can ask. Help! Thank you!
Hello! We’re looking to start using the SOX tools built-in with Apps 9. We work in the US Defense Industry. Anyone got anything that could help out? I have some documentation, but it’s for Apps 10. I didn’t know if people had set ups already that they’d be willing to share. -Kay
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.