Contract Commitment Legacy Conversion Procedures
Definition
The Contract Commitment feature provides a one-time migration of legacy information to Contract Commitment.
Overview
There are two phases to the migration process. In the first phase, users identify requirements for converting legacy data into contract commitment tables. Converting data into the contract commitment tables allows Contract Commitment to generate Required information, such as the CC Header ID, which is a not null field in CBC JE Lines and can be used later for audit purposes.
The second major conversion phase includes two subphases. In the first subphase, legacy account line data is converted for CBC JE Batches and CBC JE Lines. The second subphase includes converting all payment forecast legacy data into GL JE Batches, GL JE Headers, and GL JE Lines and updating GL Balances.
Users define the amount of detail or summarization of detail to be converted. Users can decide to convert data at the beginning of a new fiscal year or during the fiscal year.
Converting at the beginning of the fiscal year allows for a clean break from the legacy application to the new application. Converting legacy data at the beginning of the fiscal year allows users to enter any contract commitments from day one of the new fiscal year.
Converting during the fiscal year may not provide a clean break, but by converting the legacy periods to the same periods in the new application, the end result can be the same as if conversion took place at the beginning of the fiscal year.
Legacy Conversion Process Flow Diagram
The diagram below shows the Open Interface Table process, the Commitment Budgetary Control Open Interface Table process, and the General Ledger Interface Table process. These processes are described in the following sections.
Legacy Conversion Process Flow Diagram
Legacy Conversion to Contract Commitment Tables
The CC Open Interface includes the following tables:
-
CC Headers Interface Table
-
CC Account Lines Interface Table
-
CC Detail Payment Forecast Interface Table
Legacy conversion to contract commitment tables includes the following tasks:
-
identify legacy data to be converted
-
identify any validation rules associated with the conversion of each state of the contract
-
generate Conversion Exception Report to identify any exceptions due to validation error or to let users know that no exceptions were found
-
update Oracle Purchasing tables for Confirmed and Approved legacy data.
-
call Oracle Projects API to create encumbrances for contract commitments linked to projects.
CC API
The CC API performs the following tasks:
-
initiates the validation of the CC Headers Interface, CC Account Line Interface, and CC Detail Payment Forecast Lines Interface tables
-
provides exception report
-
inserts records into CC Headers table, CC Account Lines table, CC Detail Payment Forecast table, and CC Actions table
Note: If there are contract commitments linked to projects from Oracle Projects and encumbrance accounting is enabled, the PRC: Maintain Budgetary Control Balances process must be run to update the project budget. For information on this process, see Oracle Projects User’s Guide.
Legacy Conversion to Commitment Budgetary Control Tables
The CC Open Interface Table format provided the basis for the CBC Open Interface table, which is used for converting legacy data to CBC JE Batches and CBC JE Lines. The CC Open Interface table provides information for CBC JE Batches and CBC JE Lines for all new contract information created in contract commitment.
The CBC Open Interface is used to convert Provisional and Confirmed contracts that qualify based on the criteria described in the contract commitment tables.
An API is used to perform validations on data entered in the CBC Open Interface table and insert converted legacy data into CBC JE Batches and CBC JE Lines table.
Before converting CBC legacy information, contract commitment legacy data must be converted and recorded in the CC Headers table, the CC Account Line table, and the Detail Payment Forecast table.
CBC API
The CBC API performs the following tasks:
-
validates data entered into the CBC Open Interface table
-
inserts records into CBC JE Batches and CBC JE Lines
-
creates a unique batch for each period of data entered into the CBC Open Interface Table
Conversion records inserted into CBC JE Batches and CBC JE Lines with the status Permanent must not be deleted from the table.
Reference fields 1 through 4 are reserved for CBC and SBC reference information to link transaction information back to a particular contract. If additional reference information is required by users beyond what is in reference fields 1 through 4, then reference fields 5 through 10 can be used for this purpose.
Legacy Conversion to Standard Budgetary Control (SBC), General Ledger
The GL Interface table format provides the basis for converting legacy data to General Ledger. Through the GL Import process the GL Interface table data is validated.
The GL Interface Table format is the means for entering SBC legacy data into General Ledger.
Related Topics
Contract Commitment Legacy Open Interface Program in the Integration Repository (http://www-apps.us.oracle.com:1100/irep/).
Commitment Budgetary Control Legacy Open Interface Program in the Integration Repository (http://www-apps.us.oracle.com:1100/irep/).
CC Headers Interface Table
| Columns | NULL | Type | Comments |
|---|---|---|---|
| INTERFACE_HEADER_ID | NOT NULL | NUMBER | |
| ORG_ID | NOT NULL | NUMBER(15) | |
| CC_TYPE | NOT NULL | VARCHAR2(1) | Includes S for Standard, C for Cover, and R for Release |
| CC_NUM | VARCHAR2(20) | User-entered unique contract number. This can be contract number currently used in the legacy. | |
| CC_VERSION_NUM | NOT NULL | NUMBER | User-entered contract version number. If user does not enter contract version number, contract commitment defaults to 1 as the contract version number when converting. |
| INTERFACE_PARENT_HEADER_ID | NUMBER | User-derived number; provides the link of Cover to Releases | |
| CC_STATE | NOT NULL | VARCHAR2(2) | |
| CC_CTRL_STATUS | NOT NULL | VARCHAR2(1) | |
| CC_ENCMBRNC_STATUS | VARCHAR2(1) | ||
| CC_APPRVL_STATUS | NOT NULL | VARCHAR2(2) | |
| VENDOR_ID | NUMBER | Required if Confirmed; optional if Provisional | |
| VENDOR_SITE_ID | NUMBER | Required if Confirmed; optional if Provisional | |
| VENDOR_CONTACT_ID | NUMBER | Required if Confirmed; optional if Provisional | |
| TERM_ID | NUMBER(15) | Required if Confirmed; optional if Provisional | |
| LOCATION_ID | NUMBER(15) | Required if Confirmed; optional if Provisional | |
| SET_OF_BOOKS_ID | NOT NULL | NUMBER(15) | |
| CC_ACCT_DATE | DATE | ||
| CC_DESC | VARCHAR2(240) | ||
| CC_START_DATE | DATE | ||
| CC_END_DATE | DATE | ||
| CC_OWNER_USER_ID | NOT NULL | NUMBER(15) | |
| CC_PREPARER_USER_ID | NOT NULL | NUMBER(15) | |
| CURRENCY_CODE | VARCHAR2(15) | ||
| CONVERSION_TYPE | VARCHAR2(30) | ||
| CONVERSION_DATE | DATE | ||
| CONVERSION_RATE | NUMBER | ||
| LAST_UPDATE_DATE | DATE | ||
| LAST_UPDATED_BY | NUMBER | ||
| LAST_UPDATE_LOGIN | NUMBER | ||
| CREATED_BY | NUMBER | ||
| CREATION_DATE | DATE | ||
| CC_CURRENT_USER_ID | NUMBER(15) | ||
| WF_ITEM_TYPE | VARCHAR2(8) | ||
| WF_ITEM_KEY | VARCHAR2(240) | ||
| CONTEXT | VARCHAR2(30) | ||
| ATTRIBUTE1 | VARCHAR2(150) | ||
| ATTRIBUTE2 | VARCHAR2(150) | ||
| ATTRIBUTE3 | VARCHAR2(150) | ||
| ATTRIBUTE4 | VARCHAR2(150) | ||
| ATTRIBUTE5 | VARCHAR2(150) | ||
| ATTRIBUTE6 | VARCHAR2(150) | ||
| ATTRIBUTE7 | VARCHAR2(150) | ||
| ATTRIBUTE8 | VARCHAR2(150) | ||
| ATTRIBUTE9 | VARCHAR2(150) | ||
| ATTRIBUTE10 | VARCHAR2(150) | ||
| ATTRIBUTE11 | VARCHAR2(150) | ||
| ATTRIBUTE12 | VARCHAR2(150) | ||
| ATTRIBUTE13 | VARCHAR2(150) | ||
| ATTRIBUTE14 | VARCHAR2(150) | ||
| ATTRIBUTE15 | VARCHAR2(150) | ||
| BATCH | NOT NULL | NUMBER | User-defined number |
| PROCESS STATUS | VARCHAR2(1) | New column; for future use |
| Column | Validation | Destination |
|---|---|---|
| INTERFACE_HEADER_ID | INTERFACE_HEADER_ID is unique in the table. | No destination |
| ORG_ID | Organization identifier must be the same as the organization identifier of the person logged on. | IGC_CC_HEADERS.ORG_ID |
| CC_TYPE | Valid contract commitment types are C for Cover, S for Standard, and R for Release. | IGC_CC_HEADERS.CC_TYPE |
| CC_NUM | CC_NUM is unique in table per ORG_ID. | IGC_CC_HEADERS.CC_NUM |
| CC_VERSION_NUM | If CC_VERSION_NUM is NOT NULL, then use CC_VERSION_NUM NOT NULL value and increment by 1. If CC_VERSION_NUM is NULL, then use 1 as default value for CC_VERSION_NUM. | IGC_CC_HEADERS.CC_VERSION_NUM |
| INTERFACE_PARENT_HEADER_ID | If contract commitment type is R, then Interface Parent Header ID cannot be NULL. If CC type is C or S, then Interface Parent Header ID must be NULL. | No destination |
| CC_STATE | Valid states to be converted are PR for Provisional, CM for Confirmed, and CT for Completed. | IGC_CC_HEADERS.CC_STATE |
| CC_CTRL_STATUS | Valid control statuses are C for Closed, E for Entered, or O for Open. If contract commitment status is O, then the contract commitment state must be CM for Confirmed, and the CC Approval Status must be AP for Approved. | IGC_CC_HEADERS.CC_CTRL_STATUS |
| CC_ENCMBRNC_STATUS | Valid statuses are C for Confirmed and Encumbered, N for Not encumbered, and P for Provisional and Encumbered. If Dual Budgetary Control is not enabled and the contract commitment state is PR, Provisional, then valid encumbrance status is N. If Dual Budgetary Control is enabled and the contract commitment state is PR, then valid encumbrance statuses are N or P. If Dual Budgetary Control is enabled and the contract commitment state is CM, then valid encumbrance statuses are N or C. If the contract commitment state is CM and CC Approval Status is AP, then the only valid encumbrance status is C. |
IGC_CC_HEADERS.CC_ENCMBRNC_STATUS |
| CC_APPRVL_STATUS | Valid statuses are IN for Incomplete and AP for Approved. | IGC_CC_HEADERS.CC_APPRVL_STATUS |
| VENDOR_ID | Validate Vendor ID against the PO_VENDORS table to ensure that the Vendor ID exists in the table. Validate Vendor ID is active. ENABLED_FLAG = Y If the contract commitment state is CM for Confirmed, then Vendor ID is Required. |
IGC_CC_HEADERS.VENDOR_ID |
| VENDOR_SITE_ID | Validate Vendor Site ID against the PO_VENDOR_SITES_ALL table to ensure that the Vendor site identifier exists in the table. Validate Vendor Site ID is active. PURCHASING_SITE_FLAG = Y If the contract commitment state is CM for Confirmed, then Vendor Site ID is Required. |
IGC_CC_HEADERS.VENDOR_SITE_ID |
| VENDOR_CONTACT_ID | Validate Vendor Contact ID against the PO_VENDOR_CONTACTS table to ensure that the Vendor contact identifier exists in the table. Validate Vendor Contact ID is active. If Vendor ID is NULL, then this field must be NULL. |
IGC_CC_HEADERS.VENDOR_CONTACT_ID |
| TERM_ID | Terms must be validated against the AP_TERMS_VAL_V view. | IGC_CC_HEADERS.TERM_ID |
| LOCATION_ID | Validate Location ID against the HR_LOCATIONS table to ensure that the Location ID exists in the table. Validate Location ID is active, where BILL_TO_SITE_FLAG = Y. If Vendor identifier is NULL, then this field must be NULL. |
IGC_CC_HEADERS.LOCATION_ID |
| SET_OF_BOOKS_ID | Validate the Set of Books identifier; must be the Set of Books identifier of the person logged on. | IGC_CC_HEADERS.SET_OF_BOOKS_ID |
| CC_ACCT_DATE | Validate that Account Date is on or between the State and End Date of the Contract. Account Date must fall within an open or future enterable period. Validate that Account Date is within the defined calendar. |
IGC_CC_HEADERS.CC_ACCT_DATE |
| CC_DESC | No validation. | IGC_CC_HEADERS.CC_DESC |
| CC_START_DATE | Start Date must be less than or equal to End Date. If commitment type is Release, then the entered Start Date must be within the start and end date for the corresponding Cover commitment. If commitment type is Cover, then Start Date must be less than or equal to the minimum start date of all its releases. |
IGC_CC_HEADERS.CC_START_DATE |
| CC_END_DATE | If commitment type is Release, then the entered End Date must be within the start and end date for the corresponding Cover commitment. If commitment type is Cover, then the End Date must be greater than or equal to the maximum end date for all its releases. | IGC_CC_HEADERS.CC_END_DATE |
| CC_OWNER_USER_ID | Employee identification corresponds to the owner or employee. Mandatory. Employee must be active. | IGC_CC_HEADERS.CC_OWNER_USER_ID |
| CC_PREPARER_USER_ID | User identification corresponds to the owner or employee. Mandatory. Default value corresponds to FND_PROFILE.USER_ID. | IGC_CC_HEADERS.CC_PREPARER_USER_ID |
| CURRENCY_CODE | Validate that currency code is the currency for the Set of Books identifier. If the cover contract commitment is in nonfunctional currency, then all related releases must be entered using the same nonfunctional currency. |
IGC_CC_HEADERS.CURRENCY_CODE |
| CONVERSION_TYPE | NULL; no validation. | IGC_CC_HEADERS.CONVERSION_TYPE |
| CONVERSION_DATE | NULL; no validation. | IGC_CC_HEADERS.CONVERSION_DATE |
| CONVERSION_RATE | NULL; no validation. | IGC_CC_HEADERS.CONVERSION_RATE |
| LAST_UPDATE_DATE | No validation. | IGC_CC_HEADERS.LAST_UPDATE_DATE |
| LAST_UPDATED_BY | No validation. | IGC_CC_HEADERS.LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN | No validation. | IGC_CC_HEADERS.LAST_UPDATE_LOGIN |
| CREATED_BY | Validate if creator is valid Oracle user. | IGC_CC_HEADERS.CREATED_BY |
| CREATION_DATE | No validation. | IGC_CC_HEADERS.CREATION_DATE |
| CC_CURRENT_USER_ID | User identification corresponding to the owner or employee. Mandatory. Default value corresponds to FND_PROFILE-USER_ID. | IGC_CC_HEADERS.CC_CURRENT_USER_ID |
| WF_ITEM_TYPE | No validation. | IGC_CC_HEADERS.WF_ITEM_TYPE |
| WF_ITEM_KEY | No validation. | IGC_CC_HEADERS.WF_ITEM_KEY |
| CONTEXT | No validation. | IGC_CC_HEADERS.CONTEXT |
| ATTRIBUTE1-ATTRIBUTE 15 | No validation. | IGC_CC_HEADERS.ATTRIBUTE1 - IGC_CC_HEADERS.ATTRIBUTE15 |
CC Account Lines Interface Table
| Columns | NULL | Type | Comments |
|---|---|---|---|
| INTERFACE_HEADER_ID | NOT NULL | NUMBER | User-derived number |
| INTERFACE_ACCT_LINE_ID | NOT NULL | NUMBER | User-derived number |
| INTERFACE_PARENT_HEADER_ID | NUMBER | User-derived number; provides the link of Cover to Releases | |
| INTERFACE_PARENT_ACCT-LINE_ID | NUMBER | ||
| CC_CHARGE_CODE_COMBINATION_ID | NUMBER(15) | ||
| CC_ACCT_LINE_NUM | NOT NULL | NUMBER | |
| CC_BUDGET_CODE_COMBINATION_ID | NUMBER(15) | ||
| CC_ACCT_ENTERED_AMT | NUMBER | ||
| CC_ACCT_FUNC_AMT | NUMBER | ||
| CC_ACCT_DESC | VARCHAR2(240) | Recommend entering a description | |
| CC_ACCT_BILLED_AMT | NUMBER | ||
| CC_ACCT_UNBILLED_AMT | NUMBER | ||
| CC_ACCT_TAXABLE_FLAG | VARCHAR2(1) | ||
| TAX_ID | NUMBER(15) | ||
| CC_ACCT_ENCMBRNC_AMT | NUMBER | ||
| CC_ACCT_ENCMBRNC_DATE | DATE | ||
| CC_ACCT_ENCMBRNC_STATUS | VARCHAR2(1) | ||
| PROJECT_ID | NUMBER(15) | ||
| TASK_ID | NUMBER(15) | ||
| EXPENDITURE_TYPE | VARCHAR2(30) | ||
| EXPENDITURE_ORG_ID | NUMBER | ||
| EXPENDITURE_ITEM_DATE | VARCHAR2(150) | ||
| LAST_UPDATE_DATE | VARCHAR2(150) | ||
| LAST_UPDATED_BY | NUMBER | ||
| LAST_UPDATE_LOGIN | NUMBER | ||
| CREATION_DATE | VARCHAR2(150) | ||
| CREATED_BY | NUMBER | ||
| CONTEXT | VARCHAR2(30) | ||
| ATTRIBUTE1 | VARCHAR2(150) | ||
| ATTRIBUTE2 | VARCHAR2(150) | ||
| ATTRIBUTE3 | VARCHAR2(150) | ||
| ATTRIBUTE4 | VARCHAR2(150) | ||
| ATTRIBUTE5 | VARCHAR2(150) | ||
| ATTRIBUTE6 | VARCHAR2(150) | ||
| ATTRIBUTE7 | VARCHAR2(150) | ||
| ATTRIBUTE8 | VARCHAR2(150) | ||
| ATTRIBUTE9 | VARCHAR2(150) | ||
| ATTRIBUTE10 | VARCHAR2(150) | ||
| ATTRIBUTE11 | VARCHAR2(150) | ||
| ATTRIBUTE12 | VARCHAR2(150) | ||
| ATTRIBUTE13 | VARCHAR2(150) | ||
| ATTRIBUTE14 | VARCHAR2(150) | ||
| ATTRIBUTE15 | VARCHAR2(150) | ||
| BATCH | NOT NULL | NUMBER | User-defined number |
| PROCESS STATUS | VARCHAR2(1) | New column; for future use |
| Columns | Validation | Destination |
|---|---|---|
| INTERFACE_HEADER_ID | Validate that INTERFACE_HEADER_ID exists in the CC_HEADER_INTERFACE table. | No destination |
| INTERFACE_ACCT_LINE_ID | Primary key for this table. | No destination |
| INTERFACE_PARENT_HEADER_ID | If contract commitment type is R, then Interface Parent Header cannot be NULL. If contract commitment type is C or S, then Interface Parent Header must be NULL. |
No destination |
| INTERFACE_PARENT_ACCT-LINE_ID | If contract commitment type is R, then Interface Account Line ID cannot be NULL. If contract commitment type is C or S, then Interface Account Line ID must be NULL. |
No destination |
| CC_CHARGE_CODE_COMBINATION_ID | Validate that Charge Code Combination ID (CCID) exists in the GL_CODE_COMBINATIONS table. Validate that the CCID is enabled. If CCID End Date is not NULL, then check Account Date against End Date to ensure that it occurs on or before the End Date. Account Dates that occur after the End Date of the CCID End Date must create an error message. |
IGC_CC_ACCT_LINES.CC_CHARGE_CODE_COMBINATION_ID |
| CC_ACCT_LINE_NUM | No validation. | IGC_CC_ACCT_LINES.CC_ACCT_LINE_NUM |
| CC_BUDGET_CODE_COMBINATION_ID | Validate that Budget Code Combination ID (CCID) exists in the GL_CODE_COMBINATIONS table. Validate that the CCID is enabled. If CCID End Date is not NULL, then check Account Date against End Date to ensure that it occurs on or before the End Date. Account Dates that occur after the End Date of the CCID End Date must create an error message. |
IGC_CC_ACCT_LINES.CC_BUDGET_CODE_COMBINATION_ID |
| CC_ACCT_ENTERED_AMT | For cover type, must be greater than or equal to the sum of ACCT_ENTERED_AMT of related releases. For cover type, must to equal to the sum of DET_PF_ENTERED_AMT. |
IGC_CC_ACCT_LINES.CC_ACCT_ENTERED_AMT |
| CC_ACCT_FUNC_AMT | No validation. | IGC_CC_ACCT_LINES.CC_ACCT_FUNC_AMT |
| CC_ACCT_DESC | No validation. | IGC_CC_ACCT_LINES.CC_ACCT_DESC |
| CC_ACCT_BILLED_AMT | No validation. | IGC_CC_ACCT_LINES.CC_ACCT_BILLED_AMT |
| CC_ACCT_UNBILLED_AMT | No validation. | IGC_CC_ACCT_LINES.CC_ACCT_UNBILLED_AMT |
| CC_ACCT_TAXABLE_FLAG | No validation. | IGC_CC_ACCT_LINES.CC_ACCT_TAXABLE_FLAG |
| TAX_ID | No validation. | IGC_CC_ACCT_LINES.TAX_ID |
| CC_ACCT_ENCMBRNC_AMT | For encumbered contracts, this must be equal to the ENTERED_AMT. | IGC_CC_ACCT_LINES.CC_ACCT_ENCMBRNC_AMT |
| CC_ACCT_ENCMBRNC_DATE | Cannot be NULL for encumbered contracts. | IGC_CC_ACCT_LINES.CC_ACCT_ENCMBRNC_DATE |
| CC_ACCT_ENCMBRNC_STATUS | Must be the same as the header for Cover and Standard. | IGC_CC_ACCT_LINES.CC_ACCT_ENCMBRNC_STATUS |
| PROJECT_ID | Validated against PA_PROJECTS_EXPEND_V. | IGC_CC_ACCT_LINES.PROJECT_ID |
| TASK_ID | Validated against PA_TASKS_ENPEND_V for the entered PROJECT_ID. | IGC_CC_ACCT_LINES.TASK_ID |
| EXPENDITURE_TYPE | No validation. | IGC_CC_ACCT_LINES.EXPENDITURE_TYPE |
| EXPENDITURE_ORG_ID | No validation. | IGC_CC_ACCT_LINES.EXPENDITURE_ORG_ID |
| EXPENDITURE_ITEM_DATE | No validation. | IGC_CC_ACCT_LINES.EXPENDITURE_ITEM_DATE |
| LAST_UPDATE_DATE | No validation. | IGC_CC_ACCT_LINES.LAST_UPDATE_DATE |
| LAST_UPDATED_BY | No validation. | IGC_CC_ACCT_LINES.LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN | No validation. | IGC_CC_ACCT_LINES.LAST_UPDATE_LOGIN |
| CREATION_DATE | No validation. | IGC_CC_ACCT_LINES.CREATION_DATE |
| CREATED_BY | Valid USER_ID from FND_USER. | IGC_CC_ACCT_LINES.CREATED_BY |
| CONTEXT | No validation. | IGC_CC_ACCT_LINES.CONTEXT |
| ATTRIBUTE1 - ATTRIBUTE15 | No validation. | IGC_CC_ACCT_LINES.ATTRIBUTE1 - IGC_CC_ACCT_LINES.ATTRIBUTE15 |
CC Detail Payment Forecast Interface Table
| Columns | NULL | Type | Comments |
|---|---|---|---|
| INTERFACE_ACCT_LINE_ID | NOT NULL | NUMBER | User-derived number |
| INTERFACE_DET_PF_LINE_ID | NOT NULL | NUMBER | User-derived number |
| CC_DET_PF_LINE_NUM | NOT NULL | NUMBER | User-derived number |
| INTERFACE_PARENT_ACCOUNT_LINE_ID | NUMBER | Links cover to release | |
| INTERFACE_PARENT_DET_PF_LINE_ID | NUMBER | Links cover to release | |
| CC_DET_PF_ENTERED_AMT | NUMBER | ||
| CC_DET_PF_FUNC_AMT | NUMBER | Functional currency | |
| CC_DET_PF_DATE | DATE | ||
| CC_DET_PF_BILLED_AMT | NUMBER | ||
| CC_DET_PF_UNBILLED_AMT | NUMBER | ||
| CC_DET_PF_ENCMBRNC_AMT | NUMBER | ||
| CC_DET_PF_ENCMBRNC_STATUS | VARCHAR2(1) | ||
| ENCMBRNC_DATE | DATE | ||
| LAST_UPDATE_DATE | DATE | ||
| LAST_UPDATED_BY | NUMBER | ||
| LAST_UPDATE_LOGIN | NUMBER | ||
| CREATION_DATE | DATE | ||
| CREATED_BY | NUMBER | ||
| CONTEXT | VARCHAR2(30) | ||
| ATTRIBUTE1 | VARCHAR2(150) | ||
| ATTRIBUTE2 | VARCHAR2(150) | ||
| ATTRIBUTE3 | VARCHAR2(150) | ||
| ATTRIBUTE4 | VARCHAR2(150) | ||
| ATTRIBUTE5 | VARCHAR2(150) | ||
| ATTRIBUTE6 | VARCHAR2(150) | ||
| ATTRIBUTE7 | VARCHAR2(150) | ||
| ATTRIBUTE8 | VARCHAR2(150) | ||
| ATTRIBUTE9 | VARCHAR2(150) | ||
| ATTRIBUTE10 | VARCHAR2(150) | ||
| ATTRIBUTE11 | VARCHAR2(150) | ||
| ATTRIBUTE12 | VARCHAR2(150) | ||
| ATTRIBUTE13 | VARCHAR2(150) | ||
| ATTRIBUTE14 | VARCHAR2(150) | ||
| ATTRIBUTE15 | VARCHAR2(150) | ||
| BATCH | NUMBER | User-defined number | |
| PROCESS STATUS | VARCHAR2(1) | New column; for future use |
| Columns | Validation | Destination |
|---|---|---|
| INTERFACE_ACCT_LINE_ID | Validate that INTERFACE_ACCT_LINE_ID exists in the CC_ACCOUNT_LINE_INTERFACE table. | No destination |
| INTERFACE_DET_PF_LINE_ID | Primary key for this table. | No destination |
| CC_DET_PF_LINE_NUM | No validation. | IGC_CC_DET_PF.CC_DET_PF_LINE_NUM |
| INTERFACE_PARENT_ACCOUNT_LINE_ID | If contract commitment type is R, then Interface Parent Account Line ID cannot be NULL. If contract commitment type is C or S, then Interface Parent Account Line ID must be NULL. |
No destination |
| INTERFACE_PARENT_DET_PF_LINE_ID | If contract commitment type is R, then Interface Parent Detail Payment Forecast Line ID cannot be NULL. If contract commitment type is C or S, then Interface Parent Detail Payment Forecast Line ID must be NULL. |
No destination |
| CC_DET_PF_ENTERED_AMT | In the case of cover contracts, it must be greater than or equal to the sum of ENTERED_AMT of related releases. | IGC_CC_DET_PF.CC_DET_PF_ENTERED_AMT |
| CC_DET_PF_FUNC_AMT | No validation. | IGC_CC_DET_PF.CC_DET_PF_FUNC_AMT |
| CC_DET_PF_DATE | Date must be for GL Open Period and CC Open and Future Entry periods. If commitment type is Release, then the entered date must be the same as the Cover commitment; this is mandatory. If commitment type is not Release, then the Detail Payment Forecast Date is on or between the Start and End Date of the contract. |
IGC_CC_DET_PF.CC_DET_PF_DATE |
| CC_DET_PF_BILLED_AMT | No validation. | IGC_CC_DET_PF.CC_DET_PF_BILLED_AMT |
| CC_DET_PF_UNBILLED_AMT | No validation. | IGC_CC_DET_PF.CC_DET_PF_UNBILLED_AMT |
| CC_DET_PF_ENCMBRNC_AMT | Must be the same as ENTERED_AMT for encumbered contracts. | IGC_CC_DET_PF.CC_DET_PF_ENCMBRNC_AMT |
| CC_DET_PF_ENCMBRNC_STATUS | Must be the same as ACCT_LINES in case of cover and standard contracts. | IGC_CC_DET_PF.CC_DET_PF_ENCMBRNC_STATUS |
| CC_DET_PF_ENCMBRNC_DATE | Date must be for GL Open Period and CC Open and Future Entry periods. If commitment type is Release, then the entered date must be the same as the Cover commitment; this is mandatory. If commitment type is not Release, then the Detail Payment Forecast Encumbrance Date is on or between the Start and End Date of the contract. |
IGC_CC_DET_PF.CC_DET_PF_ENCMBRNC_DATE |
| LAST_UPDATE_DATE | No validation. | IGC_CC_DET_PF.LAST_UPDATE_DATE |
| LAST_UPDATED_BY | No validation. | IGC_CC_DET_PF.LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN | No validation. | IGC_CC_DET_PF.LAST_UPDATE_LOGIN |
| CREATION_DATE | No validation. | IGC_CC_DET_PF.CREATION_DATE |
| CREATED_BY | Valid USER_ID from FND_USER. | IGC_CC_DET_PF.CREATED_BY |
| CONTEXT | No validation. | IGC_CC_DET_PF.CONTEXT |
| ATTRIBUTE1 - ATTRIBUTE15 | No validation. | IGC_CC_DET_PF.ATTRIBUTE1 - IGC_CC_DET_PF.ATTRIBUTE15 |
CBC Open Interface Table
| Columns | NULL | Type | Comments |
|---|---|---|---|
| CODE_COMBINATION_ID | NOT NULL | NUMBER(15) | |
| BATCH_LINE_NUM | NOT NULL | NUMBER(15) | |
| CC_TRANSACTION_DATE | NOT NULL | DATE | |
| CC_FUNC_DR_AMT | NUMBER(15) | ||
| CC_FUNC_CR_AMT | NUMBER | ||
| JE_SOURCE_NAME | NOT NULL | VARCHAR2(25) | Seeded source name within General Ledger. Description is Historical Data Conversion |
| JE_CATEGORY_NAME | NOT NULL | VARCHAR2(25) | Seeded category names in General Ledger. Provisional and Confirmed category names are seeded in General Ledger. |
| SET_OF_BOOKS_ID | NOT NULL | NUMBER(15) | |
| ENCUMBRANCE_TYPE_D | NOT NULL | NUMBER(15) | Encumbrance Type ID is based on what users defined in Dual Budgetary Control setup. |
| TRANSACTION_DESCRIPTION | VARCHAR2(240) | Concatenate Contract Number and Account Line Description of IGC_CC_HEADERS and IGC_CC_ACCT_LINES tables, respectively. | |
| LAST_UPDATE_DATE | NOT NULL | DATE | |
| LAST_UPDATED_BY | NOT NULL | NUMBER(15) | Based on user login information |
| LAST_UPDATE_LOGIN | NUMBER(15) | ||
| CREATION_DATE | DATE | ||
| CREATED_BY | NUMBER(15) | Based on user login information | |
| REFERENCE_1 | VARCHAR2(240) | If client requires converted legacy data to be tied back to a particular contract, then this must be a required field. Get CC_HEADER_ID from IGC_CC_HEADERS table. | |
| REFERENCE_2 | VARCHAR2(240) | If client requires converted legacy data to be tied back to a particular contract, then this must be a required field. Get CC-VERSION_NUM from IGC_CC_HEADERS table. | |
| REFERENCE_3 | VARCHAR2(240) | If client requires converted legacy data to be tied back to a particular contract, then this must be a required field. Get CC_ACCT_LINE_ID from IGC_CC_ACCT_LINES table. | |
| REFERENCE_4 | VARCHAR2(240) | Reserved for SBC; do not use. | |
| REFERENCE_5 | VARCHAR2(240) | ||
| REFERENCE_6 | VARCHAR2(240) | ||
| REFERENCE_7 | VARCHAR2(240) | ||
| REFERENCE_8 | VARCHAR2(240) | ||
| REFERENCE_9 | VARCHAR2(240) | ||
| REFERENCE_10 | VARCHAR2(240) |
| Columns | Validation | Destination |
|---|---|---|
| CODE_COMBINATION_ID | Validate that Charge Code Combination ID (CCID) exists in the GL_CODE_COMBINATIONS table. Validate that the CCID is enabled. If CCID End Date is not null, then check Account Date against End Date to ensure that date occurs before or on the End Date. Account Dates that occur after the End Date of the CCID End Date create an error message. | No destination |
| BATCH_LINE_NUM | Unique Batch Line Number per Set of Books | IGC_CBC_JE_LINES.BATCH_LINE_NUM |
| CC_TRANSACTION_DATE | If ENC_TYPE_ID is Provisional, then CC Transaction Date must fall within an open or future enterable period. If ENC_TYPE_ID is Confirmed, then CC Transaction Date must fall within an open period. If the contract commitment transaction date is not in the defined calendar, then an error message is displayed. |
IGC_CBC_JE_LINES.CC_TRANSACTION_DATE |
| CC_FUNC_DR_AMT | No validation. | IGC_CBC_JE_LINES.CC_FUNC_DR_AMT |
| CC_FUNC_CR_AMT | No validation. | IGC_CBC_JE_LINES.CC_FUNC_CR_AMT |
| JE_SOURCE_NAME | Validate that source is Conversion. | IGC_CBC_JE_LINES.JE_SOURCE_NAME |
| JE_CATEGORY_NAME | Validate that Category is Provisional or Confirmed. | IGC_CBC_JE_LINES.JE_CATEGORY_NAME |
| SET_OF_BOOKS_ID | Validate that the Set of Books ID is a valid ID value within the installed application. | IGC_CBC_JE_LINES.SET_OF_BOOKS_ID |
| ENCUMBRANCE_TYPE_D | Validate Encumbrance Type ID against those defined in the Contract Commitment Options window. | IGC_CBC_JE_LINES.ENCUMBRANCE_TYPE_D |
| TRANSACTION_DESCRIPTION | No validation. | IGC_CBC_JE_LINES.TRANSACTION_DESCRIPTION |
| LAST_UPDATE_DATE | No validation. | IGC_CBC_JE_LINES.LAST_UPDATE_DATE |
| LAST_UPDATED_BY | No validation. | IGC_CBC_JE_LINES.LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN | No validation. | IGC_CBC_JE_LINES.LAST_UPDATE_LOGIN |
| CREATION_DATE | No validation. | IGC_CBC_JE_LINES.CREATION_DATE |
| CREATED_BY | No validation. | IGC_CBC_JE_LINES.CREATED_BY |
| REFERENCE_1 - REFERENCE_10 | No validation. | IGC_CBC_JE_LINES.REFERENCE_1 - IGC_CBC_JE_LINES.REFERENCE_10 |
Running the Contract Commitment Legacy Open Interface Program Procedure
To run the Contract Commitment Legacy Open Interface Program, perform the following steps.
-
In Contract Commitment, navigate to the Submit Request window as follows:
Reports - Run
-
Select the Single Request radio button.
-
In the Name field, select Contract Commitment Legacy Open Interface Program from the list of values.
-
In the Process Phase field, select a process type from the list of values.
Note: Preliminary mode can be run multiple times to view contract commitments that pass and fail validation. In Final mode, encumbrances are created for contract commitments passing validations.
-
In the Batch ID field, select a batch number from the list of values.
-
To apply the parameters, click OK.
-
To send the request to the concurrent manager, click Submit.
-
View the request in the concurrent manager as follows:
View - Requests
Running the Contract Commitment Budgetary Control Legacy Open Interface Program Procedure
To run the Contract Commitment Budgetary Control Legacy Open Interface Program, perform the following steps.
-
In the Contract Commitment responsibility, navigate to the Submit Request window as follows:
Reports - Run
-
Select the Single Request radio button.
-
In the Name field, select Contract Commitment Budgetary Control Legacy Open Interface Program from the list of values.
-
To send the request to the concurrent manager, click Submit.
-
View the request in the concurrent manager as follows:
View - Requests