Defining Cross Validation Rules in Fusion General Ledger
Overview of Cross Validation Rules
In Oracle Fusion General Ledger, cross validation rules are used to determine the account combinations that users can create dynamically when they enter transactions or journal entries. Once enabled, cross validation rule determines whether a selected value for a particular segment of the account combination can be combined with specific values in the other segments to form a new account combination.
If account combinations already exist and violate the newly enabled cross validation rules, these account combinations continue to be valid. Before disabling any existing account combinations that violate cross validation rules and that are no longer in use, we must move the balances in those accounts to the correct accounts. Then disable the account combinations manually to prevent further posting.
We should define and enable cross validation rules before-
-
Balances are loaded
-
Transactions or journal entries are imported or entered
-
Account combinations are created
The standard functionality in Oracle Fusion Application does not provides a central place to enable and disable all CVRs. Let us now understand how Cross Validation Rules work in Fusion Applications with examples.
Companies may have requirements to prevent certain combinations of segment values to be used in their account combinations, for example a particular cost center may not be combined with a specific company value. Once enabled, cross validation rules determine what segment values may be combined with other segment values across the different segments of chart of accounts. Cross validation rules only affect the creation of new account combinations. When creating a new account combination in user interfaces and processes, the values for each Chart of Accounts (COA) segment are cross checked to make sure they do not violate the validation rules.
A cross validation rule is now defined in terms of a condition filter and a validation filter. The condition filter describes the event under which the rule will be evaluated. If the event specified in the condition filter is not applicable, then the rule will not be evaluated even if it is enabled. The validation filter contains the condition that any account combination must satisfy (when the event specified in the condition filter is applicable) before it can be created. To summarize, a cross validation rule is now defined in terms of a condition filter and a validation filter. The rule is evaluated using the following logic-
If condition is satisfied, then perform specified validations.
If a Company has decided that a certain company value (e.g. Operations) cannot use a specific cost center (e.g. Marketing), then we can define the following cross validation rule to validate accounts accordingly: If Company is equal to 'Operations', then validate that Cost Center is not equal to 'Marketing'.
Setup of Cross Validation Rules in Fusion Applications
While implementation of Fusion General Ledger, set up of CVR is an important step. Cross validation rules should be created at implementation time not after few transactions are entered as undesired account combinations can get created in the interim. Updating and deleting existing rules takes place after the fact but it should not occur very often under normal circumstances.
The cross validation rules user interface (UI) is available from Functional Setup Manager (FSM) and below are the steps to define rules-
-
Navigate to 'Setup and Maintenance’
-
Create or Select an implementation project that includes the task 'Manage Cross-Validation Rules'
-
Click on the Go to Task icon for the task 'Manage Cross-Validation Rules'
-
Select the chart of accounts for which you want to define cross validation rules.
-
Add a cross validation rule by clicking on the green plus sign and enter a Name for the rule, a Condition filter, a Validation filter and an error message to be displayed when the cross validation rule applies. Always enable the cross validation rule once it's defined.
In this example we have successfully created CVR-1 for company Apps2fusion where company 01 can not be combined with cost center 1010 with error message.
Though there is no seeded report to get listing of the existing cross validation rules. However Export to Excel functionality in the Manage Cross-Validation Rules user interface can be used to save in Excel a listing of all of the cross-validation rules (name, description and enabled status) defined for a particular chart of accounts.
Comments
I'm looking for. Would you offer guest writers to write
content to suit your needs? I wouldn't mind composing a post or elaborating on a number of the subjects you write related to here.
Again, awesome web site!
sound like you know what you're talking about!
Thanks
Any way keep up wrinting.
that you need to write more about this topic, it may not
be a taboo subject but generally people don't discuss such issues.
To the next! All the best!!
it's time to be happy. I have learn this submit and if I may I want to suggest you
few attention-grabb ing things or tips. Perhaps you can write subsequent articles referring to this article.
I wish to learn even more issues approximately it!
enjoying by these.
that I get in fact enjoyed account your blog posts.
Anyway I will be subscribing to your feeds and even I achievement you access
consistently fast.
articles? I mean, what you say is valuable and all.
Nevertheless think of if you added some great visuals or videos to
give your posts more, "pop"! Your content is excellent but with images and video clips, this website could definitely be one of the best in its niche.
Amazing blog!
También pueden incorporarse los colores de las respectivas
arenas al diseño de las invitaciones, manteniendo un concepto unificado para el look de esta celebración. Envía
tu fotografía o diseño para realizar cuadros personalizados
que se destacan en oficinas, Lofts y ambientes como livings, dormitorios o cocinas.
Si por un lado la pareja desea celebrar la ceremonia de la arena al final de su boda civil
o incluirla en su matrimonio simbólico, un punto a
tomar en cuenta que es de gran importancia son los textos.
Porque la tradición ha derivado en que cada arena sea
de un color. Dentro de las nuevas alternativas aparecen costumbres de diversas religiones como el hinduismo, el
budismo e incluso ritos indígenas o simbólicos, que poco a poco son más demandados
por los clientes.
is really awesome.
enmarcaciones en aluminio o madera, pósters personalizados, fotos en madera, fotos
en metacrilato, fotos en aluminio, fotos en cartón pluma,
lonas publicitarias y otros productos originales como estores personalizados, placas de metacrilato,
biombos personalizados, roll ups y otros productos para decoración. Puedes crear elementos en el juego, tomar capturas de pantalla y agregarlos al archivo "kz.png" original como reemplazo de las imágenes
base. Paso 9: reemplaza la foto y guarda la nueva imagen kz.png que creaste y reemplaza
el archivo original en la carpeta de arte de los pasos anteriores.
O juegos como un puzzle con foto personalizado para
niños o un puzzle de Ravensburger con la imagen que queramos.
Y, en caso de que no la tenga, que sea lo suficientemente
bonito para poderlo dejar como decoración. Descubre Enriqueta Regala Bonito.
Esta es la razón de ser de Enriqueta Regala Bonito: ofrecerte una selección diferente de
regalos originales, bonitos y de calidad. En la categoría de
regalos para infantiles también podrás encontrar una amplia variedad de tazas de plástico personalizadas para que los más pequeños puedan estar a gusto en clase y en el colegio, en general.
Hay muchas ocasiones a lo largo del año en las que compramos regalos
especiales para ajustarnos a la celebración de un día especial que se celebre de manera general o una fecha que
tengamos en común con nuestra pareja, familia o amigos muy íntimos.
to keep a reader amused. Between your wit and your videos, I was almost moved to start
my own blog (well, almost...HaHa!) Great job. I really loved what
you had to say, and more than that, how you presented it.
Too cool!
Keep up the good writing.
I may as well check things out. I like what
I see so now i'm following you. Look forward to checking out your web page yet again.
I'm trying to figure out if its a problem on my end or
if it's the blog. Any feed-back would be greatly appreciated.
(from what I've read) Is that what you're using on your blog?
start to end.
topic but it has pretty much the same page layout and design. Excellent choice of colors!
I will bookmark your weblog and check again here frequently.
I'm quite sure I'll learn plenty of new stuff right here!
Best of luck for the next!
contents.
Here is my website RUAY: https://dashburst.com/ruayshuay
However I am encountering problems with your RSS.
I don't understand the reason why I cannot subscribe to it.
Is there anybody else getting the same RSS problems? Anyone
that knows the solution can you kindly respond?
Thanks!!
Brief but very accurate information… Appreciate your
sharing this one. A must read article!
volunteers and starting a new project in a community in the same niche.
Your blog provided us beneficial information to work on.
You have done a outstanding job!
It truly useful & it helped me out much. I hope to present something
again and help others such as you aided me.
has shared this enormous piece of writing at at this place.
by searching for Overview of Cross Validation Rule in Fusion Application
IE still is the marketplace chief and a huge component to people will
pass over your fantastic writing due to this problem.
but great topic. I needs to spend some time learning more or
understanding more. Thanks for magnificent information I was looking for
this information for my mission.
You're amazing! Thanks!
weblog from start to end.
a blog site? The account aided me a appropriate deal.
I were tiny bit familiar of this your broadcast provided vivid transparent idea
of things from it concerning blogging. thanks.
And i'm glad reading your article. But want to remark on few general
things, The web site style is perfect, the articles is really nice : D.
Good job, cheers
blog, I have read all that, so now me also commenting here.
and personally recommend to my friends. I'm sure they will be benefited from this web site.
IE still is the marketplace chief and a big component of folks will miss your magnificent writing due to this problem.
with your website. It looks like some of the text within your content are running off
the screen. Can someone else please provide feedback and let me know if this is happening to them as well?
This might be a problem with my web browser
because I've had this happen before. Thank you
understands what they are discussing on the net.
You definitely understand how to bring a problem to light and make
it important. More and more people must read this and understand this side of the story.
I can't believe you're not more popular given that you most certainly possess the gift.
on this, suppose you wrote a catchier title? I mean, I don't want to tell you how to run your website, however what
if you added a title to possibly grab people's attention? I mean Defining
Cross Validation Rules in Fusion General Ledger is kinda plain. You should look
at Yahoo's home page and watch how they create article headlines to get viewers interested.
You might add a related video or a pic or two to
get people excited about what you've got to say.
In my opinion, it might bring your blog a little livelier.
I will be coming back to your web site for more soon.
but I thought this publish was good. I don't understand who you're but definitely you are going to a
well-known blogger in case you aren't already.
Cheers!
I've learn this publish and if I could I wish
to counsel you some attention-grabb ing things or suggestions.
Maybe you could write subsequent articles referring to this article.
I want to learn more things approximately it!
This post truly made my day. You cann't imagine
simply how much time I had spent for this information! Thanks!
a lot more attention. I'll probably be returning to read through more, thanks for the info!
and sources back to your weblog? My blog is in the
very same area of interest as yours and my users would genuinely benefit from a lot
of the information you provide here. Please let me know if this alright with you.
Many thanks!
me. Is anyone else having this issue or is it a issue on my end?
I'll check back later and see if the problem still exists.
for me. And i am satisfied studying your article.
But want to remark on few normal issues, The site taste is perfect, the
articles is in point of fact nice : D. Just right task, cheers
for. You've ended my four day long hunt! God
Bless you man. Have a nice day. Bye
efforts and I will be waiting for your further write ups
thanks once again.
It will always be useful to read through articles from other authors and practice a little something from other web sites.
My blog ... ascg organization: http://ascg.org/
Look advanced to far added agreeable from you! However, how
can we communicate?
then i recommend him/her to pay a visit this weblog,
Keep up the fastidious job.
found something that helped me. Appreciate it!
RSS feed for comments to this post