ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings to Mailing Lists
ON
ACCOUNTS RECEIVABLES

Autoinvoice APP-11813 Error calling raapic

Date: Wed, 04 Aug 1999 10:26:29 -0400
From: "MALCOLM MACDERMID" MMACDERM@butchers.com
Subject: Autoinvoice

Hello all,
We have been experiencing a problem with Autoinvoice for more than two weeks now. During the Autoinvoice import the following error occurs: APP-11813 Error calling raapic().I know that this error is pretty generic, but so far Oracle support has been unable to solve the problem.

Thanks in advance.

Date: Wed, 4 Aug 1999 08:27:24 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: Autoinvoice

Yes, I was getting the same error. Check all of your sales people and transaction types to see that their ccid combinations are correct. Did you add a new salesperson about two weeks ago?

Date: Wed, 04 Aug 1999 15:59:02 -0400
From: "MALCOLM MACDERMID" MMACDERM@butchers.com
Subject: Re: RE: Autoinvoice

We haven't added a salesrep in 6 weeks and they all appear to be correct. This is really starting drive me crazy.

Date: Wed, 4 Aug 1999 18:27:30 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: RE: Autoinvoice

Check the "SQL trace" checkbox in the System Option Setup (AR) and run the AutoInvoice again. In the trace file you will get more information about what causes the error.

-- Suzie Roth
MIS (Ext. 7151)

Date: Wed, 4 Aug 1999 12:10:39 -0400
From: "Gupta, Upendra" Upendra.Gupta@Olsten.com
Subject: RE: Autoinvoice

Just have a look for document sequence for both INVOICE and CREDIT MEMO.. Sometimes you get problem b'cze of that.

Upendra

Date: Wed, 4 Aug 1999 10:30:10 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
Subject: Re: Autoinvoice

Hi,
you could check the following:
1.Your payment terms (for invoice or other transaction types should be valid and defined in Oracle)
2.Look at the terms_id that is populated in the ra_interface_lines_all.
3.I think this error results when the payment terms id is null.
Hope this helps,
Murthy.

Date: Wed, 4 Aug 1999 13:19:40 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: RE: Autoinvoice

Does the log file mention anything about an invalid accounting flexfield?

The thing to look for specifically in salesreps is the receivables code combination (gl_id_rec). It must be valid. Another possibility is the transaction flexfield's code combination ids as well.

Date: Wed, 04 Aug 1999 16:31:08 -0400
From: "MALCOLM MACDERMID" MMACDERM@butchers.com
Subject: Re: RE: RE: Autoinvoice

No,there is no mention of an invalid accounting flexfield. However, APP-11914 Duplicate transaction flexfield does appear.
Thanks for the suggestions.

Date: Wed, 11 Aug 1999 09:27:31 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
Cc: MMACDERM@butchers.com
Subject: Re: ORAAPPS-L digest 3509

Hi,

I've seen this error, but your scenario could be different. I'm on 11.0.2 and I have SQL Trace On under System Options for Autoinvoice.

The trace reveals that it fails while inserting a record into AR_RECEIVABLE_APPLICATIONS for a credit memo applied to an invoice. The bug is that the payment schedule record is not created for the credit memo in the first place. I was told that there are some pro-active patches available for 11.0.3, which will fix this problem.

If this is your problem, the pro-active patch might be a solution for you. I didn't get the patch, since 11.0.3 is not an option for us right now.

Regards, Murali

Date: Wed, 11 Aug 1999 09:32:56 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
Cc: MMACDERM@butchers.com
Subject: Re: ORAAPPS-L digest 3510

Hi,

You should review the input data. The segments of the transaction flexfield you set up for Autoinvoice has to be unique for each transaction. Sounds like you're trying to import a inv/cm, which is already in the system?

Regards, Murali

Autoinvoice error APP 11900

Date: Sat, 7 Aug 1999 16:03:19 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
Subject: Autoinvoice: Errored out

HI all,

We are running on 10.7 NCA and our company went live last week, and we had problems with auto invoice. It is erroring out saying

TypeBill to Customer NameItem
Description
CurrencyAmount
-------------------- ----------------------------------------
------------------
---------------------- ----------- -----------------
Invoice BLOUNT INC
VA20VA,05282,02751
,52338,02751,Z000USD 5,220.15

