Tuesday, November 3, 2015

COAMGMT Apply Updates

    RM_VERSION_PROP.IDXPROPVER02
    RM_WF_MODEL.IDXWORKFLOWMODEL01
    RM_WF_MODEL_STAGE.IDXWFMODELSTAGE01
    RM_WF_REQUEST.IDXWFREQUEST01
    RM_WF_REQUEST.IDXWFREQUEST02
    RM_WF_REQUEST.IDXWFREQUEST03
    RM_WF_REQUEST.IDXWFREQUEST04
    RM_WF_REQUEST.IDXWFREQUEST05
    RM_WF_REQUEST.IDXWFREQUEST06
    RM_WF_REQUEST_ACTIVITY.IDXWFREQUESTACTIVITY01
    RM_WF_REQUEST_ACTIVITY.IDXWFREQUESTACTIVITY02
    RM_WF_REQUEST_ASSIGNED_TO.IDXWFREQUESTASSIGNEDTO01
    RM_WF_REQUEST_ASSIGNED_TO.IDXWFREQUESTASSIGNEDTO02
    RM_WF_TASK.IDXWORKFLOWTASK01

  Adding primary keys ...

    DAL_SEQUENCE.PK_DALSEQUENCE
    DAL_UPDATES.PK_DALUPDATES
    RM_ACCESS_GROUP_CTRL_HIER.PK_RMACCESSGROUPCTRLHIER
    RM_ACCESS_GROUP_DEFINITION.PK_RMACCESSGROUPDEFINITION
    RM_ACCESS_GROUP_PROP_GLOBAL.PK_RMACCESSGROUPPROPGLOBAL
    RM_ACCESS_GROUP_PROP_LOCAL.PK_RMACCESSGROUPPROPLOCAL
    RM_ACCESS_GROUP_USER.PK_RMACCESSGROUPUSER
    RM_BLENDER.PK_RMBLENDER
    RM_BLENDER_DEFAULT_PARAM.PK_RMBLENDERDEFAULTPARAM
    RM_BLENDER_HIERARCHY_SET.PK_RMBLENDERHIERARCHYSET
    RM_BLENDER_PROPERTY_LIST.PK_RMBLENDERPROPERTYLIST
    RM_BLENDER_PROPERTY_LIST_ITEM.PK_RMBLENDERPROPERTYLISTITEM
    RM_BOOK.PK_RMBOOK
    RM_BOOK_DEFAULT_PARAM.PK_RMBOOKDEFAULTPARAM
    RM_BOOK_ITEM.PK_RMBOOKITEM
    RM_CATEGORY.PK_RMCATEGORY
    RM_CATEGORY_USER.PK_RMCATEGORYUSER
    RM_COMPARE.PK_RMCOMPARE
    RM_COMPARE_DEFAULT_PARAM.PK_RMCOMPAREDEFAULTPARAM
    RM_COMPARE_ITEM.PK_RMCOMPAREITEM
    RM_CONFIG_INFO.PK_RMCONFIGINFO
    RM_CONNECTION.PK_RMCONNECTION
    RM_CONNECTION_ALLOWED_TABLE.PK_RMCONNECTIONALLOWEDTABLE
    RM_DERIVED_PROPERTY.PK_RMDERIVEDPROPERTY
    RM_DERIVED_PROPERTY_PARAM.PK_RMDERIVEDPROPERTYPARAM
    RM_DOMAIN.PK_RMDOMAIN
    RM_DOMAIN_NODE.PK_RMDOMAINNODE
    RM_DOMAIN_VALIDATIONS.PK_RMDOMAINVALIDATIONS
    RM_DOMAIN_VERSION.PK_RMDOMAINVERSION
    RM_ENGINE_INFO.PK_RMENGINEINFO
    RM_EXPORT.PK_RMEXPORT
    RM_EXPORT_COLUMN.PK_RMEXPORTCOLUMN
    RM_EXPORT_DEFAULT_PARAM.PK_RMEXPORTDEFAULTPARAM
    RM_EXPORT_NODE.PK_RMEXPORTNODE
    RM_EXPORT_NODE_PROP.PK_RMEXPORTNODEPROP
    RM_EXPORT_PARAM.PK_RMEXPORTPARAM
    RM_EXPORT_TYPE.PK_RMEXPORTTYPE
    RM_GLYPH.PK_RMGLYPH
    RM_HIERARCHY.PK_RMHIERARCHY
    RM_HIERARCHY_GROUP.PK_RMHIERARCHYGROUP
    RM_HIERARCHY_PROP.PK_RMHIERARCHYPROP
    RM_IMPORT.PK_RMIMPORT
    RM_IMPORT_CLASS.PK_RMIMPORTCLASS
    RM_IMPORT_DEFAULT_PARAM.PK_RMIMPORTDEFAULTPARAM
    RM_IMPORT_PARAM.PK_RMIMPORTPARAM
    RM_IMPORT_SECTION.PK_RMIMPORTSECTION
    RM_IMPORT_SECTION_COLUMN.PK_RMIMPORTSECTIONCOLUMN
    RM_IMPORT_SECTION_COLUMN_HIER.PK_RMIMPORTSECTIONCOLUMNHIER
    RM_IMPORT_SECTION_COLUMN_PARAM.PK_RMIMPORTSECTIONCOLUMNPARAM
    RM_IMPORT_SECTION_PARAM.PK_RMIMPORTSECTIONPARAM
    RM_IMPORT_TYPE.PK_RMIMPORTTYPE
    RM_JOB_HISTORY.PK_RMJOBHISTORY
    RM_JOB_HISTORY_RESULT.PK_RMJOBHISTORYRESULT
    RM_MERGE_LOG.PK_RMMERGELOG
    RM_NODE.PK_RMNODE
    RM_NODE_MERGE.PK_RMNODEMERGE
    RM_NODE_PROP_GLOBAL.PK_RMNODEPROPGLOBAL
    RM_NODE_PROP_LOCAL.PK_RMNODEPROPLOCAL
    RM_NODE_TYPE.PK_RMNODETYPE
    RM_NODE_TYPE_PROPERTY.PK_RMNODETYPEPROPERTY
    RM_NODE_TYPE_VALIDATION.PK_RMNODETYPEVALIDATION
    RM_NOTIFICATION.PK_RMNOTIFICATION
    RM_NOTIFICATION_DETAIL.PK_RMNOTIFICATIONDETAIL
    RM_OBJECT_ACCESS_GROUP.PK_RMOBJECTACCESSGROUP
    RM_OBJECT_ACCESS_GROUP_NAG.PK_RMOBJECTACCESSGROUPNAG
    RM_OBJECT_ACCESS_GROUP_USER.PK_RMOBJECTACCESSGROUPUSER
    RM_PROPERTY_CATEGORY.PK_RMPROPERTYCATEGORY
    RM_PROPERTY_CONSTRAINT.PK_RMPROPERTYCONSTRAINT
    RM_PROPERTY_CTRL_HIER.PK_RMPROPERTYCTRLHIER
    RM_PROPERTY_DEFINITION.PK_RMPROPERTYDEFINITION
    RM_PROPERTY_LIST.PK_RMPROPERTYLIST
    RM_PROPERTY_LOOKUP.PK_RMPROPERTYLOOKUP
    RM_PROPERTY_PARAM.PK_RMPROPERTYPARAM
    RM_PROPERTY_QUERY.PK_RMPROPERTYQUERY
    RM_QUERY_CRITERIA.PK_RMQUERYCRITERIA
    RM_QUERY_DEFAULT_PARAM.PK_RMQUERYDEFAULTPARAM
    RM_RELATIONSHIP.PK_RMRELATIONSHIP
    RM_REQUEST.PK_RMREQUEST
    RM_REQUEST_ITEM.PK_RMREQUESTITEM
    RM_REQUEST_VERIFICATION.PK_RMREQUESTVERIFICATION
    RM_ROLE.PK_RMROLE
    RM_ROLE_PERMISSION.PK_RMROLEPERMISSION
    RM_SCHEDULED_TASKS.PK_RMSCHEDULEDTASKS
    RM_SESSION_INFO.PK_RMSESSIONINFO
    RM_SYSTEM_PREFERENCE.PK_RMSYSTEMPREFERENCE
    RM_TRANSACTION_HISTORY.PK_RMTRANSACTIONHISTORY
    RM_USER.PK_RMUSER
    RM_USER_PROP_HIERARCHY.PK_RMUSERPROPHIERARCHY
    RM_USER_PROP_VERSION.PK_RMUSERPROPVERSION
    RM_USER_PROPERTY_DEFINITION.PK_RMUSERPROPERTYDEFINITION
    RM_USER_ROLE.PK_RMUSERROLE
    RM_VALIDATION_DEFINITION.PK_RMVALIDATIONDEFINITION
    RM_VALIDATION_DEFINITION_TEMPL.PK_RMVALIDATIONDEFINITIONTEMPL
    RM_VALIDATION_PARAM.PK_RMVALIDATIONPARAM
    RM_VALIDATION_PARAM_TEMPL.PK_RMVALIDATIONPARAMTEMPL
    RM_VALIDATION_PROP_HIERARCHY.PK_RMVALIDATIONPROPHIERARCHY
    RM_VALIDATION_PROP_NODE.PK_RMVALIDATIONPROPNODE
    RM_VALIDATION_PROP_VERSION.PK_RMVALIDATIONPROPVERSION
    RM_VERSION.PK_RMVERSION
    RM_VERSION_PROP.PK_RMVERSIONPROP
    RM_WF_MODEL.PK_RMWFMODEL
    RM_WF_MODEL_FILTER_NODETYPE.PK_RMWFMODELFILTERNODETYPE
    RM_WF_MODEL_STAGE.PK_RMWFMODELSTAGE
    RM_WF_MODEL_STAGE_ASSG_GROUP.PK_RMWFMODELSTAGEASSGGROUP
    RM_WF_MODEL_STAGE_TASK.PK_RMWFMODELSTAGETASK
    RM_WF_MODEL_STAGE_VALIDATION.PK_RMWFMODELSTAGEVALIDATION
    RM_WF_REQUEST.PK_RMWFREQUEST
    RM_WF_REQUEST_ACTIVITY.PK_RMWFREQUESTACTIVITY
    RM_WF_REQUEST_ASSIGNED_TO.PK_RMWFREQUESTASSIGNEDTO
    RM_WF_REQUEST_ATTACHMENT.PK_RMWFREQUESTATTACHMENT
    RM_WF_REQUEST_ITEM.PK_RMWFREQUESTITEM
    RM_WF_REQUEST_ITEM_FAIL.PK_RMWFREQUESTITEMFAIL
    RM_WF_REQUEST_ITEM_PROPVAL.PK_RMWFREQUESTITEMPROPVAL
    RM_WF_REQUEST_STAGE.PK_RMWFREQUESTSTAGE
    RM_WF_REQUEST_STAGE_APPR_GROUP.PK_RMWFREQUESTSTAGEAPPRGROUP
    RM_WF_REQUEST_STAGE_APPROVAL.PK_RMWFREQUESTSTAGEAPPROVAL
    RM_WF_REQUEST_STAGE_ENRICHED.PK_RMWFREQUESTSTAGEENRICHED
    RM_WF_REQUEST_TAG.PK_RMWFREQUESTTAG
    RM_WF_TASK.PK_RMWFTASK
    RM_WF_TASK_PROPERTY.PK_RMWFTASKPROPERTY
    RM_WF_TASK_VALIDATION.PK_RMWFTASKVALIDATION
    RM_WF_TASK_VALIDATION_PROPERTY.PK_RMWFTASKVALIDATIONPROPERTY

  Adding foreign keys ...

    RM_ACCESS_GROUP_CTRL_HIER.FK_SECGLOBDEF01
    RM_ACCESS_GROUP_CTRL_HIER.FK_SECGLOBDEF02
    RM_ACCESS_GROUP_CTRL_HIER.FK_SECGLOBDEF03
    RM_ACCESS_GROUP_PROP_GLOBAL.FK_GLOBSECNODE01
    RM_ACCESS_GROUP_PROP_GLOBAL.FK_GLOBSECNODE02
    RM_ACCESS_GROUP_PROP_LOCAL.FK_SECNODE01
    RM_ACCESS_GROUP_PROP_LOCAL.FK_SECNODE02
    RM_ACCESS_GROUP_PROP_LOCAL.FK_SECNODE03
    RM_ACCESS_GROUP_USER.FK_SECUSER01
    RM_ACCESS_GROUP_USER.FK_SECUSER02
    RM_BLENDER.FK_BLENDPROF01
    RM_BLENDER.FK_BLENDPROF02
    RM_BLENDER_DEFAULT_PARAM.FK_BLENDERDEFPARMS01
    RM_BLENDER_HIERARCHY_SET.FK_BLENDHIERSET01
    RM_BLENDER_HIERARCHY_SET.FK_BLENDHIERSET02
    RM_BLENDER_PROPERTY_LIST.FK_BLENDPROPLIST01
    RM_BLENDER_PROPERTY_LIST_ITEM.FK_BLENDPROPLISTITMS01
    RM_BOOK.FK_BOOK01
    RM_BOOK.FK_BOOK02
    RM_BOOK.FK_BOOK03
    RM_BOOK.FK_BOOK04
    RM_BOOK.FK_BOOK05
    RM_BOOK_DEFAULT_PARAM.FK_BOOKDEFPARMS01
    RM_BOOK_ITEM.FK_BOOKITM01
    RM_BOOK_ITEM.FK_BOOKITM02
    RM_CATEGORY_USER.FK_CATUSER01
    RM_CATEGORY_USER.FK_CATUSER02
    RM_COMPARE.FK_CMP03
    RM_COMPARE.FK_CMP04
    RM_COMPARE.FK_CMP05
    RM_COMPARE_DEFAULT_PARAM.FK_COMPAREDEFPARMS01
    RM_COMPARE_ITEM.FK_CMPITM01
    RM_CONNECTION.FK_CONN01
    RM_CONNECTION.FK_CONN02
    RM_CONNECTION_ALLOWED_TABLE.FK_CONNALLOWEDTABLE01
    RM_DERIVED_PROPERTY_PARAM.FK_DERIVEDPROPPARM02
    RM_DOMAIN_NODE.FK_DOMNODE01
    RM_DOMAIN_VALIDATIONS.FK_DOMVAL01
    RM_DOMAIN_VALIDATIONS.FK_DOMVAL02
    RM_DOMAIN_VERSION.FK_DOMVER01
    RM_DOMAIN_VERSION.FK_DOMVER02
    RM_EXPORT.FK_EXP01
    RM_EXPORT.FK_EXP02
    RM_EXPORT.FK_EXP03
    RM_EXPORT.FK_EXP04
    RM_EXPORT.FK_EXP05
    RM_EXPORT_COLUMN.FK_EXPCOLS02
    RM_EXPORT_DEFAULT_PARAM.FK_EXPDEFPARMS01
    RM_EXPORT_NODE.FK_EXPNODES01
    RM_EXPORT_NODE_PROP.FK_EXPNODEPROP01
    RM_EXPORT_PARAM.FK_EXPPARMS01
    RM_HIERARCHY.FK_HIER01
    RM_HIERARCHY.FK_HIER02
    RM_HIERARCHY.FK_HIER03
    RM_HIERARCHY_PROP.FK_PROPHIER01
    RM_HIERARCHY_PROP.FK_PROPHIER02
    RM_IMPORT.FK_IMP01
    RM_IMPORT.FK_IMP02
    RM_IMPORT.FK_IMP03
    RM_IMPORT_DEFAULT_PARAM.FK_IMPORTDEFPARMS01
    RM_IMPORT_PARAM.FK_IMPPARMS01
    RM_IMPORT_SECTION.FK_IMPSEC01
    RM_IMPORT_SECTION_COLUMN.FK_IMPSECCOL01
    RM_IMPORT_SECTION_COLUMN_HIER.FK_IMPSECCOLHIER01
    RM_IMPORT_SECTION_COLUMN_PARAM.FK_IMPSECCOLPARM01
    RM_IMPORT_SECTION_PARAM.FK_IMPSECPARMS01
    RM_JOB_HISTORY_RESULT.FK_JOBHISTRES01
    RM_NODE.FK_NODE01
    RM_NODE.FK_NODE02
    RM_NODE_MERGE.FK_NODEMERGE01
    RM_NODE_PROP_GLOBAL.FK_PROPGLOB01
    RM_NODE_PROP_GLOBAL.FK_PROPGLOB02
    RM_NODE_PROP_LOCAL.FK_PROPLOC01
    RM_NODE_PROP_LOCAL.FK_PROPLOC02
    RM_NODE_PROP_LOCAL.FK_PROPLOC03
    RM_NODE_TYPE.FK_NODETYPE01
    RM_NODE_TYPE_PROPERTY.FK_NODETYPEPROP01
    RM_NODE_TYPE_PROPERTY.FK_NODETYPEPROP02
    RM_NODE_TYPE_VALIDATION.FK_NODETYPEVALID01
    RM_NODE_TYPE_VALIDATION.FK_NODETYPEVALID02
    RM_NOTIFICATION.FK_NOTIFICATION01
    RM_NOTIFICATION_DETAIL.FK_NOTIFICATIONDETAIL01
    RM_OBJECT_ACCESS_GROUP_NAG.FK_OBJECTACCESSGROUPNAG01
    RM_OBJECT_ACCESS_GROUP_NAG.FK_OBJECTACCESSGROUPNAG02
    RM_OBJECT_ACCESS_GROUP_USER.FK_OBJECTACCESSGROUPUSER01
    RM_OBJECT_ACCESS_GROUP_USER.FK_OBJECTACCESSGROUPUSER02
    RM_PROPERTY_CATEGORY.FK_PROPCAT01
    RM_PROPERTY_CATEGORY.FK_PROPCAT02
    RM_PROPERTY_CONSTRAINT.FK_PROPCONST01
    RM_PROPERTY_CTRL_HIER.FK_GLOBDEF01
    RM_PROPERTY_CTRL_HIER.FK_GLOBDEF02
    RM_PROPERTY_CTRL_HIER.FK_GLOBDEF03
    RM_PROPERTY_DEFINITION.FK_PROPDEF01
    RM_PROPERTY_LIST.FK_PROPLIST01
    RM_PROPERTY_LOOKUP.FK_PROPLOOKUP01
    RM_PROPERTY_PARAM.FK_PROPPARMS01
    RM_PROPERTY_QUERY.FK_PROPQRY02
    RM_PROPERTY_QUERY.FK_PROPQRY03
    RM_QUERY_CRITERIA.FK_QRYCRIT03
    RM_QUERY_DEFAULT_PARAM.FK_QUERYDEFPARMS01
    RM_RELATIONSHIP.FK_REL01
    RM_RELATIONSHIP.FK_REL02
    RM_REQUEST_ITEM.FK_REQITM01
    RM_REQUEST_VERIFICATION.FK_REQVERIF01
    RM_ROLE_PERMISSION.FK_ROLEPERMISSION01
    RM_USER_PROP_HIERARCHY.FK_HIERUSER01
    RM_USER_PROP_HIERARCHY.FK_HIERUSER02
    RM_USER_PROP_HIERARCHY.FK_HIERUSER03
    RM_USER_PROP_VERSION.FK_VERUSER01
    RM_USER_PROP_VERSION.FK_VERUSER02
    RM_USER_PROP_VERSION.FK_VERUSER03
    RM_USER_ROLE.FK_USERROLE01
    RM_USER_ROLE.FK_USERROLE02
    RM_VALIDATION_PARAM.FK_VALIDPARM02
    RM_VALIDATION_PARAM_TEMPL.FK_VALIDPARMTMPL02
    RM_VALIDATION_PROP_HIERARCHY.FK_VALIDHIER01
    RM_VALIDATION_PROP_HIERARCHY.FK_VALIDHIER02
    RM_VALIDATION_PROP_NODE.FK_PROPVALID01
    RM_VALIDATION_PROP_NODE.FK_PROPVALID02
    RM_VALIDATION_PROP_NODE.FK_PROPVALID03
    RM_VALIDATION_PROP_VERSION.FK_VALIDVER01
    RM_VALIDATION_PROP_VERSION.FK_VALIDVER02
    RM_VERSION.FK_VER01
    RM_VERSION.FK_VER02
    RM_VERSION_PROP.FK_PROPVER01
    RM_VERSION_PROP.FK_PROPVER02
    RM_WF_MODEL_FILTER_NODETYPE.FK_RMWFMODELFILTERNODETYPE01
    RM_WF_MODEL_STAGE.FK_RMWFMODELSTAGE01
    RM_WF_MODEL_STAGE_ASSG_GROUP.FK_RMWFMODELSTAGEASSGGROUP01
    RM_WF_MODEL_STAGE_TASK.FK_RMWFMODELSTAGETASK01
    RM_WF_MODEL_STAGE_VALIDATION.FK_RMWFMODELSTAGEVAL01
    RM_WF_MODEL_STAGE_VALIDATION.FK_RMWFMODELSTAGEVAL02
    RM_WF_REQUEST.FK_RMWFREQUEST01
    RM_WF_REQUEST_ACTIVITY.FK_RMWFREQUESTACTIVITY01
    RM_WF_REQUEST_ASSIGNED_TO.FK_RMWFREQUESTASSIGNEDTO01
    RM_WF_REQUEST_ATTACHMENT.FK_RMWFREQUESTATTACHMENT01
    RM_WF_REQUEST_ITEM.FK_RMWFREQUESTITEM01
    RM_WF_REQUEST_ITEM_FAIL.FK_RMWFREQUESTITEMFAIL01
    RM_WF_REQUEST_ITEM_PROPVAL.FK_RMWFREQUESTITEMPROPVAL01
    RM_WF_REQUEST_STAGE.FK_RMWFREQUESTSTAGE01
    RM_WF_REQUEST_STAGE_APPR_GROUP.FK_RMWFREQUESTSTAGEAPRGR01
    RM_WF_REQUEST_STAGE_APPROVAL.FK_RMWFREQUESTSTAGEAPR01
    RM_WF_REQUEST_STAGE_ENRICHED.FK_RMWFREQUESTSTAGEENRICHED01
    RM_WF_REQUEST_TAG.FK_RMWFREQUESTTAG01
    RM_WF_TASK.FK_WFTASK01
    RM_WF_TASK_PROPERTY.FK_RMWFTASKPROPERTY01
    RM_WF_TASK_VALIDATION.FK_RMWFTASKVALIDATION01
    RM_WF_TASK_VALIDATION.FK_RMWFTASKVALIDATION02
    RM_WF_TASK_VALIDATION_PROPERTY.FK_RMWFTASKVALPROPERTY01
    RM_WF_TASK_VALIDATION_PROPERTY.FK_RMWFTASKVALPROPERTY02

 Schema is up to date

