ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings to Mailing Lists
ON
ACCOUNTS RECEIVABLES

On modification of Header level info after autoinv, system populates tax code automatically

From: "Sandler, Susan" Susan.Sandler@impacgroup.com
To: "'meva@flashmail.com'" meva@flashmail.com, "'sunn999@hotmail.com'" sunn999@hotmail.com
Subject: AR Invoices Problem
Date: Mon, 19 Jul 1999 08:50:18 -0500

Dear Sunil and Eva,
I am also getting that tax code error in AR after I import from OE and when I try to change header level information on the invoice. What is happening is that the system is auto-populating the tax code field for all my lines. Why this is happening I don't know at all as I have all my customers and transaction types set up so that taxes are never calculated, as we never charge tax.

What effect does setting up a primary ship-to and bill-to address have? None of my customers are set up with any primary addresses and I haven't had a problem up until this point. Any information or guesses would be appreciated. I am on version 11.0.3.

Susan Sandler

Date: Mon, 19 Jul 1999 10:00:07 +0000
From: shafiqr@sa.ibm.com
Subject: Re: AR Invoices Problem

Check you Profile Options on AR Responsiiblity
1. Tax: Allow Override of Customer Exemptions:
2. Tax: Allow override of Tax Code
Regards Shafiq

From: Sunny Sunny [mailto:sunn999@hotmail.com]
Sent: Monday, July 19, 1999 9:11 AM
To: Susan.Sandler@impacgroup.com
Subject: Re: AR Invoices Problem

Hi,
Check out in the item attributes window whether u have attached a tax code there,in the Invoicing region.Thats also a place from where tax code can be picked up. Plus set all the tax system options as disabled in OE or AR system options they are the same. Also check the "TAX" system profile options set them to no A primary ship to and bill to site is the one which defaults on the invoice when u are entering one.Generally from OE the ship to and billto site in the Sales order is picked up by Auto Invoice.

Most important check the invoice batch source which u r using While running the Auto invoice program use the same invoice batch source which u used while running the Receivables Interface program. This is one parameter which should be the same. Plus also check all the Auto invoice options in the Invoice batch source form ,most of them should be set to ID and not to value. This is also one reason like if an Auto invoice option is set to "Value" and the "Id" gets populated then no data is found. Access the form from setup-Transactions-Source.

This might help. Sunil Wahi.

From: "Sandler, Susan" Susan.Sandler@impacgroup.com
To: 'Sunny Sunny' sunn999@hotmail.com
Subject: RE: AR Invoices Problem
Date: Mon, 19 Jul 1999 10:26:05 -0500

Hi there,