Errors: 1) APP-11900 You can supply at most one Receivables account for a transaction (an invoice, a debit memo or a credit memo)

Any help is greatly appreciated as till now no invoice is generated.

Thanks Kiran

Date: Mon, 9 Aug 1999 05:34:10 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
Subject: Re: Autoinvoice: Errored out

Hi Kiran,
You can look at the following set ups and see if it helps:
1.Your transaction types definition where in you define the receivables account(verify whether the definition is proper)
2.Attaching the correct credit memo/debit memo to the invoice transaction type(found at the end of the invoice transaction type def.)
3.Verify your auto accounting has been properly set up.
4.If no result, you can check the ra_interface_distributions_all table after some records find their place there and verify the ccid's.
Hope this helps, Murthy.

Date: Mon, 9 Aug 1999 10:10:33 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
Subject: RE: Autoinvoice: Errored out

Actually what we have done is, for every line inserted into to ra_interface_lines_all table, we have a trigger which will insert two records into ra_interface_distributions_all table one with account class 'REV' and other as 'REC' with 100 percent account distribution and we are populating the 7 interface_line_attributes. Are we missing something?

Date: Tue, 10 Aug 1999 08:11:08 +0530
From: "Bagavathi Rajan K" rajankb@wipsys.soft.net
Subject: Re: Autoinvoice: Errored out

Hi Kiran,

You have mentioned that for every line in ra_interface_lines_all, you are inserting two distribution lines one with account class as 'REC' and other with account class as 'REV' using a trigger. In that case, if you have two lines in ra_interface_lines_all, the trigger will insert 2 lines in ra_interface_distributions_all with account class as 'REC' and another two lines with account class 'REV' for the same transaction. But, a transaction should have only one distribution line with account class as 'REC' and the amount in it will be the sum of all the line amounts.

K.Bagavathi Rajan.

Date: Tue, 10 Aug 1999 15:59:58 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
Subject: RE: Autoinvoice: Errored out

Thanks a lot,
We solved the problem.

Autoinvoice completes with APP-11526: ORA-01427 error

Date: Tue, 3 Aug 1999 16:36:38 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: AR: Autoinvoice completion error

Hello,

I had an issue earlier with autoinvoice ending in error and not loading any of the invoices. I fixed that problem by fixing up some improperly set-up salesreps. Well, it's erroring out again, but there are no improperly set-up salesreps.

The only error I could find in the log with messaging level set to 10 was:

APP-11526: ORA-01427: single-row subquery returns more than one row.

I checked the interface tables and all of the rows are unique in the table via the interface_line_attributes, and each tax line links to only one line item. I do pass header freight, but these all check out as well.

Any ideas? Thanks! Tom-

Date: Mon, 9 Aug 1999 13:09:29 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: AR: AutoInvoice comletion error

Has anyone seen this type of error before in Autoinvoice? from log file:

For the log file please    

Date: Mon, 9 Aug 1999 15:01:16 -0500
From: "nca" nca@ceteco.com
Subject: RE: AutoInvoice comletion error

Apparently the table ra_interface_lines_all has more then one record with the same value in the fields Interface_line_context,interface_line_attribute1,interface_line_attribute2. That is the reason why the autoinvoice assumes that there is a record duplicated.

I hope this helps you solve your pb.

Date: Mon, 9 Aug 1999 14:35:00 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: AutoInvoice completion error

Hello and thanks,

I figured this out but decided against posting that fact! But here is something interesting that caused the multiple records that might be of interest to the list:

I'm doing a conversion from 10.7 to rel 11, and for some of the invoices, there are two different gl_dates in the distribution table in 10.7. One distribution line with one date, another with a different date, but with the same customer_trx_line_id.

Autoinvoice - current date as Default Date

Date: Fri, 13 Aug 1999 08:22:28 -0500
From: "Peter Smith" PSMIT@pcsentre.com
Subject: Current Date in Requests

We run the Autoinvoice Master Program nightly. We need to seed the current date in the DEFAULT DATE field. It keeps using the date we put in the SRS when we submit it for 1-day intervals. What am I doing wrong ?

Pete Smith
psmit@pcsentre.com
10.7NCA

