In release 11 there is no standard/out of box solution to transfer cash between internal bank accounts in Cash Management Module, users need to use Treasury module or resort to work arounds or manual GL Journals. In Release 12 Bank Account transfer functionaly is introduced in Cash Management though advanced funds transfer capabilities are still available from Treasury only.
Current post is mainly focused on "Accounting" for such Bank Transfers in Cash Management, so i skipped the detailed discussion on the new functionality; infact focus on the modifications we need to make in Sub Ledger Application Accounting Definitions (AAD) for accounting for Bank Transfers.
Context:
Bank Transfers with "Settle Transactions Through Oracle Payments= 'NO'"
Intended Functionality :
-----------------------
#1 : There are no Journal Line Defintiions seeded for Event Types:
a. Bank Account Transfer Created
b. Bank Account Transfer Cancelled
#2 : The BAT creation event is unaccountable, unless it's customized by the customer, hence no accounting is done.
So if you want to create accounting for Bank Account Transfers you need to create custom Journal line defintions and assign the same to respective event types listed above; alsoenable "Create Accounting" Option. Without this customization to SLA, records for Bank Account Transfers will be populated into CE_PAYMENT_TRANSACTIONS and XLA_EVENTS but no journals are created when we run Create Accoutning Program.
Once you make changes:
a. Make sure correct Sub-Ledger accounting method is assigned to Ledger
b. Application Accounting definitions are validated without any errors
Ref Metalink Notes:
#422895.1
#843259.1
#738626.1
Posts
13 comments:
Hi Prasanna,
I am trying to setup internal bank accounts transfer functionality in R12 cash management (with RUP6 patch applied).
I read ur post and then tried to go to "Subledger Accounting Methods" form in Payables responsibility. Since i am using 'Standard Accrual' as my accounting method in "Accounting Setup Manager" form so I found the 'Standard_Accrual' method in the "Subledger Accounting Methods" form.
Under that i couldn't find "Cash Management" in the Applications field. So i added a new record for Cash Management and entered "Cash Management Standard Accounting" in front of it as its name.. as it was the only available value in the LOV.
The problem now is that the "Application Accounting Definition" button in this form that you referred to is GREYED-OUT so i can't see the event types or add the journal line definitions to those event types.
Please guide me if there's any solution to this.
Regards,
Ali Mohsin
Dubai
Hi Momin
Use Cash Management Setup user to query the sub-ledger accounting method, if you query SLAM from AP you can only view AP AAD (other AADs will appear greyed out). It is intended functionality:
1. Query the SLAM from Cash Management Setup User
2. Copy the standard method and modify the custom definitions, you need to copy everything SLAM to Journal Line Definition. You cannot modify anything with owner as Oracle.
Hi Prasanna,
Thanks for the quick reply (I didnt expect such a quick reply). I did as you told and got that button enabled. But i am facing some other related issues which can be depicted only by way of screenshots. Can u please send me your email address or if that's not possible then please send me an email at my gmail ID: alimohsin110.
Wating for your quick response!
Regards,
Ali Mohsin
I have already Copied the standard Accounting definition to my Custom made.
Can you please tell me whether i need to define new "Journal Line Types" for the 'Bank Account Created' event? Or the seeded Journal Line Types would be enough...and if this is tge case, then which ones are those....please name them.
Moreover, if you could send me some critical screenshots of the whole process...i'd be highly indebted!
Regards,
Ali Mohsin
Okay, as earlier said, I have setup a new 'Application Accounting Definition' for Cash Management application by copying the standard application accounting definition seeded by Oracle.
Then I created new "Journal Line Definitions" (for Event Type: ' Bank Account Transfer Created' and 'Bank Account Transfer Cancelled') by using the existing "Line Types" (those already created by Oracle).
The line types i used for BAT_Created are:
Account Transfer Payment Cash CR
Account Transfer Receipt Cash DR
The line types i used for BAT_Cancelled are:
Account Transfer Receipt Offset Cash CR
Account Transfer Payment Offset Cash DR
Lastly, I assigned the newly created "Journal Line Definitions" to the two Event Types mentioned above and 'checked' the 'Create Accounting' option in front of above mentioned two Event Types.
The issue i am facing is that when after doing all above actions when i proceed to validating my custom-made "Application Accounting Definition", i get an error saying that it could not be validated. The output of the validation request erroring out says the following:
"Error Number: 95489 The account derivation rule assignments for the following Error journal line types assigned to the journal lines definition are incomplete. You must either assign an accounting flexfield rule or assign segment rules for all segments of the accounting chart of accounts. Please use the journal lines definition window to complete the account derivation rule assignments for the journal entry line."
Hi,
Once the transaction is reconciled with the bank statement or manually cleared the accounting will be created for the bank transfer.
V Paartha
Hi Prasanna,
I already tried to custom Journal line definitions and assign the same to respective event types listed above; also enable "Create Accounting" Option for Bank Account Transfer created event type based on your explanation.
Then, we tried create accounting,
unfortunately we got this error message in 'Create Accounting' output as below:
"There is no entered amount for the subledger journal entry line. Please inform your system administrator or support representative that:
The source assigned to the accounting attribute Entered Amount has no value for extract line number 0. Using the Accounting Attribute Assignments form, assign a source to the accounting attribute Entered Amount that provides a valid value."
Regards,
Budi
Hi Prasanna,
Finally, i can create accounting for Bank Account Created event type.
But, i still cannot find any journal for while doing Create Accounting for "Bank Account Cancelled" event type. Eventhough, i already did custom Journal line definitions and assign to Bank Account Cancelled event types. Is there any another way to make "Bank Account Cancelled" enable while trying Create Accounting?
Regards,
Budi.
i hav set every thing in SLA but still no accounting, can someone help me plzzzzz
Hi Prasanna and buddy
I tried doing the same and I attached the JLD of BAT clearing to BAT creation and enabled the same
Even then there is no accounting at the time BAT creation and validation (No authorization required)
Please help
Hi
Can you Please tell the navigation for Subledger Accounting Defination in Oracle Cash Managment
Hi can you please share any doc for SlA cutomization on bank account transfer created thanks waheedarshad18@hotmail.com
Hi there. Moving forward in 2018. There's another way to send money online to the Philippines and that is through Bank to bank transfers
Post a Comment