Skip to main content
Solved

Can't connect custom reference field as parent key connection when creating custom tabs

  • Oct 27, 2021 2:47 PM UTC
  • 4 replies
  • 453 views
Hero (Partner)
Forum|alt.badge.img+15

Hi All,

I have created a Custom Logical Unit and wanted to connect it with Support Key window. The requirement is connecting Customer ID and Support Key Description fields as keys.

In Custom LU, Customer ID field is a reference type field and using same LOV reference which is using in Support Key window’ customer No field.

When I try to create a new tab, it doesn’t show the Customer ID field (CF$_CUSTOMER_ID) in list, so I tried to manually write the field name in order to see the error message. Then I got this error :

ORA-20105: The connected key CF$_CUSTOMER_ID is a custom reference and cannot be used in a parent key connection.

How should I create the Customer ID field in Custom LU?
Should it be a Text Type Persistent field without any reference?
Please advise me.

Best answer by sutekh137

Yes, I would guess it needs to be Persistent, otherwise the linking of keys could be sort of circular.

I see what you are trying to do, though -- try the custom field as Persistent and see if that works…

 

Thanks,

Joe Kaufman

View original
This topic has been closed for replies.

4 replies

Hero
Forum|alt.badge.img+12
  • sutekh137
  • Hero
  • Answer
  • Oct 27, 2021 3:00 PM UTC

Yes, I would guess it needs to be Persistent, otherwise the linking of keys could be sort of circular.

I see what you are trying to do, though -- try the custom field as Persistent and see if that works…

 

Thanks,

Joe Kaufman

Just because something is part of a plan doesn't make it right.
    Hero (Partner)
    Forum|alt.badge.img+15
    • MitDenukN
    • Author
    • Oct 28, 2021 10:42 AM UTC

    I could do this by creating persistent Text type custom field.


    And I assume the users will only try to add details from connected custom tab. 

    Users won’t find a LOV for customer ID, if they try to insert data directly from Custom LU.

     

    Thank you.

    Hero
    Forum|alt.badge.img+12
    • sutekh137
    • Hero
    • Oct 28, 2021 11:59 AM UTC

    I could do this by creating persistent Text type custom field.


    And I assume the users will only try to add details from connected custom tab. 

    Users won’t find a LOV for customer ID, if they try to insert data directly from Custom LU.

     

    Thank you.

     

    Yes, that sounds like the way it should be implemented.

    I assume it worked?

     

    Thanks,

    Joe Kaufman

    Just because something is part of a plan doesn't make it right.
    Hero (Partner)
    Forum|alt.badge.img+15
    • MitDenukN
    • Author
    • Oct 28, 2021 12:00 PM UTC

    Thanks @sutekh137 , yes it worked 

      Terms & ConditionsAccessibility statement