Date: Fri, 13 Aug 1999 06:35:35 -0700 (PDT)
From: Kevin Gillins kgillins@yahoo.com
Subject: Re: Current Date in Requests

You are doing nothing wrong. Oracle will only resolve the sysdate at the time the request is made not on the resubmissions. This has been a topic of discussion many times. You could search the archives of this forum and find a solution. If I remember, there have been several different methods to resolve this.

Kevin

Unable to Autoinvoice an order

Date: Fri, 13 Aug 1999 11:26:16 -0700
From: Andy Baliton abaliton@us.salterlabs.com
Subject: Can not autoinvoice an order

Hi!
We are using Rel 11.0.2. I have an order that have lines with status of "Interfaced to Receivables" but can not autoinvoice the order. Everything else seems to be okay. No error showing.
Thanks in advance. Andy

Date: Sat, 14 Aug 1999 21:48:44 -0400
From: "Chadda, Alok" achadda@kpmg.com
To: "'abaliton@us.salterlabs.com'" abaliton@us.salterlabs.com
Subject: RE:Can not autoinvoice an order

Andy -

Could you be explain what do you mean by can not autoinvoice the order? Are you able to see any order lines in RA_INTERFACE_LINES_ALL table for this order?

Alok

Date: Mon, 16 Aug 1999 08:39:00 -0700
From: Andy Baliton abaliton@us.salterlabs.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Can not autoinvoice an order

Alok,
Thank you for your reply. The orders are in ra_interface_lines_all. I also noticed that there is an extra line on that order without an interface status. The rest of the lines are showing 'P' as an interface status. Any clue what is going on?
Thanks Andy

Date: Mon, 16 Aug 1999 12:38:45 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
Subject: RE: Can not autoinvoice an order

The ones which has P are already processed. If you will null interface_status and request_id and if they are already autoinoviced then you will get duplicate transaction flexfield error. The lines which are not picked are the ones target of investigation.

Madhu Sudan Dada

Autoinvoce aborts on encountering an invalid receivable or revenue account

Date: Mon, 16 Aug 1999 13:06:49 -0500
From: Cheryl_Moore@huntsman.com
To: ahmed ragab a_ragab@tccbce.com,
Subject: Re:auto_invoice_problems

I don't have a solution - but I have also an autoinvoice issue - Has anyone encountered the Autoinvoice process to abort if a transaction type has an invalid receivable or revenue account? My thoughts were it should give an error but instead the process aborts when it comes across a transaction type with an invalid account.

Thanks
Cheryl Moore
Ph: 713-235-6193
pgr: 800-391-6124
e-mail cheryl_moore@huntsman.com

Date: Mon, 16 Aug 1999 15:36:06 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
Subject: Re:auto_invoice_problems

It aborts only with receivables .. with revenue it should go through.
Madhu Sudan Dada

Date: Mon, 16 Aug 1999 13:10:29 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: auto_invoice_problems

