1. Cloud
  2. Guides
  3. Tours
  4. Concepts
  5. Tools
  6. References
  7. Integrations
  8. Data applications
    1. Incorta Data Delivery
    2. Oracle Cloud ERP data app
      1. Installation and Configuration
      2. Analyze Financials and Supply Chain
      3. Analyze Human Capital Management
      4. FAQs and Troubleshooting
    3. Oracle EBS data app
    4. Salesforce data app
    5. BlackLine
    6. XLCubed Excel plugin dashboards for SAP ECC
    7. NetSuite data app
    8. SAP S/4HANA Financials and Supply Chain data app
    9. Data app Data Wizard
  9. Releases

Data Applications → Oracle Cloud ERP FAQs and Troubleshooting

Below are some frequently asked questions that you might have and some troubleshooting steps.

FAQs

QuestionAnswer
How do I determine the data size for my cluster?To determine the data sizing for Oracle Cloud ERP, create a BI Publisher report using the following SQL:
SELECT owner, table_name, num_rows, round(blocks * 8 / 1024) size_mb FROM all_tables WHERE owner not in ('SYS', 'SYSTEM') ORDER BY 1, 2
Are Incremental extracts supported for Oracle Cloud ERP?Yes.
How are VOs kept up to date with Oracle releases?If Oracle adds new columns to the VOs, you can perform a full re-extract of the VO from the BICC and save the table in Incorta.
How do I dynamically load data for only the last 90 days to a table?You can use the value 90d in the date filter field Load Only Files Created Since to load only the files created in the last 90 days before the loading starts.
How do I add a query filter to a VO in the BICC?Edit the VO and in the Query Filter section add a filter like __DATASTORE__.<COLUMN> = <VALUE>
How do I query a VO from OTBI?In OTBI, select Administration → Issue SQL, and run a query. Following are example queries:
SELECT_PHYSICAL count(*) FROM "HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO"

SELECT count(*) FROM EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"')'FscmTopModelAM.ReceiptAccountingAM.ReceiptAccountingTxnP1'

Troubleshoot

IssueResolution
Not able to connect to the Oracle Cloud ERP data source from Incorta due to a system error
  ●  Verify that the Incorta server has network access to the Oracle Cloud ERP URL.
  ●  Update the Java Development Kit (JDK) to version 8.
Not able to see files in the UCMVerify that the user roles are set up correctly in the BICC and UCM. Refer to the Configuration Prerequisites for more detail.
No sample file is found for data store fscmtopmodelam.finglcalaccam.fiscaldaypvoUpload at least one sample file to WCC to be used for schema discovery
The connector did not find any extract file for the datastore fscmtopmodelam.finglcalaccam.fiscaldaypvo, or a file with a title like file_fscmtopmodelam_finglcalaccam_fiscaldaypvo-batch*.zipThere must be at least one file in the UCM so that the connector can discover which columns are selected for extraction. Sign in to the UCM and search for the file. If it exists, re-extract the file from the BICC.
No schema named [catalogam] found under catalog [fscmtopmodelam]This means that the connector did not find any files whose names start with the prefix file_fscmtopmodelam_catalogam*. Sign in to the UCM and search for that file. If it exists, re-extract the file from the BICC.
Failed to load data from [Fusion] due to [Column PURCHASEORDERDISTRIBUTIONPOHEADERID] not found in source schemaSource columns were either dropped or renamed in the Oracle Fusion source VO. Open the table in the schema, select Files, Save, then Done.
Mismatch of columns in various files of a VO in the UCMNew columns were added to the fields when the offering was uploaded and the full load files were extracted because data has been previously extracted. Read only the files in the UCM from a certain date by adding a date filter in the File Criteria - Last Modified Timestamp connector property. For example:: >= '2021-01-01 00:00'. The other option is to delete older files from the UCM.
Disk full errorContact Incorta Cloud Support to change the cache clean period for the UCM ZIP files to something less than the default of one hour.
Table load hangsOpen the loaded log. The load may have been interrupted while the tables were still reading from the data files, which can cause an java.io.IOException: Premature EOF IO error and the file lock to not be properly released. Restart the loader.
Note

You can use BI Publisher to debug in the Fusion Application. Refer to the Troubleshoot section of the Cloud Applications documentation for further information.