Hi,
I was able to create my first connection object and I had to create my own transformation method, following guidelines found in OpenIFS forum.
When I tested it (with the Test transformation option ) , I got a successful status.
But it does not work on the target LU.
What is the best way to debug this problem ? Haven’t found anything in the Debug console.
Thanks
Michael
Best answer by Mathias Dahl
Hi,
The plot thickens, as they say… This makes no sense. One explanation would be that your rule, or the transformation method, is not run/used (if that is the case, I would not understand why...).
I think I have found a way for you to check what the OCT framework returns, for your objects. Here is an example that I just tried:
select * from table (doc_reference_object_api.Get_Key_Refs('ShopOrd', 'ORDER_NO=200142^RELEASE_NO=*^SEQUENCE_NO=*^'));
Above, replace the lu name and keyref with the one for your target object and see what is returned. For me, this data is returned:
SRC_LU_NAME TRANS_SRC_LU_NAME KEY_REF READ_
------------------ -------------------- ----------------------------------------------- -----
ShopOrd Shop Order ORDER_NO=200142^RELEASE_NO=*^SEQUENCE_NO=*^ FALSE
EngPartRevision Engineering Part Rev PART_NO=5000^PART_REV=^ TRUE
PartRevision Part Revision CONTRACT=501^ENG_CHG_LEVEL=1^PART_NO=5000^ TRUE
(sorry about the formatting, if you copy and paste it someplace it may look better)
If the query above works for you, that is it returns some data, you can add some debug/trace statements in your transformation method to see if the code actually runs. Don’t forget to enable server output.
Good luck!
/Mathias
+6…
Above, I *think* two of the keys actually have the *value* “*”, but that is just a guess. Some objects allow it, I think.
As for your idea: perhaps. The risk, of course, is that you get multiple hits in the “source” if you do not specify all the keys. In some cases it will work, in others, it won’t.
Of course, we do support multiple hits, but only when you write a PL/SQL method/function to do the transformation.
When would you want this?
...
Thanks for your quick response, Mathias!
You are right, it seems the two keys actually have the value “*” after having tested this a little bit more.
Still it would be great if the idea that came from this could be an option in standard. Getting multiple hits would not be a problem (possible string overflow to be considered of course), because that is what I am looking for :)
What I would like is to be able to see all document connected to e.g. the Purchase Order Lines when having focus on the Purchase Order Header without having to make a customization.
/Erik
+32What I would like is to be able to see all document connected to e.g. the Purchase Order Lines when having focus on the Purchase Order Header without having to make a customization.
Got it! You want to avoid implementing your own transformation method. It is, per definition, of course a customization, but it is a very safe one (compared to many other types of customizations...)
+32Can you create a request on the idea wall, Erik?
+6Can you create a request on the idea wall, Erik?
Good idea! But as a customer it doesn’t seem possible to access the Idea wall. Is that correct?
+32Can you create a request on the idea wall, Erik?
Good idea! But as a customer it doesn’t seem possible to access the Idea wall. Is that correct?
It’s for consultants and partners, as I understand it (I was not sure if you are considered a partner or not). I think you can work around it by filing a case, asking nicely for this to be added. Our 2nd line support will then create the idea for you. Or you work on that partner status of yours… :-p
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