Thanks for taking the time to reply to my email. One important thing that I forgot to mention that the import completes successfully. The problem only occurs under the condition where I incomplete the imported invoice and try to change header level information (changes line level information doesn't cuase a problem). If I go and look at the imported transaction before making an changes the tax code field on the invoice line is blank. The act of changing header level information actually causes the system to auto-populate the tax code with 'Sales Tax', the location based tax code that I set up not to use, but just because the documentation said I had to set up at least one tax code. So the actual import is not the problem. I think this is a system bug because all my transaction types are set up with Calculate Taxes=No.

One question - how do you set the tax system options as 'disabled'? They are required fields.

Susan.

Date: Tue, 20 Jul 1999 12:34:56 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: RE: AR Invoices Problem

1) Set tax method to Sales tax in the system options
2)Set the Sales tax Location flexfield structure field to "No Validation Country" Flex field.
3)Define one tax code called Exempt with 0 % rate (Navigation: Setup-Tax-Codes)
Attach this Tax code to the Customer's Business purpose - Ship to
(Navigation :Customers-Standard-Addresses-business purpose-ship to-(Button-Open)
In this form u have the tax code field, attach the "Exempt" Tax code here. The end result is whenever u change the header level of the Invoice the Tax engine is called and the tax gets calculated so this time when u have done all the setups and try changing the header of invoice the "Exempt" Tax code will Default calculating 0 tax and giving no problems.

Regards,
Sunil Wahi.
Senior Application Consultant.

Master programme - warning

Date: Tue, 20 Jul 1999 14:10:48 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: AR: Autoinvoice Master Program - WARNING

Hi AR Guru's:
We have lost out AR Super-User and so I would appreciate any assistance. We have been getting a Warning completion status on the AutoInvoice Master Program. The Autoinvoice Import Program completes Normal; and we can batch print the invoices. The message (causing the Warning) is as follows:

APP-01294 AFPPRN received a return code of failure from routine FDUPRN. APP-00965 Cannot read file /applcsf/prod/out/IBEAIRD.951608Previous Messages (for Support Purposes)APP-00965 Cannot read file /applcsf/prod/out/IBEAIRD.951608APP-00406 No message explanation found for message '&MESSAGE'

Since I have never paid attention previously, I do not know if this is "normal" or a tru indication of a problem. Can anyone out there guide me? BTW: /applcsf/prod/out/IBEAIRD.951608 is not an existing file and so that part of the error message is correct.

We are 10.7NCA; RDBMS 7.3.3.6 (yes, I know I need to upgrade) on Solaris 2.6 sparc.

Thank you all for your wisdom and guidance.

Karen Blackwell
DBA/System Administrator
RockShox, Inc.
408.570-4912 phone
408.435.7468 fax

Date: Wed, 21 Jul 1999 15:04:13 +1000
From: "Bevin Watson" bevin.watson@abs.gov.au
Subject: Re: AR: Autoinvoice Master Program - WARNING

This is a feature.
The concurrent manager is trying to print the output from the master program, but the program does not produce any output Go into "define concurrent program" and change the attributes to "do not print"

Grouping Rules

Date: Wed, 21 Jul 1999 03:17:57 MYT-8
From: philip@aleytys.pc.my
Subject: AR: Autoinvoice Grouping Rules (10.7 SC)

Dear Ora-Apps,

I'm trying to get the grouping rules to work but there doesn't seem to be any documentation on the items you can pick when defining a grouping rule. For example interface_line_attributeN. Both the user manual and TRM are totally silent on this.

Basically what we want it that for each autoinvoice run, all transactions for a particular vendor will be put under one invoice. For some customers we will want to group by shipping date.

Does anybody have any documentation on columns available for grouping rules?

Philip

Date: Wed, 21 Jul 1999 08:39:24 -0400
From: ddisalvo@hearstsc.com
Subject: Re: AR: Autoinvoice Grouping Rules (10.7 SC)

Grouping Rules are defined in the "Open Interfaces" manual....Dom

Date: Wed, 21 Jul 1999 13:23:14 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: AR: Autoinvoice Grouping Rules (10.7 SC)

Hi,
Grouping rules decide how u want the order lines to be grouped into a single invoice or multiple invoices. Grouping rules are nothing but segments of the Line transaction flexfield in AR which gets populated when u run the auto invoice process. The first thing which u have to check is that the order lines should be in the interface tables if u want to group them. Check out what data the columns populate.Exact meaning of the columns u will get from the Descriptive FF Form,u can check the segments of the Line transaction FF. and decide what columns u want to group by and include them in the Grouping rule.

Help on that will be in ARug.pdf manuals.

Autoinvoice - Import invoices from external application with tax calculated

Date: Thu, 22 Jul 1999 11:21:25 BST
From: "x cbl" xcbl@hotmail.com
Subject: AR : 9.4 to 10.7 AutoInvoice

All,

I am working on an upgrade from 9.4 to 10.7. AR module only. We use ARIILK in 9.4 to load both customers and invoices. Customers are now being loaded via RACUST. However, invoices are proving more of a problem.

Using Autoinvoice, I need to load invoices from an external application that has TAX previously calculated. How is this done??? ie - what are the minimum fields required to do this?? Do I need to load a dummy line of type LINE?? What functionality/setup is required to avoid pitfalls??

help much appreciated. thanks Robert

Date: Fri, 23 Jul 1999 15:34:06 -0400 (EDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
Subject: Re: AR : Autoinvoice

Hi,
1.There is no need to create a dummy line. You can refer the tax portion to the header thru the Interface_attribute(n).

2.You have to take care of the transaction type set up where the taxable flag should be turned off(this transaction type should be used in the interface table)

Hope this helps,
best wishes, Murthy.

Cannot read value for AR_ALLOW_TRX_LINE_EXEMPTIONS

From: Basanta Kumar Dash [mailto:dashbk@hotmail.com]
Sent: Tuesday, March 09, 1999 3:35 AM
Subject: AutoInvoice

Hi, We are facing following problem while running AutoInvoice. I am wondering whether anybody is facing the same the problem or not.
The log file shows that ;
Cannot read value for profile option AR_ALLOW_TRX_LINE_EXEMPTIONS in routine &Routine.
Thanks in advance. Regards, BAsanta.

Date: Tue, 9 Mar 1999 09:25:07 -0500 (EST)
From: "Ary, Diane"
Subject: RE: AutoInvoice

I have run into this problem as well, evidentally, one of the records trying to pass through the Autoinvoice has a tax calculation. You need to go to Profile Options in System Admin. Either at the site level or the application level, you need to set the profile option name "AR_ALLOW_TRX_LINE_EXEMPTIONS" or the user name called Tax: Allow Override of Customer Exemptions. It sounds like you will need to set this to yes.

Date: Tue, 9 Mar 1999 20:04:38 -0500 (EST)
From: "Basanta Kumar Dash"
Subject: RE: AutoInvoice

Hi Diane, Thank you very much for your reply. Now it's working fine. Regards, Basanta.

Oracle error 1

Thomas Jones-Low wrote:

I am a contractor for a another firm and have been asked to try and track down this problem. The customer uses Oracle Financials 10.7 on Oracle 7.3. They use a third party tool to submit their regularly scheduled financials programs via the CONCSUB interface. Recently, within the last week, the AutoInvoice Import submission via CONCSUB has begun failing randomly. It fails once, and when resubmitted a few minutes later with the same parameters, it works fine. It then runs fine once or twice, then fails again. And so on.

Every time it fails, the error messages are the same: CONCSUB xxxxxxxx "AR" "Receivables Super User" "" WAIT=N CONCURRENT "AR" "RAXTRX" "MAIN" "T" "1056" "MX Order Entry" "22-FEB-99"

..... APP-00988 ORACLE error 1 in FDPRRC
Previous Messages (for Support Purposes)
APP-00988 ORACLE error 1 in FDPRRC
APP-01364 Cannot submit your concurrent request
Previous Messages (for Support Purposes)
APP-00406 No message explanation found for message '&MESSAGE'
What confuses me more is the documentation for the APP errors listed is completely different than the messages show above. The development staff swears up and down that they have not changed anything.

My question is: Has any one see this error or type of error before? Does anyone have any pointers to where to start looking for better answers?

Date: Mon, 15 Mar 1999 17:29:12 -0500 (EST)
From: Nanda Kishore
Subject: Re: Autoinvoice Import via CONCSUB Error

Oracle Error 1 may in reference to ORA-00001 Unique constraint violation.
If that is the case, check if the dba or any of the developers has created unique index recently. Or your dba should be able to find any newly created indexes by checking the timestamp. Thanks, Nanda

Autoinvoice terminated by Signal 11

Date: Mon, 19 Jul 1999 12:29:48 -0400
From: Elizabeth Macri emacri@prg.com
Subject: AR Auto Invoice

My Auto Invoice program is erroring on completion. It will pull through invoices either way however, the cancelled invoices and partial write offs will not come over.

I found that if I change the system profile AR: Use Invoice Accounting for Credit Memo: to YES the process will finish without the error but reject my transaction with the error: You cannot supply any account assignments for your credit transactions if the profile AR: Use Invoice Accounting for Credit Memo is YES.

The request log says that the program was terminated by signal 11
Any help would be appreciated.
Thanks
Elizabeth Macri

Date: Tue, 20 Jul 1999 12:46:43 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: AR Auto Invoice

Hi,
what is the Invoice batch source u r using for the Autoinvoice ?program,plus where are u importing data from.If u r importing credit memos,have u defined transaction types for Credit memo and also set the creation sign for them to "ANY" Apart from this the credit memo source has to be associated to the Invoice batch source in the Invoice batch source window.

Try this out, might help if u have not done these setups already.
Regards, Sunil Wahi

How to apply On-account Credit Memo to an invoice

Date: Fri, 23 Jul 1999 12:53:08 IST
From: "Kuntal Ray" k_file2@hotmail.com
Subject: AR: Auto Invoice: How to apply on-account cr. memo to an invoice

Hi All,
I am using Autoinvoice to import invoice, cr. memo and dr. memo. Autoinvoice help says, to apply any cr. memo line to an invoice line we have to use reference_line_attribute1-15 of ar.ra_interface_lines_all table. This is true for credit transactions. But I want to apply on-account cr. memo to an invoice ( not to a particular invoice line). Does any one have any idea how to do it!

Thank you in anticipation, Kuntal

Date: Fri, 23 Jul 1999 13:28:55 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: AR: Auto Invoice: How to apply on-account cr. memo to an invoice

Hi,
First of all, where are u importing inv,cr memos from ? On account credit is an unapplied credit memo,U can first import in and then manually apply it to an invoice.Whereas if u want this to be done automatically u can very well use the same process which u have been doing for a std credit memo.On account credit directly affects the customer's Receivable account.

Marie-Claude Oligny" mcoligny@cpa.qc.ca Save Address Block Sender
To: k_file2@hotmail.com
Subject: AR: Auto Invoice: How to apply on-account cr. memo to an invoice
Date: Fri, 23 Jul 1999 10:44:33 -0400

Hi,

If you want to add a credit transaction for the account and without a link with any invoice, not now , and never. You can load without a reference a credit memo without a link but you need to indicate the accounting combination and for the client a good description.

Marie-Claude Oligny
Partner
Champagne, Parent & Associates Inc.
tel: 514.942.6284

Date: Sat, 24 Jul 1999 10:42:23 IST
From: "Kuntal Ray" k_file2@hotmail.com
Subject: Again - AR: Auto Invoice: How to apply on-account cr. memo to an invoice

Hi Marie & Sunny,
Thank you for your inputs. Here are the answers to some of your questions so that u get my problem in more detail. I am importing inv & rcpt from a parallel foreign system(TTAS). TTAS is supposed to take care of a specific part of client's business i.e. imparting training on different subjects. TTAS will generate invs and rcpts for the customers who are getting the trainings. I have to load this invs & rcpts in my AR system through Autoinvoice & Lockbox. Now it may so happen that some customer who initially opted for some subject (accordingly inv - $100 & rcpt-$100 are created and loaded in my AR) may change his subject(say fees for this new subject $150). In that case TTAS will send me the name of new subject and new fees ($150) and my system will generate a
1. cr. memo($100) to cancel old inv($100)
2. a new inv($150) for the new subject
3. a rcpt ($50).
Now my system is supposed to apply this cr. memo($100) and the rcpt ($50) to the new inv($150). It won't touch the old inv & rcpt. So though I created the cr. memo with line as the old subject, it's being applied to the new inv with line as the new subject. That's why I can't use credit transaction because I am not directly crediting the old inv line. I am using on-account credit memo and since subject (item in the line - this will give the client the idea what this cr. memo is for) are different for the on-account cr. memo and the new inv so I can only apply the cr. memo to the whole inv - not to a specific line.
But Autoinvoice - it seems - gives no facility to apply a cr. memo to the whole of an inv - not to a specific line.
How can I manage this problem!
Thank u for your attention.
Kuntal

Autoinvoice - Default Grouping Rule splits invoice

Date: Fri, 23 Jul 1999 16:16:57 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: AR: Default Grouping rule splitting invoice

Hello again autoinvoicing Gurus and Jedi's,

For some reason, autoinvoicing is attempting to split an invoice into two. Here's the situation:

1) Bringing 10.7 invoices into Rel 11. through the interface.
2) I have automatic transaction numbering OFF to preserve the TRX_NUMBER from rel 10.7 (a requirement)
3) Using the default grouping rule
4) Invoice looks like this:

