In this video we are going to discuss about cross validation cross validation rules. So, what does a cross validation rules means actually the rules are given by the Oracle using of this rules we are going to take the chord combination of segments that are given by that are killed using of this rows we are going to stick the chord combinations basically whenever you want to do any transaction okay if you want to do any transaction compulsory we need to select the quarter combinations right like or debit combination and credit combination Okay, so that combinations are not predefined right. We must enter select the combination while defining that any journal entry So, already the icons are there, but combinations are not predefined. They concert there in our icon segment based on that transaction. Now we are going to selecting the chord combination we are going to constructing the chord combinations dynamically okay.

So till now we created a different type of combinations right. There is no restriction that we can select any type of combinations. But sometimes the system assign some security to the segment's they want to hiding some quarter combination. So, how they can hiding the quarter combinations means with help of de cross validation. We help that cross validation rules after assigning these roles, okay, whatever combination they're restricted That combinations you cannot able to use in the future. Okay, whatever combinations they're restricted that combinations we cannot able to use into the future.

So, that are restricted only how to restrict the quarter quarter combination means with help of de cross validation does it help us out cross validation rules solidi the article provided two types of rules and we are going to assigning that quarter combinations that to the rule certainly after assigning. So, whatever the combinations with restricted so that combinations we cannot able to use into the future that combinations we cannot able to use into the future that are permanently restricted only. Okay How to restrict or the combination with the help of de cross validation rules. Ok. Now let us go to see the example. So, already we created different combination okay there is any effect on the created combination after assigning the CO this rules no there is no effect why because already that the journal entries we pass that we pass it and we post it also right there is no effect on that created gentles of that defining distance okay whatever the demand is recreated in the future.

So, based on that combination that general interests are get affected only okay there is no effect on the creative journal Okay. How to assign this roots to the core combination? Actually before going to assigning the roles, we need to define three steps First, we require the three steps. What are the three steps means the first step is Jim should enable the cross validate segment checkbox into the structure window. If you want to define the cross validation rules into the segments, your first step is you must enter assign them cross validate segment checkbox. Cross validate segment checkbox into the structure window.

That is the first step. And second step is all the securities all the sorry all the segments must entered in the security enabled position. All the segments must and should enable the security to all the segments whatever the segments in check affections, you must entered enable the security to all the files or segments are fired as a second step third one is after assigning these two points. You must ensure recompile the structure one more time after we compile in only whatever changes you made on the structure that are permanently applicable that are permanently applicable okay. So, these are the three rules are mandatory before going to define the rules After defining these three rules, next step is go to define that cross validation rules for each loop we are going to assigning some quota combinations whatever chord combinations we restricted that combinations we cannot able to use into the future.

Maybe sometimes when you try to use that restricted combinations, the system gives the error message. Okay so now let's log into the GL and select our primary ledger. Now go to define the first jewelers masternode enable the crowd Red segment checkbox in the structure window. Structure when domains flexible structure window go to query or flexible structure when domains chart of a constraint. The navigation is set up financials lexical key segments go to query what sector press go to query mode, press f7 and do the application name. Press Ctrl F. Okay.

Now put the cursor on the flexible title select the title of this please accounting philosophy and what is your structure name? That's a counting structure. Stuck on things okay, so before going to make changes into the structure first you have to unfreeze the structure go to unfreeze it. Okay and then lastly there is a checkboxes that cross validate segment checkbox okay? enable this checkbox, okay. That is the first step, second step is all the segments must entered enabled security.

So go to click on the segment soliday for segments or delay. So Masjid enable the security to all the four segments, because in the beginning, at the time of creating the value sets, we are saying the security type of the segments is non hierarchical security light, which non hierarchical security means whenever we need a security to the segment, okay with Help of the non hierarchical security we are going to scanning the security to the segments Okay, so now put the cursor on the company segment go to weapon so here security enabled is there now go to enable the security okay we tell Bob that non hierarchical is the security provided by the user or but not third party third party is nothing but a hierarchical lock. Okay. Next, put the cursor on the department, click on open and make it is enabled. And third is account open, security enabled and finally, probably whatever the segments you can have in the chat of the call You must change and enable the security to all the four seconds okay enable a security to all the segments after that the two steps are completed first step is cross validate segment checkbox and second one is security enable after labeling again go to freeze them definition after freezing, compile the structure compiling flexible definition.

