Oracle Business Intelligence Applications

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

PLP_PLP_GLBALANCEAGGRBYACCTSEGCODES ODI Job

Received Response
3
Views
3
Comments

Hi Gurus,

We are implementing Oracle Analytics Cloud service(OAC) with OBIA + ODI (11.1.1.10.2) version with Finance,HR,Projects and Procurement OOB modules.

I am facing issue with while running incremental load and this ODI job: PLP_PLP_GLBALANCEAGGRBYACCTSEGCODES hangs at insert step.

Can anyone help me...

Cheers

Joji

Answers

  • 1046792
    1046792 Rank 1 - Community Starter

    We resolved this issue. We have changed the parameter at database level and it works.

    Cheers

    Joji

  • Michelle Flynn
    Michelle Flynn Rank 2 - Community Beginner

    What did you change?  We have the same problem with this mapping.  In our dev and test environments it runs well.  In prod it hangs on the insert.

  • 1046792
    1046792 Rank 1 - Community Starter

    Hi, Compare Dev and PROD database parameters. In our case we have few parameters different and we alligned both dev and prod as same and it worked.