Thursday, January 31, 2008

Feature Replacement - Cash Management Module

Hi All,

as we all know there were many new features that were provided in the Release 12 version, but how many of us know about the modifications(Alterations / Deletions / Replacements) that took place in the existing features. It is really hard to find out the changes made to the existing features, unless otherwise we work on that area. I am making an attempt to cover such existing areas which got modified due to the introduction of new Release 12 features.

In this topic we will discuss about the change that has been made to the Cash Management Setup. As we all know the only setup which one needs to make for the Cash Management
Module is the System Parameter Setup under the navigation
Cash Management Responsibility > Setup > System > System Parameters ( Navigation remains the same for Rel 11 and Rel 12)

In Release 11, under the System Parameters form we have 3 TABS,
TAB 1 = General || TAB 2 = Auto Reconciliation || TAB 3 = Open Interface

Screen Shot of System Parameter Form in Release 11
Whereas in Release 12, under the System Parameters form we have only 2 TABS,
TAB 1 = System Controls || TAB 2 = Cash Management Transactions

Screen Shot of System Parameter Form in Release 12
Since there are new tabs are in place for Release 12 versions we will see whether they cover the functions that are being carried out through 3 tabs in Release 11 versions.
In Release 11,
General TAB = Receivable Activity , Float Handling, Archive/Purge Options, Matching Order option for AP and AR, Signing Authority Approval.
Auto Reconciliation TAB = Exchange Rate details, Tolerances details
Open Interface TAB = Interface code and Interface matching criteria
In Release 12,
System Controls TAB = Reconciliation Controls, Signing Authority Approval and Archive/Purge Options
Cash Management Transactions TAB = Exchange rate type options, Bank Account Transfer Authorisation type.

If you make a comparison between the above, you will find out almost many features continues to remain the same apart from few which were not appearing in Release 12 , and few which were new in Release 12, we will see what are they now.

Features that were available in Release 11 Cash Management Module but NOT
=================================================================
available in Release 12 Cash Management Module
==============================
1) Receivable Activity
2) Float Handling
3) Matching Order option for Payables and Receivables
4) Tolerances Details
5) Interface Code and Interface Matching Criteria
6) Check box for Using Reconciliation Open Interface

In case if you are wondering how cash managment will work without these, there is no need to panic, since all the above metioned features got shifted to different area in Release 12. You can do all these setups while creating Bank Accounts in Release 12.
You will find all these controls under Create Bank Account process ( i.e. after creating a bank and bank branch) in Step 3 which is Account Controls.

Screen Shot of Account Controls page (Bank Account) in Release 12
Features that were NOT available in Release 11 Cash Management Module but
=================================================================
available in Release 12 Cash Management Module
==============================

Bank Transfer is a new feature in Cash Managment Module, earlier it was carried out in Treasury modules and by few workarounds in the financial modules. So the below features are in support of bank Transfers.
1) Bank Account Transfer Authorisation Type
2) Bank Transfer Rate Date

To sum up, in Release 12 setting up of cash management is not only limited to System Parameter Form, it also requires Bank Account setups to be done.
And many may argue that System Parameter form is not the only setup in the Cash Management Module, since we need to setup Banks, Payment Methods, Receivable Activities etc etc..., but all these are related setups, whereas System Parameter setup is the one and only setup that can be made in a Cash Management Module and not anywhere else.

Will meet you guys with other features ...

12 comments:

Navaneeth said...

Hi!!
I have a problem with Bank Account Transfer functionality between 2 banks in the same legal entity.

I have defined Intracompany balancing rules - one for my legal entity and one dummy legal entity called ‘No Legal Entity’. I did these setups according to Metalink: Bug No. 6113591.
Also, Assigned the Legal Entity to Cash Management User to enable Bank Transfer. But Still I am getting the following message when I try to validate the Bank Transfer:

1. FUN_INTRA_RULE_NOT_ASSIGNED
2. Intercompany balancing was unable to generate the intercompany account.

Can you help me.

Karthikeyan said...

Hi Erikson,
refer the below : (Metalink note 459388.1 )
To implement the solution, please execute the following steps::
Please try this in a TEST instance first.
Please follow below steps.

1. Select Cash Management responsibility.
Navigate: Setup->accounting setup manager->Accounting Setup.
Accounting Setups Tab
Search Ledger: customer ledger
Click Update accounting options
Click update for Primary Ledger: customer ledger ->Setup step: Intracompany

2. Balancing Rules.
Click Define rules for Legal Entity Name: customer ledge
Click Create Rules
Source :Other
Category: Other
Balancing Details tab->
Debit balancing Segment Values: All Other
Credit balancing Segment Values: All Other
Debit Account: your account
Credit Account: your account
Options tab:
Default Options: Manually entered clearing balancing Segment Value

Anonymous said...

Can you explain in detail the setup steps needed to create Bank Account Transfer journal Entries.

I have created a Bank Account Transfer with the option ‘Settle through Oracle Payments’ = NO. Status of the Bank Account Transfer = Settled. I cleared that Bank Account Transfer and ran Create Accounting but I couldn’t see any journal entry in GL for that Bank Account Transfer.

I believe there is some setup missing for creating the Bank Account Transfer Journal Entry. Can you tell me the missing setup.

Really appreciate your help. Thanks in advance

Karthikeyan said...

Could you check whether your bank transfer is recorded in CE_PAYMENT_TRANSACTIONS tables first .... !
This is the table/module where the data will get updated first ... !

Anonymous said...

Yes the bank account transfer is populated in CE_PAYMENT_TRANSACTIONS table with the status = SETTLED.

I believe some setup needs to be done for creating Bank Account Transfer Journal entries. Is that right?

Anonymous said...

Hi Karthikeyan

Were you able to figure out the problem??

Navneeth

Anonymous said...

Hi!!

I fixed the issue by creating Subledger Accounting Definition for Cash Management.

apps.alisyed said...

Dear,

Can you please guide how did u configure this?

Unknown said...


Your blog is so nice, and the article is very good it helps to so many people.

Oracle Financials Training in Ameerpet, Hyderabad

yamuna said...

Good Information, thanks for sharing this blog.
Oracle Fusion Financials Online Training

Fusion Financials said...

Your blog has broadened my horizons on [subject]. I never thought about it from that angle before! Fusion financial training in hyderabad

Fusion Financials Training said...

This insightful blog provides a comprehensive exploration into the transformative realm of feature replacement within the Cash Management Module, shedding light on the nuances and implications for Fusion Financials Training. The author adeptly guides readers through the evolution of this module, offering valuable insights for finance professionals and system administrators keen on optimizing their cash management workflows.