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

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=*^ FALSEEngPartRevision Engineering Part Rev PART_NO=5000^PART_REV=^ TRUEPartRevision 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

Object connection transformation

Page 2 / 2

…

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

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.

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...)

Can 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?

Can 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

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded