Forum Discussion

Gaurav's avatar
Gaurav
New Contributor III
12 days ago

Data Adapter showing Invalid object for ReconItem table

Hello,
We've recently upgraded to OFC 8.4 and after this upgrade, underlying RCM table names have been updated.
For ex - XFW_RCM_ReconItems is now updated as ReconItem.

Earlier on OFC 8.2 , we were able to query this table using a data adapter as well as in Business rule (DBConnInfoApp) . But now it's not working anymore. Same issue is occurring for all other RCM related tables. 
It does work for other tables not related to OFC/RCM (for ex - Member).

Are there any restrictions in OneStream to query certain application tables? Is there any workaround for this?

Regards,
Gaurav

Table showing in Application Database:




Giving error while querying from data adapter:

 

User Interface
  • Gaurav's avatar
    Gaurav
    11 days ago

    Found the workaround from onestream support, it is an existing Platform bug that impacts OFC tables.
    To query this in data adapter, you will have to include rcm. or txm. before the table name.
    ex - RCM.ReconItem

    Thanks,

     

  • Gaurav's avatar
    Gaurav
    New Contributor III
    11 days ago

    Found the workaround from onestream support, it is an existing Platform bug that impacts OFC tables.
    To query this in data adapter, you will have to include rcm. or txm. before the table name.
    ex - RCM.ReconItem

    Thanks,