Wrong Account Numbers
Date: 21 Mar 99 18:07:51 EST
Date: Mon, 22 Mar 1999 22:30:29 -0800 Creation of SOB
Date: Mon, 22 Mar 1999 17:46:25 -0500 SOB ID
"Mark Thomas" appsora@hotmail.com wrote:
Date: Thu, 22 Apr 1999 13:09:12 +0200 Changing SOB Name
From: Frances_Morrier@concentramc.com
Date: Wed, 28 Apr 1999 15:46:42 -0500
Date: Wed, 28 Apr 1999 13:57:01 PDT
Date: Wed, 28 Apr 1999 17:01:17 -0400
Date: Wed, 28 Apr 1999 17:47:30 -0400 Upload Segment Values
--- Han Allen-A11606 a11606@tjisbdc.tianjin.corp.mot.com wrote:
Date: Sun, 9 May 1999 07:45:21 -0700 (PDT) New Set of Books
Date: Tue, 15 Jun 1999 10:55:45 -0400
Date: Tue, 15 Jun 1999 11:22:10 -0400
Date: Tue, 15 Jun 1999 11:27:19 -0400
Date: Tue, 15 Jun 1999 11:32:51 -0400
From: Thomas Matthews
Subject: FA: Wrong Account Numbers in Apps 11
Hello,
We just noticed this past week, that when we run the "Standard Journal
Entries" process that the account numbers that get sent over to General L=
edger
are incorrect.
For depreciation we get this:
Dr. Depreciation Expense (01-100-7110) $100000
Cr. Depreciation Reserve (01-100-7110) $100000
Its obvious that this is incorrect.
I have checked ALL my accounts that I defined at the Category level and t=
hey
are correct.
This appears to be a problem with Account Generator.
We are using Applications Version 11.0.200.
Any ideas on what to do? Are there any patches available for this?
Thanks,
Tom
From: "Mohan Iyer"
Subject: RE: Wrong Account Numbers in Apps 11
Hi Tom,
You need yto fix the problem with a load of the default FA:Account Generator
rules.
Looks like you did an upgrade from 10.7 and it sort of junked the
Flexbuilder rules (if you had any) or just went wierd.
We had a similar problem when we went live on R11 from 10.7 and the analyst
after looking at our FA:Account Generator setting just had us load the
default rules for FA:Account Generator as it would have been when Apps was
installed(fresh).
Somehow, the file in the relevant directory cannot be loaded into the
database using the WorkFlow Loader program (atleast ours could not be) and
he sent us a default file that we loaded through Workflow Builder.
Let me know if you need the file and I will email the same to you from my
work.
Mohan Iyer
Oracle Apps - Financial Consultant
Fortuna Technologies Inc.
Sunnyvale, CA
From: murali.avanamuthu@unisys.com
Subject: GL: problem in creating new SOB
Hi,
We're implementing 11.0.2 with MRC & Multi-org.
Our calendar is called 'Unisys Calendar' and is of type '13Mth'. The 1=
2 months
Jan - Dec are defined normally and 31-DEC to 31-DEC is defined as an ad=
justing
period. We have defined periods from Jan 1981 to Jan 2002 ( to enable =
data
conversion and Y2K related testing).
Now when we try to define a new set of books, we get a error saying:
'There is a gap in your Unisys Calendar calendar. Not all dates betwee=
n
30-Nov-90 and 31-Dec-90 are assigned to a period. Please fix the calen=
dar OR
choose another calendar.'
The technical message is :
Ora - 6512 from APPS. GL_PERIOD_STATUSES_PKG at line 259
I reviewed this package and it seems like there is a table called
'GL_DATE_PERIOD_MAP', in which there are rows for 01-DEC-1990 to 30-DEC=
-1990
with period_name as 'NOT ASSIGNED'. That's why we seem to be getting t=
heis
error.
Whereas, the GL_PERIODS table is not aware of such a period. In fact D=
EC-90 has
been defined as a valid period.
Any clues?
Thanks in advance,
Murali
Hi,
we are trying to develop some reports in GL. We have multiple sets of
books. I want to collect the set_of_books_id depending on the
responsibility the user log into. How does the set of books id gets
populated as soon as the user logs in?
Thanks a lot in advance,
Mark Thomas
From: "Firake, Vinay (CAP, GCF)" Vinay.Firake@gecapital.com
Subject: RE: GL Technical
Mark,
A SOB is attached to a responsibility through the profile option 'GL Set of
Books id'
You can find out the SOB attached by the procedure
fnd_profile.value('GL_SET_OF_BKS_ID')
Hope this helps
Vinay
[mailto:Frances_Morrier@concentramc.com]
Sent: Wednesday, April 28, 1999 2:07 PM
Subject: GL: Changing Set of Books Name
Has anyone ever successfully changed the set of books name? Our high-level
organization name has changed and we would like the new name to appear on
reporting--FSG's, all sub ledger reports, etc.
One of our technical folks has indicated that there is no way to change
this 'on a screen' and he is hesitant to go ahead and change it via SQL.
Any comments from someone who's experienced this need?
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: Changing Set of Books Name
We researched it once, and it isn't too difficult, apparently. However, we
never actually went through with it. If it will help, here is the script we
wrote to do this. We were actually planning on changing the names of some
SOBs which we had stopped using. We wrote this for 10.7, and NEVER actually
ran it. We chickened out.
The date last updated told us which SOBs to change. No promises or
guarantees. USE AT YOUR OWN RISK!!!
spool fixsobname.txt
update fnd_profile_option_values
set profile_option_value 'Z DO NOT USE - ' || profile_option_value
where rowid in (select v.rowid
from gl_sets_of_books b
, fnd_profile_option_values v
where b.last_update_date to_date('05-NOV-1996')
and b.name profile_option_value
and b.set_of_books_id 26)
/
update gl_sets_of_books
set name 'Z DO NOT USE - ' || name
, short_name 'Z ' || short_name
where last_update_date to_date('05-NOV-1996')
and set_of_books_id 26
/
select v.profile_option_value
from gl_sets_of_books b
, fnd_profile_option_values v
where b.last_update_date to_date('05-NOV-1996')
and b.name profile_option_value
and b.set_of_books_id 26
/
select set_of_books_id
, name
, short_name
, latest_opened_period_name
, last_update_date
from gl_sets_of_books
where last_update_date to_date('05-NOV-1996')
and set_of_books_id 26
order by last_update_date
/
rollback;
spool off
---
Ernie Logan, Jr. | She put me on Earth to accomplish
Ernie_Logan@bmc.com | a certain number of things. Right
(713) 918-3649 | now, I'm so far behind, I will never
918-1313 (FAX) | die.
From: "RADHA KRISHNAN" radha_rk@hotmail.com
Subject: Re: GL: Changing Set of Books Name
Hi,
You can probably try and define a new set of books with the 'new
name' and attach the same calender,currency and chart of accounts
of your old set of books.
This new set of books may be attached to whatever is the relevant
responsibility. That could give the new name when you work with it.
I am not sure whether this is a correct remedy for your requirement.
You may pl try this and share your experience with us.
Thanks,
Radhakrishnan
radha_rk@hotmail.com
From: "Joe Maliszewski" jmaliszewski@csi.com
Subject: RE: Changing Set of Books Name
Actually, I did it from the Apps. Used Examine on the SOB form. Then
changed the Profile Options on the form also. No repercussions. But I
think it depends a bit on the modules installed.
Joe Maliszewski
Consultant
jmaliszewski@csi.com
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
Subject: RE: Changing Set of Books Name
As usual Joe is right. As we change the SOB form and profile option it
perfectly worked for us.
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
Hi,
Does anyone has experience to upload key segment values by program.
Would
you please tell me the method and send me the program. We are using
R10.7NCA.
My email address is a11606@email.mot.com.
Thanks in advance.
Best Regard,
Allen
From: Kevin Gillins kgillins@yahoo.com
Subject: Re: Upload Segment Values
Here are the 2 tables needed in a 10.7 install to load the value sets
with values. This is a non account type valueset. There is just one
more value for loading an account type value set in the
compiled_value_attributes.
Hope this helps
insert into fnd_flex_values (
flex_value_set_id,
flex_value_id,
flex_value,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
enabled_flag,
summary_flag,
description,
compiled_value_attributes,
value_category,
attribute1
)
select
b.flex_value_set_id,
fnd_flex_values_s.nextval,
a.your_value_column,
trunc(sysdate),
2,
trunc(sysdate),
2,
0,
'Y',
'N',
a.your_description,
'Y' || chr(10) || 'Y',
'xxxxxx', -- value set context name for context
sensitive
null
from
your_values_table a,
fnd_flex_value_sets b
where
load_number =&&1 and
your_process_flag = 'A' and
b.flex_value_set_name = 'YOUR_VALUE_SET_NAME' and
not exists (
select 1
from
fnd_flex_values c
where
b.flex_value_set_id = c.flex_value_set_id and
a.your_value_column = c.flex_value)
;
insert into fnd_flex_values_tl (
flex_value_id,
language,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
description,
translated
)
select
a.flex_value_id,
'AMERICAN',
trunc(a.last_update_date),
a.last_updated_by,
trunc(a.creation_date),
a.created_by,
a.last_update_login,
a.description,
'Y'
from
fnd_flex_values a,
fnd_flex_value_sets b
where
a.flex_value_set_id = b.flex_value_set_id and
b.flex_value_set_name = 'YOUR_VALUE_SET_NAME' and
not exists (
select 1
from
fnd_flex_values_tl c
where
a.flex_value_id = c.flex_value_id)
;
Kevin Gillins
Oracle Applications Consulting
WEB PAGE http://www.geocities.com/SiliconValley/4946
From: Missy Schaetzke Missy_Schaetzke@zd.com
Subject: New Set of Books
We implemented 10.6 for the manufacturing and financial apps in January
'97, upgraded to 10.7 character September '97. Up until recently we've
only had the need to use one set of books. I've been asked to do some
research on adding another set of books.
Our financial group is looking to add another set of books that would share
our current chart of accounts, accounting calendar and functional currency
with our existing set of books. We would only be using AR, AP & GL for
this new set of books.
My questions are, do we need to be multi-org in order to this? What
considerations should we keep in mind? Also, we are in the process of
upgrading to R11 next month. Would we be better off waiting until we are
live on R11 or setting this up in our current environment?
If you need more information please let me know.
Thanks,
Missy Schaetzke
Sr Systems Analyst
Ziff-Davis Education
From: "Joe Maliszewski" jmaliszewski@csi.com
Subject: RE: New Set of Books
Based on what you explain, yes, you would need Multi-Org.
Regarding considerations, there are many. Consider the shared data. You
can read the Multi Org manual.
Regarding the 11 vs. 10.7 issue, Multi Org in 11 is a more stable install
than in 10.7. Some tasks are automated where you had to do them manual in
10.7. But I would ask a question regarding what is driving the need to do
the Multi Org install? If it is needed before the upgrade to 11 then that
answers your question. If it can wait I would probably wait. Do the
upgrade then go to MO in 11.
Regards,
Joe Maliszewski
Consultant
jmaliszewski@csi.com
From: "Steve Hersh" hershs@worldnet.att.net
Subject: RE: New Set of Books
You don't need another set of books, just use a different value for your
balancing segment. There is no need to maintain a seperate set of books if
you do not need to.
From: Steve Bradley sbradley@sprynet.com
Subject: New Set of Books
If you are using AP and AR with your original SOB and want to also use them
with your new SOB, you will need to be Multi-Org. Single org can only
point to one SOB.
Respectfully,
Steve Bradley, CPA
OASIS Consulting Group, Inc.
Office 404-352-8387
Fax 404-609-9856
Pager 888-912-2569