Skip to main content
Solved

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

  • October 27, 2021
  • 4 replies
  • 363 views

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
Did this topic help you find an answer to your question?
This topic has been closed for comments

4 replies

Forum|alt.badge.img+12
  • Hero
  • 217 replies
  • Answer
  • October 27, 2021

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


Forum|alt.badge.img+15
  • Author
  • 276 replies
  • October 28, 2021

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.


Forum|alt.badge.img+12
  • Hero
  • 217 replies
  • October 28, 2021
MitDenukN wrote:

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


Forum|alt.badge.img+15
  • Author
  • 276 replies
  • October 28, 2021

Thanks @sutekh137 , yes it worked 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings