Please enable JavaScript.
Coggle requires JavaScript to display documents.
Lifepoint - Data Extraction - Coggle Diagram
Lifepoint - Data Extraction
Pre-reqs
Access to Oracle Fusion Cloud BICC console
Administrative privileges for BICC configuration
Understanding of GL business requirements
Azure Data Factory and Databricks environment ready
GL Business requirements
identify required data
GL
Chart of Accounts (COA)
GL Balances (Period and Daily)
GL Journals and Journal Lines
GL Periods and Calendars
Budget vs Actual data
GL Code Combinations
Currency rates and translations
AP?
AR?
Map requirements to View objects
Review Oracle Fusion GL data model
Identify corresponding View Objects for each requirement
Document data relationships and dependencies
Common View Objects
GL
FinExtractAM.GlExtractAM.GlBalancesExtract
FinExtractAM.GlExtractAM.GlJournalExtract
FinExtractAM.GlExtractAM.GlJournalLineExtract
FinExtractAM.GlExtractAM.GlCodeCombinationExtract
FinExtractAM.GlExtractAM.GlPeriodStatusExtract
FinExtractAM.GlExtractAM.GlCurrencyRateExtract
FinExtractAM.GlExtractAM.GlLedgerExtract
FinExtractAM.GlExtractAM.GlAccountExtract
FinExtractAM.GlExtractAM.GlBudgetExtract
FinExtractAM.GlExtractAM.GlDailyBalanceExtract
BICC Offering Configuration
Create Offering for GL
2.Add GL View Objects to Offering
Extraction Job Configuration
1.Create GL Extraction Job
Configure Incremental Parameters
Job Scheduling
Create GL Schedule
Configure Notifications
GL Configuration Validation
Test GL Extraction
Performance Testing (Optional)
GL BICC Integration with Azure
Configure Azure Data Factory
Configure Databricks Processing
GL Configuration Documentation (Optional)
BICC Config export
Version Control (store in GIT)