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?
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: Re:Error in Row Set Account Assignment
#2089
pretty_pink (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Error in Row Set Account Assignment 12 Years, 7 Months ago  
Hi Hasan,

I've encountered a problem regarding account assignments in FSG ROW SETS. The segment values of the account assignments only shows the COA segment values excluding the ledger segment, which I think is the reason for the error. Here's the error: ORA-01400: cannot insert NULL into ("RG"."RG_REPORT_AXIS_CONTENTS"."LEDGER_SEGMENT_TYPE"

Can you help me with this problem?
 
Report to moderator   Logged Logged  
 
Last Edit: 2011/08/17 09:57 By pretty_pink.
  The administrator has disabled public write access.
#2095
pretty_pink (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:Error in Row Set Account Assignment 12 Years, 7 Months ago  
Please see attached file for details.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2111
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Error in Row Set Account Assignment 12 Years, 7 Months ago  
In R12 there is a new flexfield in GL, called GL Ledger Flexfield. It is for internal use only and should not be modified manually. It has an additional "Ledger" segment.
The question is have you modified this flexfield?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2114
pretty_pink (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:Error in Row Set Account Assignment 12 Years, 7 Months ago  
No. I don't as I also knew that GL Ledger Flexfield should not be modified. I always used the Accounting Flexfield.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2124
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Error in Row Set Account Assignment 12 Years, 7 Months ago  
Have you already run "Program - Generate Ledger Flexfield"?
Did that fix the issue?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2126
pretty_pink (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:Error in Row Set Account Assignment 12 Years, 7 Months ago  
Do I need to run this program?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2136
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Error in Row Set Account Assignment 12 Years, 7 Months ago  
Yes please regenerate the flexfield by running the program.
If that does not fix the problem then follow these steps:
1-Setup->Financials->Flexfields->Key->Segments
2-Query for Application - General Ledger
FlexfieldTitle - GL Ledger Flexfield
3-Select the chart of account
4-Unfreeze flexfield definition
5-Make sure ledger segment is enabled
6-freeze flexfield definition
7-Compile
Retest the issue
 
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