From oracle-ai-data-platform-fusion-bundle
Productized Fusion → Oracle AI Data Platform pipeline with curated BICC extracts (GL/AR/AP/PO/Suppliers/Items), bronze/silver/gold medallion in Delta, conformed dimensions (account/calendar/org/supplier/item), gold marts (AR-Aging/AP-Aging/GL-Balance/PO-Backlog/Supplier-Spend), and OAC workbooks installable via OAC REST API. Use when the user wants to load Fusion ERP/HCM/SCM data into AIDP, build a CFO dashboard from Fusion, set up a Fusion-backed lakehouse, install OAC dashboards for Fusion data, set up OAC MCP for natural-language Fusion analytics in Claude/Cline/Copilot, run BICC extracts incrementally, productize the Oracle blog "Bring Fusion Data into AIDP Workbench Using BICC", or extract Fusion via the saas-batch REST API. Triggers — "load Fusion into AIDP", "set up Fusion bronze layer", "build CFO dashboard from Fusion", "install OAC workbooks for Fusion", "run BICC extract", "Fusion AIDP medallion", "saas-batch Fusion extract".
How this skill is triggered — by the user, by Claude, or both
Slash command
/oracle-ai-data-platform-fusion-bundle:aidp-fusion-bundleThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Productizes the official Oracle blog [Bring Fusion Data into Oracle AI Data Platform Workbench Using BICC](https://blogs.oracle.com/ai-data-platform/bring-fusion-data-into-oracle-ai-data-platform-workbench-using-bicc) plus the ateam companion [How to Extract Fusion Data using Oracle AI Data Platform](https://www.ateam-oracle.com/how-to-extract-fusion-data-using-oracle-ai-data-platform). One ins...
aidp-fusion-bundle — Fusion ERP/HCM/SCM → AIDP, batteries includedProductizes the official Oracle blog Bring Fusion Data into Oracle AI Data Platform Workbench Using BICC plus the ateam companion How to Extract Fusion Data using Oracle AI Data Platform. One install, three commands, populated lakehouse + installed OAC dashboards.
aidp-fusion-bicc (sibling plugin, smaller scope).aidp-fusion-rest.aidp-epm-cloud.aidp-essbase.This bundle is additive to and complementary with Oracle's managed Fusion data offerings. It productizes Option 1 of pdf1's three-option architecture (BICC into AIDP for "Custom AI and ML, raw data access, data engineering"). Never positioned as a replacement for FDI, OAC, OTBI, BIP, or Data Transforms.
Mirrors pdf1 §"What Can You Do Once the Data is in Oracle AI Data Platform":
aidataplatform connector familyai_generate("which suppliers had >$1M Q1 spend?") against gold marts via OCI Generative AIInstall the CLI on your laptop:
pip install -e /path/to/oracle-ai-data-platform-fusion-bundle
Scaffold a bundle in your repo:
aidp-fusion-bundle init
Edits bundle.yaml and aidp.config.yaml to match your environment (Fusion pod URL, AIDP workspace, OAC URL, OCI Vault refs for credentials).
Probe prerequisites against your pod:
aidp-fusion-bundle bootstrap --check-iam
Confirms BICC role, BICC External Storage profile (set in BICC console), AIDP catalog, IAM policies, Vault access.
Run the orchestrator:
aidp-fusion-bundle run --mode seed # first-time full extract
aidp-fusion-bundle run --mode incremental # daily delta
Install OAC dashboards (one-time per OAC instance):
# 5a. Upload bundle-vN.bar to your OCI Object Storage bucket. Use a folder
# prefix in the object name; --bar-uri later passes the Oracle-documented
# `file:///<folder>/<name>.bar` shape.
oci os object put --bucket-name aidp-fusion-bundle-bar \
--file ./bundle-v0.1.0a0.bar \
--name aidp-fusion-bundle/bundle-v0.1.0a0.bar
# 5b. (One-time, in OAC UI) Create the AIDP connection. Run the bundle
# in --print-only mode to write the 6-key JSON, then upload it via
# OAC UI: Data → Connections → Create → "Oracle AI Data Platform".
aidp-fusion-bundle dashboard install --target oac --oac-url ... --print-only
# 5c. Run the REST install (snapshot register + restore + poll). The bundle
# uses GET /catalog?type=connections&search=<name> to find the existing
# connection and skip the POST. Subsequent installs re-use it.
aidp-fusion-bundle dashboard install --target oac \
--oac-url https://oac.example.com \
--bar-bucket aidp-fusion-bundle-bar \
--bar-uri 'file:///aidp-fusion-bundle/bundle-v0.1.0a0.bar'
Uses ONLY Oracle-documented public REST endpoints: GET /catalog?type=connections&search=<name> (precheck), POST /catalog/connections (skipped when precheck finds the existing connection — the realistic flow), POST /snapshots, POST /system/actions/restoreSnapshot, GET /workRequests/{id}. See docs/oac_rest_api_setup.md for the one-time IDCS confidential-app + Object Storage Resource Principal setup.
End users chat with the data via OAC MCP. Print the MCP config snippet:
aidp-fusion-bundle dashboard mcp-config
Paste into claude_desktop_config.json (or Claude Code / Cline / Copilot equivalent), restart the AI client. Then ask "what's our AR aging?" and watch MCP call discoverData → describeData → executeLogicalSQL against fusion_catalog.gold.ar_aging.
BIA_ADMINISTRATOR_DUTY or ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT. Without it, /biacm/api/v[12]/* endpoints 302-redirect to IDCS. Bootstrap probes for this. (✅ Casey.Brown demo pod: BIAdmin granted; works.)fusion.external.storage Spark option references this BICC profile name. There is no parallel AIDP-side registration. Bundle does not provision the BICC profile; bootstrap verifies it exists.fusion.initial.extract-date for incremental.POST /catalog/connections REST validator does not bless AIDP idljdbc — Oracle's validator falls through to generic Oracle DB schemas requiring serviceName/password/connectionString. The realistic flow is therefore: customer creates the connection via OAC UI once (using the 6-key JSON written by --print-only), then dashboard install re-uses it via the precheck on subsequent runs. (✅ Live-validated TC10h-4, 2026-05-03 against disposable OAC1.)file:///<folder>/<name>.bar — NOT oci://..., NOT bare object name, NOT the OCI Object Storage HTTPS URL. None of the seven URI variants tried during TC10h were correct. Verified live TC10h-3.search=* — GET /catalog?type=connections (no search) returns a single-element TypeInfo header ([{"type":"connections"}]), NOT the actual list. Bundle's list_connections defaults search="*" so the precheck works. (Caught + fixed during TC10h-3 live validation.)C:\Users\anuma\.claude\plans\oracle-ai-data-platform-fusion-bundle.mdoracle-ai-data-platform-workbench-spark-connectorsoracle-aidp-samples/data-engineering/ingestion/Read_Only_Ingestion_Connectors.ipynbProvides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.
Searches MemPalace before answering questions about past work, people, projects, or prior decisions. Returns verbatim stored content instead of guessing from model memory.
npx claudepluginhub ahmedawan-oracle/claude-code-plugins --plugin oracle-ai-data-platform-fusion-bundle