12 updates were applied to COAMGMT@//EPMSRV:1521/ORACLE


Press any key to continue.

Wednesday, April 8, 2015

Oracle DRM 11.1.2.4 : DRG New Features!

Please check the link for the DRM new features, in this blog post I have specifically talked about the Data Relationship Governance Features (DRG)

http://www.trendingthoughts.com/blog/2015/03/21/drm-11124-is-here-drg-new-features

Monday, March 30, 2015

DRM 11.1.2.4: DRG Workflow Request Submission using Batch Client

In the previous blog you have seen how to load request items from a file, sometimes being a DRM developer you may end up doing the same on a regular basis,

We can automate the request submission using the Batch client, provided we have a properly formatted input file with the request items.


"D:\products\DataRelationshipManagement\client\batch-client\drm-batch-client.exe" /URL=net.tcp://EPMSRV:5211/Oracle/Drm/Engine /log=D:\DRM\Data\Inbound\BatchLoad.log /u=Operations /pw=Welcome! /op=RequestSubmit /delim=tab /conn=Inbound /vabbrev="Vision Jan 2013" /hierarchy="Parent Total" /conn=Inbound /filename=AcctConditional-I.txt /workflowtask="Add Financial Account" /workflowmodel="New Financial Account" /requesttitle="Batch Request" /deleteonsubmitfailure=0 


