Code Combination
Loading Code Combinations
Date: Mon, 05 Apr 1999 18:11:57 +0700
From: "S. NATARAJAN" SNATA@WIPSYS.GE.COM
Subject: Code Combination
Hi 1. Do we have any standard way to generate the Code Combination based on the client
rules.
2. If I have my my output (Code Combination ) on a Flat file is there any way I can put it
on the Apps Table.
Thanks Natarajan. Wipro Enterprises Solutions.
Date: Mon, 05 Apr 1999 09:18:05 -0500
From: Mike Dennis mdennis@mdp.com
Subject: Re: Code Combination
As I recall, we loaded most of our code combinations when implementing by turning on
dynamic insertion and loading a "journal entry" into the general ledger open
interface table for each combo with $0. Then, imported the entry (which created the
combos), turned off dynamic insertion, and then deleted the journal entries.
Full description of Code Combinations
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Segment Value descriptions
Date: Mon, 28 Jun 1999 16:49:15 -0400
Hi all,
I am trying to create a simple SQL report which lists all my segments (the entire code
combination) and also the description which goes along with that. Can someone please tell
me where I can get the full description of the entire code combination.
Thank you, Bill
From: "Karnik, Bhushan" Bhushan.Karnik@Olsten.com
Subject: RE: Segment Value descriptions
Date: Mon, 28 Jun 1999 17:04:40 -0400
try fnd_flex_value_children_v view.
COA for Insurance Co.
From: Sesha_Komaravolu@techsol.com [mailto:Sesha_Komaravolu@techsol.com]
Sent: Thursday, 8 April 1999 5:17
Subject: Insurance Chart of Accounts!
Hello!
I am currently at an Insurance company and they have defined 11 segments for the
Accounting Flexfield (GL).
I would like to know if this is the normal trend in the insurance industry and is a Book
segment usually used?
Can I get some insurance companies account structures (with segments)?
Appreciate your help. -Sesha
Date: Thu, 8 Apr 1999 07:23:52 +0800
From: "Solomon, Stephen" Stephen.Solomon@rac.com.au
Subject: RE: Insurance Chart of Accounts!
Sesha,
I am working at the a company called the RAC of which it has a insurance branch and we
only have 5 segments
xx - Company
xxxx- Account
xx - Location
xxx - Section
xxx - Product
By having as many segments as you have got it would make entry of code combinations very
tedious. Not sure about the Book segment as we are operating as a single org not multi.
Cheers Stephen
Currency as a Segment
Date: Sat, 10 Apr 1999 11:36:17 +0400
From: PeriasamyR@mashreqbank.com
Subject: GL Chart of Account Structure - Need for currency segment
Hello all, We are currently implementing Rel 11 General Ledger for a leading bank in
Middle East. The legacy system's GL Account codes contain a currency indicator built into
it. We also understand that in some other GL implementations in banks, a separate segment
for currency is included in the Accounting Flexfield structure. Considering the
multi-currency feature of GL entry and inquiry and also ability of using FSG to report on
period balances in all currencies along with their converted values, is there any specific
need to have a 'Currency' segment in Accounting flexfield. We are also implementing
FA/AP/PUR/INV(!!!).
Thanks in advance 'Peri' Periasamy Ramamoorhty ('Peri') Satyam Enterprise Solutions Ltd.
From: Steve Bradley [SMTP:sbradley@sprynet.com]
Sent: Monday, April 12, 1999 10:03 AM
Subject: RE: GL Chart of Account Structure - Need for currency segment
I am not sure what the business reasons are for the currency indicator segment in the
bank's legacy system. Maybe it serves the same purpose as the Oracle currency field. I
have been working with foreign currency systems for 10 years ( 6 years with Oracle) and I
have never seen a business need for a currency segment in the account structures.
Prior to 5 years ago, most US financial systems were very weak in foreign currency. If the
legacy system you speak of is a US system the currency segment may have been a work around
the foreign currency deficiency. There may be some custom code for currency conversions,
revaluations, translations, etc.
Respectfully, Steve Bradley, CPA OASIS Consulting Group, Inc. Office 404-352-8387 Fax
404-609-9856 Pager 888-912-2569
Date: Mon, 12 Apr 1999 11:48:05 -0400
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
Subject: RE: GL Chart of Account Structure - Need for currency segment
Hi Peri!
Consider a situation where your bank is trading in Currency. Means currency can be treated
as an item and one can derive many reports if the currency is maintained as one of AFF
segment besides making use of OF functionality like Budget, Summary, Mass allocation etc
etc..
Thanks Ravi Jagannathan (MIS) Tel : (305) 816 4831
Default Segment Qualifier
Date: Mon, 26 Apr 1999 11:20:04 -0400
From: "Cathy LaMarre" lamarreca@irctt.com
Subject: GL: Help setting a form default
We are 10.7 char and I am having trouble setting a form default. The form is FNDFFMS
(Define Segment Value). You can get there with Setup, Financial, Flex, Validation, Values.
The field I would like to default to nothing is within the pop-up box for Segment
Qualifiers. The Account Type defaults to "Expense". I would like it to not
default and hence the user would have to select a value. Normally I would go into sqlforms
and just null out the default value and regenerate the form. I do not have the source code
for FND forms. I cannot find a profile or any other setup to set this default. Does anyone
know how I can do what I want ?
The reason why I need to do this is some of our users are careless in data entry and the
value cannot be changed once the segment value is created.
Thanks. Cathy
Date: Tue, 27 Apr 1999 07:30:49 -0400
From: "Bob Delaney" rdelaney@prodigy.net
Subject: RE: GL: Help setting a form default
This problem was supposed to be fixed in R11, but apparently it was not. The following
work around will force users to update the account type when adding new accounts.
Bob Delaney Principal Consultant Information System Services, Inc
Sign on to the Application Developer responsibility
Menu path Application-Validation-Quick Codes-Special
Use Find, select ACCOUNT_TYPE
Add a new account type "X" with a description of something like
"??????" (make sure whatever description you use is no longer than the
description for Owner's Equity)
Menu path Flexfield-Key-Register
Use Find, specify Application of Oracle General Ledger, hit Find button
Select Qualifiers button for Accounting Flexfield
Down arrow to GL_Account
Change the default value from Expense to "??????"
Menu path Application-Validation-Quick Codes-Special
Use Find, select ACCOUNT_TYPE
Disable the new account type "X"
If you try to enter a new natural account without overriding the default account type, you
get an error message explaining the problem and the account will NOT be added until the
account type is corrected.
Date: Tue, 27 Apr 1999 12:04:45 -0400
From: Steve Bradley sbradley@sprynet.com
Subject: RE: GL: Help setting a form default
This appears to be a wonderful solution but it doesn't seem to work in 10.7 C. The account
type default "X" works but disabling the value does not create an error when
saved and the Account value is accepted with account type of "X". Disabling the
default account type only removes it from the QuickPick.
Respectfully, Steve Bradley, CPA OASIS Consulting Group, Inc. Office 404-352-8387 Fax
404-609-9856 Pager 888-912-2569
Date: Tue, 27 Apr 1999 21:23:23 +0530
From: "Shamica Wakade" shamica@sohm.soft.net
Subject: Re: Help setting a form default
Hi Cathy,
The value 'Expense' for the Segment Qualifier is defaulted from a Screen in Application
Developer responsibilty - Flexfield - Key - Register. Query for your Flexfield here and go
to the next screen - 'Qualifiers'. In this screen, change the default value of the Segment
Qualifier - GL_ACCOUNT to null.
HTH Shamica.
Change of COA
From: "Richard du Feu" Richardd@care.ca
Subject: GL:Chart of Accouts Change
Date: Wed, 28 Apr 1999 13:50:26 -0400 (EDT)
Hi everybody,
We are going to be going though a restructuring here. We will have to be changing our
Chart of Accounts and setting up multiple sets of books. Right now we do not have a
parent/child hierarchy, but will be wanting to set up a Chart of Account structure like
this. What are the implications with changing the accounting flexfield? Is it better to
create a new flexfield and set of books to use for the new structure? If we do this how
will it affect reporting on historical information, created by the existing chart of
accounts and flexfield? Would we have to create new responsibilites for the new chart of
accounts and set of books? Then when we need to review old infomation we move to the old
responsibility? We are also planning to implement AP and PO. Is it better to wait until we
have our new GL chart of accounts created. I would love any advice any of you could
provide.
Thanks again, Richard
Date: Thu, 29 Apr 1999 09:01:27 +0400
From: PeriasamyR@mashreqbank.com
Subject: RE: GL:Chart of Accouts Change
Richard,
Since your new chart of accounts is going to be different, create a new set of books and
convert the opening balances from the old books and start off.
To access the data from old set of books, migrate transactions or balances through
consolidation into the new book. In fact, you could consolidate old data to an another new
set of books (with new structure), say (Historical Data Book) and use FSG to consolidate
balances between the two new books - current, historical. This would obviate the need to
reconcile the migrated data rigorously.
Key to this is how successful would be the consolidation mapping between the old set of
book with old structure to the new set of books with new structure. Issues of parent
values not being present is relatively not important, except in sofas as it could help to
simplify the consolidation mapping.
Regards Peri
Separate Revenue Accounts for same item
From: Divya_Gupta@Dell.com
Subject: Separate Revenue Accounts on 10.7 NCA
Date: Tue, 11 May 1999 10:52:11 -0400 (EDT)
We are currently using 10.7 NCA. We have items set-up using the Inventory module, and
against each item, we have the revenue account defined. The problem is that we sometimes
have orders that have a Zero Rate of VAT, and for these orders, we need to show the
revenue in a different account?
Because we use the same items for both normal, and Zero VAT orders, I do not see how we
can change the revenue account to sometimes show the revenue in one account, and for Zero
VAT orders, show the revenue in a different account? Any ideas will be most welcome.
Thanks, Divya.
Date: Wed, 12 May 1999 12:09:44 GMT
From: "Indrasen Kasireddi" indrasen98@hotmail.com
Subject: Re: Separate Revenue Accounts on 10.7 NCA
We have taCKLED THE same Problem for our European Org by creating a database trigger on
RA_CUST_TRX_LINES_GL_DIST_ALL table.
Hope this Helps!!! Good LUck -sen
Cross-Validation Rule Violation Report
Date: Mon, 24 May 1999 15:14:25 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
Subject: GL: Report Error
When we run the Cross-Validation Rule Violation Report (under Sysadmin) we get the
following error:
Connected to ORACLE ID: GL
APP-00981 ORACLE error 942 in FDFGXR
Has anyone else gotten this error message when running the CV Rule Violation Report?
We can run the CV Rules Listing Report with no problems.
Thanks in advance, Sarah Sarah Aronovici Augsburg Fortress Publishers 612-330-3363
aronovis@augsburgfortress.org
Date: Mon, 24 May 1999 14:33:19 MDT
From: "Vijay Kumar Ch" horo_horo@hotmail.com
Subject: Re: GL: Report Error
hi sarah,
the error is because the report is not able to find the tables. try running missing grants
and synonyms option from adadmin utility , also regenerate the report.
this might solve the issue. regards, Vijay
Date: Mon, 24 May 1999 17:24:26 -0400
From: ddisalvo@hearstsc.com
Subject: Re: GL: Report Error
Hi, we had the problem here and there is a bug fix (patch # 484162). Thanks, Dom
Creation of Fund Accounts
Date: 14 Jun 99 16:48:03 EDT
From: Thomas Matthews tjohnmatthews@netscape.net
Subject: Fund Accounting in Oracle G/L
Hello,
Does anyone have any knowledge about how to handle many funds within Oracle G/L?
We have a Unrestricted, Temporarily Restricted, and a Permanently Restricted fund (aka
Retained Earnings).
I thought about utilizing separate balance segment values, but that could get difficult
because we would have to identify each transaction in those 3 categories.
Does anyone know of the best way to mimic 3 separate retained earnings accounts in this
way?
Thanks, Tom
Date: Mon, 14 Jun 1999 17:09:15 -0400
From: "Cunningham, Ronald" rcunningham@noblestar.com
Subject: RE: Fund Accounting in Oracle G/L
Hi Thomas,
Fund Accounting (aka Governmental or Non-profit accounting) is set up in Oracle GL using a
"fund" segment. This is separate from the natural account segment which would
contain the retained earnings account (or in fund accounting terminology, the fund balance
account). This allows a separate set of natural accounts for each fund. With this segment,
financial statements can be prepared by fund and by organization (or organization by fund
or fund by organization).
Hope this helps,
Ron
Ronald A. Cunningham
Oracle Consultant
-----------------------------------------------------------------------
Noble(star Systems Corporation
http://www.noblestar.com
Email: rcunningham@noblestar.com
Phone (Voice Mail): 703.464.4000
Phone (Home Voice/TDD): 803.732.1713
FAX (Home): 803.749.8878
-----------------------------------------------------------------------
Date: Mon, 14 Jun 1999 17:15:09 -0400
From: "Kurylo, Mary" Kuryma@consumer.org
Subject: RE: Fund Accounting in Oracle G/L
You can set up 3 R/E accounts, one for each. In your set of books definition, leave the
retained earnings account as the one with the most activity (probably the unrestricted.)
You should be able to get some sort of trial balance for each fund to see the activity/net
income. Just do a manual entry to the other r/e accounts and dr/cr the unrestricted.
Mary Kurylo
Applications Development Analyst
Consumers Union of US Inc.
Disabling CV Rules
Date: Fri, 18 Jun 1999 10:29:10 +0500
From: "Javaid Ansari" JMANSARI@mail.arco.com
Subject: GL: HISTORY DATA TO FINANCIALS
Hi
Oracle Applications family members,
We are in the process of transferring historical data from our legacy accounting system to
Oracle Financials (10.7 SC). The system is giving us EFO4 i.e. cross validation rule error
message at the Journal Import Execution stage. These errors are in hundreds.
So the questions are:
Can we disable the cross validation rules before the data import and then enable them
after posting this data. This data will be imported in March 1999 business. For this
purpose we have reopened March. After posting we will close it again. If the answer is
YES, then do we need to disable cross validation rules, rule by rule or is there any
screen where we can simply disable all the rules in one go.
If the above can be done, then what would happen to the account combinations that will be
created from this data acceptance. Is there a way we can block creation of these account
combinations ? or do we need to go line by line and then disable these hundred's of
account combinations after posting this data.
Would appreciate feedback ASAP.
Thanks
-- Javaid Ansari
Developer on D2K
Date: Fri, 18 Jun 1999 15:09:06 +0930
From: "Farrell, David" David.Farrell@boral.com.au
Subject: RE: HISTORY DATA TO FINANCIALS
You would need to diable the CV rules one by one- or more specifically, disable only the
ones that your combinations invalidate. If you try to create the combination on screen
you'll see which rules it fails.
However if you did disable, post, then enable the rules you would need to disable the
individual combinations as they could still be posted to, as the CV rules control the
creation of accounts, not whether the accounts are enabled or not....
David Farrell
National PO Technical Development - F2000
Phone: 02-8836 5359 - 0414 738 955
Date: 18 Jun 99 01:09:37 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
Subject: Re: GL: HISTORY DATA TO FINANCIALS
Hi Javaid,
You could change the key flexfield so that cross validation is not used, but I wouldn't
bother. It would probably be best just to sit at a terminal for a while and manually
disable the rules. It couldn't take more than an hour to click on all the enabled flags
for the rules, and it would be a lot safer. I remember changing that value in a test
system one time in the past in the opposite situation without seeing any problems, but I
don't think the risk would be worth it, and the testing would take longer than the
changes.
There is a report out of Sys Admin that will show all the violations. The report also has
a parameter that allows the violating CCIDs to be disabled.
It's called something like the Cross Validation Violation Report.
Good Luck, Craig
Craig Yedinak
Independent Consultant
Date: Fri, 18 Jun 1999 05:36:58 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: Re: GL: HISTORY DATA TO FINANCIALS
I would NOT recommend this method of temporarily disabling the cross validation rules.
Once a code combination has been used a cross validation rule will NOT prevent it from
being re-used. Once its been used, if you later want to "lock it out" you will
have to DISABLE the CCID.
I would take the time to clean up your import data. It will save you a lot of problems in
the long run.
Date: Mon, 21 Jun 1999 14:36:20 -0400
From: Steve Bradley sbradley@sprynet.com
Subject: RE: HISTORY DATA TO FINANCIALS
Below are 2 SQL scripts for disabling and enabling CVR's. The first scrip disables all
CVR's not already disabled. It also modifies the description so the enable CVR script will
only update the ones disabled by SQL. This is needed when you have been in operation for a
period of time and have disabled CVR's. You do not want them enabled again.
Run the Cross Validation Error report with update to disable the combinations created that
violate the rules you turned off and back on with SQL. This report is in the SYS ADMIN
responsibility.
//Disable all active CVR's
update fnd_flex_validation_rules
set enabled_flag = 'N',
description = 'XX'||description
where enabled_flag = 'Y';
//Enable all CVR's disabled above
update fnd_flex_validation_rules
set enabled_flag = 'Y',
description = substr(description,3)
where enabled_flag = 'N'
and description like = 'XX%';
Respectfully,
Steve Bradley, CPA
OASIS Consulting Group, Inc.
Office 404-352-8387
Fax 404-609-9856
Pager 888-912-2569