Reconciliation
From: Teresa Reynolds teresa.reynolds@ey.com
Date: Fri, 19 Mar 1999 13:33:41 -0500 (EST)
It was hard to understanding exactly what you were doing.....but it sounds like you were manually entering the statement lines. Then you pressed the available button and did the search on the receipt. The search found your receipt, but when you pressed the reconcile button, it didn't reconcile. Okay, I am going to ask the obvious first.....did you check the box to the left of the receipt to select it, before you pressed the reconcile button? Teresa
Date: Fri, 19 Mar 1999 17:28:47 PST
From: "Basanta Kumar Dash"
Subject: Re: Cash Management - HELP!
Hi Teresa,
Yes, I did that. I did exactly what you have described. I checked the check box before
pressing reconcile button. After that there is no message on the screen and the surprise
thing is that it's working fine with Payments.
Your help is most appreciated.
Regards, Basanta.
Statement Upload
From: Warwick Gill [SMTP:WarwickG@langeberg.co.za]
Sent: Tue 16 March 1999 16:50
Subject: Problems with Statement Upload in cash management
Hi I'm having a problem with automatic statement upload. I have written a program using VB
to place the details in the bank statement interface tables, and it does this perfectly.
When I try to import the statements into the statements table, it always attempts to
perform an automatic reconcilliation and errors out. I can view the statement lines but
cannot alter any of the lines or reconcile them to cheques or receipts. Any attempt to do
this results in the following error:
FRM -40654: Record has been updated. Requery block to see change.
This has really got me stumped. I'd appreciate any input from people who have had the same
or similar problems, or even suggestions on how you may think I can get past this. Thanks
Warwick
Date: Mon, 22 Mar 1999 09:55:56 +0200
From: Suzie Roth
Subject: RE: Problems with Statement Upload in cash management
Hi, 1. The import program (Bank Statement Import) doesn't do any autoreconcilliation even
if it looks like it does because of the second program it runs.
2. We got the same error message once. You have loaded nulls into your table that is why
you are getting this error message. Try to insert into the interface table very simple
data, without any nulls, and see that you can update the data through the interface form.
Suzie.
Clearing Account issues
Date: Tue, 23 Mar 1999 09:50:29 -0600
From: monty.free@uslgn.mail.abb.com
Subject: CM: Cash Management Out of Balance
We have posted from A/P to G/L for the first time since manually clearing all of our
payments in the Cash Management application. The Transaction- Cash in Transit report from
CM shows that all payments are in fact cleared. This would seem to indicate that the
Clearing account in G/L should have a zero balance.
However, when we run a Trial Balance and the Account Analysis Report from G/L, the
Clearing account has a balance.
We have called a TAR into Oracle Support Germany but have not received a response. We are
looking for suggestions on where to look for problems.
Thanks... Monty Free ABB Lummus Global, Inc.
Loading EDI Bank Statements
Date: Fri, 16 Apr 1999 11:10:55 PDT
From: "Somu Kopparthy" skopparthy@hotmail.com
Cc: skoppart@csac.com
Subject: CE - Loading EDI Bank Statements
Message: Hi All:
I am looking for information on how to load Banks statements (EDI format) into cash
management. We are getting the Bank statements through EDI format. We have to load these
bank statements into cash management for reconciliation. We don't have any EDI software
for transalation. Does anyone have any routines to load EDI bank statements into cash
management.
Any help would be great. Thanks in advance. Thanks Somu Kopparthy e-mail:
skoppart@csac.com
Date: Fri, 16 Apr 1999 20:23:24 +0200
From: Warwick Gill WarwickG@langeberg.co.za
Subject: RE: CE - Loading EDI Bank Statements
Hi
I have written a a VB app to load the statements into cash management. It is a simple case
of getting the format of the file you get via EDI, extracting the relavent information and
populating the ce_statement_headers_interface and ce_statement_lines_interface tables.
Regards Warwick
Oracle Public Sector Accounting
From: GWRR@aol.com
Subject: Oracle Public Sector Accounting
Date: Tue, 27 Apr 1999 10:00:11 -0400 (EDT)
Hello,
Does Oracle'sPublic Sector encumbrance accounting features in Purchasing and Payables work
for you?
My client must record and post the actual expenditure account (in addition to the
(expense) encumbrance account) at the time the PO is created. Oracle does not create a
transaction for the actual expenditure account until it is invoiced and match in Payables.
Has anyone else had this problem? If so, what was your solution?
Also in Payables, my client uses pool cash accounting. One Payables liability and one bank
account are used to record and pay Payables invoices. But the client requires that all
invoices and payments in Payables also create additional Payables and cash accounts
entries by fund along with the origina Payables liability and cash account entries. Has
anyone else had this problem? If so, what was your solution?
Thanks, Gwen
From: Akshay Bhatt [mailto:akshayobhatt@hotmail.com]
Sent: Tuesday, April 27, 1999 10:40 AM
Subject: Re: Oracle Public Sector Accounting
Hi
Have implmented OF. Purchasing and AP are Ok & we had to go for Cash Management to
reflect transactions until they were cleared by bank. For entries in GL for encumbrance
you have to run the Create Journals program. Irrespective of journals, funds are updated
online. Hope this may be of some help to you.
Akshay
Date: Tue, 27 Apr 1999 16:37:46 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: Oracle Public Sector Accounting
Regarding the cash pooling requirement. We created a zero-fill cost center to act as our
cash pool and chose the automatic offset option of "balancing" in the Payables
options. The liability and the cash entries coming out of AP are then specific to each
fund, yet by looking at our cash pool cost center with the liability or cash account, we
are able to see the total liability and total cash.
So, for example, one liability entry may be Fund 00001. Cost Center 000000. Account.21000
while another may be Fund 00002.Cost Center 000000.Account 21000. By looking at 21000 we
are able to see the total liability balance. This also works for our single bank account -
the cash entries would be Fund 00001.Cost Center 000000.Account 11000. and Fund 00002.Cost
Center 000000.Account 11000.
Bank file details
Date: Wed, 5 May 1999 07:44:42 -0700 (PDT)
From: Jas jas_walia@yahoo.com
cc: (bcc: Radha Krishna/Corporate/AirTouch)
Subject: Cash Management -- Bank File
Hi :
Our bank's BAI file only suppies Cheque numbers but other document numbers like Receipt
number is not supplied with the bank file.
My question is if I import this file into Cash Management and run auto reconciliation
program. It will run sucessfully or turn into an error.
Thanks Jas
Date: Wed, 5 May 1999 10:14:16 -0700
From: Radha.Krishna@Notes.airtouch.com
Subject: Re: Cash Management -- Bank File
Two Cash Management tables need to be populated for the Bank Reconciliation Program. They
are
a) CE_STATEMENT_HEADERS_INT_ALL
b) CE_STATEMENT_LINES_INTERFACE
for a) we need to populate Statement_number(we can use statement date instead if your bank
file doesn't provide the statement number,Bank_account_number :is the Bank Branch account
number from where your file is coming, Statement_date(The date of the statement),
Org_id(if using multi_org).
for b) we need to populate Bank_account_number(the same number given in the headers
table), Statement_number(same as given for in headers table), line_number(if not provided
, create a sequence), Trx_date( the date on which the transaction occured ,from the file),
Bank_transaction_number(is the cheque_number that needs to be populated).
With this data your program should run.
Cheers, Radha.
Date: Wed, 5 May 1999 10:19:54 -0700 (PDT)
From: Jas jas_walia@yahoo.com
Subject: Re: Cash Management -- Bank File
Thanks
Cash Management & Payroll Reco
From: Aguilar, Michelle AguilaMi@rf.suny.edu
Date: Tuesday, May 18, 1999 10:50 AM
Subject: Cash Management & Payroll Recon
Does anyone know how we can reconcile payroll checks from the Oracle Payroll module by
using the Cash Management module?? Our payroll team is telling us the check number is not
stored anywhere and there is no field for a cleared date.
Date: Tue, 18 May 1999 10:53:07 -0500
From: "Ken Conway" ken.conway@bosscorporation.com
Subject: Re: Cash Management & Payroll Recon
Michelle:
You must create a custom solution for payroll check reconciliation if you plan to go live
with Oracle Payroll in 1999. When Release 11i becomes available, there is a planned
integration between Oracle Payroll and Oracle Cash Management to handle check
reconciliation.
Hope this helps, Ken Ken Conway BOSS Corporation Better Organization Service Solutions
214-495-7654 (Voice) 214-495-7653 (Fax) 770-622-5500 (Headquarters) Email:
ken.conway@bosscorporation.com http://www.bosscorporation.com
Available Transaction Report
Date: Wed, 2 Jun 1999 06:44:28 -0600
From: psawyer@Baxglobal.com
Subject: Cash Management, Transaction available
When I run the available transactions reports in Cash Management it shows voided checks
and receipts that were reversed. These will never be reconciled. How do I reconcile or
delete these items so they do not show on the report? What I am really after is an
outstanding check list.
Date: Wed, 2 Jun 1999 16:05:34 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: RE: Cash Management, Transaction available
You can reconcile it against dummy bank statement lines (of types: "Stopped",
"Rejected" or "NSF"). Oracle will fix it in 11.5 release. For more
information you can check BUG num. 787986.
-- Suzie Roth MIS (Ext. 7151)
Cheque No. format problem
mohan murali wrote:
Hi,
This is a cash management and AP question. I issued a check in AP with check number as 09,
but AP stripped the preceeding '0' and entered the check number as 9.
I received the bank statement in CM with check number as 09 (This is the number that is
displayed on the check). When I try to manually reconcile this transaction, Cash Managment
could not find an available transaction with check number '09'.
How to handle this issue? Is this a case for customization or am I missing something in
setup?
Your inputs are highly appreciated.
Thanks
Date: Fri, 04 Jun 1999 20:47:48 -0700
From: Mohan miyer@fortuna.com
Subject: Re: Cash Management!!!!
Hi Mohan,
This is because when you load the data form the bank it gets loaded in the CE Interface
tables and the column used for the Check Number in this table is a character column,
however the column in AP_CHECKS is a numberic column.
You will need to convert the data in the interface table to a number, then you will not
have any problems.
Let me know if you need any help with this I have a script that will fix it every time you
load the interface table.
Mohan
Bank Statement No.
Date: Fri, 11 Jun 1999 08:06:48 -0500
From: tams 019 Oracle Install jmule@mailhost.tcs.tulane.edu
Subject: Simple Cash Management question...
Attention Cash Management gurus:
I have a seemingly simple problem that I can't figure out. When populating the Bank
Statement Open Interface tables we need to have the statements go to only 1
STATEMENT_NUMBER (i.e. multiple LINE_NUMBERs for only one statement). In our bank feed we
have transactions coming from only 1 bank (also only 1 account number) and the bank file
we receive does not have the equivalent of a statement number on it (so I have to generate
a bogus one). The problem is: if I attempt to populate the CE_STATEMENT_HEADERS_INT_ALL
table with say a '1' for the STATEMENT_NUMBER and the other NOT NULL columns
(BANK_ACCOUNT_NUM and STATEMENT_DATE) are also hard-coded values, I get an integrity
constraint on the table (duplicate key values). How can I create a SQl*LOADER that allows
me have only a single statement number with multiple statement lines (in
CE_STATEMENT_LINES_INTERFACE). I've included the current control file I'm using. The users
do not like the fact that I populate the tables with multiple statement numbers (i.e. each
statement line has a 1-to-1 relationship with the statement header STATEMENT_NUMBER) -
this apparently creates a cumbersome situation when they attempt to reconcile.
LOAD DATA
REPLACE
INTO TABLE CE_STATEMENT_HEADERS_INT_ALL
WHEN (16) = 'R'
(STATEMENT_NUMBER SEQUENCE(MAX,1),
BANK_ACCOUNT_NUM POSITION(027:035) CHAR,
BANK_NAME CONSTANT "HIBERNIA NATIONAL BANK",
STATEMENT_DATE SYSDATE,
CURRENCY_CODE CONSTANT "USD",
LAST_UPDATE_DATE SYSDATE,
LAST_UPDATED_BY CONSTANT "1"
)
INTO TABLE CE_STATEMENT_LINES_INTERFACE
WHEN (16) = 'R'
(BANK_ACCOUNT_NUM POSITION(027:035) CHAR,
STATEMENT_NUMBER SEQUENCE(MAX,1),
LINE_NUMBER SEQUENCE(MAX,1),
TRX_DATE POSITION(036:041) DATE(6) "MMDDYY",
TRX_CODE CONSTANT "R",
EFFECTIVE_DATE SYSDATE,
AMOUNT POSITION(007:015) CHAR
"TO_NUMBER(SUBSTR(:AMOUNT,1,7)||'.'||SUBSTR(:AMOUNT,8,2))",
CURRENCY_CODE CONSTANT "USD",
BANK_TRX_NUMBER POSITION(001:006) CHAR
"TO_CHAR(TO_NUMBER(:BANK_TRX_NUMBER))"
)
John Mule'
Tulane University
(504) 862-8000 ext. 1988
jmule@mailhost.tcs.tulane.edu
Date: Fri, 11 Jun 1999 16:11:55 -0500
From: "Jared Schulz" JSchulz@VantageSolutions.com
To: oraapps-l@cpa.qc.ca, jmule@mailhost.tcs.tulane.edu
Subject: RE: Simple Cash Management question...
Keywords: Oraapps
John:
I experienced a similar problem at one of my clients. Our solution was to populate the
STATEMENT_NUMBER column with the STATEMENT_DATE or SYSDATE. This way, each successive run
of the interface will generate a new STATEMENT_NUMBER. Make sure this value does not
include hours, minutes or seconds, though.
You can load the LINE_NUMBER column with the SQL*Loader RECNUM reserved word. This way,
each record will be incremented by one.
Regards,
Jared Schulz
Vantage Solutions
http://www.VantageSolutions.com
Bank reco without AR and CM
Date: Wed, 14 Jul 1999 22:51:08 +0530
From: Mohan Dutt mohandutt@rediffmail.com
Subject: Bank Reconcilliation without AR and Cash Management
Hi,
We have implemented GL and AP modules. Is Bank Reconcilliation possible without AR and
Cash Management modules? Is there any shared forms of AR and Cash Management which can be
installed to run Auto Clear? Instead of Automatic Reconcilliation if anyone has tried
manual reconcilliation, which all shared tables were considered for developing the Bank
Reconcilliation report?
Thanks in advance.
Mohan
Date: Thu, 15 Jul 1999 09:23:53 -0400
From: ralph ramnath rramnath@neal-and-massy.com
Subject: RE: Bank Reconcilliation without AR and Cash Management
I am particularly interested in the reply. Some time back, I polled the forum for comments
on implementing GL, AP and CM without AR. My question was - Can deposits be entered into
GL and passed to CM for reconciliation.? If so, is there a program that does this? If not,
iwhere can we get info on the tables in CM that have to be populated from the GL deposits?
I hope these questions get answered in the dialog that follows.
Thanks
Date: Sun, 18 Jul 1999 09:15:19 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: RE: Bank Reconcilliation without AR and Cash Management
Hi,
Journals entered in the GL account which is defined as the Cash account of the specific
bank account, are available for reconciliation on the CM side. There is no need to
transfer anything to the CM. The CM "looks" for available transaction in the
subledgers (AR, AP) and in the GL (the cash account). For technical information (tables,
views) you can use the TRM (Technical reference manual) and for setup and processes
issues, the user manual of the CM can be helpful.
Regards, Suzie.
Date: Sun, 18 Jul 1999 08:33:08 +0100 (BST)
From: =?iso-8859-1?q?Mohan=20Dutt?= mohan_at_pwc@yahoo.co.uk
Cc: suzie_roth@stcl.scitex.com
Subject: RE: Bank Reconcilliation without AR and Cash Management
hi suzie,
my question was whether it's possible to carry out manual reconcilliation without AR and
CM. Since we have got only AP and GL (where receivables are being accounted directly thru
JVs),has anyone developed a customised report for bank reconcilliation statement?
Installing Cash Management with AP without AR
Date: Mon, 26 Jul 1999 15:54:27 -0500
From: "Melissa A. Barbeau" Melissa.Barbeau@ey.com
Subject: Integration of Cash Management with AR and AP
My client is installing AP and Cash Management, however, we are not installing Oracle AR.
How will this impact bank reconciliation in Cash Management in terms of the set up as well
as the process?
Thanks Melissa
Date: 26 Jul 99 17:11:21 -0400
From: "Diane Bayes" DBAYES@ca.oracle.com
Subject: Re: Integration of Cash Management with AR and AP
Please make sure that AR is not set to installed. If so, then you will have to set up AR
enough to process a receipt.
Diane Bayes
Senior Technical Analyst - Applications
Date: Mon, 26 Jul 1999 16:42:42 -0500
From: "Melissa A. Barbeau" Melissa.Barbeau@ey.com
Cc: dbayes@ca.oracle.com
Subject: Re: Integration of Cash Management with AR and AP
Thanks for the response. Just so I am clear - if we do not have Oracle AR installed it
will not cause problems. Then are you not able to reconcile receipts? However, if you do
have Oracle AR installed, you do need to do the basic set ups?
Melissa
Date: 26 Jul 99 18:44:09 -0400
From: "Diane Bayes" DBAYES@ca.oracle.com
Subject: Re: Integration of Cash Management with AR and AP
If AR is not set to installed, then there will not be any problems. Where are the receipts
coming from if you do not have AR installed? Oracle Cashmanagement will only reconcile
receipts Oracle AR.
Diane Bayes
Senior Technical Analyst - Applications
Date: Tue, 27 Jul 1999 13:35:15 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: Integration of Cash Management with AR and AP
Hi,
First if u have AR installed u have an option of performing the clearing in AR or in CE.
The benefit is if u have CE the reconciliation can also be done there which is not
possible in AR If u do not have AR and are going to implement only AP and CE it will not
affect much.But to inform u something important, u cannot reconcile direct deposits to the
bank. Plus u also cannot reconcile Bank Charges because there's nothing called
"Missleaneous Payments" in AP so u need to enter a negative receipt in AR Thus u
do need a shared install of AR atleast. IF not then u can treat bank charges and Direct
deposits or transfers as cleared by default.
Regards, Sunil Wahi
Cash Forecasting not working
Date: Tue, 27 Jul 1999 13:25:01 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Cc: sunn999@hotmail.com
Subject: Cash Management- Forecasting
Hi,
A Query on Cash Forecasting
I have set up cash Forecasting templates
For Rows I am using source as AP invoices,AR invoices and receipts,AP Payments.
For columns i am using GL periods
The problem comes when I run the Program "Submit Cash Forecasting" by Gl periods
The program completes in no time giving no output.The log is also empty. THis I am facing
in the Production Database but in Vision it's working fine The version of Production
database is Release 11.03 Has this anything to do with the Organization field in the Rows
form because I am not able to pick up any Organization from the LOV in that field.
I just want to confirm whether it's a bug or there are some other setups. I have also
tried it out using Days as columns.
Thanks in advance for the help.
Sunil Wahi
Date: Tue, 27 Jul 1999 17:50:30 +0200
From: Yuval Nir yuval_nir@stcl.scitex.com
Subject: RE: Cash Management- Forecasting
I have encountered the same problem and no solution as of yet.
Yuval Nir
Date: Tue, 27 Jul 1999 16:47:03 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: Cash Management- Forecasting
Yuval/Sunil
Cash Forecast not being executed by GL Period seems to be known bug and should have been
fixed in Rel. 11.0.2!! However, this does not seem to be the case. Do check with support
on this matter. The bug no. is 659113.
Hope this helps.
Ananth
Senior Applications Consultant
Date: Thu, 29 Jul 1999 14:21:39 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: Reply: Cash Management- Forecasting
Hi,
Thanks Ananth ,I have already logged it with support but no response yet.
Regards,
Sunil Wahi
BAI2 format of Nations Bank
Date: Tue, 27 Jul 1999 17:26:13 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: Has anybody work on Bank Statements with Nations Bank
All,
Has anybody worked on Nations Bank file format for Bank Reconciliation ? I got a BAI2
format which is difficult to be interpreted ( as per the given Layout ). It is difficult
to format this file through Shell scripts also. Did anybody get their specified file
format from NAtions Bank. I called several times but they say cannot send in specified
format.
Thanks,
-chakrapani
The file contents are as follows:
*** Transmission in Progress ***
01,053000196,z00075,990623,1651,1,78,78,2/
02,z00075 ,061000052,1,990622,0000,USD,/
03,0101196740,USD,010,000,,,015,000,,D,2,1,000,2,000,020,000,,,040,000,,,045 /
88,000,,,050,000,,,057,000,,,073,000,,,075,000,,,079,000,,,080,000,,,081,000
/
88,,,100,990529,1,D,3,0,990529,1,000,2,000,105,000,,,110,000,0,D,3,0,000,1/
88,000,2,000,120,000,,,140,000,,,150,000,,,170,000,,,180,000,,,186,000,,,190
/
88,000,0,D,3,0,000,1,000,2,000,200,000,,,210,000,,,215,000,,,239,000,,,250/
88,000,,,260,000,,,270,000,0,D,3,0,000,1,000,2,000,280,990529,,,294,000,,/
88,310,000,,,350,000,,,390,000,,,400,990529,13,,406,000,,,
412,990529,,,416/
88,000,,,420,000,,,450,000,,,470,990529,,,480,000,,,486,000,,,490,000,0,,500
/
88,000,,,510,000,,,515,000,,,539,000,,,550,000,,,570,000,0,,580,000,,,594/
88,000,,,596,000,,,650,000,,,690,000,,/
16,281,990529,Z,4510002104,3750678491/
16,581,62000,Z,1400049399,0000036482/
16,581,41801,Z,0300427806,0000036546/
16,581,2635,Z,0500366164,0000036584/
16,581,113183,Z,0000000000,0000036614/
16,581,792,Z,0500366879,0000036628/
16,581,3916,Z,1600037106,0000036637/
16,581,15000,Z,1600035329,0000036648/
16,581,8149,Z,0300386592,0000036661/
16,581,3001,Z,1400049380,0000036666/
16,581,412917,Z,0300471925,0000036704/
16,581,25620,Z,1600035328,0000036708/
16,581,267255,Z,0300427807,0000100721/
16,581,34260,Z,0400116931,0000100725/
49,6933703,25/
03,0101196773,USD,010,000,,,015,000,,D,2,1,000,2,000,020,-185795,,,040,000,,
/
88,045,000,,,050,-185795,,,057,000,,,073,000,,,075,000,,,079,000,,,080,000,,
/
88,081,000,,,100,1883846,1,D,3,0,1883846,1,000,2,000,105,000,,,110,000,0,D,3
/
88,0,000,1,000,2,000,120,000,,,140,000,,,150,000,,,170,000,,,180,000,,,186/
Date: Wed, 28 Jul 1999 08:49:42 +0200
From: Warwick Gill WarwickG@langeberg.co.za
Subject: RE: Has anybody work on Bank Statements with Nations Bank
Do they not have a specification detailing the format you refer to below?
Date: Wed, 28 Jul 1999 09:28:35 -0400 (EDT)
From: Rajendra Gutta CMCIRPG@NJTRANSIT.STATE.NJ.US
Subject: Re: Has anybody work on Bank Statements with Nations Bank
Hi Chakrapani,
I had worked on the Nations bank data for bank reconciliation in cash management for one
of my clients in MD a cuople of years ago.It was resembling the same one you had appended.
I developed a SQL*LOader script based on the first two positions,eg if the first 2
position was 01 the data was of a particular format.I do not remember exactly but i had
developed the interface with the SQL*Loader. Let me know if i could be of any help.
Raj. All,
Date: Wed, 28 Jul 1999 23:59:58 -0400
From: "Gogia, Ajay" agogia@kpmg.com
Subject: Re: Has anybody work on Bank Statements with Nations Bank
Chakrapani,
We have just developed a PL/SQL script to load BAI file in CE Interface tables. Ask your
bank to provide you the BAI file layout document. You do need this document to interpret
the file. If you need any help you can contact me directly.
Ajay Gogia
Senior Consultant
kpmg
Pager : 1.800.556.3240
Internet: agogia@kpmg.com mailto:agogia@kpmg.com
Tel: 757.881.6898