Autoinvoice sans Autoaccounting Rules
Date: Fri, 3 Sep 1999 12:21:24 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: OraApps-L@cpa.qc.ca
Cc: ajaya@buy.com
Subject: AutoInvoice problem
I am importing invoices on Rel 11. Auto accounting rules are not being used for any of the
batch sources. If I am not using auto accounting rules, then How do I handle
RA_INTERFACE_DISTRIBUTIONS
Thx in Advance
Ajay
Date: Sat, 4 Sep 1999 16:27:20 +0530
From: Sridhar Sridhar@sierraopt.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AutoInvoice problem
If you are not using Auto accounting for Invoice . You can pass Account
information to which this transaction belongs to in
RA_INTERFACE_DISTRIBUTIONS_ALL table. You Should pass Accounting class
,Amount or Percent ,combination Code id or Segment1-30 and Line
transaction flex to which this transaction belongs to information in
RA_INTERFACE_DISTRIBUTIONS_ALL .
Date: Tue, 7 Sep 1999 09:57:08 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AutoInvoice problem
Sridhar,
In the RA_INTERFACE_DISTRIBUTIONS_ALL table, do we need to have 2
entries per line in the RA_INTERFACE_LINES_ALL table ? How do I do the
debit and credit part of the transaction, Since one record can have
just one amount field in the RA_INTERFACE_DISTRIBUTIONS_ALL table
TIA
Ajay
Date: Wed, 8 Sep 1999 08:29:44 +0530
From: "BAGAVATHI RAJAN K" rajankb@wipsys.soft.net
To: oraapps-l@cpa.qc.ca
Subject: RE: AutoInvoice problem
Hi Ajay,
For every line in RA_INTERFACE_LINES_ALL, there will be one line in
RA_INTERFACE_DISTRIBUTIONS_ALL with account_class as 'REV' or 'TAX'. This
is the credit part. For the debit part, there will be one line per invoice
in RA_INTERFACE_DISTRIBUTIONS_ALL table with account_class as 'REC'.
For examble, consider 3 lines in RA_INTERFACE_LINES_ALL table for an
invoice.
Revenue line1 amount:$1000
Revenue line2 amount:$500
Revenue line3 amount:$200
RA_INTERFACE_DISTRIBUTIONS_ALL will have 4 lines as shown below.
Amount: $1700 Account_Class:REC Account:Receivables Account (or Debit
Account)
Amount: $1000 Account_Class:REV Account:Revenue Account1
Amount: $500 Account_Class:REV Account:Revenue Account2
Amount: $200 Account_Class:REV Account:Revenue Account3
Hope This helps you.
Regards,
K.Bagavthi Rajan.
Date: Wed, 8 Sep 1999 09:51:16 +0530
From: Sridhar Sridhar@sierraopt.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AutoInvoice problem
Ajay,
You can have one or more lines for one line in ra_interface_lines_all
table .The sum of amount in all distributions lines should be equal to
amount of lines.
You can differentiate debit and credit part of transaction using
Account_class column in Distributions table .
TIA
Sridhar
Date: Wed, 8 Sep 1999 10:21:10 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AutoInvoice problem
Hi
You require only 1 line per transaction in RA_INTERFACE_DISTRIBUTIONS_ALL.
The account code you supply is for revenue. The respective customer account
will be the receivable. Hope this clarifies.
Regards
Date: Wed, 8 Sep 1999 17:26:04 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AutoInvoice problem
I am trying to import 2 invoices. I have 4 lines in the
RA_INTERFACE_DISTRIBUTIONS_ALL table.
(2 lines/invoice) One line with account class of 'REC' and another line
with account class 'REV' for
Debit and Credit accordingly.
Now I receive the following error
You can supply at most one Receivables account for a transaction (an
invoice, a debit memo or a credit memo)
I quite dont understand this message. Any help?
TIA
Ajay
Date: Wed, 8 Sep 1999 17:40:24 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AutoInvoice problem
look at your line in the ra_interface_distributions_all table and make sure
that the code_combination_id you supply is the same and correct for
all of your distribution lines.
Date: Thu, 9 Sep 1999 08:21:35 +0530
From: "BAGAVATHI RAJAN K" rajankb@wipsys.soft.net
To: oraapps-l@cpa.qc.ca
Subject: RE: AutoInvoice problem
Hi Ajay,
Sometime back, a problem with the same error message was posted to this
list. In that case, there were more than one line in
RA_INTERFACE_DISTRIBUTIONS_ALL with account_class as 'REC' for an invoice.
In your case, you have only two lines in this table with account_class as
'REC'. So, i think you haven't linked the lines with account_class as 'REC'
to the appropriate invoice & hence, the system might be considering the two
lines for the same invoice. Check it.
K.Bagavathi Rajan.
APP-11526 error
Date: Fri, 3 Sep 1999 14:26:25 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: OraApps-L@cpa.qc.ca
Subject: Autoinvoice Import - Release 11.02
I am trying to import invoices and I receive the following error
APP-11526 : 0
arcsai() Not all AutoAccounting Types are defined
Error calling acrcsdu_do_setup()
Error calling raaini()
Is this a Rel 11 thing or a data problem ?
TIA
Ajay
Date: Fri, 3 Sep 1999 18:04:14 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: Autoinvoice Import - Release 11.02
Receivables Account.
Date: Fri, 3 Sep 1999 16:20:13 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Autoinvoice Import - Release 11.02
Madhu,
Do you mean that Receivables Account for AutoAccounting is not OK.
It is set up as
Company
Department
Account
Product Line
Location
all coming from the Transaction Types table
Ajay
Date: Sat, 4 Sep 1999 08:59:58 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Autoinvoice Import - Release 11.02
Just a thought? Have you set-up the necessary autoaccounting types in Receivables?
Revenue, Receivable, Freight, etc. -- whatever the types being imported?
Regards
Date: Sun, 5 Sep 1999 09:17:30 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: Autoinvoice Import - Release 11.02
Hi,
You should have setup 7 types in Auto-accounting.
Autoinvoice clearing, Freight, Receivable, Tax,
Revenue, Unbilled Receivable and Unearned Revenue.
You should not have setup 'Rounding Distribution',
though it comes up in the LOV when you setup
Autoaccounting. If you have, delete it.
You will get this message if you have not setup the 7
types mentioned above OR if you've setup the rounding
thing.
I guess this rounding account is related to
Header-level rounding functionality introduced in
11.x, but Autoinvoice code has not been revised to use
this account.
Hope this helps,
Murali
Patchset R FRM-4o735 and 4o815 errors
Date: Tue, 7 Sep 1999 08:36:36 -0700 (PDT)
From: Mark Myszkowski myszko@yahoo.com
To: OraApps-L@cpa.qc.ca
Subject: Problems with AR patchset
We're on 10.7 NCA NT 7.3.4.4. We've just applied AR patchset R
(818461, 818459). Now when we go into Receivables Manager GUI Set Up
- System - System Options we get the following errors:
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception
ORA-665500.
FRM-40815: Variable GLOBAL.system_options does not exist.
The system options form itself is blank for all alternative regions!
I've opened a TAR with support last week but would appreciate any
thoughts from the forum. (We did apply level P first, I don't know if
this issue was caused by P or R).
TIA
Mark Myszkowski
Entre Computer Center
Brookfield, WI USA
(414) 938-2139 x3129
(414) 938-2155 (fax)
Date: Tue, 7 Sep 1999 16:46:50 -0700 (PDT)
From: DIPANKAR BASU dipankar_99@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Problems with AR patchset
The best option for you will be to go to 7.3.4.0.0 sc 161, as it is
timetested with patchset R. Your support requests will be processed
faster as it will be in tandem with Oracle Support.
Date: Thu, 9 Sep 1999 07:13:01 -0700 (PDT)
From: Mark Myszkowski myszko@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Problems with AR patchset
In case anyone is interested, the error I reported below (above) was caused by
an incompatible version of globe.pll (v76.10). I knew I could get the
correct version (v76.14) from AP T so I applied that first and then the
AR patches. I also had to apply 730116 before the tax location flex
fields could be recompiled. (Thank you OWS!)
Discount for Open Item
Date: 7 Sep 99 14:54:51 MDT
From: vv vv venvivek@usa.net
To: Submit Question oraapps-l@cpa.qc.ca
Subject: URGENT : AR : To Calulate Discount for the AR Open item.
Hi Guys.
In vanilla Oracle when U go to the receipt screen - line items on just by
pressing the tab from the amount applied field the Oracle calculates the
discount amount for U based upon the customer setting.
My concern is how oracle calulates the discount amount.
I have open the form arxrwmai.fmb and gone through the script, the when
validate item calls the lib routine
"arp_app_folder_item.amount_applied_dsp_hook" and it further calls the lib
routine "arp_app_folder_item2.discount_dsp" here the oracle calculates the
discount, the requirement is to arrive the discount in my custom procedure how
can i get the discount amount in a variable from this lib routine.
Any help will be appriciated.
Regards.
Vivek.
Credit Memo Import through Autoinvoice
Date: Tue, 7 Sep 1999 16:26:39 -0500
From: "Brewster, Joel" Joel.Brewster@infoUSA.com
To: "Oracle Applications Forum (E-mail)" OraApps-L@cpa.qc.ca
Subject: AR: Problem Importing a Credit Memo Through AutoInvoice Program
Hello All,
We are experiencing a strange problem when atttempting to import a credit
memo via the AutoInvoice program. The concurrent manager will successfully
complete when a term_id is supplied. However, the AutoInvoice Execution
Report/ AutoInvoice Validation Report indicates that the record was rejected
because "You cannot supply payment terms for your credit memo transaction.".
I then set the term_id null in the interface table and run the AutoInvoice
program again. This time the concurrent manager will abruptly abort and the
AutoInvoice Execution Report/ AutoInvoice Validation Report does not even
get generated. Is anyone aware of whether this is a known bug in the
AutoInvoice program or have a solution to the problem? Any help would be
much appreciated.
TIA,
Joel Brewster
InfoUSA
joel.brewster@infousa.com
Date: Tue, 7 Sep 1999 15:32:17 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Problem Importing a Credit Memo Through AutoInvoice Program
Did you verify that the invoice you are crediting is imported? I have
gotten
this
error when the invoice I am attempting to credit has not yet been imported.
Date: Wed, 8 Sep 1999 10:34:18 +0530
From: Sridhar Sridhar@sierraopt.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Problem Importing a Credit Memo Through AutoInvoice Program
hai Joel,
We are also facing same problem while importing Credit Memo through
Autoinvoice Interface. If you are running Database Ver is 7.4 then there
is patch for this. We could not test this as we are running on 7.3.3.
Keep us updated with your progress in importing Credit Memo .
TIA
Sridhar
Date: Wed, 8 Sep 1999 09:20:52 -0500
From: "Brewster, Joel" Joel.Brewster@infoUSA.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Problem Importing a Credit Memo Through AutoInvoice Program
Tom,
Thanks for your response. I have tried to import the credit memo with and
without the invoice I am attempting to credit. Neither effort completed
successfully. If you come across any other ideas, I'd like to hear them.
Thanks,
Joel
Date: Wed, 8 Sep 1999 08:21:17 -0700 (PDT)
From: Liyakath Ali liyakath777@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Problem Importing a Credit Memo Through AutoInvoice Program
Hi,
Check the setup of the batch source. Go to Accounting Information
Screen , If you selected payment term as ID change it to VALUE.
I hope it works.
Regards,
Mohammed Liyakath
Customer - shifting among Orgs
Date: Tue, 7 Sep 1999 22:43:12 -0400
From: "Mohammed, Wahed" Wahed.Mohammed@cognos.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AR Customer Details shifting among Orgs
Hi All,
Our Environment
10.7 NCA
Unix 2.5.1
Multi-Org OE / AR / GL / AP
We are in the process of moving / duplicating customer data from
one Org to another, as new Orgs are created. Any input ( Scripts / Special
considerations ) on this is appreciated.
Thanks in advance.
Wahed.
Date: Wed, 8 Sep 1999 11:02:52 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AR Customer Details shifting among Orgs
Since you do not mention of any legacy system, the new customer data has to
be collected from the manual processes, tabulated and then imported, maybe
using the Customer Interface. Obviously, you would not want to have the
identical address/contact/phones information in all of your organizations.
If any customers are existing in any of the Organizations already created,
then such customers should not be created. Instead you should take
RA_CUSTOMERS.ORIGINAL_SYSTEM_REFERENCE from the database and use it as a
reference to import the addresses, contacts and/or phones information.
If it will be of any help, I am pasting here some guidelines for importing
customers. In case you decide to use this it may be necessary to add/delete
some of the fields as per your own requirements. Note however that some of
the fields are mandatory.
Please click here for the guidelines
Invoice - Mass Complete thru PL/SQL
Date: Wed, 8 Sep 1999 10:46:45 -0700
From: "Alim, Sukma (salim)" salim@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AR::Mass completing invoices
Hi all,
I am working on a customization request to mass complete AR invoices
programmatically using PL/SQL package. I found Oracle's package that
validates the invoice before it complete the invoice but I can't find how
Oracle
1) creates payment schedules and
2) includes the invoice in the standard aging and collection process.
I am not sure if Oracle does these with Pro*C or PL/SQL. Does anyone have
any experience that you can share regarding this or know of the package name
that Oracle uses to do the above 2 tasks?
Thank you, I really appreciate any help on this.
Regards,
Sukma
Date: Wed, 8 Sep 1999 16:59:29 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: AR::Mass completing invoices
I was wondering I have seen a lot about data load which does some data
pumping to forms. I have nto tested anything but was thinking .. is it
possible to pump completion info to a form and complete invoices .. that
will reduce all customization headache.
Madhu Sudan Dada
Date: Thu, 9 Sep 1999 11:04:16 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AR::Mass completing invoices
If you are in character you could trying pasting from Excel. I have seen it
work and it is fantastic. Of course, building the first sheet is tricky and
needs quite a bit of trial and error.
Regards
Date: Thu, 9 Sep 1999 01:40:05 -0700
From: "Shenker, Adam" Adam.Shenker@Aspect.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AR::Mass completing invoices
I have actually done this for sun in Holland.
What you can do in the spreadsheet is set up all the typed commands that you
would use into the spreadsheet (A tab would be the next cell)
Hide all comands from the user and request that they type in any data that
they require in spreadsheet cells in the correct position.
We then set up a button in the spreadsheet and this copied all the data into
the buffer.
At this point you just place the cursor in the correct place within
Applications and paste the macro.
Simple and effective.
Credit Memo - Amount Doubles
Date: Wed, 8 Sep 1999 16:21:55 -0700
From: Karen Blackwell KBlackwell@rockshox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AR: Credit Memo doubles $$, now we cannot close month end
Environment:
10.7NCA
7.3.3.6
Solaris 2.6
We have a Credit Memo which has caused us no end of grief. And OWWS is
sending us in circles.
The CM is related to an RMA which was a copy of a Sales order. The CM
checks out in the apps; the customer account shows OK (the CM is applied).
It has posted to the GL. However, it is showing up on the Unposted Items
report, which is disallowing us to close. Additionally, the amount listed
on the Unposted Items report is DOUBLE the original CM amount.
Most of the tables check out OK. Until we get to
AR_RECEIVABLE_APPLICATIONS_ALL table -- this is listing the amount as
doubled. Also, we do not have any related entries in the
ar_receivable_applications and ar_payment_schedules tables. (I am not
positive this is relevant, but it is one direction OWWS pointed us.)
If anyone out there has seen such a mess, any guidance or clues would be
great. I have searched Metalink 2.0, but am seriously considering looking
at the old one too.
Thanks in advance....
Date: Thu, 9 Sep 1999 13:01:48 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: AR: Credit Memo doubles $$, now we cannot close month end
OWWS should be able to fix it. They do have some smart people and
otherwise also it should not be tough fix. If you want me to help,
email me and I think I can help on fixing this. Give the fix to support
and ask them to bless it.
Madhu Sudan Dada
Date: Thu, 9 Sep 1999 11:12:53 -0700 (PDT)
From: matthew parker mr_yerdel@yahoo.com
To: oraapps-l@cpa.qc.ca
Cc: KBlackwell@rockshox.com, torth@sequent.com
Subject: Re: AR: Credit Memo doubles $$, now we cannot close month end
I spent the last 9 months with Oracle AR development dialed into our
system and working with OWWS and Oracle consulting along with sending a
complete copy of our database to Oracle AR development.
Initially we had the same problem with not getting an appropriate
response (as perceived by our management) from OWWS. It required our VP
to apply pressure to Oracle along with bringing in Oracle consulting to
get results. We then had Bo Lin from OWWS onsite for a week along with
having Cathy Lavender (the most SR. AR Analyst from the BDE group who
wrote the internal white paper on corruption in AR and their fixes).
The first thing to ask though is what patch set are you on. The latest
patch set released this week (AR S megapatch) is considered the nirvana
for AR. This patch set has the final fixes to the wide range of
corruptions that we worked through with Oracle AR development. (No
guarantees that it fixes everything, but with the 58,000-invoices/
235,000 lines we processed a day along with 1100 corrections per day we
hit more than our share of AR corruption bugs, See below).
As to your unposted item problems, we had a variety of unposted item
problems: currency error on the balance screen, Partial Canadian
entry, with no effective date, Item will not display in the apps, The
accounted amount and amount are not the same in AR_ADJUSTMENTS,
mismatched gl_dates, This CAD Credit Memo has been applied to USD
Invoice, amount != acctd_amount in GL_DIST, credit memos across closed
periods, invoices and receipts off by a penny, etc.
Each one of these required Oracle AR development to dial in and fix
them. Oracle AR development has a set of scripts for unposted items:
ard.sql, crh.sql, cr.sql, dist.sql, and trx.sql. There is also a set of
scripts in OWWS to find all information relating to a particular
invoice by Bryan Hodges: ar_invoice_info_107.sql, ar_cm_info_107.sql,
ar_cash_info_107.sql.
As to your comment in the previous email that your problem might not be
like Tom's because he is on a different version, when the developer
would come up with a fix for 10.7 he was porting that fix to 11i.
Apparently not all code was rewritten in 11i.
Below are AR Corruption issues and the related TARS and or BUG numbers
for us. This will make it easier for you to request information from
OWWS as to specific bugs for them to reference and the scripts they
have for these issues. At the end of the 9 month period we had a multi
script set that Oracle AR development was having us run on any long
weekends that we had available to us. Initially the scripts took 51
hours and now only take 36 hours. These scripts (Section A below) have
all the AR corruption issue diagnostics and fixes built in. They don't
have a name yet but the developer has turned them over to OWWS. The
developer also is responsible for all issues relating to AR corruption
and continuously updates these scripts as new issues arise. These
scripts are suppose to be able to be used against 10.7, 11.0, and 11i.
Also included with the scripts were new reconciliation reports that
helps the financial users a lot. You will have to get them from
development as they are only porting them to 11i.
Please click here
for the TARS and BUGS issues