ERPstuff - Oracle EBS Community

Hi All,
Is any body did bank account transfer in cash managent in R12.0.4, If so please let me know setup steps.

When iam trying to do this, unable to get the Source bank as well as destination Bank name in list of values.

Is Payment templete is required setup? we are not using oracle payments.

Please help.

Thanks

Try the below one.

1. Login as sysadmin user
2. Go to User Management Responsibility
3. Go to Roles and Role Inheritance
4. Click 'Create Role' (or you can use 'BANK CREATION' seeded role)
5. Enter role details
Category - Miscellaneous
Application - Cash Management
6. Click 'Security Wizards' button and then save and proceed
7. Click 'Run Wizard' icon against the name 'CE UMX Security wizard'
8. Click 'Add Legal Entities' and select the legal entity from LOV
9. Check 'Bank Account Transfer' or all the three checkboxes and save
10. Go to users tab
11. Query the user and attach this new role

Try bank account transfer now for the user.

You may also go through the metalink id 414705.1

Cheers,
Saravanan TG

Hi Saravanan,

Thanks for your immdiate reply.

i have done all the mentioned setups , but while validating the bank account transfer iam getting the below error message. If you know the reason please reply.

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

Thanks for your help

You need to setup the intracompany accounts (if you want to transfer funds for bank accounts within a legal entity) and intercompany accounts (if you want to transfer funds for bank accounts across legal entities) in the ledger setup before transferring funds.

Cheers,
Saravanan

I forgot to mention the above update. I already did the inter company accounts.

About Intra company accounts, where i need to setup in accounting setups.

thanks

You need to setup the <b>Intracompany Balancing Rules</b> in the same accounting setup page.

Cheers,
Saravanan

Still iam getting the same error even after enabling the intra company balancing setup in accounting setup options.

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

Hi

Ru getting this erroe

FUN_INTRA_COMPANY_balancing RULE is not decided

or like that
null
null

inter company not able to genrate Intra company balancing rule

Can you upload the screenshot of the intracompany balancing setup?

Also refer the metalink id 434308.1 and verify the setup.

Cheers,
Saravanan

hi

If you find the error

like null
null

Inter company not able to genrate Intra company balancing rule





To implement the solution, please apply one of the two following solutions:


1. Change the cross validation rules so that the account generated is correct
2. Don't use cross validation rules. Follow the steps:


Step 1:
=======
1.) Go to General Ledger --> Setup : Financials : Accounting
Setup Manager --> Accounting Setups
2.) Search for the Ledger that has been used in the transaction
3.) Click on the icon for Update Accounting Options
4.)Click on the update icon for 'Intercompany Accounts'
5.) Copy the Chart of Accounts value
.
Step 2:
=======
1.) Go to General Ledger --> Setup : Financials : Flexfields :
Key --> Segments.
2.) Key Flexfield form will be opened. Search for 'General Ledger' in
Application and 'Accounting Flexfield' in Flexfield Title.
3.) You will see Structures
4.) Search for the text copied in 5.), in Title of structure

do the following:

Step 3:
======
3.) Uncheck the the option 'Freeze Flexfield Definition'
4.) Uncheck 'Cross-Validate Segments'
5.) Check 'Freeze Flexfield Definition', save and compile.
6.) Clear the cache doing
a.) Go to 'Functional Administrator' responsibility
b.) Core Services --> Caching Framework --> Global Configuration
c.) Click on Clear All Cache

Doc id

857386.1


Thanks

Best Regards,
Niletra Desai

Hi Sarvan

I have one Query how can you Handle Bank Accounts Transfer

i want to know which Reports you used ,

Have You modified the India/Cash Bank Book Report.

Thanks

Best Regards,
Niletra Desai

Hi niletra,

Yes. We modified India - Bank/Cash book report to include the bank transfer transactions.

Cheers,
Saravanan

Hi Saravanan,

As suggested by you, i have done the intra balancing rules with the help of note - 434308.1 but still iam getting the error message
"Enter a value for debit account."

Please help.

Thanks in advance.

Pl check note 813397.1 and also check if any invalid objects exists like packages,

4.2 FUN_INTRA_RULE_NOT_ASSIGNED
4.2.1 ?Enable Intracompany Balancing? flag is not checked for the Ledger.
4.2.2 Balancing Segment Value not assigned to the Legal Entity
4.2.3 Intracompany Rules are not defined
4.3 Intercompany Balancing was unable to generate the intercompany account
4.3.1 Intercompany or Intracompany Balancing Rules are not defined
4.3.2 Intercompany or Intracompany Accounts are Not Valid
4.3.3 Accounting Flexfield Setup is not correct
4.4 Error messages encountered while Create Accounting/Posting a GL Journal

If it is a test or dev instance, then enter as given below in Intracompany balancing rules and then try bank account transfer.

1. Source - Other
2. Category - other

Balancing Details Tab
==============
1. Debit Balancing Segment Value - All Other
2. Credit Balancing Segment Value - All Other
3. Debit Account - Enter the account combination with intracompany receivable account in the account segment (Choose proper account if prod instance)
4. Credit Account - Enter the account combination with intracompany payable account in the account segment Choose proper account if prod instance)

Options Tab
========
Level of Summarization - Summary Net
Clearing Balancing Segment Value - Use for Many to Many Journals Only
Default Options - Default Rule


Cheers,
Saravanan