Need To Perform Conversion From C2M 2.7 To CCS. (Doc ID 2998199.1)

Last updated on JANUARY 16, 2024

Applies to:

Goal

On: 23A version, Environment Related

Need to perform Conversion from C2M 2.7 (OCI) to CCS. What are the tools available to do this?

Question 1: Data extraction from C2M and generate CSV files for SQL loader.

We are currently in the process of migrating approximately 370 tables (76 Maintenance Objects) from Oracle C2M to Oracle CCS. To facilitate this migration, we are seeking to identify if there is an established method from Oracle for extracting C2M data for each transactional table and converting it into CSV files that adhere to the CTR file structure provided by the K1-CNVGA batch. This requirement stems from the need to efficiently migrate data between C2M and CCS.

The objective is to extract C2M data for each transactional table and transform it into CSV files compatible with the CTR file structure. This migration involves approximately 370 tables (76 Maintenance Objects) transitioning from Oracle C2M to Oracle CCS. The inquiry seeks to determine whether Oracle provides a pre-built script or tool specifically designed for this type of migration between Oracle products.

Question 2: A few Maintenance objects are not supported for conversion. What is the workaround for these?

CCS does not support conversion for the following 31 maintenance objects, what is the recommended workaround for converting these maintenance objects? Please provide detailed instructions and any relevant tools or resources that can be used to facilitate the conversion process.
C1-ADJ-UPSTG
C1-OCBGEN
ENROLLMENT
SEV PROC
STOCK LOC
TENDER CTL
C1-APPR REQ
F1-BUNDLE
F1-FACT
F1-SYNC REQ
VAL ERR
BAL CTL GRP
BATCH JOB
C1-USAGE
F1-PROSTR
F1-SYNCREQIN
BATCH RUN
C1-NTF-PREF
DEPOSIT CTL
F1-OUTMSG
C1-PARQST
DEP CTL STG
VAL FK ERR
CASE
F1-GENPROC
PAY STG
AUDIT
C1-ADJ-STCTL
F1-SVCTASK
MESSAGE LOG
TO DO ENTRY
 
Question 3:
Even though a maintenance object is supported by K1 Conversion jobs, a few tables are not supported by conversion, what is the the workaround for these kind of tables?
 
For e.g.: Tables C1_SS_CONT_OVRD, CI_SS_PHONE_OVRD in ACCOUNT MO are not supported for conversion (there is no CTR layout for these tables).
Question 4: On the process to migrate Transaction Data to CCS - What are the exact steps to move all data from STAGING schema (STGADM) to PROD schema (CISADM)?
 
Detail : We reached to a migration stage where all transaction data is in STGADM schema. Now next step is to move data from STGADM schema to CISADM schema. can you direct us where are its steps documented for this data movement.
 
Question 5: Can you help with documentation on batch job submission in CCS. We are looking to submit batch from REST service (aka F1-SubmitJob REST API), by passing batch parameter in XML
 
Detail: Need step/documentation how to execute Batch from outside CCS application, since we have requirement to run multiple batches.

Solution

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