General Ledger (Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing Initiated)
In this integration, the file created in Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing uses the FBDI template for Import Journal to create a CSV file in Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing.
The “.zip” file is loaded into UCM for further processing in Oracle ERP Financial Cloud.
For the Import Journal template refer to https://docs.oracle.com/en/cloud/saas/financials/21b/oefbf/general-ledger.html#journalimport-3142
Note: In the following table, blank values are passed as placeholders in “csv”.
FBDI Values for GL_INTERFACE TABLE
Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing Source Value
Comments (DATA Mapping Comment)
*Status Code
NEW
Journal Import Status
 
Default by CCS in Batch report.
*Ledger ID
 
Ledger ID from the Manage Primary Ledger page in ERP.
 
Defaulted in CCS.
*Effective Date of Transaction
CI_FT (ACCOUNTING_DT)
Accounting Date. Should be in YYYY/MM/DD format.
*Journal Source
 
Journal Entry Source Name.
 
Defaulted in CCS as per ERP configuration.
*Journal Category
 
Journal Category Name for the transaction.
 
Must be a valid value in Manage Journal Categories Setup Task Page in ERP.
 
Populated /Defaulted by CCS.
*Currency Code
CI_FT (CURRENCY_CD)
Must be a valid value in Manage Currencies Task Page in ERP.
 
Use 3 character ISO currency code (Example: USD)
*Journal Entry Creation Date
SYSDATE
Journal Creation Date in YYYY/MM/DD format.
*Actual Flag
A
Balance Type of the Journal.
 
Defaulted “A” by CCS
Segment1
CI_FT_GL (GL_ACCT Position1)
Distribution Codes Configuration in CCS to reflect the General Ledger accounts in the ERP.
 
From Segment 1 to 10
Segment2
CI_FT_GL (GL_ACCT Position2)
 
Segment3
CI_FT_GL (GL_ACCT Position3)
 
Segment4
CI_FT_GL (GL_ACCT Position4)
 
Segment5
CI_FT_GL (GL_ACCT Position5)
 
Segment6
CI_FT_GL (GL_ACCT Position6)
 
Segment7
CI_FT_GL (GL_ACCT Position7)
 
Segment8
CI_FT_GL (GL_ACCT Position8)
 
Segment9
CI_FT_GL (GL_ACCT Position9)
 
Segment10
CI_FT_GL (GL_ACCT Position10)
 
Up to Segment30
 
CCS has functionality for 10 Segment. For the next 20 Segment CCS batch report will pass a Blank Value.
Entered Debit Amount
CI_FT_GL, (Amount)
Blank if the Amount is negative.
 
Amount columns must not contain a thousand separator and must use a period (.) as the decimal separator.
Entered Credit Amount
CI_FT_GL, (AMOUNT)
Blank if the Amount is positive.
 
Amount columns must not contain a thousand separator and must use a period (.) as the decimal separator.
Converted Debit Amount
 
 
Converted Credit Amount
 
 
REFERENCE1 (Batch Name)
CI_FT_PROC, (BATCH_CD)
 
REFERENCE2 (Batch Description)
 
 
REFERENCE4 (Journal Entry Name)
 
 
REFERENCE5 (Journal Entry Description)
 
 
REFERENCE6 (Journal Entry Reference)
 
 
REFERENCE7 (Journal Entry Reversal flag)
 
 
REFERENCE8 (Journal Entry Reversal Period)
 
 
REFERENCE9 (Journal Reversal Method)
 
 
REFERENCE10 (Journal Entry Line Description)
 
 
Statistical Amount
 
 
Currency Conversion Type
 
 
Currency Conversion Date
 
 
Currency Conversion Rate
 
 
Interface Group Identifier
CI_FT_PROC, (BATCH_NBR)
A number used for grouping of Journals.
Context field for Journal Entry Line DFF
 
 
ATTRIBUTE1 Value for Journal Entry Line DFF
 
 
ATTRIBUTE2 Value for Journal Entry Line DFF
 
 
ATTRIBUTE3 Value for Journal Entry Line DFF
 
 
ATTRIBUTE4 Value for Journal Entry Line DFF
 
 
ATTRIBUTE5 Value for Journal Entry Line DFF
 
 
ATTRIBUTE6 Value for Journal Entry Line DFF
 
 
ATTRIBUTE7 Value for Journal Entry Line DFF
 
 
ATTRIBUTE8 Value for Journal Entry Line DFF
 
 
ATTRIBUTE9 Value for Journal Entry Line DFF
 
 
ATTRIBUTE10 Value for Journal Entry Line DFF
 
 
Attribute11 Value for Captured Information DFF
 
 
Attribute12 Value for Captured Information DFF
 
 
Attribute13 Value for Captured Information DFF
 
 
Attribute14 Value for Captured Information DFF
 
 
Attribute15 Value for Captured Information DFF
 
 
Attribute16 Value for Captured Information DFF
 
 
Attribute17 Value for Captured Information DFF
 
 
Attribute18 Value for Captured Information DFF
 
 
Attribute19 Value for Captured Information DFF
 
 
Attribute20 Value for Captured Information DFF
 
 
Context field for Captured Information DFF
 
 
Clearing Company
 
 
Ledger Name
 
 
Encumbrance Type ID
 
 
Reconciliation Reference