Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Journal and SubLedger level Reporting Currencies (1 viewing) (1) Guest
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 0
TOPIC: Journal and SubLedger level Reporting Currencies
#2928
ERPKumar (User)
Junior Boarder
Posts: 33
graphgraph
User Offline Click here to see the profile of this user
Journal and SubLedger level Reporting Currencies 11 Years, 11 Months ago  
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.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2930
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Journal and SubLedger level Reporting Currencies 11 Years, 11 Months ago  
At what point do you get the above exception? Once you complete your ledger?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2931
ERPKumar (User)
Junior Boarder
Posts: 33
graphgraph
User Offline Click here to see the profile of this user
Re:Journal and SubLedger level Reporting Currencies 11 Years, 11 Months ago  
Primary Ledger is done and I have this error when trying to ADD Reporting currencies for Journal level and Sub ledger level reporting currency.

Hope you got me.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2932
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Journal and SubLedger level Reporting Currencies 11 Years, 11 Months ago  
It is important to know when exactly you get this error in order for me to try to troubleshoot the issue. Which event is triggering this error. "when trying to add reporting" is a very generic statement. An error comes on the screen after a certain event like "when button is pressed" etc. A screen shot would help. Thanks.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2933
ERPKumar (User)
Junior Boarder
Posts: 33
graphgraph
User Offline Click here to see the profile of this user
Re:Journal and SubLedger level Reporting Currencies 11 Years, 11 Months ago  
Hasan,

Sorry about that ! I`m attaching a document with detailed screen shots here to this thread. Please go through that when you get a min.

Thanks.
File Attachment:
File Name: Journal_level_and_Sub_ledger_level_Reporting_Currencies_Problem.doc
File Size: 695808
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2939
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Journal and SubLedger level Reporting Currencies 11 Years, 11 Months ago  
Ok, so you are getting this error when you click on Apply button. That is what I wanted to know. Thanks.

One possible cause of this issue as the following:

The start_date_active for the lookup ORG_TYPE does not match the organization unit's start date.

This is registered with Oracle as Bug 6903873.

Here is a workaround:

Change the start_date_active for the lookup (ORG_TYPE['OU']) to match with your operating unit.

You can change the date by using following navigation:

HRMS Manager responsibility -> Other Definitions -> Lookup Tables screen.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2985
hamnaabeer (User)
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
Re:Journal and SubLedger level Reporting Currencies 11 Years, 11 Months ago  
Hi Hassan,

I am unable to access any video. It is giving me the following message. Is it some thing from my side.

Here is the Message:

Forbidden
You don't have permission to access /flash_stream/vod/media/of_on_install_strategy_j1.mp4 on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Thanks,
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3013
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Journal and SubLedger level Reporting Currencies 11 Years, 10 Months ago  
Hamnaabeer,
Sorry for the late reply. Please create new topic for new problem in the forum. For technical inquiries like these send an email directly to our customer service email address (or use the form on the website). We will assist you relatively faster on these technical issues.
If you are still facing issues please send an email to us and we will assist you in troubleshooting the problem.
Thanks
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4876
kinghere (User)
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
Re:Journal and SubLedger level Reporting Currencies 10 Years, 7 Months ago  
Hasan,
I got the same error. I don't even see "Lookup Tables Screen" option under Global HRMS Manager -> Other Definitions.

Can you help?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4894
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Journal and SubLedger level Reporting Currencies 10 Years, 6 Months ago  
Dear Kinghere, Please open a new post for this problem. Every one involved in this post is getting email notifications. We dont want that to happen. Thank you for your understanding.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop