My Oracle Support Banner

BI Cloud Connector Console Extraction Is Failing After 19A Upgrade (Doc ID 2508596.1)

Last updated on JUNE 28, 2022

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Symptoms

 After 19A Upgrade of Fusion Application, the below error is encountered when extracting data from Fusion Application through BICCC:


BICCC Module Extraction:

  1. Financial
    2. Project
    3. Procurement & Spend, Sales
    4. Customer Data Management
    5. Human Resources

    * VO: FscmTopModelAM.InvoiceDistributionAM.InvoiceDistributionPVO

    * Error Message: Caused by: java.sql.SQLException: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 904, message: ORA-00904: "INVOICEDISTRIBUTIONPEO"."BILL_TRANSACTION_TYPE_CODE": invalid identifier at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed.

Changes

 
* Previous FA version: 18C
* New FA version: 19A

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.