Oracle Business Intelligence

Products Banner

Missing objects in BICC object store

Submitted
529
Views
5
Comments

Description

Objects are missing in BICC object store. These need to be made available in BICC object store. Attached file have details. 

Use Case and Business Need

Implementing ODI and Autonomous data warehouse to extract data from oracle fusion for reporting needs. However BICC object store is missing many objects needed for reporting. These need to be made available in BICC object store for ODI to extract data. These need to be made available in BICC object store for team to continue development. 

More details

Fusion Object Name Data Store available in BICC All Columns available in BICC BICC Data Store
FA_BOOKS_SUMMARY BICC Data Store NOT AVAILABLE No  
FA_CALENDAR_PERIODS BICC Data Store NOT AVAILABLE No  
FA_MC_BOOKS BICC Data Store NOT AVAILABLE No  
FA_RATES BICC Data Store NOT AVAILABLE No  
FND_APPLICATION BICC Data Store NOT AVAILABLE No  
FND_FLEX_VALUES BICC Data Store NOT AVAILABLE No  
FND_FLEX_VALUES_TL BICC Data Store NOT AVAILABLE No  
FND_FLEX_VALUES_VL BICC Data Store NOT AVAILABLE No  
FND_FLEX_VALUE_SETS BICC Data Store NOT AVAILABLE No  
FND_ID_FLEX_SEGMENTS BICC Data Store NOT AVAILABLE No  
FND_ID_FLEX_STRUCTURES BICC Data Store NOT AVAILABLE No  
FND_LOOKUP_VALUES BICC Data Store NOT AVAILABLE No  
FND_TERRITORIES BICC Data Store NOT AVAILABLE No  
GL_JE_CATEGORIES BICC Data Store NOT AVAILABLE No  
GL_JE_SOURCES BICC Data Store NOT AVAILABLE No  
GL_SETS_OF_BOOKS BICC Data Store NOT AVAILABLE No  
HR_ALL_ORGANIZATION_UNITS BICC Data Store NOT AVAILABLE No  
HR_ALL_ORGANIZATION_UNITS_TL BICC Data Store NOT AVAILABLE No  
HR_OPERATING_UNITS BICC Data Store NOT AVAILABLE No  
RA_CUSTOMER_TRX_LINES BICC Data Store NOT AVAILABLE No  
AP_AWT_GROUPS BICC Data Store NOT AVAILABLE No  
GL_SEG_VAL_HIERARCHIES BICC Data Store NOT AVAILABLE No  
HR_LOCATIONS_ALL BICC Data Store NOT AVAILABLE No  
AP_INVOICE_LINES_ALL BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceLineExtractPVO
258 fields out of 264 exists
FISCAL_CHARGE_TYPE, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, MATCHING_RULE_ID, MATCHING_RULE_SET_ID, SHIP_TO_CUST_LOCATION_ID
AP_SELF_ASSESSED_TAX_DIST_ALL BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinApInvTransactionsAM.InvoiceSelfAssessedTaxDistributionPVO
126 fields out of 204 exists
AR_ADJUSTMENTS_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.AdjustmentExtractPVO
AR_CASH_RECEIPTS_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReceiptHeaderExtractPVO
AR_COLLECTORS BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing; this table is part of many data stores
AR_LOOKUPS BICC Data Store AVAILABLE Columns NOT AVAILABLE This object is part of many data stores
AR_PAYMENT_SCHEDULES_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.PaymentScheduleExtractPVO
AR_RECEIPT_METHODS BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReceiptMethodExtractPVO
AR_RECEIPT_METHOD_ACCOUNTS_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReceiptMethodAccountExtractPVO
AR_RECEIVABLES_TRX_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReceivableActivityExtractPVO
AR_RECEIVABLE_APPLICATIONS_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReceivableApplicationExtractPVO
AR_REF_ACCOUNTS_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReferenceAccountExtractPVO
FA_ADDITIONS_B BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinFaSharedUtilAM.FaTransactionExtractPVO
Many fields are missing; this table is part of many data stores
FA_ADDITIONS_TL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinFaTrackDescDetailsAM.FaAdditionBasePVO
FA_ADJUSTMENTS BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.FaBiccExtractAM.AdjustmentExtractPVO
FA_ASSET_HISTORY BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing
FA_ASSET_INVOICES BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.FaBiccExtractAM.AssetInvoiceExtractPVO
FA_BOOKS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.FaBiccExtractAM.BookExtractPVO
143 fields out of 156 exists
FA_BOOK_CONTROLS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.FaBiccExtractAM.BookControlExtractPVO
174 fields out of 185 exists
FA_CATEGORIES_B BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinFaDeprnSetupCategoriesAM.CategoryBasePVO
30 fields out of 64 exists
FA_CATEGORIES_TL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinFaDeprnSetupCategoriesAM.CategoryBasePVO
FA_CATEGORY_BOOKS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.FaBiccExtractAM.CategoryBookExtractPVO
81 fields out of 84 exists
FA_CATEGORY_BOOK_DEFAULTS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinFaDeprnSetupCategoriesAM.CategoryBookDefaultPVO
68 fields out of 90 exists
FA_DEPRN_DETAIL BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinFaDeprDepreciationAM.DepreciationDetailPVO
31 fields out of 42 exists
FA_DEPRN_PERIODS BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.FaBiccExtractAM.DepreciationPeriodExtractPVO
FA_DEPRN_SUMMARY BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.FaBiccExtractAM.DepreciationSummaryExtractPVO
36 fields out of 57 exists
FA_DISTRIBUTION_HISTORY BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinFaSharedUtilAM.DistributionHistoryPVO
"inventory_date_taken" field is missing
FA_LOCATIONS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinFaAssetsSetupLocationAM.LocationPVO
23 fields out of 45 exists
FA_METHODS BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing
FA_RETIREMENTS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.FaBiccExtractAM.RetirementExtractPVO
68 fields out of 71 exists
Missing: backlog_reserve_retired, reval_amortization_retired, revalued_cost_retired
FA_TRANSACTION_HEADERS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinFaSharedUtilAM.TransactionHeaderPVO
Many fields are missing
FA_TRX_REFERENCES BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinFaSharedUtilAM.TransactionHeaderPVO
GL_CODE_COMBINATIONS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVO
Many fields are missing; 117 fields out of 256 exists
GL_DAILY_CONVERSION_TYPES BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.GlBiccExtractAM.DailyConversionTypeExtractPVO
34 fields out of 36 exists
Missing: ENTERPRISE_ID, SEED_DATA_SOURCE
GL_DAILY_RATES BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.GlBiccExtractAM.DailyRateExtractPVO
29 fields out of 40 exists
Missing: ATTRIBUTE_DATE1-5, ATTRIBUTE_NUMBER1-5, ENTERPRISE_ID
GL_JE_HEADERS BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalHeaderExtractPVO
GL_JE_LINES BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVO
GL_LEDGERS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.GlBiccExtractAM.LedgerExtractPVO
113 fields out of 122 exists
GL_PERIOD_STATUSES BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.GlBiccExtractAM.PeriodStatusExtractPVO
31 fields out of 42 exists
HR_LOCATIONS BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing
HZ_CUSTOMER_PROFILES_F BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.CustProfileExtractPVO
HZ_CUST_ACCOUNTS BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing; this table is part of many data stores
HZ_CUST_ACCOUNT_ROLES BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing; this table is part of many data stores
HZ_CUST_ACCT_SITES_ALL BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing; this table is part of many data stores
HZ_CUST_PROFILE_CLASSES BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.CustomerProfileClassExtractPVO
131 fields out of 151 exists
HZ_CUST_SITE_USES_ALL BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing; this table is part of many data stores
HZ_LOCATIONS BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing; this table is part of many data stores
HZ_PARTIES BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
HZ_PARTY_SITES BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing; this table is part of many data stores
HZ_RELATIONSHIPS BICC Data Store AVAILABLE Columns NOT AVAILABLE Many fields are missing; this table is part of many data stores
RA_BATCH_SOURCES_ALL BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionBatchSourceExtractPVO
109 fields out of 112 exists
RA_CUSTOMER_TRX_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionHeaderExtractPVO
RA_CUSTOMER_TRX_LINES_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionLineExtractPVO
RA_CUST_TRX_LINE_GL_DIST_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionDistributionExtractPVO
RA_CUST_TRX_TYPES_ALL BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionTypeExtractPVO
86 fields out of 90 exists
RA_RULES BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.DistributionRuleExtractPVO
RA_TERMS_TL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ArBiccExtractAM.PaymentTermTLExtractPVO
XLA_AE_HEADERS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalHeaderExtractPVO
73 fields out of 99 exists
XLA_AE_LINES BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalLineExtractPVO
Many fields are missing; 141 fields out of 325 exists
XLE_ENTITY_PROFILES BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.XleBiccExtractAM.LegalEntityExtractPVO
73 fields out of 83 exists
Missing: LE_INFORMATION_DATE1-5, LE_INFORMATION_NUMBER1-5
ZX_LINES BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.ZxBiccExtractAM.DetailTaxLineExtractPVO
334 fields out of 348 exists
AP_CHECKS_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ApBiccExtractAM.DisbursementHeaderExtractPVO
AP_DISTRIBUTION_SETS_ALL BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
12 fields out of 28 exists
Missing: ATTRIBUTE_CATEGORY, ATTRIBUTE1-15
AP_INVOICE_PAYMENTS_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ApBiccExtractAM.PaidDisbursementScheduleExtractPVO
AP_INVOICES_ALL BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceHeaderExtractPVO
225 fields out of 230 exists
AP_LOOKUP_CODES BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
Missing: DISPLAY_SEQUENCE
AP_PAYMENT_SCHEDULES_ALL BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoicePaymentScheduleExtractPVO
AP_TERMS_B BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.ApBiccExtractAM.PaymentTermHeaderExtractPVO
29 fields out of 61 exists
Missing: SEED_DATA_SOURCE, GLOBAL_ATTRIBUTE***
FND_LOOKUP_VALUES_B BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
FND_TERRITORIES_VL BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
GL_IMPORT_REFERENCES BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalImportReferenceExtractPVO
GL_LEGAL_ENTITIES_BSVS BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.GlBiccExtractAM.LegalEntityBSVAssgmtExtractPVO
HR_ORGANIZATION_UNITS_F_TL BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
IBY_EXT_BANK_ACCOUNTS BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
IBY_PAYMENT_METHODS_TL BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinPmtFDPmtMethodAM.PaymentMethodTranslationPVO
Missing: SEED_DATA_SOURCE
PER_ALL_PEOPLE_F BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.ReceiptAccountingAM.ReceiptAccountingTxnRefPVO
PJF_PROJ_ELEMENTS_B BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
PJF_PROJECTS_ALL_B BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
PO_HEADERS_ALL BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
POZ_SUPPLIER_SITES_ALL_M BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
POZ_SUPPLIERS_V BICC Data Store AVAILABLE Columns NOT AVAILABLE This table is part of many data stores
XLA_DISTRIBUTION_LINKS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalDistributionExtractPVO
92 fields out of 98 exists
XLA_EVENTS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalEventExtractPVO
35 fields out of 38 exists
XLA_TRANSACTION_ENTITIES BICC Data Store AVAILABLE Columns AVAILABLE FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalTransactionEntityExtractPVO
XLE_REGISTRATIONS BICC Data Store AVAILABLE Columns NOT AVAILABLE FscmTopModelAM.FinExtractAM.XleBiccExtractAM.RegistrationExtractPVO
Missing: ENTERPRISE_ID

Original Idea Number: 201e5d126a

3 votes

Submitted · Last Updated

Comments