Please Help : Problem with Journal level and Subledger Level Reporting Currency.

Hello Mr.Hasan,

Just wanted to check and see if you could please help me here with the Journal level and Subledger level Reporting currency.

I`m able to successfully create the reporting currencies for Journal level and Subledger level currencies through the Accounting Setup Manager screen following your videos and I can see them there.

However, I cannot see them when I query my Data Access Set to look into my Primary Ledger.

I have the SQL Exception :

java.sql.SQLException: ORA-20001: HR_7220_INVALID_PRIMARY_KEY: ORA-06512: at "APPS.HR_ORGANIZATION_API", line 4872 ORA-06512: at "APPS.GL_LEDGERS_PKG", line 111 ORA-06512: at line 1

I know you gave us a small workaround and I followed that video too. I created around 2 more dummy ledgers as you showed in the workaround video and I still see this error.

Really do not know what else to do with this exception here and I`m kind of struck with Journal level and Subledger level reporting currencies and I cannot move forward.

Please help if there is any other solution or if there is anything we can do.

Thanks.