My Oracle Support Banner

Implicit Join Missing After Doing Full Migration Or Incremental Migration (Doc ID 2614954.1)

Last updated on MARCH 17, 2022

Applies to:

Siebel CRM - Version 18.8 to 21.6 [Release V17]
Information in this document applies to any platform.


    The implicit join is missing after doing Full Migration or Incremental Migration


          Steps To Reproduce

  1. Created a custom extension table based on Siebel base table S_SRC.
  2. Created a custom column "TEST" in the custom extension table.
  3. Click the Apply button in the Table section of Siebel Tools.
  4. Created a Custom field in the BC "Campaign" based on the extension table using implicit join.
  5. Exposed the new field in the Campaign List Applet.
  6. Delivery the changes to the Repository.
  7. In the Source environment login into the Application and Navigate to the Campaign List Applet
  8. Create a new record in the Campaign List Applet and add value in the new field based on the extension Table.
  9. The new field in the Source environment is editable.
  10. Logout of the Application in the Source environment.
  11. Do a Full Migration or Incremental Migration from Source to Target environment.
  12. In the Target environment logged into the Application and Navigated to the Campaign List Applet.
  13. The new field in the Campaign List Applet based on the column from the extension table is read-only and uneditable.
  14. The SQL that is generated from the List Applet does not show the implicit join to extension Table





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.