Line1
Tax on line1
Line2
Tax on Line2

Freight line 5) All columns listed as MUST BE THE SAME in the documentation ARE the same.

I painstakingly built a select statement to confirm this! So why is it trying to split the invoice?

Thanks for your help in advance,
Tom Orth

Date: Sun, 25 Jul 1999 10:15:42 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: RE: Default Grouping rule splitting invoice

Hi,
There are other rules that causes split invoices. All the attributes in the interface table (ra_interface_lines) that are mapped to the invoice's header (ra_customer_trx) can cause split of an invoice. Check if you have the same value, for the lines of the same invoice, in those fields. For example: different value in one of the header_attribute[1-15], purchase_order, term_name, term_id, primary_salesrep_number, primary_salesrep_id etc. will cause the lines to appear in different invoices.

-- Suzie Roth
MIS (Ext. 7151)

Date: Sun, 25 Jul 1999 12:57:19 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: AR: Default Grouping rule splitting invoice

Hi,
First Is the data there in the interface tables ,a silly question but it does matter, the data has to be there at the time u r running Auto Invoice. Check out the grouping rule, it migth be grouping by the Interface attributes like Order number,Item ,etc. Check ur interface criteria ,define a very generic grouping rule and try it out.

Check this out.
Regards,
Sunil Wahi

