SQL Data Control Task Flow Form Created From WebCenter Portal is Not in Read-Write Mode. (Doc ID 2014375.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle WebCenter Portal - Version 11.1.1.8.6 and later
Information in this document applies to any platform.

Symptoms


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');
       c. commit

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
      d. Create
      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
     

Cause

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