So, whatever changes you made you must gentle recompile the structure after compiling only so that changes are permanently saved into the structure level. Okay, now that that is recompiled successfully Okay, now let's go to define a cross validation rules. The navigation is setup financials flexible scale rules and navigation is set of financials flexible ski roads Now what predefined the cross validation boards? So go to query or structure application as the press Ctrl F level and application as General Ledger go to query your application and what is your chart of account structure name test accounting structure, I'd go to Select your structure this is a structure and what is a cross validation? rule me entered any name the name is purely user testable description is not mandatory and what is the error message? Actually, we have to give our one error message actually when this error message is displayed whenever we use any of the sticker combinations, because we are going to restrict some combinations, right So, whenever we use any restricted combination said that in the system user error message, so, whatever their illnesses we enter here the same error message is populated whenever we use that restricted code combinations okay and other users cannot use existing color combinations younger any message okay that message purely use anything you can give any message you just cannot use existing chord combinations okay.

And what is the cross relation rule elements the rule elements are that two types one is included and second one is exclude okay these are the two rules include and exclude whatever combination we enter into the include rule so that are included into the combination maybe we can use that combination at Anytime the system is not giving any error messages, okay, but excluding me, so whatever combination is selected in the excluding that are excluded from that cross validation. So whenever we use that excluding code combination the system this trick that combinations at the term system populate this type of error message. Now, I'm going to selecting some different icon 100121006. Okay, so all these six icons within that include rule only, so you can use the six combination at any time known there is no restriction. Okay, and whatever they explore select the exclude chord combinations.

01 Company Hold on. Hi, suppose here I'm selecting the more than one departments Count selecting the 0100 to 1001 okay selected some different rules into the exclude whatever combination is selected in exclude that combinations are restricted. So, you cannot use that combinations into the future when try to use that combination the system gives the error message okay the chord combinations are the rules are the two types one is included and second one is exclude okay my center select the include segment include a combination exclude also okay got to say which transaction complete one record uploaded saved okay Now we created the roles and we assigned elements to the system now next step is go to test whether the rules are applicable to the segments or not. How we can test with help of that gentleman go to rise a gentleman Dental Center created new Jenna go to the CVS journal means cross validation general CBR means cross validation.

So the CVS means cross validation rules. Okay. This is your test like they're two days later, and currencies. Okay. What are the lines select the core combination This combination it is accepted why because all this this combination which is in that include rule only rate, but when you select any other combination like selecting the department or some other department 102 department let us see. It is also actually separate one zero to select some different account.

No display error messages users cannot use existing combination when I use any restricted combination. This is some user error message This is nothing but their cross validation rules this is nothing but a cross validation rules Okay, you're going to take some chord combination whatever chord combinations redistricted So, that combinations we cannot able to use into the future when try to use that combination the system gives our error message this is also restricted okay. This is nothing but the exclude the explored combinations are restricted. This is nothing but a cross validation. Okay. Okay.

So maybe you can do this The different combinations also because we selected the range of counts for whatever it comes we selected as a excluded combination that combination service ticket we cannot able to use that combinations into the future okay this is nothing but 10 cross validation okay and next is de reports in Oracle Application that is a ngl model there is a different type of reports out there, but as a functional people you are going to developing these two types of reports. The first one is the standard report trial balance report and second one is the FSC FSA reads financial statement generated financial statement is generated. Okay. The first one is a trial balance report. What is a trial balance trial balance report is a one standard report. The structure of the report is given by arkell started up the report is given by the Oracle, we cannot customize that report structure.

We cannot customize that report the structure. Okay. This is a standard report standard structure always we have to follow the same structure only. But we cannot customize the structure. Actually the elements report is created periodically maybe quarterly we can create our fairly recently once also. It's a one type of standard report it contains all the expenses, all the incomes, all the liabilities, all the assets, whatever we do the purchase whatever we do the sales, all this transactions are entered into this report.

Okay, how to download the report means with help of the primary ledger the report developed with the help of the primary ledger, maybe after completing all the transaction the information is saved to the ledger right? With help of the ledger we are going to develop this trial balance report. It is a one standard report standard report makes the structure of the report is given by the Oracle the structure of the report is given by the Oracle we never create a new structure and we never customizing the existing structure also. We never create a new structure and we cannot customizing the existing sector also, whatever the sector is there, we must ensure use the same structure and we must ensure to use that same structure. Okay, that's why it is a standard report. But there is a second report that says we can customize it.

The fizzy report, we can customize that fuzzy means we are going to develop our own structure based on our client requirement. Based on our client requirement, we can customize the structure. But trial balance report is a standard report we cannot customize it compulsory v motion should users standard structure only. Maybe this report is developed every quarterly every hour fairly every year also. Okay, so how to double how to cast out to develop this report means with help of the primary ledger once we assign the primary ledger, all the transactions are activated in the primary ledger right? Once we assign the primary ledger By default, the report takes the data from the primary ledger and the report contains three columns.

