How to Determine the Folder Name for a Specific Capture Batch Using a BatchID (Doc ID 602932.1)

Last updated on NOVEMBER 28, 2023

Applies to:

Goal

The Capture batch folder is named based on the BatchID of that specific batch (the ECID field for a batch from the ECBATCHES table).  In the database, it is stored as a base 10 value.  The batch folder is named using the same BatchID, but as a Base 36 representation of the BatchID.  This makes it difficult to track down the Batch Folder (base36 in the file system) using the BatchID from the Capture database (base10 in the ECBATCHES table).

The Capture batch folder is stored in a 3 character file cabinet folder which can be determined by querying the ECFILECABINETS table and getting the value of the ECID field for that file cabinet.  Each ECID (in the ECFILECABINETS table) is a base 10 number.  The ECID is then converted to a base36 value for the folder in the file system and is padded with zeros to make it a 3 character folder name. For example an ECID of 1 would be "001" and an ecID of 15 would be "00F".

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.