Compiling AFF - Error
Date: Thu, 1 Jul 1999 15:46:18 +0100
From: Peter Wolyniec pwolyniec@edenconsulting.co.uk
Subject: Accounting Flexfield: Compiling
All,
Hit the following error on compilation of my AF:
APP 01536 FDFRKS: Unable to compile flexfield APPL=101 CODE=GL#
NUM=101
Anyone have any ideas as to what the cause might be?
Thanks
Pete W.
Date: Thu, 1 Jul 1999 09:02:28 -0600 (MDT)
From: "Mavis O'Connor" moconnor@IR.ColoState.EDU
Subject: Re: Accounting Flexfield: Compiling
This exact error happened to me. It was because I had not checked
the balancing segment qualifier for any of the flexfield segments.
AFF greater than 30 characters
Date: Tue, 13 Jul 1999 07:34:47 -0400
From: "Aguilar, Michelle" AguilaMi@rf.suny.edu
Subject: GL Accounting Flexfield
We are entering the Conference Room Pilot phase of our Oracle implementation
for version 11.02 and we are testing a Chart of Accounts that has a total
accounting flexfield length of 37 characters (including the six separators).
We have some documentation that indicates that some standard reports may
truncate the accounting flexfield after 30 characters and may need to be
customized. If you are familiar with this problem could you please provide
us with information as to (1) what reports get truncated after 30 characters
and (2) how difficult is it to customize the reports that get truncated.
Thanks.
Michelle
Date: Tue, 13 Jul 1999 10:57:03 -0400
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Subject: RE: GL Accounting Flexfield
Michelle: We faced the same problem during our implementation of GL.
Basically any report that displays the AFF you will have a problem with
(Account Analysis, etc.) You need to the select the reports that the users
feel are necessary with the compelete AFF and then either customize them or
create reports from scratch that provide similar information. Hope this
helps.
Regards,
Tony Venkatesh
(301) 206-8452
(703) 793-0847
tonyv@mcsgroups.com
Can We Create a New Accounting Flexfield ?
Date: Fri, 16 Jul 1999 11:31:27 +0530
From: Kluz amn9c038@trishul.icil.co.in
Subject: Can* We* Create* a* New* Accounting* Flexfield*?
Dear All
Is it possible to create an new accounting flexfield with the
flexfield and segment qualifiers.
Please tell, If Yes, How? If Not Why?
Thank you
Kluz
Date: Fri, 16 Jul 1999 09:00:47 -0400
From: msudhir@answerthink.com (Manjapra Sudhir)
To: amn9c038@trishul.icil.co.in
Subject: Re: Can* We* Create* a* New* Accounting* Flexfield*?
Hi Kluz,
Sure you can create a new accounting flexfield? The question I have
for you is is data loaded to the exixsting flexfield? If data is loaded I
recommend that you do not. If you are in a test environment you could try
this. The way to do is disable the current structure add a new segment and
attach the relevant value set. The path will be
setup/flexfield/key/segments. It is never recommended in a production
environment beacause data gets corrupted. Hope this helps. Bye.
Regards,
Manjapra Sudhir
Designing structure of Accounting FlexField
Date: Mon, 02 Aug 1999 12:07:33 -0400
From: "Bimal Patel" bimal.patel@acnenergy.com
Subject: AFF setup-Urgent
Hello Group,
We are trying to setup 6 segment structure as under:
Company.Region.Account.Subaccount.Services.Open
( 3 . 2 . 6 . 3 . 8 . 4 = No of characters in each segment)
We propose to setup each state as a Region as we need to track
information statewise.
In Service segment we plan to generate values outside financial system
as follows:
First 2 digit Product line
Next 2 digit Operational Area
Next 4 digit Service Provider Company Info
Questions for setup are:
1)Should we have 3 seperate segments to track above information and
maintain everything within Financial only.In this case AFF will be of 8
segments instead of 6 or the way proposed above?
2)Are there any better suggestions to this design to meet this
requirements?
3)Is it that some of this information can be tracked in AR through Item
FF or Transactional FF?
Please treat this as Urgent and flood me with comments.
Bimal Patel
Date: Mon, 02 Aug 1999 15:06:12 -0500
From: "Danette Fedock"danette_fedock@ccmail.c-tec.com
Subject: Re: AFF setup-Urgent
We went kinda crazy and had 9 segments (so we could track everything).
Our consultants thought we were nuts but it has come is very handy
when doing queries. Although, some reporting software you can buy
allows you to split a segment to do reporting.
Date: 3 Aug 99 01:09:18 IST
From: senthil senthilvenkatesh@usa.net
Subject: Re: [Re: AFF setup-Urgent ]
Bimal...
no harm in having more segements .... except that it would be a lot more
cumbersome... but then if u require to have complex reports generated i
suggest u have it as 8 segements as thru AR u would not get the required
reports.... i suggest u have an 8 segment account code and put some effort in
defining account aliases...
hope i have been of help....
regards
senthil
Date: Mon, 2 Aug 1999 16:07:19 -0400
From: "Epp, Charles A" cepp@kpmg.com
Subject: RE: AFF setup-Urgent
The short answer to the question is if you want to do any relevant reporting
on it, it should be a separate field in GL. From a GL business perspective,
look at whether a financial manager or user would need to know this
information in GL or if it does reside better in AR. I don't know what your
company does but looking at the structure, it seems that the meaningful
segments in GL would be:
Company
Region
Account (I don't see why you need an account and subaccount)
Product LIne
Operational Area (I don't see why you need Service provider
company info)
A good rule of thumb is to minimize the amount of structure within the AFF
that is more meaningful and resides more logically in a subsystem. In
addition, if is a piece of data that a financial manager would want to track
because it has a material affect on the overall financial performance of the
company, build it into the AFF. If tracking product line is critical, which
it sounds like if would be, build another AFF segment. In your case, you
likely need only one account segment (if it needs to be lengthened to
incorporate the subaccount, do so). The service provider company info
sounds like it is static information that is specific to a service provider
versus a financial data piece that changes each period (like cost of sales
or sales commission). If that's not the case, consider it as another
segment. Hope that helps.
Date: Tue, 03 Aug 1999 07:39:48 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: [Re: AFF setup-Urgent ]
Bimal:
Leave the details to the sub-ledgers if possible. More often than not, you
will find that this is actually possible. Except in a few cases. You need to
analyse the information that you need to enable you to take "informed"
decisions. And then check whether any of the standard reports you have in
the subledgers meet this need effectively. If they don't, then you have a
case for including this as a segment in your AFF. See if you live without
it. Else...
Further, the greater the number of segments in your AFF, the wider it gets
and some reports do not have the ability to capture the entire code
completely. If I rememeber correctly, this is restricted to 30 Char. (Not
sure - check this out).
Bottomline - analyse your information needs from a broad perspective when it
comes to designing your AFF. Detail reporting is best left to sub-ledgers
for that is where you have details of the transactions. The GL AFF is better
used for having an overall view of the business ably supported by reports
from sub-ledgers. The AFF should actually cover business dimensions. And to
that effect, analyse issues such as responsibility accounting, companies
which need a balance sheet at the end of a period (basically do you need
reports on what each company in the balancing segment owes and owns?),
budgeting needs...From here on you will have to drill down and get more
specific. But not to such detail where you will land up duplicating reports
from sub-ledgers.
Hope this helps.
Ananth
Senior Applications Consultant
Cost Allocation FF in HR Vs AFF
Subject: [orahrms-l] COST ALLOC FF
From: "Barnett, Janet L." jlbarnet@mountaineergas.com
Date: Thu, 15 Jul 1999 10:14:52 -0400
Does the Cost Allocation FF need to look exactly the same as the
Accounting FF?
(same number of segments)
Thanks for any help...Janet Barnett
Mountaineer Gas Company
Subject: Re: [orahrms-l] COST ALLOC FF
From: "William C.Stratton" bstratton@sprynet.com
Date: Thu, 15 Jul 1999 11:02:13 -0400
Hi Janet,
Not necessarily, but highly recommended if you are using Oracle General
Ledger. This simplifies the mapping of costing from Payroll to Oracle GL.
Not all Oracle Payroll customers use Oracle GL, so that is why the cost
flexfield for payroll is allowed to be different that the cost flexfield for
Oracle GL
Hope this helps.
Bill Stratton
BOSS Corporation
Better Organization Service Solutions
6455 East Johns Crossing, Suite 404
Duluth, GA 30097
770-622-5500 (V) 770-622-5400 (F)
http://www.bosscorporation.com
Subject: RE: [orahrms-l] COST ALLOC FF
From: "Schwartz, Ken" kschwar@rwjf.org
Date: Thu, 15 Jul 1999 11:15:45 -0400
Janet:
That depends on the General Ledger system you are using. If it is the
Oracle general Ledger, then YES you should make the segments look EXACTLY
like what is set up in GL. I recommend using the GL established value sets
to INSURE that you have an exact match.
Regards,
Ken Schwartz
Independent Consultant
Specializing in Oracle HRMS
Site: 609-720-7529
Cell: 404-226-6334
Mail: kenschwartz@mindspring.com
Site Mail: kschwartz@rwjf.org
Subject: Re: [orahrms-l] COST ALLOC FF
From: Lewis R Cunningham lcunning@lmumail.lmu.edu
Date: Thu, 15 Jul 1999 08:45:07 -0700
If you're just an HR site (no payroll) I would map it to whatever costing
your payroll system is expecting. Currently, ADP can only handle small
account codes (I think it's 5 positions, but I don't have the docs with
me), unless you don't mind cutting individual segments and sticking them in
left over columns.
If you have Oracle Payroll and Oracle GL, map to GL. If you don't have
Oracle payroll, map to what your payroll systems is expecting. It can map
to GL.
Lewis
Subject: RE: [orahrms-l] COST ALLOC FF
From: Scott Madole smadole@solbourne.com
Date: Fri, 16 Jul 1999 08:30:22 -0600
No,
You may create additional segments in your cost allocation flexfield that do
not correspond to segments of your accounting flexfiled. This allows you to
track more detail at your sub-ledger level. For instance your accounting
flexfield may include a segment for project, but you may want to track
project and task at the payroll level for time entry purposes. You can
create an additional segment in your cost allocation flexfield for task.
Subject: RE: [orahrms-l] COST ALLOC FF
From: Scott Madole smadole@solbourne.com
Date: Fri, 16 Jul 1999 08:32:47 -0600
You should include all segments of your accounting flexfield and use the
same value sets, but you can create additional segments that do not map to
the GL. This allows you to report on more detail in your sub-ledger. That is
the purpose of the GL Flexfield Map Screen.
Sub-account, though is not defined and is open, is required to rollup
Date: Tue, 10 Aug 1999 14:10:18 -0400
From: "Bimal Patel" bimal.patel@acnenergy.com
Subject: Re:Gl Account Hierarchy
Hi,
Our client has specific requirement,where in the Natural Account segment one
of
the level would be sub account info.
As sub account info is not final as yet they would like to keep it open(No
specific pre determined values/Range)but still wants to have Roll up feature
of
hierarchy to be in place.The structure is :
Level 1 Assets
Level 2 Cash /Accounts Receivables etc
Level 3 Natural Account(Detail cash a/cs etc)
Level 4 Sub Account
Is it posible to have Repetitive values at sub account level?(Cash will have
sub
a/c 000001 and also Some receivable item will have sub a/c 000001)
How to incorporate such requirement in FF structure?
Thanks
Bimal Patel
Date: Tue, 10 Aug 1999 12:25:16 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: Re:Gl Account Hierarchy
Not a problem, but be aware that subaccount 00001 will
always have the same name regardless what main account
it is used with.
Date: Tue, 10 Aug 1999 15:38:53 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Gl Account Hierarchy
That is not necessarily true. If you make Sub Account a Dependent segment
each one can have a different name (the Dependent Segment).
Now, personally, I detest Dependent segments. And we could get into a whole
debate on that. I don't want to go down that road. We have discussed on
this forum a couple of times in the past couple of years.
I didn't respond to this original request because I could not make heads nor
tails of what they were trying to accomplish. I am still not sure what the
question is.
Joe Maliszewski
Consultant
Date: Tue, 10 Aug 1999 19:33:30 -0400
From: "Bimal Patel" bimal.patel@acnenergy.com
Subject: Re: Gl Account Hierarchy
Clarification:
The main accounts are all decided by parent company and are not in serial
order.
This implementation is done only at subsidiary level and they want to keep
subaccount information for their internal reporting only without the
knowledge
of their parent company.
For eg If Main Cash A/c is 000410 their sub a/c could be 000001 or 000004
and for Main revenue a/c is 001500 still they want to use sub a/c 000001
with
diffrent meaning then one used with cash a/c.(may mean revenue from
product1)
Does it make sense now?
Sorry for the confusion-if at all u had one.
Bimal Patel
Date: Wed, 11 Aug 1999 11:16:30 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Gl Account Hierarchy
I understand what you are attempting to do. And a Dependent Segment is the
way to accomplish that functionality. But I am against Dependent Segments.
The main reason is you will NOT be able to report on the Dependent Segment
by itself. In you example, with Revenue 001500, you will not be able to get
a P/L by product because the subaccount(Dependent Segment) is linked to that
one account only. So subaccount 000001 could mean product 1 for acct 001500
but could mean product xyz for account 001501.
I do not know the requirements of the site so I do not know if this is or
could be a need.
Dependent segments also limit some other functionality.
My last piece of advice is:
Test, test and test some more. When you think you have tested enough go
back and test some more.
Joe Maliszewski
Consultant
Date: Wed, 11 Aug 1999 12:45:26 -0400
From: sbradley@sprynet.com
Subject: RE: Gl Account Hierarchy
I agree with Joe on the use of dependent segments. You cannot report on it
nor can you define parents. The only thing it does for you is permit the
use of the same value with different independent parent values and use
different names for the same value. The definition process is slightly more
involved because you must select the independent value it is associated
with.
If a dependent relationship is truely desired (and in many cases it is
justified) I always propose the following solution.
Combine the 2 segments into one by expanding the independent segment to a
size large enough to handle the independent and dependent values. You lose
nothing in functionality except for now having a larger segment that has 2
logical fields within it. Data entry is easier if you have zero fill
properly configured.
Steve Bradley, CPA
OASIS Consulting Group
Office 404-352-8387
Fax 404-609-9856
Pager 888-912-2569
Date: Wed, 11 Aug 1999 14:07:52 -0400
From: "Bimal Patel" bimal.patel@acnenergy.com
Subject: Re: Gl Account Hierarchy
hi Steve and Joe,
Thanks for your inputs.Even I had thought of defining Dependent segment
option but since this client wants to use this as Reporting segment
independently this was ruled out.Also if we increase size of independent
segment then their specific requirement of not reporting to their Parent
company about their own structure is not met with.
What I have proposed to my client is to define sub account as seperate level
in hierarchy and right now they have agreed to set aside 250 values of sub
a/c for each main account.Is there any problems you can think of with this
solution.
thanks
Bimal
Date: Wed, 11 Aug 1999 14:42:22 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Gl Account Hierarchy
I suppose that would work. It seems limiting though. And it also uses one
Segment for multiple purposes. That is not a recommended approach.
It sounds as though there are requirements which only a person on site would
be able to evaluate.
Don't forget to test!
Joe Maliszewski
Consultant
How to handle Dependant Segments
Date: 11 Aug 99 14:08:27 IST
From: senthil senthilvenkatesh@usa.net
Subject: GL Segment Dependancies
Hi guys could u pls tell me how to handle sement dependencies in Accounting
Flexfield. O want one segment as company(independant,)another as Division
(dependant on Company), and another as Sub-division (this i want dependant on
the Division)....Pls tell me how toachieve this...
regards
senthil
Date: Wed, 11 Aug 1999 14:37:21 +0530
From: Sandeep Devarchetti sandeepd@sohm.soft.net
Subject: Re: GL Segment Dependancies
Hi Senthil
I think you can achieve this by defining the independent value set for
Company
segment and dependent value sets for the the Division
and Sub Division segment.
HTH
Sandeep
Allow Posting Flag got disabled on its own
Date: Thu, 12 Aug 1999 08:46:54 -0400
From: don.bell@ca.pwcglobal.com
Subject: Acct Validation Code Combination Problem
We have dynamic insertion turned on in GL and use cross-validation rules -
Rel 10.7 sm 16.1.
Recently we have had problems with journals being rejected due to the Allow
Posting Flag being
mysteriously disabled in the account code combinations screen. All segment
values are enabled
and the cross-validation rules do not exclude these combinations. Does
anyone know why the
Allow Posting flag in the account code combinations table would be disabled
when each segment
value has been created with posting allowed?
I would really appreciate your help on this.
Thanks.
Date: Thu, 12 Aug 1999 09:03:02 -0500
From: "Nguyen, Michael" MNguyen@co.scott.mn.us
Subject: RE: Acct Validation Code Combination Problem
Don -
Not sure I understand your quesion exactly. My experience with Cross
Validation Rules is that once you set these up, if there are past postings
with the code combination, they will continue to be valid unless you end
date them.
Date: Thu, 12 Aug 1999 10:32:05 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Acct Validation Code Combination Problem
This is true. You can also disable a CC, though not always recommended
because of some problems it can cause with the sub-ledgers. I don't think
this was his issue though.
See my prior post. ( see below)
Joe Maliszewski
Consultant
Date: Thu, 12 Aug 1999 10:30:13 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Acct Validation Code Combination Problem
There is nothing I know that would do this "behind the scenes". Did you
check to see when the CC was changed last and by who? I am not sure if it
in 10.7 but in 11 there is a CC Violation report with a parameter to run it
to actually disable all CCs that violate Cross Validation Rules.
Check those items and let us know what you come up with.
Joe Maliszewski
Consultant
Date: Thu, 12 Aug 1999 09:00:37 -0700 (PDT)
From: Kevin Gillins kgillins@yahoo.com
Subject: Re: Acct Validation Code Combination Problem
If there was a rule defined one time that would make these combinations
violate the rule and someone run the report "Cross-Validation Rule
Violation Report" with the disable option set to Yes then the combos
would get disabled.
Someone may have updated the table with SQL.
Someone went to the combo screen and disabled them manually.
Kevin
Date: Thu, 12 Aug 1999 13:10:09 -0400
From: don.bell@ca.pwcglobal.com
Subject: Re: Acct Validation Code Combination Problem
The account code combinations we are having trouble with are still "
enabled ". It's the " allow posting flag " which has been disabled. The
Cross Validation Rule Violation Report was recently run but the code
combinations in question were not disabled and I do not know if the " allow
post flag " was enabled or disabled prior to running the report. Since the
accounts have both " Post " and " Budget " flagged as "Yes" when originally
set up, I would not have expected the "Posting" flag to be disabled by
running the Cross Validation Rule Violation Report.
Thanks.
Don
Date: Thu, 12 Aug 1999 12:34:22 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
Subject: Re: Acct Validation Code Combination Problem
Don,
I've seen some e-mails flying back and forth on this. Have you gone
into "About this Record" to figure out who may have last updated the
record? It would show date and time updated by username.
Sue
Date: Thu, 12 Aug 1999 10:50:38 -0700 (PDT)
From: Kevin Gillins kgillins@yahoo.com
Subject: Re: Acct Validation Code Combination Problem
Don, check the creation date and last update date. If they are the
same then check each of the segment values for posting and budget
allowed. I wonder if one of the segment values has posting allowed set
to 'N' which will set all combinations created with that value to not
allow posting. Maybe on the department level or some other segment.
Just a thought.
Kevin
Using additional Segments in Cost Allocation KFF in HR module
Subject: [orahrms-l] Adding flexfields on Cost Allocation Key Flexfields
From: "Shrestha, Amal" AShresth@JPI.com
Date: Fri, 23 Jul 1999 13:04:23 -0500
We are on Oracle HRMS 10.7. I would like to use additional segments on
the HR Cost Allocation Key Flexfields. These additional segments will
be used to store information such as cost center manager name, cost
center regional office, and etc. After creating these additional
segments on this flexfield on the test instance, Costed Run shows that
all charges have occurred on the suspense account, 9999..99...
After disabling these additional segments from this flexfields and
re-running the costing, Costed Run shows the results as expected.
Does anyone have a solution to this problem? What could have caused
this problem or do you think I may have missed a step somewhere?
Thanks!
Amal Shrestha
Application Developer
JPI
600 E. Las Colinas Blvd. # 500
Irving, TX 75039
Phone: 972-556-3840
FAX: 972-556-3860
mailto:ASHRESTH@JPI.com
Subject: Re: [orahrms-l] Adding flexfields on Cost Allocation Key Flexfields
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Tue, 27 Jul 1999 08:55:11 -0400
I can't understand why u are having this problem. I have tested the same
scenario and works as expected. U need to endure that in the mapping screen
(Mapping HRMS Cost Allocation Keyflex fields to GL Accounting Flexfield)
that only the Costing fields that correspond to GL accounting flexfields
are map. The other fields , in your case the additional segments should not
be mapped.
Regards
Manny.Wohiren@yale.edu
Territory Flexfields - Value Sets do not appear
Date: Sat, 20 Mar 1999 13:45:08 PST
Date: Mon, 22 Mar 1999 13:49:11 -0800
Date: Mon, 22 Mar 1999 14:03:48 -0800
Date: Tue, 23 Mar 1999 15:01:08 PST
From: "tayi sanjit"
Subject: VALUE SETS DO NOT APPEAR!!
Hi!
While enabling the Territory Flexfield in release 11.0.2, we have to
create a new value set and attach it to the relevant segment. Value sets
have been created but when I try to attach them in the Key Flexfields
form, they do not appear.
Is it a bug and what's the solution??
Thanks!
sandy
From: Cary Walker
Subject: RE: VALUE SETS DO NOT APPEAR!!
Hello Sandy,
I've seen the same behavior in 10.7 regarding value sets for Flexbuilder.
In my case ,the cause was that the value set had the protected_flag set to
'Y'. You see the protected flag in the table APPLSYS.FND_FLEX_VALUE_SETS.
Not sure if that helps but I hope it does.
Regards,
Cary Walker
From: william.k.richardson@ac.com
Subject: RE: VALUE SETS DO NOT APPEAR!!
I've had that happen before as well. In my case, we had exceeded the
maximum size for the name field of the value set. We could view them in
Define Value Sets, but they did not appear when creating the flexfield
structure. I also don't remember what the max size was.
Try using a shorter name and see if that helps.
Bill
From: "tayi sanjit"
Subject: Re: VALUE SETS DO NOT APPEAR!! - Thanks Rohini!
Rohini,
It worked!
I reduced the size and it worked! Thanks a ton!
Is it a bug?
Regards,
SANDY