Skip to main content
G
Gaurav
Contributor
December 19, 2024
Solved

Data Adapter showing Invalid object for ReconItem table

  • December 19, 2024
  • 1 reply
  • 0 views

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:

 

Best answer by Gaurav

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,

 

1 reply

G
GauravAuthorAnswer
Contributor
December 19, 2024

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,

 

Terms & ConditionsAccessibility statement