Context sensitive DFF
Date: Sun, 13 Jun 1999 16:53:06 -0700
From: Satish Reddy SReddy@zilog.com
Subject: Desc Flex
We setup a context sensitive desc flexfield on mtl_system_items.We imported items through
the interface and updated one of the attribute's through SQL.But for the context sensitive
flexfield the value does not show up in the form.But when we define it through the form it
shows up.This is the problem only with context sensitive desc flexfields.
Any help??
Thanks in advance.
Date: Mon, 14 Jun 1999 08:42:17 -0400
From: "Devulapally, Sridhar, CFCTR" sdevul0458@att.com
Cc: SReddy@zilog.com
Subject: RE: Desc Flex
Hi Satish
I think the context sensitive column is being null when you import the items. Make sure
the attribute_category or whichever column you based your context sensitivity on is also
populated during imports. This should help your problem.
Thanks
Sridhar Reddy
DFF - Malfunction in Custom Form
Date: Mon, 21 Jun 1999 23:24:25 -0500
From: Diana Boules dboules@csac.com
Subject: AOL:Descriptive Flexfield in custom form
We are using Sun Solaris 2.6, RDBMS 8.0.4, and Oracle Apps Rel 11.0.2.
We have registered a custom application in AOL and it is using the Apps schema. We have
written custom forms which are working fine. Then we added the usage of descriptive
flexfields within the custom forms. When we use the descriptive flexfield and manually
enter in the values, everything works great. If we define the descriptive flexfield to
have a default value of type constant, then in the popup window the form it will display
the values correctly. BUT when we we say OK in the popup window in the form, the
application closes all windows and we are back to our desktop. No errors or any
information in a trace file.
Anyone else have this issue or a resolution?
Diana
Problem with generating territiory flexfield
Date: Tue, 29 Jun 1999 13:09:15 +0200
From: Bohdan Paszkiewicz paszkie@ibm.net
Subject: AR: Problem with generating territiory flexfield
We are running the French version of Oracle Applications (v. 11.0.28) and when we try to
compile the territory flexfield, it fails. The message suggests that it fails to generate
view called AR_TERRITORIES_KFV.
Can anybody help.
Regards
Bohdan Paszkiewicz
Mapping DFF with Oracle Forms
Date: Tue, 29 Jun 1999 18:22:08 -0700 (PDT)
From: siddhartha nandi sid_nandi@yahoo.com
Subject: Mapping DFF with Oracle Form
Hi,
I need to activate the DFF in 'Pending Jobs & Schedule' screen in WIP. I registered
one but DFF does not get activated. I think I have to mapped correctly. How do I know how
to map it.
Any help is appreciated.
Thanks,
Sid.
===
Sid Nandi
Sr. Principal Consultant
Millennia Vision Corporation
Snandi@mvsn.com
650-232-6330 (230)
Custom KFF in Custom Form
Date: Sun, 4 Jul 1999 19:09:49 +1000
From: Sheila Cruickshank scruickshank@assist.com.au
Subject: Forms 4.5 Flexfields
Hi,
Can someoine who is a FORMS 4.5 Guru, offer some advice.
I am trying to put a customised KEY Flex in a customised Form. I have implemented them in
Forms 2.3 with no trouble using POPID, VALID - No trouble, but this is my first attempt at
GUI Forms.
I tried to follow the Standard Coding Manual - although I may have an old version - it
says 10sc but I am implementing for 10.7 NCA
I have defined the the FlexKey using FND_KEY_FLEX.DEFINE as per manual, I have then placed
FND_FLEX(Event) on the Triggers as per manual, but the FORM doesn't work. The KEY-EDIT
works, and I can enter the segments If I do a QUERY ENTER, I only get the segment
separators which are '.' When I move to the concatenated Segements field it does not
automatically open the segments window, (unless a press KEY-EDIT)
Have I missed a step? If anyone has successfully implemented this feature, could you
please email a few tips and tricks.
Thanks Sheila
How to change updatable property of Descriptive Flexfield
Date: Thu, 15 Jul 1999 20:08:05 +0200
From: Noga Oppenheim NOGAO@Amdocs.com
Cc: Jacob Eshed JACOBE@Amdocs.com
Subject: Descriptive Flexfield: DESC_FLEX
In form ARXTWMAI, Descriptive Flexfield: DESC_FLEX, an UPDATEABLE property needs to be
changed to FALSE.
The command, used in CUSTOM.pll, on WHEN-NEW-RECORD-INSTANCE event is:
SET_ITEM_PROPERTY('TGW_HEADER.DESC_FLEX',UPDATABLE,property_false)
The property is checked by the command:
fnd_message.debug(GET_ITEM_PROPERTY('TGW_HEADER.DESC_FLEX') and got, in the debug message,
that the property is FALSE, as expected.
Despite the message, the Descriptive Flexfield is, steel, updateable.
When using the SET_BLOCK_PROPERTY instead, the Flexfield (as other fields) become not
updateable. Also, changing other properties like ENABLED, works for this field.
Condition
* The Invoice is in Posted state.
* Other fields in the form get the false UPDATEABLE property from the Applications.
* All other Descriptive Flexfields seems to be in UPDATEABLE property = true (can be
updated) and can't be changed to false UPDATEABLE property.
Involved components
Navigation Path :AR-Transactions - Transactions.
Form Name : ARXTWMAI
Block name : TGW_HEADER
Source Field : DESC_FLEX
Noga Oppenheim
Information System
tel: 972-9-7763012
fax: 972-9-7763090
nogao@amdocs.com
How to define Territory Flexfield
Date: Wed, 21 Jul 1999 11:22:52 +0530
From: Susan Susan_jackson@mail.usa.com
Subject: Territory Flexfield
Hi all
Please give pointers on.......................
Where and how is a territory flexfield defined, I have searched all options but to no
luck.
Thank you Susan
Date: Wed, 21 Jul 1999 13:05:38 +0700
From: "Juanda - Acc" j-juan@sampoerna.co.id
Subject: Re: Territory Flexfield
\Navigate Setup System Territory
Date: Wed, 21 Jul 1999 13:09:18 +0700
From: "Juanda - Acc" j-juan@sampoerna.co.id
Subject: Re: Territory Flexfield
Define Territory Flexfield :
\Navigate Setup Financial Flexfields Key Segments
- Title = Territory Flexfield
Rgrds
Retaining DFF value
Date: Wed, 28 Jul 1999 14:40:36 -0500
From: "Mandadi, Harish" HMandadi@obiwan.intecom.com
Subject: Retaining DFF Values
Hi All,
I have a requirement where based on item type I need to populate DFF and enter a value in
the field. I am able to do all this but, some how it is clearing the value in the DFF. Any
ideas how to retain DFF value. We are on 10.7NCA on HP USX 11.
Thanks in advance. -Harish
Date: Wed, 28 Jul 1999 12:50:30 -0700
From: "MCAVOY, Brian J." bmcavoy@shl.com
Subject: RE: Retaining DFF Values
Where are populating the DFF based on the item type, is this on a transaction or
something?
Brian McAvoy
Consultant
EDS
pager 888-319-3433
bmcavoy@shl.com
Date: Wed, 28 Jul 1999 15:57:57 -0500
From: "Mandadi, Harish" HMandadi@obiwan.intecom.com
Subject: RE: Retaining DOFF Values
Yes it is based on item type...
Customize Standard Account Generator Processes
Date: Wed, 28 Jul 1999 18:23:24 -0700 (PDT)
From: karl sta ines karlstaines@yahoo.com
Subject: Customize Standard Account Generator Processes
Questions for Account Generator Gurus! This is our first in account generator. We have
implemented financials application before without using flexbuilder. Accounts are manually
coded. We now moved to 11.02 and implemented PA also, thus the need for the account
generator.
1.Would making changes to the existing processes (in each item type that I need) be the
quickest way to do the workflow, based on your ezperience?
2.Will the system allow me to do this? (I have saved the hidden item types in a separate
file, and here is where I am planning on making the changes)
3. How do I "put back" the customized processes to the database.
4. How do I test, being a functional person, i.e., without going behind the scene?
I appreciate the help.
K
Date: Thu, 29 Jul 1999 10:22:30 +0300
From: "Dina Rotem (h)" dinar@rafael.co.il
To: Ora OraApps-L@cpa.qc.ca, karl sta ines karlstaines@yahoo.com
Subject: Re: Customize Standard Account Generator Processes
Karl
Do you plan to have accounting rules based only on items types? In AP, for supplier
invoices that are not match to PO, you can customize the account only if you have project
distribution. Since, only then Account Generator is triggered. In Purchasing, requisitions
and orders have standard AG rules based on the account set on the item level. You should
customize it only if you need different rules, based on project information, for example.
However, you must define your own rules for PO with expense destination, that have project
distribution.
Dina
Date: 29 Jul 1999 08:58:52 -0700
From: Ramirez Rosalie rosalie@itconvergence.com
Subject: Re: Customize Standard Account Generator Processes
Yes - it will only be for project-related purchases and project-related expense reports
charges.
Enter comments in DFF conditionally
Subject: [orahrms-l] Reg: Descriptive Flex Fields
From: "Khandrika, Babu" Bkhandrika@tnpe.com
Date: Tue, 20 Apr 1999 14:31:15 -0500
Hi!
The requirement is that user should be able enter comments (Validation None) into
attribute5 if the value in attribute4 is 'NONE'. Please let me know if you have any
suggestions.
I appreciate your help!
Babu.
DFF:Populating Attribute Category based on Natural Account
Date: Sat, 31 Jul 1999 02:12:56 -0700
From: "Saranath P" saran_p@mailcity.com
Subject: DFF:Populating Attribute Category based on Natural Account
Hi All,
We have a requirement to force users to enter a value on DFF on a specific format/pattern
based on the Natural Account Segment Value they choose in a Transaction. The Attribute
Category will decide the Format to be Used. Certain Specific natural accounts have a
specified format which will help in reconciliation of transactions coming in from a lot of
external systems.
These transactions will be entered in GL or AP or AR and the DFF will be enabled on all
the relevant forms.
We are looking for a way to populate the DFF Attribute Category in any of the forms, based
on the Natural Account Segment Value used in the Transaction.
We are on Rel 11 NCA on Sun Solaris. We have GL, AP, AR and FA.
Request your help ASAP.
Thanks in Advance
Prabu B
Unable to define Account Qualifier
Date: Mon, 09 Aug 1999 16:21:58 -0400
From: "Bimal Patel" bimal.patel@acnenergy.com
Subject: Re:Account qualifiers in Flexfield-Help
Hello,
We are implementing Release11.0.200 on Oracle 8.0.5 and have a problem with defining
Account Qualifiers:
I defined value sets, Corresponding values,Attach value sets to segments and also defined
Flexfield Qualifiers for the same. However while defining segment values,cursor doesn't go
to qualifier field and instead jumps to next record.
Has any one else has faced similar problem? Any suggestion/help will be appreciated.
Bimal Patel
Oracle Application consultant-Functional
Date: 10 Aug 99 11:25:03 IST
From: senthil senthilvenkatesh@usa.net
Subject: Re: [Re:Account qualifiers in Flexfield-Help]
Hello bimal....
by qualifier do u mean qualifier in Natural account segement !!!! pls clarify
regards senthil
How to enable DFF for a specific Batch Source
Date: Wed, 11 Aug 1999 08:58:56 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: How to enable DFF for specific batch sources
All,
I want to enable a Descriptive Flexfield on Receipts screen in A/R. I want it to be
enabled only for specific batch sources. How to do it? For this DFF there is no Reference
field like Batch source.
Please let me know how to do this ?
Thanks, -chakrapani
Default value of Flexfield Segment - Query 1
Date: Thu, 12 Aug 1999 15:15:54 -0600 (MDT)
From: Karen Beck Karen.Beck@Central.Sun.COM
Subject: Setting Default Value for a Flexfield Segment
Hi everyone,
I'm having so much trouble setting a default value for a flexfield segment that I'm
beginning to think it's not possible! I'm working in character mode, Oracle Receivables
10.7 and attempting to assign a flexfield a default value based on another flexfield
segment that is entered from within the same flexfield window.
My ultimate goal is to have the second 'date' flexfield segment would 'default' to a date
2 weeks after the first 'date' flexfield segment is entered. The standard
':$FLEX$.VALUE_SET_NAME' syntax that I have used (successfully) for reporting parameters
doesn't seem to work.
Is this a lost cause and should I just give up?
Thanks, Karen
Default value of Flexfield Segment - Query 2
Date: Thu, 12 Aug 1999 17:38:41 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
Subject: Help : FlexFileds default value
Hi all,
In the enter customers form, we have three flexfields, I want to have default values
populated in the two flexfileds depending on the value of the first field. Is there is any
way to get it done. Even I wrote a sqlstatement to for the default values, but it is not
populating and it is not even giving any error.
Any help is greatly appreciated.
Thanks Kiran
Cross Validation and Security Rules
Date: Thu, 26 Aug 1999 18:13:44 -0400
From: "Epp, Charles A" cepp@kpmg.com
Subject: Question re: CRoss-validation & SEcurity Rules
Good afternoon all. I wonder if anyone could enlighten me on cross validation and security
rules with regard to GL and Oracle Projects:
1) I am aware cross validation rule are set up in GL and function across modules like AP,
PO, etc. Is GL the only place they can be set up and reside? If I am using Oracle
Projects, does Projects have its own defined set of CV rules or does it use GL's?
2) The same question goes for security rules as for CV rules? Do they only get set up and
reside in GL, or does Projects have its own set up and maintance of security rules? If so,
and i am using GL, Projects, AP, and PO, how do the separate rules sets stay "in
sync"?
I recall somewhere that Projects and GL are separate and distinct modules but didn't know
if they were so separate as to have separate set ups for the above. Thanks for any help.
Date: Thu, 26 Aug 1999 16:33:53 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
Subject: CRoss-validation & SEcurity Rules
Hi,
Some fundamentals first.
Cross-validation Rules are applicable on Key Flexfields, while Security Rules are
applicable on both Key Flexfields and Descriptive Flexfields.
If Cross-Validation rule is in force, all users of the module are affected. They can see
the segment values, but when they try to do any transaction, they will get an user defined
error message.
In case of Security Rule, the concerned user can not see the respective value unless he
has that responsibility. So the question of using that value does not arise. Security Rule
is attached to Responsibilities - which in turn are attached to users.
There are different key flexfields in different modules
GL has
Accounting Flexfield
PO has
Item Flexfield
Oracle Projects and Oracle Payables have no flexfields.
Cross-Validation Rules and Security Rules for Accounting Flexfield has to be set up in GL.
Cross Validation Rules and Security Rules for Item Flexfield can be set up in PO.
Apart from these key flexfields, there are Descriptive Flexfields in all modules. If you
plan to use them, you can use Secutity Rules for them.
As there is no possibility of conflict, the question of being "in sync" or
"out of sync" between the modules does not arise.
Prasanna Jena
KAY Software Inc.,
Silicon Valley.
Date: Fri, 27 Aug 1999 19:25:49 +0200
From: Jean-Guy_Duba@ernst-young.fr
Subject: Re: CRoss-validation & SEcurity Rules
Charles,
1) CVRs are used to control that no inadequate accounting flex or other flex are
generated. It is a quality device. Defined in GL, they can apply to AR/AP/FA/PA/IC....,
all the modules that are creating somehow flexs.
Very Powerful (you can create CVRs on 3 segments with specific error message , after 3
segments, it is almost intellectually impossible to design and maintain them). To be
tested very carefully in pre-prod instance to avoid "killer time" in prod as you
can stop completion of heavy programs (FA depreciation run.....etc)
. 2) Security rules are based on segments and value sets: it is a "security"
device, you remove possibilities to enter or inquire on certain segment values. Classical
restriction are : the balancing segment in GL, some cost segment values in GL, the country
code value in FA Location flex.........
3) Basic step is a full functionnal analysis before going to CVRs or Security rules. Most
of the time, the end result is an intelligent (well, not always.....) mixture of these two
features.
Regards.
Parent Value segment - posting to
From: "Bill Keenan" billek@ccai.net
Reply-To: oraapps-l@cpa.qc.ca
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: General Ledger Parent Value question
Date: Sun, 29 Aug 1999 10:30:24 -0400 (EDT)
Hi,
I am setting up segment values, and when it comes to company values, I want to create
several parent/child relationships. I beleive I can also post to these parent values, if
desired, and if I set up the value to be postable. Am I correct?
Can you please confirm my thought that I can post to a parent value.
Thank you,
Bill
Date: Mon, 30 Aug 1999 10:56:41 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: General Ledger Parent Value question
Hi Bill,
You can save a parent account segment as
Allow Posting = Yes
Allow Budgeting = Yes
But the very fact that you have qualified it as a Parent value - makes sure that you can
do neither posting or budgeting in it. They can definitely be used for reporting. But it
is not straight forward. The parent account will not get the total value of the child
values unless the respective Summary account has been defined. And to get the summary
values you will need the 'Roll up group' as well.
Hope it helps.
Prasanna Kumar Jena
KAY Software Inc.,
Silicon Valley, CA.
Date: Mon, 30 Aug 1999 18:28:10 -0400
From: "Bill Keenan" billek@ccai.net
To: oraapps-l@cpa.qc.ca
Subject: Re: G/L Parent Value Question
Can you Inquire on Parent values with the application? I don't beleive you can by what
I've read, but I would like to confirm.
Thank You,
Bill
Date: Tue, 31 Aug 1999 10:59:35 +0530
From: Kasturi Srinivasan srinika@pcsbom.patni.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Re: General Ledger Parent Value question
Hi Bill,
You cannot post to Parent Values. Parent Values are Rolled up using Parent/child Hierarchy
. Parent Values are summary of child values defined thru Hierarchy Editor.
If you want more arithmetic operations other than summation in Hierarchy you need to go
for OLAP tools like OFA , OSA, etc.
Any more questions feel free to ask.
Regards
srinika@pcsbom.patni.com
Kasturi Srinivasan
Oracle Application Consultant
Patni Computer Systems Limited
Date: Tue, 31 Aug 1999 09:45:22 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: G/L Parent Value Question
1) Parent value : organisational or accounting logical grouping of child values. Cannot
post or budget (NEVER). Cannot inquire. No balances in GL_BALANCES, but they can be seen
in FSGs reports. Most useful in mass allocation formulas and in budgets allocation.
2) Summary accounts : Cannot directly post, but balances in GL_BALANCES (thus classical
issue on the usefulness vs sizing of the database). Can inquire. Can be seen in FSGs. Most
useful in recurring JE formulas, in mass allocation formulas, in budget formulas and
allocation.
3) Roll up groups : Grouping of parent values of any level in your segment values
hierarchy (parent level 1, 2....) used in Summary Accounts definition.
Conclusion: From child to parent, then from parent to groups, then Summary accounts
definition with groups or directly with value T (Total) and D (Detail). You need to define
T for each segment of your accounting flex to enable summary accounts such as D-D-T-T-T
......etc
DFF in AR - Tabbing in
Date: Mon, 30 Aug 1999 15:36:42 -0400
From: "Subramani Thulasiram" subramani.thulasiram@acnenergy.com
To: oraapps-l@cpa.qc.ca
Subject: DFF Question
Hi everyone,
I have a question on DFF setup. I had setup a DFF in my Customer Screen in AR with 7
segments .My problem now is i am not able to tab into any fields within the DFF , but i am
able to tab to the next fields outside of the DFF. Did anyone face a similar problem ? We
are on application 11.0.3 and database 8.0.5. Am i missing anything in the DFF setup.
Thanks
-Thulasi
Date: Tue, 31 Aug 1999 09:50:17 -0400
From: "Thurm, Anita" Anita_Thurm@compuware.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: DFF Question
We had a similar problem. Oracle supplied a patch - 857097, which is for UNIX and NT based
platforms.
Tables storing KFF
Date: Wed, 1 Sep 1999 15:24:59 +0530
From: sprakash@itil.com
To: oraapps-l@cpa.qc.ca
Subject: flex value
hello,
In Which Table does the Keyflexfield is stores in Oracle Apps. What is the relation
between AP And AR. ( how they are related)
bye
Date: Wed, 1 Sep 1999 11:01:48 -0400
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: flex value
Prakash,
KFF data are stored in many tables. If you are talking about flexfield values they are
stored in FND_FLEX_VALUES.
There is no direct relationship between AP and AR. Well we have a netting report that
gives you a report on the transaction balances of a customer/supplier.
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831