Error while performing first full load for OBIA 11.1.1.10 on financial and P&S

3231950

Hi All,

We are facing the following error while performing the first full load for OBIA 11.1.1.10 for Financial and P&S with a data source of peoplesoft 9.2

ODI-1228: Task SDE_PSFT_Stage_GLSegmentDimension_LOVFilters.W_GL_SEGMENT_LOV_ID_G_Full (Integration) fails on the target ORACLE connection BIAPPS_DW. Caused By: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

We have checked the enterprise calendar id and it is updated.

Please advise what might be the cause and what is the solution.

Highly appreciated

Thank You in advance

Venkata Yaswanth Ramisetty

Hi,

If possible, can you please share the query at which step you are facing this error from the session log so that it will be easy to debug.

Thanks,

Yaswanth