Autoinvoice ends with error :ORA-20000: APP-15482 and does not load any invoice

Date: Mon, 26 Jul 1999 15:17:54 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: AR: Autoinvoice "Completed with Error" status

Has anyone seen this in Release 11?

The only consistent thing I can see is that it is the error

ORA-20000: APP-15482: Please correct the receivable account assignment.

That's all well and good. But it doesn't load ANY of the invoices for that run.

Date: Mon, 26 Jul 1999 21:10:31 -0400 (EDT)
From: Steve Sopoci stsopoci@yahoo.com
Subject: Re: AR: Autoinvoice "Completed with Error" status

Are you using autoaccounting to generate the accounting strings and is the receivable account for the transaction type maybe not filled? This error can be because of autoaccounting or an invalid ccid string setup in gl_combinations_code tables. Hope this helps.

Date: Tue, 27 Jul 1999 01:35:12 PDT
From: "Andrea Storer" astorer@hotmail.com
To: torth@sequent.com, Oraapps-l@cpa.qc.ca
Subject: Autoinvoice - Receivable Account Error

Tom,

The error is due to the AutoAccounting setup not being able to generate a valid Receivable account.

Have seen this before, and the error message is a bug fix from Oracle. Prior to the fix AutoInvoice used to load all of the invoices with no payment schedules - not nice.

