Security Rules and PO Matching
Date: Wed, 30 Jun 1999 11:51:27 +0200
From: CONNELLY Martin martin.connelly@eurocontrol.be
Subject: Payables: flexfield security rules
We have defined a flexfield security rule which
restricts the entry of certain accounting flexfield
combinations for our Oracle Payables responsibilities.
When entering invoice distributions directly this
security works as expected. However, the security
rule is not applied when matching to a PO. This
gives rise to incorrect invoice distributions.
As a workaround, we defined an Alert which
checks the security rules on invoice distributions
and places an appropriate hold on the invoice.
However, when you try to correct a distribution
by either reversing or modifying the flexfield,
payables decides to apply the security rule again.
Any help appreciated,
Martin Connelly
Martin Connelly, DF/MIS Financial Systems
Eurocontrol
96 Rue de la Fus=E9e B-1130 Brussels, Belgium
Telephone: +32 2 729 3018
Email: Martin.Connelly@eurocontrol.be
Date: Wed, 30 Jun 1999 13:51:29 +0100
From: "Grist, Fergal" Fergal.Grist@ncp.co.uk
Subject: RE: Payables: flexfield security rules
Hi Martin
The behaviour of your payables system is as I
would expect - so I think the problem is that
you're trying to use Security Rules to solve
a problem which they weren't designed to do.
This is because Security Rules do not define
valid combinations, they only define the
combinations which can be entered through the
screen under a particular responsibility.
When a PO is matched in Payables, you are not
entering any new distributions through the
screen, you are simply inheriting them from
Purchasing.
Of course, if you need to modify the newly
created invoice distributions, then you're
back to the screen entry and the Security
Rules once again prevail.
I hope this clarifies the Security Rules
functionality. If you wish to describe your
business requirements, I may be able to
recommend a number of Oracle features which
will solve your problem.
Regards
Fergal Grist.
Loading of Cross Validation Rules
Date: Fri, 16 Jul 1999 07:05:17 PDT
From: "DASARI SUBRAHMANYAM" srdasari@hotmail.com
Subject: LOADING OF CROSS VALIDATION RULES **URGENT**
Hi all,
I have loaded Cross validation rules using sqlplus from one instance to
another instance. Tables loaded are FND_FLEX_VALIDATION_RULES and
FND_FLEX_VALIDATION_RULE_LINES. Rules are working fine to prevent invalid
combinations. Problem comes when i need to update the rule. When i am
trying to update the loaded records i get the following message:
'FRM-40735: ON-UPDATE trigger raised unhandled exception NO_DATA_FOUND'
When i update the record that is entered through the firm i do not have no
problem it is updated.
Any one has come across similar problem? Any suggestions to overcome this
problem.
THanks in advance
dasari
Date: Fri, 16 Jul 1999 11:45:57 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: LOADING OF CROSS VALIDATION RULES **URGENT**
There are more tables involved than just those two. I don't have a TRM in
front of me, but a quick scan of the data dictionary resulted in the
following:
OBJECT_NAME / OBJECT_TYPE / OWNER
------------------------------ --------------- --------
FND_FLEX_VALIDATION_EVENTS / TABLE / APPLSYS
FND_FLEX_VALIDATION_QUALIFIERS / TABLE / APPLSYS
FND_FLEX_VALIDATION_RULES / TABLE / APPLSYS
FND_FLEX_VALIDATION_RULE_LINES / TABLE / APPLSYS
FND_FLEX_VALIDATION_RULE_STATS / TABLE / APPLSYS
FND_FLEX_VALIDATION_TABLES / TABLE / APPLSYS
I suggest you re-think what you are doing, or get a TRM and be certain of
your relational integrity.
Date: Fri, 16 Jul 1999 11:20:32 PDT
From: "DASARI SUBRAHMANYAM" srdasari@hotmail.com
Subject: RE: LOADING OF CROSS VALIDATION RULES **URGENT**
Ernie,
Thanks a lot. I solved the problem. I needed to load another table
fnd_flex_vdation_rules_tl. I did it and it is working fine now.
dasari
Account Segment upload macro
Date: Fri, 23 Jul 1999 15:41:31 -0400 (EDT)
From: Siddharth Shah shahsd@yahoo.com
Subject: GL-Account Segment Upload Macro!
Hi,
Can someone send me the GL Account segment upload
macros and the instructions on how to load it. I want
to use this at the client site.
Thanks.
Siddharth
Date: Fri, 23 Jul 1999 16:53:16 -0400
From: ralph ramnath rramnath@neal-and-massy.com
Subject: RE: GL-Account Segment Upload Macro!
You need to say what version....there is one for 10SC and one for 10NCA/11
Date: Fri, 23 Jul 1999 17:51:28 -0400 (EDT)
From: Siddharth Shah shahsd@yahoo.com
Subject: RE: GL-Account Segment Upload Macro!
Ralph,
The version we are working on is 11.02 NCA.
Siddharth
Date: Sat, 24 Jul 1999 08:37:41 -0400
From: "Bob Delaney" rdelaney@prodigy.net
To: shahsd@yahoo.com, "Ora Apps" OraApps-L@cpa.qc.ca
Subject: RE: GL-Account Segment Upload Macro!
You can download the Dataload utility from the author's web site at
http://www.users.globalnet.co.uk/~jdstuart/nca_load.htm
There are three versions currently available. 4.0.X is a standalone product
that will support either SC or NCA. The other two versions are Excel
macro's - one for NCA and another for SC. I would recommend using the 4.0.X
version, since that where the effort is being spent to continually improve
the product. It can be used with SC, but there a few commands that won't
work and you have to specify "Oracle Applications" as the window name,
versus NCA, where you specify the name of the specific form.
The product is very easy to use - good luck.
Bob Delaney
ISS, Inc
Maintain Summary Templates
Date: Fri, 16 Jul 1999 17:19:34 +1000
From: Schwerdt Mark MARKSCH@melbourne.vic.gov.au
Subject: GL: Maintain Summary Templates
I have noticed a job in GL titled 'Maintain Summary Templates'
Presumably there are circumstances where this job can be used instead of
deleting and re-entering the summary template.
Does anybody know what this does/doesn't do ?
thanks
Mark Schwerdt
Date: Fri, 16 Jul 1999 15:43:12 +0800
From: Stephen.Solomon@rac.com.au
Subject: RE: Maintain Summary Templates
Mark,
The maintain Summary templates program updates your summary account
information and ensures that any new detail accounts you have added are
included in the templates. The program is useful to run before posting
journals that include the new accounts added , although the posting process
updates the summary templates, running this program before can improve
performance of the posting program.
Hope this helps
Stephen Solomon
Systems Accountant
RAC Group WAv
Phone: +61 8 9421 4394
Fax: +61 8 9421 4545v
Email: Stephen.Solomon@rac.com.au
Dynamic Insertion
Date: Sun, 25 Jul 1999 11:56:54 -0400 (EDT)
From: siddhartha nandi sid_nandi@yahoo.com
Subject: Dynamic insertion
Hi,
we have a need in which a segment (product segment which is also the
item category) of the AFF will have to be changed from the default
'0000' to a specific value depending on what item is transacted.
For ex. default scrap a/c is 01-0000-13310-0000-0000-00
The fifth segment which is the product segment should automatically get
changed to the product category of the item being transacted. e.g for
item XXXX say product category is 2901, then scrap a/c should be:
01-0000-13310-0000-2901-00.
We have planned to write a trigger to accomplish this.
The question is, how to get the CCID of the new AFF combination
01-0000-13310-0000-2901-00 if it does not exist.
Your help is appreciated. Does body has a better idea?
Thanks in advance.
Sid.
Sid Nandi
Sr. Principal Consultant
Millennia Vision Corporation
Snandi@mvsn.com
650-232-6330 (230)
Date: Sun, 25 Jul 1999 17:51:04 -0400 (EDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
Subject: Re: Dynamic insertion
Hi ,
1.If the AFF is already set for dynamic insertion then there seems no
problem as new combination will be created for non existing
combinations
2.But if AFF is not already set then there will be a problem with the
CCID(because the FF has to be recompiled et.c...).
3.In the latter case manually the combinations have to be created
before using them.
Hope this helps,
Murthy
Summary Template not creating Summary Accounts
Date: Thu, 05 Aug 1999 14:49:10 +0200
From: Bohdan Paszkiewicz paszkie@ibm.net
Subject: GL: Problem with summary templates
We are running french version of GL v. 11.0.28. and summary template
fails to create summary accounts. It fails because it cannot create a
unique index gl_summary_int_u1 because of the duplicates. Anybody had
this problem?
Bohdan Paszkiewicz
Date: Thu, 5 Aug 1999 18:29:43 -0400
From: "Sabrina Diaz, TRI" SDiaz@tricom.com.do
Subject: GL: Problem with summary templates
Bohdan,
same thing happen to us. It is originated because some parents value may
contain a child value more than once. I created the following select
statement which tells you which parents overlap others. You should test
this for all the segment in your account that have parent-child
relation.
select substr(a.PARENT_FLEX_VALUE,1,8) Padre,
a.RANGE_ATTRIBUTE, -- Padre o Hijo --
substr(a.CHILD_FLEX_VALUE_LOW,1,8) Inferior, -- Rangos --
substr(a.CHILD_FLEX_VALUE_HIGH,1,8) Superior,
substr(b.PARENT_FLEX_VALUE,1,8),
b.RANGE_ATTRIBUTE , -- Padre o Hijo
substr(b.CHILD_FLEX_VALUE_LOW,1,8) Inferior, -- Rangos --
substr(b.CHILD_FLEX_VALUE_HIGH,1,8) Superior
from apps.fnd_flex_value_norm_hierarchy
a,apps.fnd_flex_value_norm_hierarchy b
where a.flex_value_set_id = &FLEXID -- ID del Segmento Cuenta --
and b.flex_value_set_id = &FLEXID -- ID del Segmento Cuenta --
and a.PARENT_FLEX_VALUE b.PARENT_FLEX_VALUE
and ((a.CHILD_FLEX_VALUE_LOW = b.CHILD_FLEX_VALUE_LOW and
a.CHILD_FLEX_VALUE_high = b.CHILD_FLEX_VALUE_high)
or (a.CHILD_FLEX_VALUE_LOW = b.CHILD_FLEX_VALUE_LOW and
a.CHILD_FLEX_VALUE_low = b.CHILD_FLEX_VALUE_high)
and(a.CHILD_FLEX_VALUE_High = b.CHILD_FLEX_VALUE_LOW and
a.CHILD_FLEX_VALUE_high = b.CHILD_FLEX_VALUE_high))
order by substr(a.CHILD_FLEX_VALUE_LOW,1,8)
/
To get the FLEXID for the segments in your account flexfields try this:
select segment_name, flex_value_set_id
from apps.fnd_id_flex_segments
where id_flex_code = 'GL#'
/
Hope this really helps,