This chapter describes the procedures for running Extract Transform Loading (ETL) processes in Oracle Workflow Manager and the Design Center in Oracle Warehouse Builder. This chapter includes the following topics:

• Loading Billed Data
• Rejecting a Group Bill File
• Rejecting a Master Bill File
• Running the LOAD_PRODUCTION Process Manually
• Loading Unbilled Data
• Loading Prepaid Data
• Resolving Checksum Errors
• Rejecting an Unbilled or Prepaid Data File
• Purging Unbilled or Prepaid Data Records
• Database Partitioning Architecture
• Process of Setting Up New Database Partitions
• Moving Data Between Partitions
• Removing an Empty Partition Group Key
• Rejecting a Data Move Between Partition Groups
• Running the ETL Purge Process