Search This Blog

Friday, September 23, 2016

Currency Conversion - p_ETL_CUR, Invalid object name

When first setting up currency conversion on a feed in BPM Connect, the following error can occur:

P_ETL_CUR ?" Failed with the following error: "Invalid object name...."   

The following picture illustrates this error from the windows event log:







This error can be caused by "null" values being populated in the CONFIG_PKG table's CurrencyOper field when the CurrencyCalc field is enabled to "Y".

See the following illustration of this combination:


To rectify, go to Process -> Data Pipeline -> Advanced Settings.

Set the Currency Conversion Operator to an * or / depending on the type of currency rate being used. 







This error is has been identified in the 324 pack of BPM Connect. 

No comments:

Post a Comment