Submit Workflow Request:

/op = RequestSubmit

/delim=                 Printable delimiter character the request items file use
s - single character (|~`:, etc) | tab | comma | space | #nnn  (#33 - #126)
/conn=                  (optional) Name of external connection pointing to locat
ion where file specified with filename option resides
/vabbrev=               Name of version to use for created request
/hierarchy=             Name of hierarchy to use for loaded request items
/filename=              (optional) Name of request items file if using an extern
al connection.
/infile=                (optional) Path and file name for a local request items
file to use.
/workflowtask=          Name of the workflow task to use
/workflowmodel=         Name of the workflow model to use
/requesttitle=          Title of submitted request
/deleteonsubmitfailure= Delete the draft request if submit fails validation - Y:
 Yes | N: No | T: True | F: False | 1 | 0
/allowblankoverrides=   (optional) If true, then blank values in the source file
 are treated as blank value overrides for each item, according to
                        the 
/blankvalueindicator param
/blankvalueindicator=  (optional) If specified, any column value matching the 
                        blankvalueindicator will be interpreted as a blank value override.
                        If not specified, any blank column value will be 
                        interpreted as a blank value override




Friday, June 28, 2013

Oracle DRM Certification

Oracle is clever and clear, as to crack this exam we need to read all the guides:-(
and a good working experiance is definitely required to address some of the common sence questions.

So start reading...
  1. DRM User Guide
  2. DRM Admin Guide
  3. API Reference
A good idea is to read and practice all the questions from the Student and Activity guides ( Boot Camp ).


  • Don't neglect going through the sample questions provided by Oracle, it will provide you an overview of how the exam will be, 

Refer the below 2 topics from the below link, for sure you will see 1-2 Questions:-)



And go through the below document throughly, he will try to confuse you
Example: AddNode and AddNodewithProps


Below is the Exam Topics per Oracle and see my comments for each section.

Implementation Scope and Risks
Describe best practices for project scoping and establishing implementation timelines
Describe common implementation risks
Describe phasing implementations
Describe implementation roles and responsibilities
Evaluate common customer Issues
Evaluate common customer strengths
Understand testing and rollout best practices

 Questions:
 Basic questions on why we use DRM, puposes,
 Please read the DRM Project Life cycle part of Admin/User Guide.

Hyperion Data Relationship Management Overview

Describe DRM key features
Manage versions
Manage heirarchies
Manage nodes
Use Property Queries
Manage Exports / Reports
Use Audit Data
Understand user roles and responsibilities
Understand the DRM Architecture

 Questions:
 Version Life Cycle
 They try to confuse you between a Submitted/Finalised version.
 Also a queastion around as of versions.

Managing the Initial Data Load
Perform structural reconciliation
Manage naming collisions
Manage duplicate nodes

 Questions:
 Refer the System preferences for Shared node maintanance.

Managing Properties and Property Categories
Manage properties from upstream and downstream systems
Manage similar properties
Manage property defaults
Manage calculated properties (derived, inherited, lookup)
Manage property scoping
Manage node types
Manage property categories
Define and load properties and structure

 Questions:
 I see good number of questions from this list, don't neglect reading ADMIN/USER  
 guides.
 
Alternate Hierarchies

Define and build alternate hierarchies
Support differences or force consistency
Build alternate hierarchies from attributes and an export

  Questions:
  I remeber a question around building an alternate structure and also how to create  
  Export to address a requirement without building an alternate structure.

Mappings

Manage basic one to one or one to many mappings using properties
Manage basic one to one or one to many mappings using hierarchies
Manage complex many to many mappings
 
 Questions:
 Refer property date types Associated Nodes and groups.


Managing Data Feeds
Identify upstream and downstream systems
Identify and analyze interfaces used
Understand timing of feeds
Understand file format and restrictions
Understand Imports, Action Scripts, Blender, and Exports
Manage upstream data feed(s) and reconciliation
Manage downstream data feed(s) and reconciliation
Include skipping and padding levels in balance or recursive hierarchy feeds
Manage multiple downstream systems of the same type
Generate mapping tables for ETL processes for downstream systems
Implement automated data feed(s)

 Questions:
 Queations around DB Table exports, Blenders.

Versioning


Manage version composition
Manage version timings
Manage usage of version status
Manage synch methodology for what/if and planning versions

 Questions:
 Version life cycle, on a whole you see minimum 2-3 queations around version life 
 cycle.

Business Rules
Manage business rules for downstream systems
Manage business rules for client processes
Manage business rules to address system issues

 Questions:
 A scenario was given, tests our common sense.
 
Users
Manage users and assign roles
Manage node access groups and property categories
Manage node access for users
Setup anonymous access

 Questions:
 Most important and I see lot of questions around User roles, you have to througly read " Managing Users" chapter from the Admin guide .


Workflow
Evaluate if workflow is needed and determine workflow requirements
Integrate workflow through the request API


 Questions:
 Security protocols and SOAP Header queations.

API Integration
Evaluate API integration requirements
Integrate through the public API


 Questions:
 Please read the API reference guide, give an overview study.

Go ahead you can do it!

Cheers!
Murali

Friday, November 9, 2012

Lets not get confused with 'Hierarchy Sort Order'

On a Hierarchy we have 3 different Sort Properties,

1. Hierarchy Sort Order:

          This is used to specify the position of a Hierarchy in a Hierarchy Group
          when you have multiple hierarchies under a Hierarchy Group ( Sytem 
          category)
          Ex: -1, 0, 1
               Accounts
                                         CASH   -1 
                            FUND    0 
                         
2. Default Hierarchy Sort:

            Specifies the default sort order for all the users, when not selected
            hierarchies will get sorted Alphanumerically.

            A custom derived property with 'SORT' Data Type can be assigned based             on requirement.

3. User Hierarchy Sort:

           If User wanted to have a own representation of hierarchy structure, it is            possible by assigning a custom property to User Hierarchy Sort,

           When assigned it takes precedence over the default hierarchy Sort.



Enjoy Learning!

Thursday, November 8, 2012

Custom Ordering of Nodes in Oralce Hyperion DRM

Most of us are aware that DRM sorts data in Alphanumeric by default, and we can have a custom sort order by defining a derived property of 'SORT' data type based on the requirement and assign the same as hierarchy default sort order.

For Ex: sorting the nodes using it's Node ID.

With the latest release of DRM 11.1.2.X you can have your hierarchy sorted in what ever the way you wish to based on your business requirement,

Ex:

P1    core.sortorder
  X    0
  A    0
  D    0
  C    0


With the earlier versions the above order is not possible as DRM tries to sort it alphanumerically ( if there is no sort order selected, default nature of DRM) or if you apply a custom sort order it will get sorted based on it.
Ex: Sort by node type,

In order to achive the above order we need to use the 'core.SortOrder' as the 'default Hierarchy sort order',
By default this property is a Hidden property and we explicitly needs to make it available for selection.

We can use this while Importing your Data or on a existing hierarchy,
what happens is when you move a node under a particular parent
Ex: Move the node 'D' as a sibling to node 'X',
DRM will prompt you as 'Put as Sibling or reorder', when selected the node 'D' will be placed after the node 'X' and also the property 'core.SortOrder' will get updated.

You can get more clarity when you try to view Audit ( transaction History) and see what action script System has generated.


Ex:

P1     core.SortOrder
  X     0
  D     1
  A     2
  C     3


Remember core.SortOrder is applicable only for the nodes under a particular parent, sort order number differs for each node under different parents.

When applied on a existing hierarchy it will not dynamically changes the hierarchy structure, we need to explicitly re-order the hierarchy based on our requirement

Also when an import performed, by default all the nodes will be assigned with 'core.SortOrder' as '0' and it will get changed when a re-order happens.

Enjoy Learning!