Journal Import - entries unbalanced
Date: Tue, 7 Sep 1999 15:52:00 -0500
From: Janaki.Yarlagadda@frco.com
Subject: Journal import erroring out showing unbalanced entries
Hi All,
Here at my client's place we are importing journals from a legacy
source which is automatically kicked off once every week. When i was
trying to import them it errored out saying the entries are not
balanced. Theni went into the Journal import Correct screen and
correncted some entries. Now if i query from sql the
entered_dr,entered_cr are equal. But if i run the import process it
errors out saying unbalanced entries and the strange thing is there is
a skip in the je_line_num column. Though physically there were only 59
lines the last line has a line number of 65. I couldn't not find line
no.'s 49,51 and so on. We are in production and this is having a great
impact on us. Any help is greatly appreciated.
Thanks,
Janaki
Date: Tue, 7 Sep 1999 16:39:02 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Journal import erroring out showing unbalanced entries
One suggestion (if you can do this in a test or development instance) would
be to turn on suspense posting so that it will let you import an unbalanced
journal. Then you can view the journal and see all the lines. We had a
similar problem while testing a custom cash receipting system. We would
import 4 lines and the journal import would fail saying there were 7 lines.
But, we could only see 4 lines in the interface table.
Our problem (which I hope is not yours) was that there were multiple ccid's
for the same unique account code combination. These had been accidently
created by some trigger tweaking a consultant had done in our development
instance. We didn't even know they existed. When we imported to that
account code combination it generated 4 lines in the import for the same
account code combination, one for each occurrence of the ccid.
Good luck.
Kathy Farmer
Scott County
Date: Wed, 8 Sep 1999 08:43:16 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Cc: "'Janaki.Yarlagadda@frco.com'" Janaki.Yarlagadda@frco.com
Subject: RE: Journal import erroring out showing unbalanced entries
Can you query the journal entry in the journal entry form? The journal entry
should have a posting status of error. Does it show as an unpostable journal
entry in the journal posting form? If you can query the journal entry, you
should be able to correct it through the journal entry form. You should also
see the blank/missing lines. What release are you on?
HTH,
Stan
Date: Wed, 8 Sep 1999 08:47:18 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Journal import erroring out showing unbalanced entries
One trick I use with JE's that have error'd and won't
post is to query up the JE and simply retype the
description and save. This kicks off the forms
validation routines and sets the JE back to a postable
state. This works best if there was a posting crash
because of space other system level problems.
That said, you should follow Stan's suggestion and
maybe take it one step farther by comparing the SQL
lines to the lines that appear in the JE form. If it
can't be corrected and if you have the original source
available, then delete this batch and re-import it.
Andy Schindler
NRC, Inc
GL Interface reversal Query 2
Date: Tue, 07 Sep 1999 16:38:30 -0400
From: steve_leslie@ninewest.com
To: OraApps-L@cpa.qc.ca
Subject: AR: Reverse GL Interface Process
Hi All,
Our site is 10.7 NCA 16.1 Accounts Receivable.
We ran the G/L Interface in A/R for all our invoices (Import=No, no
journals created). These transactions were defined as Postable to the
GL.
Unfortunately, we can no longer change the Bill To information on our
Open Invoices that were posted to the GL. Quite often our users need
this ability to change the customer on an invoice.
Question: Is there any way to either reverse the G/L Interface
process for these transactions OR is there some way in A/R to solve
the problem.
Thank you for any suggestions you may have...
Date: Wed, 08 Sep 1999 08:20:44 GMT
From: "Sunny Sunny" sunn999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: Reverse GL Interface Process
Hi,
I cannot give u a solution for ur existing problem,probably if u have posted
all the transactions to GL u will not be able to change any information on
the Invoice, u can try for negative adjustments and raising new invoices.
But what u can do in future is have a transaction type defined with "Post to
GL" set to no, and let the user use that particular Transaction type while
entering an invoice,later on when they change the customer information they
can also change the Transaction type name to a Transaction type which allows
posting to GL.
This way the transaction will not be posted to GL and changes are possible
before posting.
Regards,
Date: Wed, 8 Sep 1999 13:17:04 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: AR: Reverse GL Interface Process
There is a process which is not supported by Oracle -- which can reverse
the GL post. I donot recollect the name of the process but support can
give you that and then you can repost.
Madhu Sudan Dada
Date: Thu, 09 Sep 1999 02:06:21 PDT
From: "moses rajasingh" mosesrajasingh@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: Reverse GL Interface Process
Hi
I have faced the same situation, we run the ar-gl interface, when it was in
the interim table, wrongly we deleted it. Now the situation is AR the
records are showing is posted, but that is not in GL.
There is patch ARGCGP.EXE, in the ORACLE METALINK, it is given how to use
this patch, it will reinstate all the records.
regards
moses
Date: Thu, 9 Sep 1999 13:09:02 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: AR: Reverse GL Interface Process
ARGCGP for non NT platforms.
Madhu Sudan Daa
Date: Thu, 09 Sep 1999 20:39:48 PDT
From: "moses rajasingh" mosesrajasingh@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: Reverse GL Interface Process
Hi
This ARGCGP.EXE is running under DOS, because we have NT platforms
moses
Consolidation (SOB) and Business Group
Date: Tue, 7 Sep 1999 07:08:20 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Set Of Books Consolidation!!
All-
The manuals say that the Business Group is an
Organization which represents a consolidated
entity(parent company)and that is where we should
(ideally) consolidate all the set of books.
I am wondering if we can make any organization a
Parent Company without giving actually giving it a
relation (label) of a Business Group and consolidate
other SOB into it. I am also assuming that in Oracle
Apps the consolidation of SOB has nothing to do with
the Org classifications.
Kindly let me know if my assumption is correct or not?
Thank you in advance.
Siddharth
Date: Tue, 7 Sep 1999 16:51:11 -0700 (PDT)
From: DIPANKAR BASU dipankar_99@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Set Of Books Consolidation!!
Hi Siddharth,
From your description, it is not clear whether you are going in for
independant postings in the parent company too. The answer will be
dependant on that.
Date: Mon, 13 Sep 1999 20:12:35 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Set Of Books Consolidation!!
I think there is a slight confusion here from the perspective of Orgs.
The Business Org is an Organization Unit owned and used primarily by the HR
module, it is also used in any of the modules that use Employees - PO, AP,
etc.
The Operating Unit is a an entity that bifurcates the sub-ledger modules.
The Set of Books is the repository that assimilates all the data from the
sub-ledgers, they are however connected in a specific way to the Operating
Unit. However, more than one Operating Unit can interface to a single Set of
Books.
Consolidation is a function of the GL. The consolidation functionality has
nothing to do with the Operating Unit, Business Group, or anything outside
of the GL module.
There is no hard and fast definition of a Parent Set of Books. You can
technically consolidate from any Set of Books to any Set of Books. The Set
of Books consolidate to is the Parent and the other(s) is/are the
Subsidiary.
I hope this clears your doubts and helps you decide how to address the issue
clearly and logically.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: Mon, 13 Sep 1999 22:55:47 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Set Of Books Consolidation!!
Siddarth,
Consolidation is a GL function wherein you can consolidate a parent &
subsidiary set of books and there are no restriction regarding set of books.
Organization is a separate subject which has nothing to do with your
consolidation. The topic on multi-organization in the help will clear your
doubts.
Ravi
Encumbrance process
Date: Tue, 07 Sep 1999 07:26:48 PDT
From: "prince suthakar" prince_sutha@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: ENCUMBRANCE PROBLEM PLEASE HELP IT
Hello Gl and AP gurus,
I have a problem in encumbrance, I have no idea for it, please help it,
If we raise an invoice, Is encumbrance woluld be affect or Not ?
Give me some idea.
TIA
prince
Date: Wed, 8 Sep 1999 10:06:57 +0800
From: "Stankevicius, Jon" Jon.Stankevicius@health.wa.gov.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: ENCUMBRANCE PROBLEM PLEASE HELP IT
Hello Prince Suthakar,
The issue surrounding encumbrances generated from an AP invoices, as I
underrstand is as follows.
If you have purchase order encumbrances enabled, and you are matching your
invoice to this purchase order, then the following will/will have happened.
Firstly, when you raised the purchase order, Purchasing will raise a
purchase order encumbrance. (You can see this entry in GL encumbrances with
the source as 'Purchasing').
When you match the invoice to the purchase order, the Payables module will
create a negative encumbrance to nil out the purchase order encumbrance and
will also at the same time create an 'actual'. You can identify these
entries from the GL as they have the source 'Payables'. In this way, the
encumbrances flow through the system so that at any point in time, the
correct amount of funds are tied up.
If you enter a Payables invoice that is not to be matched to a Purchase
Order (and you have encumbrance accounting enabled), Payables, I think,
creates an encumbrance entry. This is because the Payables process: Payables
Transfer to GL has not been run yet, so there is not yet any 'actual'
expense in the GL. When you eventually submit the Payables Transfer to GL
job, Payables will generate two journals: one is the 'actual' representing
the expense; the other is the negative encumbrance entry nulling out the
original encumbrance raised when you approved the invoice. As you can see,
this process is to cover the gap between when the invoice is entered and
approved to the time the 'actuals' are sent over to GL for the purpose of
making sure that funds have been reserved.
I may have some of this process wrong, but this is the general idea.
A note of caution: Oracle's encumbrance processes are far from reliable and
bug free, as far as I can see. I will provide just one example, but there
are many others.
When matching an invoice to a purchase order, Purchasing creates its
encumbrances line by line, based upon the quantity times unit price. When an
invoice gets matched to this Purchase Order, Payables reverses this
encumbrance. However, it reverses the encumbrance based upon its own
calculation which forces (rounds) the encumbrance to the fixed dollar amount
of the invoice. This may not match the encumbrance raised by the Purchasing
Module, hence you can get residual encumbrance amounts that are the result
of these two different rounding methods.
It is a criticism of Oracle that the Payables does not reverse the
encumbrance in accordance with the way the Purchasing Module created it.
Perhaps Oracle's Purchasing and Payables programmers should get together and
talk to each other about how they are dealing with each other's accounting
entries. After all, Oracle is supposed to be an integrated product.
JonS
Jon STANKEVICIUS
Coordinator Financial Systems
Corporate Finance Branch
Finance and Resource Management Division
HEALTH DEPARTMENT OF WESTERN AUSTRALIA
AUSTRALIA
Tel: +61 8 9222 2315
Fax: +61 8 9222 2259
Email: jon.stankevicius@health.wa.gov.au
Date: Tue, 7 Sep 1999 23:27:19 -0400
From: "Farber, Andy" farban@consumer.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: ENCUMBRANCE PROBLEM PLEASE HELP IT
Two additional comments,
1. Even if your invoices are matched to purchase orders, they still create
invoice encumbrances. The PO encumbrance is reversed, and the Invoice
encumbrance is created; the invoice encumbrance is reversed when the GL Post
is run from payables, which creates and reserves the actual. (Even if the
actual is not posted immediately, the journal entry is marked as PASSED
funds checking, and the funds are reserved in a temp table, BL_BC_PACKETS.)
2. While still buggy (we're on Rel 10.7 Char), I have not seen errors in how
the AP encumbrance is calculated. The PO encumbrance is reversed properly,
based on the PO amount matched, times the PO price. The Invoice encumbrance
is the AP quantity times the AP price. The confusion may come from
differences in the price and quantity; if there is a price change, there are
two actuals - one for the PO quantity/price, and a second for the net of the
PO quantity/price and the AP quantity/price.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
Date: Wed, 8 Sep 1999 08:39:05 -0400
From: Carolyn DeSimone cdesimone@goaa.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Cc: "'Jon.Stankevicius@health.wa.gov.au'"
Subject: Re: ENCUMBRANCE PROBLEM PLEASE HELP IT
Question: If the ordered, received and invoiced quantity match (3-way) and
the "final match" is activated doesn't the residual encumbrance amount
credit the distribution account of the purchase order? If final match is
not activated does the amount hit an accrual account, or is it still
encumbered by the PO?
I'm on the purchasing side of the system and am trying to figure out how we
are going to deal with open purchase orders as we close our out our year.
Regards,
Carolyn DeSimone
Purchasing Systems
Administration
407-825-2028
page: 570-9439
email: cdesimone@goaa.org
Journal Import - Duplicate CCIDs
Date: Wed, 8 Sep 1999 09:08:34 -0500
From: Janaki.Yarlagadda@frco.com
To: " - *oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: duplicate code combinations
Hi All,
We were trying to import journals from legacy. and when we are doing
that one of the segment combination is found to have multiple ccid's
and the system is identifying them as 2 i.e. inspite of 6 lines it is
creating 12 lines and as the result we are having an increase in the
debits and import process is erroring out with out of balance problem.
Can any one suggest us how to take care of the problem to eliminate
duplicate ccids? Disabling the other ccid is not fetching any result.
Any suggestions are greatly appreciated.
Thanks,
Janaki
Date: Wed, 8 Sep 1999 17:48:14 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: duplicate code combinations
I am sorry to hear that you do seem to have the same problem we had! In our
case we were fortunate to be in our development instance which we refresh
regularly from our production instance. Before we decided to refresh our
multiple ccid for single combination instance we discussed fixing the
problem. The only solution we came up with would be to hit this at the
table level with SQL. I don't think you'd want to attempt this without
calling Oracle Support.
Also, do you know how these multiple ccid's were created so that no
additional problems will be created? As part of your legacy import are you
trying to create ccid's during the import process? That would be similar to
the trigger we had tried that caused this problem on our system.
Kathy Farmer
Scott County
Query Account - Sort on Segment
Date: Wed, 8 Sep 1999 17:33:32 +0200
From: sebastien.herpin@clf-dexia.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: GL: form Query account
Hi Friends,
In the form 'Query account', GL retrieve accounts sorted by ccid.
Is it possible to sort them by segments ?
Thanks.
Exchange Rate and Type - Automate/default
Date: Thu, 9 Sep 1999 09:21:57 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: AP: Entering Foreign Currency Invoices Question!
All--
My client is interested in automating/defaulting the
Exchange Rate Type and Rate based on the Invoice Date
and the Supplier Info. They find it to be an
additional step when entering foreign currency
invoices. Is there some profile option that can do it
or is it a customization?
There is profile option "Dual Currency Exchange Rate
Type". We tried to set that up as Corporate at the
Responsibility level but it did not help us. What does
this profile option do?
Kindly help.
Thank you in advance.
Siddharth Shah
Date: Thu, 9 Sep 1999 10:58:36 -0600
From: Brenda.Karran@cnpl.enbridge.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP: Entering Foreign Currency Invoices Question!
There is an option under AP Setup/Options/Payables under the Currencies tab
to
set the default rate type to spot.
Date: Thu, 09 Sep 1999 13:37:55 PDT
From: "Harish K" har23@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP: Entering Foreign Currency Invoices Question!
Siddharth:
Ths default type comes from your system options form. So this is the
default exchange rate type for all foreign currency transactions and not
limited to any supplier.
The profile option is only when using Dual Currency, you can either specify
a transaction rate for each transaction or use the daily rate associated
with the transaction date. This profile option specifies the default
currency conversion type Journal Import should use to determine the daily
rate if you do not enter a transaction rate.
-Harish
Date: Thu, 09 Sep 1999 23:09:58 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP: Entering Foreign Currency Invoices Question!
siddarth,
AP allows the booking and payment of foreign currency invoices. At the time
of boking the invoice you have to specify the exchange rate and at the time
of payment you have to again specify the exchange rate. The rate may be
corporate, spot or user defined. Any procedure different from this will
invole customization.
Ravi