Yes, I ran into this not long ago. I wrote a stored procedure to comb through the sales reps and transaction types to find invalid codes to fix this problem. Since I was doing a migration, I was importing massive amounts of information, the abort without an error message (and not importing any of the other, good invoices, was a major problem.

Use Concsub to call Autoinvoice

Date: Wed, 18 Aug 1999 09:46:39 -0700 (PDT)
From: Mark Myszkowski myszko@yahoo.com
To: OraApps-L@cpa.qc.ca
Subject: CONCSUB

Can anyone post an example of using CONCSUB to call Autoinvoice?

TIA
Mark Myszkowski

Date: Wed, 18 Aug 1999 10:42:11 PDT
From: "stephen bryant" sbryant@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: CONCSUB

Hi,

One of the sample below is:

CONCSUB apps/fnd \
SQLAP \
'"Payables Manager"' \ - hard code
SAB \ hard code (Oracle user id)
WAIT = N \
CONCURRENT \
SQLAP \
APXXTR \
"A" "101" "SAB" "BATCHNAME" "1" "N" '"AP IMPORT"' '""'
"58" '""' '"'"Y"

After manually submit the Payables Invoice Import program, please review these parameters of the Concurrent Request form.

Good Luck,
Steve

Date: Wed, 18 Aug 1999 14:44:07 -0400
From: "KPMG - Chadda, Alok" CHADA@naa.org
To: "'myszko@yahoo.com'" myszko@yahoo.com
Cc: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: RE:CONCSUB

Mark -

I found the following in my notes. Let me know if this works
CONCSUB ar/ar AR "2-Receivables Super User" ARUSER
CONCURRENT AR RAXMTR \"1\"\"1000\" \"AR INVOICES\" \"01-AUG-99\" \"\" \"\"
\"\" \"\" \"\" \"\" \"\" \"\"\"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\"
\"\" \"\" \"\" \"Y\" \"\"

HTH
Alok

Date: Thu, 19 Aug 1999 10:13:40 +1000
From: Sheila Cruickshank scruickshank@assist.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: CONCSUB

echo
echo "CONCSUB for submitting the AUTOINVOICE Open Interface "
echo

appl=AR

conc_request=`CONCSUB $ora_login ISCAR 'SIS AR System Administrator GUI'
$ora_user WAIT=N CONCURRENT $appl RAXMTR '1' $batch_id \"\" $run_date \"\"
\"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\"
\"\" \"\" \"\" \"\" 'Y' \"\"`

echo $conc_request

conc_id=`echo $conc_request | cut -f3 -d' '`

echo $conc_id

here is another sample,
I have cut the request id to check if it ran successfully or errored. Hope this helps, You can also use WAIT=Y if you want to.

Sheila Cruickshank

Date: Thu, 19 Aug 1999 11:17:38 -0700 (PDT)
From: Mark Myszkowski myszko@yahoo.com
To: OraApps-L@cpa.qc.ca
Subject: Autoinvoice with CONCSUB

Thanks to all who responded to my original question on how to call Autoinvoice using CONCSUB. Here's how it looks (NT):
CONCSUB apps/apps AR "Receivables Manager GUI" ARUSER WAIT=N CONCURRENT
AR RAXMTR "1" "1020" "ENTRE" "17-AUG-99" \"\" \"\" "1000" "1000" \"\"
\"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\"
\"\" "Y" \"\"

Now I'd like to write a batch file in NT that could submit this every day with the current date as one of the parameters. Any ideas?

TIA
Mark Myszkowski

Date: Thu, 19 Aug 1999 11:45:55 -0700
From: CFowler@littonapd.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Autoinvoice with CONCSUB

Hi,

Here is the code from a concsub that we run daily which does use the current date for the date parameters:

"apd_daily_ops_pm" [Read only] 50 lines, 1257 characters
##########################################################################
#File: apd_daily_ops_pm
#Purpose: Submit daily requests where date parameter is required (PM)
##########################################################################

#
echo ORACLE_SID:$ORACLE_SID
#
#applications wide variables
#
today=`date +%d-%b-%y`
oracle_uid=apps/apps
conc_params="wait=y concurrent"
#
#applications specific
#
user_name=RPTOPS
inv_shortname=mfg
responsibility="Oracle Manufacturing"
#
#program specific - Receiving Transactions Register
#
module="PO RCVTXRTR"
#
p1_RCVTXRTR="\"DAILY-RECEIPTS\"\"101\"\"RECEIVE\""
p2_RCVTXRTR="\"\"\"\"\"\"\"\"\"\"\"50134\""
p3_RCVTXRTR="\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"N\"\"N\""
p0_RCVTXRTR="$p1_RCVTXRTR $today $today $p2_RCVTXRTR $p3_RCVTXRTR"
#
echo CONCSUB:$FND_TOP/bin/CONCSUB \
echo oracle_uid:$oracle_uid \
echo inv_shortname:$inv_shortname \
echo responsibility:"$responsibility" \
echo user_name:$user_name \
echo conc_params:$conc_params \
echo module:$module \
echo p1_:$p1_RCVTXRTR
echo p2_:$p2_RCVTXRTR
echo p3_:$p3_RCVTXRTR
#
#finally execute this thing...
#
$FND_TOP/bin/CONCSUB $oracle_uid \
$inv_shortname \
"$responsibility" \
$user_name \
$conc_params \
$module \
$p0_RCVTXRTR
#
##########################################################################

Our environment is 10.7 16.1SC 7.3.4 IBM AIX 4.3.1.

I hope this helps.
Candace