SQL Data Control Task Flow Form Created From WebCenter Portal is Not in Read-Write Mode.
Last updated on MARCH 08, 2017
Applies to:Oracle WebCenter Portal - Version 18.104.22.168.6 and later
Information in this document applies to any platform.
When trying to create a SQL Data Control Form using UI Components and then adding the Task Flow to a page, the form data is static.
The Submit button is there, but the values cannot be changed. It is displayed as Read-Only, even though the form was created as read/write.
The following steps demonstrate the problem:
1. Login into the database to the dev_webcenter schema
2. Create "test" table with data:
a. create table test ( col1 varchar2(20));
b insert into test (col1) values ('test1');
3. Login to WebCenter Portal
4. Administration - Shared Assets - Data Control
5. Create Data Control :
a. Name: testDC (of type SQL)
b. Data Source: WebCenterDS
c. select * from test
e. Make it available (tick Available checkbox)
6. Create a Portal and add Data Control to catalog
a. Create Portal
b. Administor Portal - Assets - Resource Catalogs - Copy of Default Portal Catalog
c. Make the new "Copy of Default Portal Catalog" catalog available
d. Edit "Copy of Default Portal Catalog"
e. Add from Library: testDC
f. Administor Portal - Settings : Change Resource Catalog for Pages: "Copy of Default Portal Catalog" , Save
7. View Portal and Edit Page
8. a. Open testDC , Drag testDC to Page.
b. Pop-up appears: select Form.
c. In the "Create Form" window, there are 2 options , Form and Read-Only Form. Select Form
d. "Include Submit Button"
e. Create and Save Page
9. View Page and notice nothing can be changed and submitted
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms