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 and later
Information in this document applies to any platform.


 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: 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.


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


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

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