Journal Import API endpoint is a common Integration Service for importing Journal line items into Oracle Financial Cloud(OFC). This API allows Boundary Systems to send multiple journal entries in the defined schema format, Integration Service will validate the schema, converts and sends to OFC General Ledger System. OFC will return the Group ID and processes the Journal Items asynchronously. In case of errors in processing the Journal Import items, boundary systems will receive the email to the configured email or can check the status and download the error logs from Dashboard application using the Group ID received
sent.
Data Owner: Ascend 2.0 Integrations Team
Access Restrictions: This product uses OAuth2 protocol to access resources. Please register and obtain approval form the integration team to generate Client key and Secret.
Base URL:
Test : https://test.api.ucla.edu/admin/finance/integration/gl/journals
SIT : https://qa.api.ucla.edu/admin/finance/integration/gl/journals
Sample Request
Type: Object
{
"consumer":
{
"consumerTrackingId": "",
"consumerReferenceId": "",
"consumerNotes": "",
"boundaryApplicationName": "Epic"
},
"journalBatch": [
{
"journalBatchName": "Epic 2022020201", //Optional journalBatchName can be blank
"journalBatchDescription": "Epic 2022020201", //Optional journalBatchDescription can be blank
"ledgerName": "UCLA Campus US", //Added ledgerName as a required field
"balanceType": "A",
"journalBatchSourceName": "Epic",
"journal": [
{
"journalName": "EPIC Data 1",
"journalDescription": "Journal Import API Testing",
"journalCategoryName": "Epic",
"accountingDate": "2024/01/01",
"journalReference": "",
"journalLines": [
{
"coaSegments": {
"entity": "1411",
"financialUnit": "1000000",
"fund": "10500",
"account": "500004",
"transactionClass": "400",
"program": "00000",
"portfolio": "00000000",
"flex": "00000000",
"activity": "000000",
"intercompany": "0000",
"future": "00000"
},
"debitAmount": 100.00,
"JournalLineDescription": "",
"reconciliationReference": "",
"journalLineReference2": "",
"journalLineReference3": ""
},
{
"coaSegments": {
"entity": "1411",
"financialUnit": "1000000",
"fund": "20000",
"account": "500004",
"transactionClass": "000",
"program": "00000",
"portfolio": "00000000",
"flex": "00000000",
"activity": "000000",
"intercompany": "0000",
"future": "00000"
},
"creditAmount": 100.00,
"JournalLineDescription": "",
"reconciliationReference": "",
"journalLineReference2": "",
"journalLineReference3": ""
}
]
},
{
"journalName": "EPIC Data 2",
"journalDescription": "Journal Import API Testing",
"journalCategoryName": "Epic",
"accountingDate": "2024/01/01",
"journalReference": "",
"journalLines": [
{
"journalName": "EPIC Data 2",
"coaSegments": {
"entity": "1411",
"financialUnit": "1000000",
"fund": "10500",
"account": "500004",
"transactionClass": "400",
"program": "00000",
"portfolio": "00000000",
"flex": "00000000",
"activity": "000000",
"intercompany": "0000",
"future": "00000"
},
"debitAmount": 200.00,
"JournalLineDescription": "",
"reconciliationReference": "",
"journalLineReference2": "",
"journalLineReference3": ""
},
{
"journalName": "EPIC INT 2",
"coaSegments": {
"entity": "1411",
"financialUnit": "1000000",
"fund": "20000",
"account": "500004",
"transactionClass": "000",
"program": "00000",
"portfolio": "00000000",
"flex": "00000000",
"activity": "000000",
"intercompany": "0000",
"future": "00000"
},
"creditAmount": 200.00,
"JournalLineDescription": "",
"reconciliationReference": "",
"journalLineReference2": "",
"journalLineReference3": ""
}
]
}
]
}
]
}
Sample Response Body
Type: Object
{
"message": "Journal Import payload received successfully!",
"trackingId": "d0a86c63-e5f6-4eb6-a866-60ed3cb31122",
"groupId": "20240309023132108",
"fileName": "Epic_GL110_JournalImport_20240309023132108",
"totalLines": [
{
"Batch Name": "EPIC Data 1",
"Total Lines": 2
},
{
"Batch Name": "EPIC Data 2",
"Total Lines": 2
}
]
}