Statements with only Non Zero values
From:
Stephen.Solomon@rac.com.au
10/14/99 5:15 AM
Subject:
[orafin] AR: Statements with zero value
To:
orafin@mail-list.com
Hi all,
When we run out statements for our various transactions types there are
always a significant number of suppliers that have a zero balance but a
statement is printed anyway. Is there an option that will enable you only to
print statements for customers with a balance greater than 0.
Thanks
Stephen
Stephen Solomon
Systems Accountant
RAC Group
Phone: +61 8 9421 4394
Fax: +61 8 9421 4545
Email: Stephen.Solomon@rac.com.au
Interface to legacy system in Oracle not working
Date: Sun, 03 Oct 1999 16:52:49 GMT
From: "DEBBY BROWN" debbiedarl@hotmail.com
To: OraApps-L@cpa.qc.ca
Subject: PROBLEM IN AR INTERFACE
I am trying to interfacemy existing system (In Oracle) to OF. I am creating
a database link and by a public synonym I am able to populate the Interface
table for Customer Interface and Auto Invoice. But when I run Customer
Interface or Autoinvoice Program it rejects all the lines. I checked all
available report and screen but though the records are diplayed there the
Error message field is empty. It does not show any error messages. When some
error like wrong memo_line name, etc where made it showed the errors. So
what might be these error which does not show any error message. PLEASE
Somebody help. I Have a dead line to meet.
In autoinvoice when I query the exceptions screen, in the invaild value
field it shows value as '(nil)'. Please do Help.
Debbie
Date: Thu, 14 Oct 1999 23:56:59 -0600
From: Amber Allen-Sauer amber@allen-sauer.com
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: RE: PROBLEM IN AR INTERFACE
Debbie,
First you will need to successfully load your customers before you can
interface invoices for them. There are lots of things that could be
wrong here, but first some more details: Does the concurrent program
error or complete normal. What does the Customer Interface output say?
It should say:
Total Records: x
Inserted Records: x
Updated Records: x
Exception Records: x
Then below the summary will be your specific error messages. Have you
followed the required setup in the Open Interfaces Manual? Also What
version are you on 10.7 or 11x?
I just got both Customer Interface and Autoinvoice working in 11.0.3 and
it took a couple of patches to get them there, but I had specific
errors. I would suggest starting with something very easy, like update
an existing customer's name or address, then insert 1 new customer, etc.
Amber
Allen-Sauer Consulting, Inc.
Autoinvoice - Batch creation - control over
Date: Tue, 5 Oct 1999 09:25:18 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Invoice Import - Autoinvoice problem
Hi,
I am running into this problem, where everytime I run
AutoInvoice program it creates batches in Oracle even
though the program has not imported any invoices. The
batch will have 0 invoices in it. Is this connected to
any profile option or any other setup? I am working on
Apps Rel 11.03 The Batch source I have chosen has Auto
Batch numbering turned off.
How do I create batches with my own numbers for any
given batch source ? Which columns should be populated
in RA_INTERFACE_LINES_ALL table ?
Thanks
A
ar_location_rates - delete values
Date: Fri, 01 Oct 1999 09:57:44 -0700
From: "Raman Anand" Raman.Anand@xylan.com
To: oraapps-l@cpa.qc.ca
Subject: Sales tax Question
Hello All,
we are intergrating vertex with applications 11.0.3.Can we
delete the values from the AR_LOCATION_RATES
table so that we can upload new values for tax rates and zipcodes
provided by Vertex?We are having problems with
updating the existing records using the Sales Tax Interface Program.Most
of the records are not geting updated to the
correct tax rate and zip code.So,we thought of deleting the records from
the AR_LOCATION_RATES table and bring
in new records through the interface.Does deleting the records from
AR_LOCATION_RATES table affect the
current transactions in the system?
Your help will be greatly appreciated.
Thank You
Raman
Date: Fri, 15 Oct 1999 08:34:43 -0500
From: "Barry Hammon" barry.hammon@wwt.com
To: oraapps-l@cpa.qc.ca, Raman.Anand@xylan.com
Subject: Re: Sales tax Question
Hello Raman,
I implemented Vertex for a client who had been using Oracle Applications
in a production environment for approximately one year. The problem with
deleting the data from the AR_LOCATION_RATES table is that it is linked to
data in the following tables: RA_ADDRESSES_ALL, AR_LOCATION_VALUES,
AR_LOCATION_COMBINATIONS, RA_TAX_EXEMPTIONS_ALL, and RA_ITEM_EXCEPTION_RATES.
Please let me know if you are interested in additional details.
Thanks,
Barry L. Hammon - Senior Consultant
World Wide Technology, Inc.
62 Weldon Parkway
Maryland Heights, MO 63043
Phone: (314) 919-1531; Fax: (314) 919-1626; Pager (314) 419-2746
Toll Free: (800) 432-7008, Ext. 1531
Debit Memo - associate Trx No to
Date: Fri, 1 Oct 1999 16:20:44 -0400
From: Dinesh Makked dmakked@deltadentalva.com
To: "'Oraapps'" oraapps-l@cpa.qc.ca
Subject: AR Question!
Could someone please tell me how to associate transaction number to a debit
memo.
Thanks
Customer Interface for Multiple Orgs
Date: Thu, 07 Oct 1999 11:15:31 GMT
From: "Sanjay Sharma" mrsanjays@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Customer Interface for Multiple Orgs
Hi,
I am trying to import customer information from Legacy systems to a new
installation of APPS. The interface data contains 2 lines that refer to a
particular customer 'ABC' and each of these lines is linked to different
organizations. The Site use is 'BILL_TO' in both cases. Theoritically, the
system should accept this data and create one customer 'ABC' and two
different addresses which correspond to the organization specified. But in
reality, it doesnt seem to do so.
The interface program throws out an error as follows:
**********************************************************************
APP-15449 This customer reference has two identical primary site uses
defined
**********************************************************************
Is this interface not equipped to handle multi org data? If anybody has a
clue to this, pl reply.
Thanks in advance.
Regards,
Nagendra
Date: Fri, 15 Oct 1999 11:28:33 -0500
From: Eric Wu ezw@panduit.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Customer Interface for Multiple Orgs
Hi,
You can try just use primary site =N,or
interface one org once.
Eric
From: guy munte [SMTP:guy_munte@hotmail.com]
Sent: ? 18 ??????? 1999 11:33
To: brnimrod@pcit-ltd.co.il
Subject: Re: FW: Customer Interface for Multiple Orgs
Hi
your problem is that you are trying to interface tow different org's at
once. if you are working in multi-org (and I believe you do because I ran
into the same error message one) you must load the interface once for one
organization, run the import from that organization and after you are
finished, run the interface for the anther organization in an insert mode
for
address because the customer is already there (it has no org_id in it).
Shawish
Receivable Interface error in processing linked list
Date: Mon, 18 Oct 1999 08:13:46 -0700 (PDT)
From: "Jay P." jpmrp@yahoo.com
To: OraApps Oracle "Mail Questions" OraApps-L@cpa.qc.ca
Subject: AR:Receivables Interface Errors out
All;
Our Receivables interface errors out every night, but does process
records, the error in the request log on the last page is as follows;
***Finished Receivables Interface ***
Current system time is 17-OCT-1999 22:16:00
Completed socfre
Exiting OEIIRA normally
Current system time is 17-OCT-1999 22:16:00
Error in processing linked list
Successfully resubmitted concurrent program OEIIRA with request ID
123456 to start at 18-OCT-1999 22:00:00
+--------------------------------------------
Does anyone know what the processing linked list is and why it errors
out.
Thanks in advance for your help.
Jay
Date: Mon, 18 Oct 1999 10:16:45 -0500
From: Kim Bauman kbauman@midcom-inc.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Receivables Interface Errors out
What version are you running of Oracle Applications? We are running 11.02
and have experienced this problem since going live.
The problem we have is if no parameters are entered. If you run the
Receivables Interface with parameters it does not end in error. I have
support working on getting a patch to resolve this problem.
Thanks
Kim Bauman
Oracle HD Administrator
ANZA Inc.
Date: Mon, 18 Oct 1999 08:35:30 -0700 (PDT)
From: "Jay P." jpmrp@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Receivables Interface Errors out
We are on 10.7 Smart Client, the only parameter we pass is OE
Standard
Thanks
Jay
Finance Charges how calculated
Date: Tue, 19 Oct 1999 06:56:06 -0700 (PDT)
From: jay kapadia jkpd2000@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: AR: Finance Charges
hi,
does any one know in which table,column the calculated
finance chages are kept.
i think our system is not calculating finance charges
can any one help ?
thanks
j.kpd
Date: Tue, 19 Oct 1999 16:28:55 +0200
From: "Sridhar RAO" sridhar_rao@salomon-sports.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: Finance Charges
Hi jay,
I have some knowledge about the finance charges calculated while
printing the customer statements. As soon as you commit on the screen to
print the customer statements a concurrent program is launched. This
runs a report ARXSGPO.rdf.
The program uses two standard tables to store the statement information
temporarily, namely
AR_STATEMENT_HEADERS and
AR_STATEMENT_LINE_CLUSTERS
AR_STATEMENT_HEADERS as the name suggests stores the summary information
for every customer transaction. The field FINANCE_CHARGES in this table
gives you the finance charges for a customer. This table joins with
AR_STATEMENT_LINE_CLUSTERS using the column LINE_CLUSTER_ID.
In AR_STATEMENT_LINE_CLUSTERS all the activity against an invoice can be
found. INVOICE_NUMBER identifies the trx number. TRX_ORDER_SEQUENCE and
TRANSACTION_CODE are the key fields in this table that identify the type
of transaction (PMT, INV, CM etc.)
The data in these tables is purged at the end of the concurrent program
for printing the statements. One work around to see the data is to abort
the process in the middle or modify the report ARXSGPO.rdf to avoid
purging.
Hope this helps
- sridhar
Date: Tue, 19 Oct 1999 22:01:25 -0400
From: Steve Harper steve.harper@pragmatek.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Finance Charges
Whether or not finance charges are calculated is controlled by Profile
Class region in the Customer Profile attached to the customer. This
setting (like all Customer Profile settings) can be overridden for a
specific customer.
Steve Harper
PRAGMATEK Consulting Group, Ltd.
Credit Memo - Invoice No where stored
Date: Wed, 20 Oct 1999 10:10:06 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AR: Credit Memo
Hi all,
If a credit memo is created against an invoice, I want to know in which
column
the invoice number is stored for that credit memo?
I know it is a simple question. But I am new to AR.
Thanks
Kiran
Date: Wed, 20 Oct 1999 17:12:34 +0200
From: "Sridhar RAO" sridhar_rao@salomon-sports.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: Credit Memo
Hi Kiran,
All application information can be obtained from the table
AR_RECEIVABLE_APPLICATIONS_ALL. The key fields in this table are
CASH_RECEIPT_ID --from AR_CASH_RECEIPTS_ALL
CUSTOMER_TRX_ID, APPLIED_CUSTOMER_TRX_ID -- from RA_CUSTOMER_TRX_ALL
PAYMENT_SCHEDULE_ID, APPLIED_PAYMENT_SCHEDULE_ID -- from
AR_PAYMENT_SCHEDULES_ALL
e.g. :
-----
1. CM Application
If a credit memo CM01(Payment Schedule ID = 1000) is applied to an invoice
INV01( Payment Schedule ID = 1001) then the corresponding rows in
AR_RECEIVABLE_APPLICATIONS_ALL can be obtained by querying on :
PAYMENT_SCHEDULE_ID = 1000( of the Credit Memo) and
APPLIED_PAYMENT_SCHEDULE_ID = 1001( of the invoice to which the CM has been
applied)
2. Receipt Application
If a receipt REC01(CASH_RECEIPT_ID = 1) is applied to an invoice INV02(
Payment Schedule ID = 1002) then the corresponding rows in
AR_RECEIVABLE_APPLICATIONS_ALL can be obtained by querying on :
CASH_RECEIPT_ID = 1 and
APPLIED_PAYMENT_SCHEDULE_ID = 1002( of the invoice to which the receipt has
been applied). If the receipt is applied to more than one invoice just
query on CASH_RECEIPT_ID = 1
To understand the table AR_RECEIVABLE_APPLICATIONS_ALL read the information
given in the Technical Reference Manual for AR.
Just FYI, try this SQL if you want to find out the transactions to which a
credit memo has been applied.
select trx_number, class
from ar_payment_schedules_all
where payment_schedule_id in
(
select ara.applied_payment_schedule_id
from ar_receivable_applications_all ara, ar_payment_schedules_all aps
where ara.payment_schedule_id = aps.payment_schedule_id
and aps.trx_number = Credit Memo Number
and class = 'CM'
)
- sridhar
Date: Wed, 20 Oct 1999 20:13:20 GMT
From: "Titanic Iceberg" yaoliu@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: Credit Memo
select trx_number from ra_customer_trx
where customer_trx_id =
(select previous_customer_trx_id from ra_customer_trx
where trx_number = CM #)
Receipts not being posted
Date: Wed, 20 Oct 1999 17:57:44 +0200
From: "Sridhar RAO" sridhar_rao@salomon-sports.com
Subject: Problem in transfer from AR to GL
Hi,
We are facing some problems in transferring entries from AR to GL.
We did the following
- Created a Receipt Batch
- Many receipts created manually under the batch. Almost all the
receipts are unapplied. Only 3 of them are unidentified.
The problem :
After transferring the entries from AR to GL(Journal Import) for the
period OCT-99 all the receipts created above appeared in the Unposted
Transactions report. This report gave a message in the end :
"This receipt is part of an unposted quick cash batch."
What could be the reason for this?
Thanks in advance
sridhar
Date: Wed, 20 Oct 1999 11:21:00 -0700
From: Tina.Thousand@weac.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Problem in transfer from AR to GL
If the batch type is Manual-Quick, then you are using QuickCash
functionality
for your receipts batch which requires an additional step - Post QuickCash
before the receipts actually update customer accounts & before they can be
posted to the GL. Hope that helps!
Tina Thousand
Ernst & Young, LLP
Date: Wed, 20 Oct 1999 13:49:47 -0500
From: "Severtson, Anne" amsevertson@sbec.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Problem in transfer from AR to GL
The post quick cash message can be misleading. It can also mean that
the journal entry you are trying to create does not balance in the current
month.
Autoinvoice - Tables to fill for interface
From: Manjula Muthukumar [SMTP:m_manjula@oracleassist.com]
Sent: Thursday, October 21, 1999 12:14 PM
To: Multiple recipients of list
Subject: AR: AutoInvoice Interface.
Hi All,
I am trying to import legacy open invoices into AR. I am importing data
only into RA_INTERFACE_LINES table. When I submit the Autoinvoice
interface, it is giving me the following errors.
1.Message not found. Check the log file for more information.
(this error I am getting for all records)
2.You must supply sales credit assignments for this transaction when you
specify you require salesperson
( This error only for line_type 'LINE')
3.You must link the transaction of line type 'TAX' to a transaction of
line
type 'LINE'
( This error is for Line_type 'TAX').
I would really appriciate all your help.
Thanks,
Manju.
Date: Thu, 21 Oct 1999 14:31:31 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AutoInvoice Interface.
Hello Manjula,
You need to populate the ra_interface_salescredits_all table as well with
the
salesrep
information.
Also, for line type of tax, you must "link" the tax line to the line for
which the tax applies
using either the link_to_line_attribute1 through 15 columns or the
link_to_line_id column.
These data are, for the link_to_line_attribute1 through 15, the
interface_line_attribute1 - 15
of the taxed line. You don't have to use all 15 columns. Just make sure
the
combination
of whatever columns you use are unique. If you have not enabled
autoaccounting, you
will also have to populate the ra_interface_distributions_all table. You
will probably want
to populate this table since you won't want to change any of the accounting
from your
legacy system.
I know this may be confusing, so feel free to write back. Also,. the User's
guid provides
an example in the autoinvoice section.
Date: Fri, 22 Oct 1999 09:27:57 -0400
From: "KPMG - Chadda, Alok" CHADA@naa.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE:AR: AutoInvoice Interface.
Manju-
1.Message not found. Check the log file for more information. (this error
I am getting for all records)
You must be getting a value after message not found message. This value
you must be assigning to one of the columns in the Interface Table. Check
whether it is a correct value for that column.
2.You must supply sales credit assignments for this transaction when you
specify you require salesperson
( This error only for line_type 'LINE')
If you have set salesperson as required, you need to populate
ra_interface_salescredits table with the right values. Otherwise uncheck
the salesperson required checkbox in system options. The navigation path
is
System-System Optionms and go to Miscellaneous alternate region.
3.You must link the transaction of line type 'TAX' to a transaction of
line type 'LINE'
( This error is for Line_type 'TAX').
If you are planning to have TAX at line level, you need to link TAX line
with its corresponding 'LINE'. You need to populate
LINK_TO_LINE_ATTRIBIUTE's with the right values. Read Receivables User
Guide and go through the Transaction Flexfield setup details.
HTH
Alok