Unfortunately as it's a bug fix it doesn't list the invoices as with all other AutoInvoice errors and tell you which one has failed, it just fails the whole run. This leaves you with the task of searching for the incorrect Receivable account - not enviable.

hope this helps Andrea

How to avoid invoicing during Autoinvoice when a commercial invoice has already been generated

Date: Tue, 27 Jul 1999 07:55:06 -0400
From: "Annette Anost" aanost@goodegg.com
To: "Oracle OE Listserver" ORACLE_OE_SIG@GI.COM,
Subject: OE-AR: Comml Inv or Auto Invoice

Hello Everyone:

Wanted to know if there is a trigger within OE or AR that says if I have already produced a commercial invoice from OE for a customer, do not generate an invoice when auto invoicing. Does anyone currently have a business process in place to accommodate this scenario or know what the set-up options are?

Thanks in advance for your assistance.
Annette Anost
aanost@goodegg.com

Date: Tue, 27 Jul 1999 06:33:44 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: OE-AR: Comml Inv or Auto Invoice

Annette,

I don't think that you should do that. A commercial invoice would just list all the shipped items and is intended for the customs authorities. You would have to create an invoice thru autoinvoicing to impact receivables.

HTH.
Regards,
Ravi Krishnamurthy
Senior Consultant
AnswerThink Consulting Group

Date: Tue, 27 Jul 1999 13:42:43 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: OE-AR: Comml Inv or Auto Invoice

Hi,
As far as i know A commercial invoice is only a shipping document now if u do not want an invoice for a sales order with a comercia; invoice why transfer the data to the interface tables Remove the "Receivables Interface" cycle action from the order cycle. U then need not perform an interface which is picked up by Auto invoice.

Regards, Sunil Wahi

Import invoices through Autoinvoice as Incomplete

Date: Tue, 03 Aug 1999 13:13:27 PDT
From: "Oracle Forum" oforum@hotmail.com
Subject: Want to bring Invoice as status-INCOMPLETE, from AUTOINV.

I want to bring over Invoices from AutoInvoice in an 'INCOMPLETE' status. I want to know if there's any control (either Setup related or in RA_INTERFACE_LINES_ALL), which will help me achive this.

You can call me directly and ask for UDAY.
Pager: 1-888-443-4085
Regards

Date: 3 Aug 99 14:50:21 PDT
From: Roger Drolet rdrolet@netscape.net
Subject: Re: [Want to bring Invoice as status-INCOMPLETE, from AUTOINV.]

AutoInvoice will not import an invoice that is incomplete. Import it as complete and then you can use AR functionality to change it to incomplete and make revisions. However, your revisions will not automatically adjust inventory if you make them in AR.

Roger Drolet
Conley, Canitano & Assoc., Inc.

Date: Tue, 3 Aug 1999 20:51:15 -0400
From: "Chadda, Alok" achadda@kpmg.com
Cc: "'oforum@hotmail.com'" oforum@hotmail.com
Subject: RE:Want to bring Invoice as status-INCOMPLETE, from AUTOINV.

Hi -
I don't think there is a way to bring invoices without writing a database trigger on RA_CUSTOMER_TRX_ALL.
HTH Alok

Autoinvoice and Grouping Rule

Date: Wed, 4 Aug 1999 10:38:58 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
Subject: AR-AutoInvoice

Hi all,
1.We have to create only one invoice for an order and a return from the Order entry in AR.
2.Right now two transactions are created when we run the auto invoice program
3.Can changes made to the grouping rule acheive this objective.

Any input is appreciable,
Thanks, Murthy.

Date: Wed, 4 Aug 1999 10:56:40 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: AR-AutoInvoice

The grouping rules work by checking for the equivalence of certain values in the ra_interface_lines_all table. There are certain mandatory columns to be in the grouping rules. This grouping rule is the default. All records that have these columns identical will be considered part of the same invoice. These columns are in the documentation for autoinvoice in the receivables users guide. In release 11 the open interfaces manual and users guide have been combined.