How Can I Find the Connectors and Schemas Associated With Common View Objects?
Question
How can I find the schemas and connectors associated with common View Objects?
Environment
All Oracle Fusion Cloud Applications connectors
Answer
Each Oracle Fusion Cloud Applications connector contains a large number of tables. Use the table below to identify the connectors and schemas associated with common View Objects:
| View Object | Connector | Schema |
|---|---|---|
| Accounts Receivable | Oracle Fusion FSCM | FIN_EXTRACT_AR_BICC_EXTRACT |
| Accounts Payable | Oracle Fusion FSCM | FIN_EXTRACT_AP_BICC_EXTRACT |
| General Ledger | Oracle Fusion FSCM | FIN_EXTRACT_GI_BICC_EXTRACT |
| Subledger Accounting | Oracle Fusion FSCM | FIN_EXTRACT_XLA_BICC_EXTRACT |
| Tax | Oracle Fusion FSCM | FIN_EXTRACT_ZX_BICC_EXTRACT |
| Expenses | Oracle Fusion FSCM | FIN_EXTRACT_EXM_BICC_EXTRACT |
| Order Management | Oracle Fusion FSCM | SCM_EXTRACT_DOO_BICC_EXTRACT |
| Shipping | Oracle Fusion FSCM | SCM_EXTRACT_WSH_BICC_EXTRACT |
| Inventory Management | Oracle Fusion FSCM | SCM_EXTRACT_INV_BICC_EXTRACT |
| Opportunity Management | Oracle Fusion CRM | CRM_EXTRACT_MOO_BICC_EXTRACT |
| Service Marketing | Oracle Fusion CRM | SERVICE_EXTRACT_SVC_MGMT_BICC_EXTRACT |
| Marketing | Oracle Fusion CRM | CRM_EXTRACT_MKT_BICC_EXTRACT |
For more information on how View Objects (also called datastores in the source) link to your database tables, see our View Object to database lineage mapping documentation. We recommend using our Google Sheets connector to sync this documentation, allowing you to write SQL queries that reference it in your destination.