OK, but could you somehow create the event in a way where that is possible?
Could you please explain how I could access the EVENT_DATA_ in my pl/sql event action ?That would be very helpful.BR Kresten
Thanks.I’ll take a look at that.BR Kresten
I’m testing this with an admin access user, so permission should not be an issue. @infaz: yes the query does return a name.BR Kresten
Sure all questions are more that welcome!Everything has been reloaded.The field does show up in the field list and as a colum in the window,but the window doesn’t retrieve data from _CFV .Here is the select:select Code_C_Cfp.Get_Cf$_Person_Name(Authorize_Comb_Finance_API.Get_Code_Part_Text('1', 'CODEC', '8010')) from dualParameters: v.COMPANY, v.CODE_CI tried with this as well but same result:select 1 from dual where :code_c is not nullParameter: v.code_c
Yes I did.
That’s very usefull. Thanks!
How do you access the entries? I can’t find them in the database.
Hi Kevin,This sounds very interesting but I can’t follow what you do.Is it possible to find the profile layout somewhere in the database?That could make it possible to setup scheduled backup of profiles.BR Kresten
Thanks. I’ll try that.It’s not used at all.
Hi,Did you find a solution to this?Debugging doesn’t show anything at all on exporting profiles.Could we locate to profile as a file somewhere on the server ?Vh. Kresten
I can do cool stuff with that. Thanks!
I ended up using Customer Invoices Analysis.
That is fair. I’ll ask IFS. BR Kresten
That’s very interesting.No reason is given? Why would this LU be excluded and could I break anything trying to remove that row?BR Kresten
It turned out that the problem was that the negative line I made had a different Currency and therefore was not included in the invoice.BR Kresten
I finally got to run the automatic transaction by unmatching transactions from pl/sql.I still can’t make anything match automatically.I tried with a new cashbook.The transactions are matching on amount, date and currency, but when automatic transaction matching runs nothing happens.What am I missing?
Thanks!
Thanks!This looks like debug info.I just had to run the debugger from the employee window.BR Kresten
The debugger doesn’t return anything usefull when connecting a pic manually.So I don’t know if there is an API to to use.
So simple ! Brilliant!
That is a good workaround, but I’m looking for a way to check if a row is locked before I try to do operations on that row.
It would be occasional and for most part on custom methods.
This i good code. Thanks!Your blog is interesting reading every time.I remember you promissed a blogpost about creating Java_Class transformers in IFS someday. Is that day comming up anytime soon?
Thanks! I’ll try that.You wrote a guide on how to to create XML from PLSQL with DBMS_XMLDOM. I’ll take that approch.(https://dsj23.me/2019/09/18/how-to-use-dbms_xmldom-to-create-xml-from-pl-sql/) I need to add this Custom XML to an application_message.I have these two procedures to help me.application_message_api.New__ and message_body_api.New__ First I use application_message_api.New__ to create a new message.It returns the error “Message '100000000000002' has no body”So I useI run your code from “How to use DBMS_XMLDOM to create XML from PL SQL” to get a CLOB element to use in the body.Then I use message_body_api.New__ to create the body for the message adding th CLOB element. But, the new body has no CLOB data, and the application message gives the same error: “….has no body”I’m doing this wron obviously, and I not even started adding the file.I hope you can guide me a bit further.
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.
