Autoinvoice -linking tax and freight lines to OE
Date: 13 Jun 99 12:35:22 MDT
From: knujwalajr jupitor knuj4@usa.net
Subject: Help on Auto Invoice(OE/AR Experts)
Hi,
Through Auto Invoice I am trying to insert extra Tax and Freight Lines
corresponding to Order Lines from OE.
I am trying to link TAX Line(ra_interface_lines_all.line_type=TAX) and
FREIGHT Line (ra_interface_lines_all.line_type=FREIGHT) with order
Line(ra_interface_lines_all.line_type=LINE).
But the extra tax and Freight Lines are not getting Linked to order
Lines.Freight is getting created on separate Invoice.I checked all the
mandatory grouping columns.For extra Tax line i am using link_to_line_context
as 'Global Data Segments' instead of 'Order Entry'.
For Link to Line attribute values i am giving interface_line_attribute values
for extra Tax Record.
Can some body please help me ?
Thanks in Advance
Copying transactions
Date: Wed, 16 Jun 1999 12:59:58 -0700
From: "Amejka, William" wamejka@dreamworks.com
Subject: AR: Copying transactions
Hi all,
We would like to utilize the copy transaction functionality in Oracle
Receivables 10.7 NCA, but we have 2 issues
1. the function only copies completed invoices
2. when it creates a new invoice, the new invoice is completed as well.
Questions.....
1. Has anyone found a way to copy incomplete invoices
2. Is there a way to automatically make the new invoices incomplete
Thanks for your help!
Bill
Loading Salesreps
Date: Mon, 28 Jun 99 09:03:08 -0500
From: rbush@bellsouthwd.com
Subject: AR: Loading Salesreps
Hi,
I have 1,400 new salesreps I need to load into Oracle AR. Does anyone
have the sql*loader scripts they may want to share to accomplish this,
since oracle does not support an open interface for this process.
Thanks,
Rich Bush
BellSouth Wireless data
(732) 602-5260
Vertex Load
From: bdungy@csc.com
Subject: Vertex Load
Date: Mon, 28 Jun 1999 15:35:35 -0400
I think there may be something wrong with the arvertex.ctl file or the
seqmast file that I have from vertex. When I try to load the
ar_tax_interface table using arvertex.ctl the process runs for hours but
doesn't appear to be loading any data. Both the Oracle Top Session monitor
and GlancePlus (HP-UX) show no I/O activity for the process. However, it
is using almost 100% of the CPU. I've let it run as long as 5 hours
straight before without seeing any appreciable progress. Is there
something that I need to do when unloading the seqmast file from tape other
than issuing "tar -xv" (i.e. reblocking the data, etc.)? Any ideas would
be appreciated.
Thanks,
Bruce Dungy, Senior Oracle DBA
CSC Healthcare
Customer merge not giving results
From: DASARI SUBRAHMANYAM [mailto:srdasari@hotmail.com]
Sent: Saturday, June 26, 1999 4:18 AMTo: Multiple recipients of list
Subject: Re: [Concurrent Program Help Required ***URGENT***]Hi all,
My client has a problem in running customer merge program between customers.
When the user runs customer merge it runs with status success. But,
Customer Merge Execution Report does not contain any lines. The log file
generated shows some debugging messages from ARP_CMERGE package.
When i go and query for transactions in AR, they are appearing with the old
customer only.
Is there a patch? I have taken care of all the prerequisites as mentioned
in the manual to do customer merge.Any help will be greatly appreciated.-dasari
From: SCross@littonapd.com
Subject: RE: [Concurrent Program Help Required ***URGENT***] ATTN Dasari
Date: Mon, 28 Jun 1999 10:21:25 -0700
Dasari,
First you need to find out why it didn't run. Usually the Request Log can
give some information. I've had some abort because it didn't finish before
the database came down for backups or it ran out of tablespace. Is the
setup correct? Do you have a billing or shipping address for each
corresponding address? After you correct the problem, you can resubmit
through the AR responsibility - Control, Requests, Run. Choose customer
merge and enter the request id.
If you don't know the request id, you can find it in the RA_customer_merges
table. This worked for me so I hope it solves your problem.
Susan Cross
Litton Aero Products
scross@littonapd.com
Date: Tue, 29 Jun 1999 05:38:00 PDT
From: DASARI SUBRAHMANYAM srdasari@hotmail.com
Subject: RE: [Concurrent Program Help Required ***URGENT***] ATTN Dasari
Hi Susan,
Thank u very much for ur concern. I believe my problem is not related to
tablespaces or running of database. The customers i tried have bill to and
ship to addresses and i mapped bill to - bill to and ship to - ship to of
each customer.
When i queried on ra_customer_merges table, the process flag is 'N'. I
understand fromt the documentation, for merge to be complete the process
flag has to be 'Y'.
Log file gives me many message from the packages ARP_CMERGE_MASTER and other
packages. In between i get Oracle Error 'User Defined Exception'. Since it
is accessing more than 10 packages, i do not want to go into the code. I
logged tar with oracle and i did not get any reply till now.
I would appreciate if any one has some knowledge of this problem/patch.
bye
dasari
Customizing AutoInvoicing
From: Robert Kopf rkopf@mapmobile.com
Subject: AR: Customizing AutoInvoicing
Date: Mon, 28 Jun 1999 13:49:31 -0400
We are relatively new to Oracle Applications and are just beginning some
customizations to the AR, Inventory, and Order Entry areas. We have come
across the AutoInvoicing functionality and would like to use. However, our
billing scheme necessitates some customization.
Our customers are billed each month for a service plan at a set price.
Additionally, they are billed for any services rendered over and above what
their service plan entitles them to. For example, a customer would be billed
in June for July's service, as well as any additional services they requested
in May. Therefore, a customer's invoice is different every month, even though
their original service plan remains the same. The amount of additional
services a customer has used is stored in another system that can easily be
passed to Oracle Applications (i.e. text file, cron process download, etc.).
Can the AutoInvoicing feature in the AR module be used to establish a recurring
amount for the service plan and then have the additional service charge added
automatically when an invoice run is performed at the beginning of each?
Robert Kopf
Map Mobile Communications, Inc.
840 Greenbrier Circle
Chesapeake, VA 23320
(757) 424-1191
rkopf@mapmobile.com
Credit Transactions - problems
Date: Tue, 29 Jun 1999 12:39:57 +0500
From: Faisal Yasin fyasin@ora-tech.com
Subject: problem in credit Transaction module in AR
Hi, All
Please resolve my problem.
We have been facing a problem in credit Transaction module in AR since
last
six months, there have been several complains logged to response UK/AU.
We
also received the response from both sites, but the actual problem is
still
persist as this problem is now causing delay in work and created a
situation that we can not continue our work. A brief history of this
problem is described as below and I hope that it will help you to
understand the problem.
(A) The problem is when I click either credit transaction or transaction
summary, system gives me the following error:
APP-01728: An assignment does not exist for these parameters.
Cause: An attempt was made to find a sequence for this document
flexfield.
The profile option says Sequential Numbering is only partially used.
Action: None is necessary unless you excepted this document flexfield to
have a sequence defined.
(B) After ignoring when I enter credit transaction either from
transaction
summary or credit transaction and try to save it gives me the following
error message:
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04068
The history is as follows:
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04068
---------------------------------------------------------------------
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body “APPS. ARP.CREDIT_MEMO_MODULE”
does
not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at “APPS.ARP_PROCESS_CREDIT_INS_COVER”, line 215
ORA-06512: at line 1
-----------------------------------------------------------------------
SOLUTION:
We were asked to check the invalid objects and fixed them. The problem
did
not resolved.
CASE 2.Reference to Tar # which is logged to
RESPONSE_APPS@uk.oracle.com
In this response we were asked to check specifically for the package
arp_credit_memo_module, if the package does not exist then recreate it
using the sql ARTECMMS.pls script.
This script is suppose to create the Package, it does create the package
but also created some new problems.
CASE 3.Reference to Tar ,which is logged to
GTANAS.@au.oracle.com
In here we have been asked to apply AR MEGA Patch # 791987 containing a
server patch/database patch and a client patch.
After successfully applying the patch on the server as well as on the
client the problems appearing in case 1 and case 2 are gone. As the
impact
of the client patch when I click on the credit transaction option, a new
form invoked, instead of the old form. This form is basically used to
find
the invoice. But unfortunate once again the basic problem of saving the
credit transaction remains intact.
Best regards
Date: Wed, 30 Jun 1999 10:05:56 +0500
From: Faisal Yasin fyasin@ora-tech.com
Subject: Re: problem in credit Transaction module in AR
Hi Irfan,
Platforms is Digital Unix
Application Version is 11.0.3
Regards,
Working with California's Section 6378 - Exemption from 5% ST
Date: Tue, 29 Jun 1999 11:04:46 -0400
From: William Hall WHall@media100.com
Subject: OE/AR Working with California's Section 6378
California has a Section 6378 which exempts teleproductions from 5% of the
state sales tax. Has anyone any thoughts on how to apply the 5% credit
automatically when it is identified that the customer has a Section 6378?
Thank you,
Bill
MICR info in Lockbox
Date: Tue, 29 Jun 1999 10:39:43 -0700 (PDT)
From: Kevin Johnson kevin_t_johnson@yahoo.com
Subject: AR: LockBox MICR Information?
Has anyone had any experience using MICR number within LockBox?
We are looking at potentially using these and have some questions. We
are running 10.7 NCA and have about 250,000 customers.
Does Oracle allow MICR to be stored at the Customer Site Level?
Does Oracle allow multiple MICR numbers per customer?
In order to use MICR numbers do we have to preload MICR information
onto the Customer table using Customer Interface or manually? Or can we
just allow LockBox to load them in as they are received over time?
In order to use MICR do we have to load Customer Bank information
first?
Where do you manually load MICR information? Is this on the Customer
Standard (Bank Accounts dropdown) form in the Account Number, and Bank
Number columns?
Thanks any help would be appreciated.
Misc Receipts in Lockbox
Date: Tue, 29 Jun 1999 10:47:41 -0700 (PDT)
From: Kevin Johnson kevin_t_johnson@yahoo.com
Subject: AR: Misc Receipts in LockBox
Does anyone know about backing Miscellaneous Receipts out of LockBox
batches?
When LockBox creates receipts I beleive it creates everthying as a type
of Cash as opposed to Misc. If we notice that a receipt should have
been Misc. we could reverse and re-enter it as Misc.
If we do this can we re-enter the Misc. receipt back into the same
batch (Oracle Batch and Bank Batch) so that the Batch balancing and
status still works correctly?
Thanks