Create custom metadata profile in WCC

Once logged in WCC

Navigate to
Administration->Admin Applets->Configuration Manager
Add the new field by clicking on Add...

This will prompt for:

Field Name, Field Caption, Field Type and so on...

Also you will be able to create an option list

A lot of options you will have, for example, validated, non validated lists, multiselect lists, edit and select. dependant values etc ...

Note:

The field order field will allow you tu allocate the field on the desired location on the user interface.

You must make sure that the Enable User Interface checkbox is enabled.

Custom Checkin, Create security group in WCC

Security Group

Access this screen using a browser, choose Administration, then Admin Applets, then User Admin.

Then start the applet:

1. To create a security group and assign permissions:
   

   1. From the User Admin Screen, select Security then Permissions by Group.
      The Permissions By Group Screen is displayed.
   2. Click Add Group to display the Add New Group Screen.
   3. Enter a group name and description.
   4. Click OK.
   5. Set permissions for the security group:
   1. Select the security group.
   2. Select the role to edit.
   3. Click Edit Permissions.
   4. After enabling the permissions that you want the role to have for the group, click OK to close the Permissions by Group screen

   
   

In my next post, I will show you how to creare a custom metadata profile in WCC.

See you.

Inplace upgrade, Reuse the existing OWB Home

The following steps are used to recover an existing OWB Home.

1.- Get the OWBSYS and OWBSYS_AUDIT users

Execute the following sentences:

2.- sqlplus OWBSYS/*****@OWB_HOME/owb/rtp/sql/stop_service.sql
chmod +x ./app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.pks
chmod +x ./app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.plb

chmod +x ./app/oracle/product/11.2.0/dbhome_1/owb/reposasst/upg/load_java.sql OWBSYS ***

3.- Run the following SQL statement to identify the OWB_HOME for the current installation. The rtrepos.properties file is located in the path indicated by the SERVER_SIDE_HOME of the query.

1. sqlplus OWBSYS/OWBSYS_PASSWORD
2. SELECT host_name, server_side_home from wb_rt_service_nodes s, v$instance v where s.instance_number=v.instance_number;
   HOST_NAME
   SERVER_SIDE_HOME
   yourhost_machine
   OWB_HOME

4.- For an existing repository that is installed on an Oracle 11g database (not Oracle 10g), ensure that OWB_HOME and ORACLE_SID values are pointing to the database where the repository is installed. Ensure that the PATH contains OWB_HOME/bin.

If the rtrepos.properties file is not found then:

• sqlplus owbsys/*********
• @/u01/app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.pks
  @/u01/app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.plb
  @/u01/app/oracle/product/11.2.0/dbhome_1/owb/reposasst/upg/load_java.sql OWBSYS *********
• @/u01/app/oracle/product/11.2.0/dbhome_1/owb/rtp/sql/reset_repository.sql *********

The reset_repository forces the user to register the location again using the Control Center Manager.

When the file is created START the service.

@/u01/app/oracle/product/11.2.0/dbhome_1/owb/rtp/sql/start_service.

Ce tout!

Integration FDMEE with ERP Fusion

Recently, I was asking to integrate FDMEE with ERP Fusion using the WSDL,

using the FusionCloudAdapter.sh and FusionCloudAdapter.py.

The ODI Log throws the following exception:


2017-10-11 13:20:36,490 ERROR [AIF]: Error in initializeFsGLCloudSource.
2017-10-11 13:20:36,491 FATAL [AIF]: Error in initializeFsGLCloudSource
Traceback (most recent call last):
  File "<string>", line 451, in initializeFsGLCloudSource
  File "<string>", line 475, in executeFusionService
  File "<string>", line 557, in executeJythonScript
  File "/u01/hyp/hyperion/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 138, in <module>
    fusionCloudAdapter.extractCubeInformation()
  File "/u01/hyp/hyperion/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 16, in extractCubeInformation
    self.fusionCloudHelper("extractCubeInformation")
  File "/u01/hyp/hyperion/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 112, in fusionCloudHelper
    raise RuntimeError
RuntimeError

Reviewing OS Level and Application Level I realize that the file was asking about other permissions to be executable.

Solution:

chmod +x -Rf  * in the folder there the py  adapter  and the sh file es located.

Test the wsdl service located in cloud. -> Success.

Charms !