Segment Qualifier - Reconciliation Flag
Date: Tue, 31 Aug 1999 08:27:45 -0700 (PDT)
From: "Trang T. Vinh" tvinht@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Reconcilation Flag Segment Qualifier
Hello All!
In R11, when you setup a value for your accounting flexfield, for example, a natural
account, there is a segment qualifier called 'Reconcilation Flag'. (You can specify a
value of 'Yes' or 'No'). What does this mean and what is the impact?
Thanks for the help!
===
Trang T. Vinh
Principal Consultant
The Visionary Group, Inc.
Phone: 619.248.3490
tvinht@yahoo.com
Date: Tue, 31 Aug 1999 18:04:58 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: Reconcilation Flag Segment Qualifier
Trang,
This flag means that you can use the GL functionnality "Reconciliation" on this
account. Basically, all the accounting flex including this account could have DR and CR
reconcilied. If the flag is No, you will not be able to select such account for
reconciliation.
Functionnally speaking, you reconcile accounts with a lot of identical DR and CR movements
(transit accounts,loans, accruals....).
Once all the reconciliation process is performed, the balance could then be explained
straightforward : it is composed of the "unreconcilied items" (there is a
standard report on these items. In R10.7, a small customization was required to have
totals on this report, I do not know how is it in R11). Another customization should also
cover the General Ledger, as in some countries, accountants require reconcilied items to
be removed from that report (was not the case in standard). In R11, I know that the
features around reconciliation are much better than in R10.7 (find, reconciliation
flagging and deflagging...).
The accounting clercks responsible for account reconciliation has just to "age"
the outstanding items to see if all the adequate entries have been done, especially when
it comes to accrual made for reporting purposes and not automatically reversed (classical
closure time headache !!).
Hope this will help you.
Date: Wed, 1 Sep 1999 11:22:51 +0400
From: rajiv@lucky.co.ae
To: oraapps-l@cpa.qc.ca
Subject: Re: Reconcilation Flag Segment Qualifier - Reply
Reconcialiation segment is used if your site uses localizations for your country or
region.
Rajeev Lalwani
Date: Wed, 1 Sep 1999 09:33:25 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Reconcilation Flag Segment Qualifier - Reply
For additional information see Oracle documentation:
"General Ledger Entry reconciliation" from Oracle Financial for European Region
Ch 1
Richard
Date: Thu, 2 Sep 1999 10:59:34 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: RE: Reconcilation Flag Segment Qualifier
Mohan,
Do not agree : reconciliation has nothing to do with average balance
processing. See the email I already posted to the list on "Reconciliation".
Regards.
Balancing Segment Change
Date: Fri, 03 Sep 1999 10:48:56 +0800
From: jian.hu@cn.pwcglobal.com
To: oraapps-l@cpa.qc.ca
Subject: GL Balancing segment change
Hi, there,
We have helped one client implement GL 10.7 characters mode. After that,
the client has changed the balancing segment from Currency segment to
Company segment . But it seems not taking effect. How to make this change
taking effect?
Thanks a lot in advance, and best regards,
Jian Hu
Date: Sun, 05 Sep 1999 17:36:55 +0400
From: Srinivas Sreepada satncr@emirates.net.ae
To: oraapps-l@cpa.qc.ca
Subject: Re: GL Balancing segment change
hi Jian Hu !
I am curious as to why the Currency Segment was the balancing segment in the
first instance, what are the reasons for that ?
hope you have no problem in sharing your ideas ....
Asset Category FF errors
Date: Fri, 03 Sep 1999 09:06:26 GMT
From: "Sanjay Sharma" mrsanjays@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Assets Category Flexfields: Urgent
Hi Friends,
I hv defined the following segments for the Assets Category Flexfield:
Number Name Column
1 FA type seg Segment 1
2 FA main seg Segment 3
3 FA sub seg Segment 4
FA type seg is Independent, FA main seg is Independent and FA sub is
dependent upon FA main seg. I hv defined values in all the value sets and
also defined the Assets Categories in Asset Categories form. At the time of
quering my assets categories, I am getting the follwing message, can any one
explain the reason?
APP-588 Program error: An error has occurred while looking up a flexfield
segment combination. Please inform your support representative that:
The FND_FLEX_SERVER validation function has encountered a null or negative
combination ID (-1) while trying to look up the segment values for this
combination. This may indicate an invalid entry in the unique ID column of
the combinations table.
Following is the config details of our installation:
SERVER
CLIENT
Product Oracle Applications Oracle Applications
Product Version Number 10.7.0 SC 161
Related Product FIXED ASSETS
Related Product Version Number 10.7.016SC
RDBMS Version Number 7.3.2 7.3.2
SQL * Net Protocol
& Version No 3.3 TCPIP 3.3 TCPIP
Hardware RS 6000 F50 IBM PC 300GL
Operating System
& Version AIX 4.2.1 Windows 98
Thanx in advance.
Sanjay
Date: Fri, 03 Sep 1999 02:10:38 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: GL Balancing segment change
Hi,
Did u compile the accounting flexfield segment and did it go through withour
error?
ravi
Date: Fri, 03 Sep 1999 02:20:49 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Assets Category Flexfields: Urgent
sanjay,
we also encountered the same error while defining an independent and
dependent value set. The error was due to the dependent value set not
correctly defined. Define your value set and recompile your flexfield again
and try.
Ravi
Date: Fri, 3 Sep 1999 12:51:08 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: Assets Category Flexfields: Urgent
When defining your asset category flex, check the following:
Major Category Identifier is defined on one of your 3 segments.
A default value has been defined for each value set attached to the
depending segments.
The column number should be 1, 2 and 3.
Hope this help
Date: Fri, 03 Sep 1999 11:13:40 GMT
From: "Sanjay Sharma" mrsanjays@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Assets Category Flexfields: Urgent
All the points mentioned by you has been taken care of, but for the choice
of Segment numbers. I think, by mistake Segment 3 was chosen from the LOV
while defining the second segment. I understand these Segment numbers
represents the Column at the back-end tables. In the case of Asset Category
FF, we are allowed 7 segments, does chosing 3 instead of 3 makes a
difference.
TIA
Sanjay
Date: Fri, 03 Sep 1999 11:24:29 GMT
From: "Sanjay Sharma" mrsanjays@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Assets Category Flexfields: Urgent
Hi Ravi,
I hv checked the dependent value set. There seems to be no prob. I hv even
tried making a quick addition, while entering the Asset category, the
dependent values r coming perfectly on the basis of the independent values,
e.g. for Furniture & Fittings Main Category, I can pick from Tables, Chairs
etc. from the Sub Category LOV but it is not creating the asset.
Help!!!!
Sanjay
Date: Sat, 04 Sep 1999 07:49:18 GMT
From: "Sanjay Sharma" mrsanjays@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Assets Category Flexfields: Urgent
I hv disabled the earlier segments and used Segment # 5,6 & 7 for my 3
segments.
Attached the value sets earlier defined to these segments.
Defined one combination of the FF at Asset Category form. On requery, that
error msg is not coming, phew!!!
But after creating an asset using this combo, I am not been able to query my
asset. The trn is being saved and asset # is automatically generated but
when I am qerring that asset, I am getting the following msg:
"FRM-40735: ON_UPDATE trigger raised unhandled exception NO_DATA_FOUND"
In my system controls the last asset # used is the smae as created by my
quisk additions.
Tell me why...........
Thanks
Interfacing values into AKFF Segment
Date: Sat, 04 Sep 1999 09:30:26 +0100
From: "J.Suresh" jsuresh@net.ntl.com
To: OraApps-L@cpa.qc.ca
Subject: Interfacing values into AKFF Segment - Error ON-UPDATE trigger
Hi,
We are in 10.7 SC GUI. I am populating PARENT Values only from legacy
system into AKFF Segment which is NOT a balancing/accounting/cc
segment.The segment validation is Independent. I populated
fnd_flex_values, fnd_flex_value_norm_hierarchy and
fnd_flex_value_hierarchies tables. I am able to find the new values in
Segment Values window form and it picks-up the relevant child values,
the new parent values shows up in Hierarchy Editor and also in COA
Segment Value listing Report. But while I try to update the values (the
description, enabled flag, hierarchy level, qualifier)in Segment Values
window form it raises the following error: FRM-40735: ON-UPDATE trigger
raised unhandled exception NO-DATA-FOUND. How do I sort this out? Thanks
in Advance.
Regards,
J.Suresh
Date: Sat, 4 Sep 1999 19:08:40 MYT-8
From: philip@aleytys.pc.my
To: "J.Suresh" jsuresh@net.ntl.com, oraapps-l@cpa.qc.ca
Subject: Re: Interfacing values into AKFF Segment - Error ON-UPDATE
Been there, done that. You forgot to populate the fnd_flex_values_tl
table.
Philip
Philip Chee: Tasek Corporation Bhd, P.O.Box 254, 30908 Ipoh, MALAYSIA
e-mail: philip@aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932
Date: Mon, 06 Sep 1999 19:05:20 +0100
From: "J.Suresh" jsuresh@net.ntl.com
To: philip@aleytys.pc.my
Subject: Re: Interfacing values into AKFF Segment
Hi Philip,
Thanks I am able to modify values in the Segment Values form. Inspite of
me
populating fnd_flex_value_hierarchies table it gets overwritten
subsequently -
so shall I avoid populating that table? Will it have any adverse effect
if I did so?
Regards,
J.Suresh
Date: Tue, 7 Sep 1999 21:21:23 MYT-8
From: philip@aleytys.pc.my
To: "J.Suresh" jsuresh@net.ntl.com, oraapps-l@cpa.qc.ca
Subject: Re: Interfacing values into AKFF Segment
Sorry I haven't had a need to update/insert into the
fnd_flex_value_hierarchies table directly so I haven't had a close look
at this table. What do you mean "gets overwritten"? The application
overwrites your rows or your script overwrites earlier inserts?
Philip
Philip Chee: Tasek Corporation Bhd, P.O.Box 254, 30908 Ipoh, MALAYSIA
e-mail: philip@aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932
Date: Tue, 07 Sep 1999 18:59:52 +0100
From: "J.Suresh" jsuresh@net.ntl.com
To: philip@aleytys.pc.my
Subject: Re: Interfacing values into AKFF Segment
Hi Philip,
Initially I populated fnd_flex_value_hierarchies table which was overwritten
by
application. Subsequently I found out whenever a child range is modified
for a
parent, a concurrent request (Compile Value Hierarchies) is being submitted
which updates fnd_flex_value_hierarchies table and hence no need to populate
fnd_flex_value_hierarchies table while interfacing data into AKFF Segment.
Thanks and regards,
J.Suresh
KFF, Validation and Cross Reference Rules function
Date: Wed, 8 Sep 1999 09:40:30 +0200
From: "Teofilovski, Tommi" TOTEO@wmdata.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: key flex fields, validation and cross reference rules function???
Hi,
I have a question about validation and cross reference rules for the key
flexfields in GL. I am in need of a function (API?) that can do this for
me. Is there such a function in Oracle Application? or do I have to develop
one of my own from scratch???
t.
Tommi Teofilovski
WM-data Konsult AB
Sandhamnsgatan 65
Box 27030
S-102 51 Stockholm, Sweden
Cell: +46 70 670 40 23
FND routine to verify Combos
Date: Wed, 8 Sep 1999 11:26:23 +0200
From: "Teofilovski, Tommi" TOTEO@wmdata.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: crossvalidation, valueset...
Hi,
Is there any FND routine i can use to a check if the value i have entered
(account flex key structure) is valid and a function to add the structure to
Oracle Applicatios? Where can i find the documentation for this?
Regards,
T.
Date: Thu, 9 Sep 1999 09:54:58 +0200
From: LAVERACK Stephen stephen.laverack@eurocontrol.be
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: crossvalidation, valueset...
T
You may wish to try either of the following packages:
FND_FLEX_EXT
FND_FLEX_KEYVAL
They both provide various APIs to convert segments to CCID and vica versa,
cross-validate segments/CCIDs, create CCIDs, etc.
Full documentation is provided in the package specifications.
In short, FND_FLEX_EXT provides a high level interface to the key flexfield,
using a pl/sql table data-structure called SegmentArray to represent your
segments in their logical order. FND_FLEX_KEYVAL is a more low level
interface, which manages a concatanated string of segments. I've found
FND_FLEX_KEYVAL gives you the added ability to cross-validate the segments
without creating the combination, if necessary.
Steve
DFF - include in customized Form
Date: Wed, 8 Sep 1999 17:34:37 +0100
From: alexandre.gravelin@degremont.com
To: oraapps-l@cpa.qc.ca
Subject: DFF in customized Form
Does anybody has an experience of including an existing DFF (standard
DFF)in a customized form
In fact our need is to add the PO line DFF in the Find form of PO
Summary
I know that it is a standard functinality in OE but not in PO
Is it possible to do that ? How ?
Thanks for Help
Alexandre
Disabled Combos - removal of
Date: Thu, 9 Sep 1999 08:19:20 +1000
From: Jeanine_Bailey@COW.mav.asn.au
To: OraApps-L@cpa.qc.ca
Subject: Removal of disabled GL account combination
Once a combination has been disabled, is there any way to prevent it from
appearing on FSG reports?
We have a number of invalid combinations which occured when we had dynamic
insertion on during the set up of our site.
These combinations have no transactions or balances, but if they are within
the
flexfield ranges selected in FSGs, still appear on the reports. It is not
feasible to hide the rows, as this would require a lot of manual
intervention
for each report.
Any suggestions would be appreciated
Date: Wed, 8 Sep 1999 21:16:52 -0400
From: "Farber, Andy" farban@consumer.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Removal of disabled GL account combination
You can set the flag DISPLAY ZERO=NO in the rows. This will not show any
lines that have (net) zero amount.
Andy
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org