Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
1
Comments
3231950
3231950 Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

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

Answers

  • Venkata Yaswanth Ramisetty
    Venkata Yaswanth Ramisetty Rank 5 - Community Champion

    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