The first one is a description column second is the debit amount and third one is the cost Tell me So, two lines are the debit and as well as the credit and also the amount of the debit line and credit and both are the same always okay the amount of the debit and credit both are the same always in trial balance report. Suppose sometimes if it is not same the differences goes to that suspense account if the amount is not same, but the debit is not the debit side we enter all expenses losses or non liabilities credit side we entered all our incomes incomes gains and profits. Always the two lines are both are equal always if it is not equal, that difference goes to the suspense suspense account. Automatic the suspense account is get enabled with a different segment. Okay, this is the But sorry, Trial Balance report.

It's a standard report the report is given by our killam Okay, we cannot customize the structure we cannot customize the structure always the structure is a standard structure given by the work that is good to see the structure Okay. How to run the report because already the structure given by the Oracle right. So we cannot customize the structure and we cannot create a new structure. Always be how to use the existing structure and always be how to use that existing structure on how we can call the report means with help of one standard program. The program memories are this request to learn how to run the program request them then go to submit a new request. It is a single request.

Now it asking that request to name. So it's asking the concurrent program how to call the report means with help of the concurrent program. How to call the report means with help of that concurrent programming. So what is the concurrent program for the child branch report is trial balance report trial balance Detail Report. These are different programs or their trial when additional segment detail average budget encumbrance expanded translation sorry, mining all are optional we always select the trial balance Detail Report I want to see the detailed report on it. I want to see the detail report of the trial balance.

The Taliban's report can contains that different type of the accounts or type of accounts we entered. We entered all expenses all incomes all liabilities and all assets that we said we entered all expenses liabilities and losses. Great said we enter all incomes gains and profits. Okay, by default these seconds are taken because already we come with a different transaction. Right are we completed different types of transactions all right all the transaction details are saved into the primary ledger right? Whenever we assign the primary ledger by default all takes all the completed transactions from the ledger with help of the transactions the report is generated okay.

So the report structure is given by Oracle only that is a new structure standard structure given by the Oracle we never created a new structure and we cannot customize the standard sector also existing sector also okay now go to select this sir trial balance report. detailed report now Italia by default it takes your primary ledger the ledger name is just like this currency is a test Dianna currency type of it is a page break segment guys next segment is nothing but your company right. So your report is developed prefer only your company or more than one company. Okay, so the next segment is your company Okay, and it asking that company value, low and high. Suppose if you have multiple company transactions, we can select the multiple values also here means whenever we select the multiple company names. By default the report is generated for the two companies at a time.

By default the report is generator for two companies at a time money but now we have only our one hour Company transactions on data there is no other company transactions. So that's why here you have to select the 01 our company one only one company and what is the period because our transactions in the match period on the right and there is a match period and what is our monitor type is a PGD are always there is a three types are there p JTD means project to data PGD period to date and YT divided it means year to date so, I always see how to use that date Amman type as a period to date on in any situation you stick always there want to type is there period according to the period vise there Montes get enabled okay. We did he Okay. Okay. Submit and go to click on the Submit they want to submit the request now find if this program is successfully completed now the report is generated because in our primary ledger there is a limited transactions are there right?

So with the help of that limited transaction the report is generated Completed after completing this report now go to click on w or now go to click on w or foot then the report is generated because we have only limited transactions right. So then that limited transaction data is displayed here suddenly the amount is transferred to such Count 3600 caches 84,100 debit and credit and expenses 64,000 and salaries is 5500 rent is 13,000. The differences goes through suspense account. Okay, there is a trial balance report and your currency and your primary ledger. And company name is 01 name of the company that has just city Theseus. And to this day two pages only one page and maybe whenever we will create this report according to the year well, maybe there is a total one year transit it will take total one year transaction survey.

But because now we have a transaction so only in the month of March only right? transactions are there. So that's why we select the period as a merchant, but we select the total periods. So it takes a different all the transactions on it. Okay, maybe we can run this three months quarterly ones are up 11 sorry 11 cents. So, frequently the company create this report is they want to know the company whether it is in the profit position or in the losses position.

At that time they create this report trial balance report. It is a one standard report given by Oracle Application. The structure of the report is given by Oracle Application only we never create a new structure and we cannot customize that existing structure also. It is only the standard report trial balance report. Okay. And the next type of report is FSC.

What is a fuzzy fuzzy means the full form of a fizzies financial statement generated the full form of Ephesus financial statement generator. It is your profit and loss account report. Okay, this is a standard report but we can customize their report structure. So we can create our one structure also. Okay, and let us see that link in the next video. We'll see that Fs