SBL-DAT-00509 Error Of Inactive Table Even Though Custom 1:1 Extension Table/Table Columns Not Used in Business Component Configuration (Doc ID 2915403.1)

Last updated on JULY 20, 2023

Applies to:

Symptoms

Getting below error after creating and Inactivating the Custom 1:1 Extension Table

The issue can be reproduced at will with the following steps:

1. Create 1:1 ext table(CX_TEST_SR_X) on S_SRV_REQ table
2. Create one varchar column(TEST) under custom extension table created in step 1
3. Apply the Table
4. Create Dev Workspace
5. Query for Business Component "Service Request"
6. Query for Field Description
7. Update the Join Property = CX_TEST_SR_X
Column = TEST
In OOB Description has no join and Column is DESC_TEXT
8. Deliver the Workspace to MAIN
9. Bounce the Siebel Server
10. Login to Application
11. Navigate to Service Request List Applet
12. Create New Record and enter the required field values and put some text in Description field as well even though it is Mandatory
13. Save the Record and Delete the record
14. Login to Tools
15. Inactivate the Table CX_TEST_SR_X and Apply the Table changes
Create Dev Workspace
16. Query for Business Component "Service Request"
17. Query for Field Description
18. Remove the Value from Join Property and update the Column to DESC_TEXT
19. Deliver the Workspace to MAIN
20.  Bounce the Siebel Server
21. Login to Application
22. Navigate to Service Request List Applet
23. Create New Record and enter the required field values and put some text in Description field as well even though it is Mandatory
24. Save the Record
No Issues after this step
25. Delete the record
Here it will throw an error

Changes

Cause

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