Exporting Sequence Number from DRM

In DRM Version 11.1.2.2. there is a special category called Export Specific Category. This category is only visible in Export. This category has some auto generated properties that can come handy in special situations.

One such situation would be to send a auto-generated sequence number from an export. in order to do this

1. Create an export.

2. in the Column tab, select the Export Specific category and select the [Record ID] property.

3. set the filters/target and run the export.

Output from export should now have a auto-generated sequence numbers.

There are some other properties in the category too that i found in 11.1.2.3 (not sure if these are available in 11.1.2.2 ) 

1. Calculated Level  {0} -> Exports Level Numbers of the node starting with '0'. i.e. Top Node will be Level 0.

2. Calculated Level {1} -> Same as above but starts with '1'. i.e. Top Node will be Level 1.

3. Calculated Parent -> Automatically finds the parent node.

Give it a shot.

DRM-12405: The TimeZoneID parameter name passed with the session is not supported: Central Standard Time (Mexico)

This error generally indicates the time zone between your database and operating system are not the same.
check the database timezone and update it or change the time on your operating system. either way make sure they both are on the same timezone.

SELECT SESSIONTIMEZONE FROM DUAL;

SELECT current_timestamp FROM DUAL;


SELECT dbtimezone FROM DUAL;