Creating Data Control & Task flow in Webcenter Portal Builder

Prerequisite – Webcenter portal and Webcenter Spaces should be installed and there schemas as well.

Database should be installed in database. For this sample demo –I created sample tables in Webcenter schema .

You can connect to database using creating new connection

→ Please find attached script and execute in the database.

→ Open the link – http://localhost.silbury:8888/webcenter (Might be localhost for you)

→ Go to Shared Asset

→ Go to Data Control – Create

→ Click continue.

→ Select WebCenterDs – enter password- enter sql query as below in screenshot

→ Click Create.And make available for using in catalog .

→ Now Click on Taskflow -Create

→ Make task flow available

→ Click on Edit and Integration

→ Click open Data Control

→ Click Open EmployeeDC

→ Add Employee DC

→ Click On as Table

→ Click on default next and then create. Table will be there in Taskflow. Click Save then Close.

→. Now click on Portals on top Menu -< Create Portal

->Click Create

→ Click View your portal

→ Edit you page as below to add content

→ Click Open on UI components

→ Click Open On task Flows

→ Add Employees and save.

→ Click Save and then click on View Portal

→ This is final portal

→ Can Create more page like this.

→ If you want to navigate back to Data control or change query or add new task flow -click on edit page then Administer Portal

→ There you can edit data control and task flows.

Watch Video here

Happy learning with Vinay Kumar

Fixed- No service defined for COLLECTION_GET_ADMIN_MARKED_CONFIG.

When you made connection between Webcenter portal and Webcenter content and you got error like this

oracle.stellent.ridc.protocol.ServiceException: No service defined for COLLECTION_GET_ADMIN_MARKED_CONFIG.

Don’t be afraid .Simply in order to resolve this, we need to enable folders_g in UCM and disable the FrameworkFolder if you found.Its not there in PS7.Enable component because it is not supported to have them both enabled at the same time.

Login to UCM with an admin user and select Admin Server in the administration section:

Select Component Manager on the left hand side and click on advanced component manager to have more control. In the basic component manager, the folders_g component is not listed so we need to go the advanced manager

In the Enabled Components list, select FrameworkFolders and disable it.From the disabled list, select folders_g and enable it.

Now restart UCM server.

Happy Learning with Vinay Kumar in techartifact….

Fixed for error – Oracle not available Shared memory realm doesnot exist

Requirement- While installing Webcenter 11.1.1.8 ,every time i start linux image , i got this weird error.

I already updated ORACLE_SID and ORACLE_HOME in listener.ora
Now what.If you are not a dba, this error can give you trouble for while.

Solution- Go to Oracle_home/product/11.1.2/dbhome_1/bin
-> type ./sqlplus
-> In user write as conn / as sysdba
-> password – enter password for sys.
-> then type these command

startup nomount;
it will show following message

It shows the message

ORACLE instance started.

Total System Global Area 113246208 bytes

Fixed Size 787708 bytes

Variable Size 61864708 bytes

Database Buffers 50331648 bytes

Redo Buffers 262144 bytes

-> alter database mount;

-> alter database open;

happy installing with Vinay in techartifact…