PLP_PLP_GLBALANCEAGGRBYACCTSEGCODES ODI Job

Question

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

1046792 · Answer

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.

Michelle Flynn · Answer

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 · Answer

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

Cheers

Joji