Starting No. of Automatic Customer Numbering
Date: Tue, 9 Mar 1999 04:13:28 -0500 (EST)
Date: Tue, 9 Mar 1999 09:16:27 -0500 (EST) Changing Customer sequence
JVales@darc.com wrote:
Date: Wed, 12 May 1999 00:56:42 -0500 Automatic Customer numbering and Cache
Date: Mon, 21 Jun 1999 15:46:00 -0500
Date: Tue, 22 Jun 1999 08:44:00 -0400
Date: Tue, 22 Jun 1999 09:17:27 -0500
Date: Tue, 22 Jun 1999 09:33:48 -0500
Date: Tue, 22 Jun 1999 17:47:20 +0200
Date: Tue, 22 Jun 1999 11:39:20 -0400
Date: Tue, 22 Jun 1999 11:24:26 -0500
Date: Tue, 22 Jun 1999 11:51:36 -0500 How to have Customers Start Date as per legacy
Date: Mon, 21 Jun 1999 13:29:23 -0700 (PDT)
Date: Tue, 29 Jun 1999 15:04:04 -0600 Changing customer's zip code
"Marni Baggett" mbaggett@brk.photronics.com on 04/08/99 11:59:49 AM
Date: Thu, 15 Apr 1999 13:01:47 -0500 Customer Merge
Customer Merged by mistake
Date: Mon, 3 May 1999 09:47:35 +0530
Date: Mon, 3 May 1999 17:22:47 -0400
Date: Wed, 05 May 1999 09:27:07 -0500
Date: Wed, 5 May 1999 12:20:23 -0400 Customer Merge how to automate
Date: Tue, 18 May 1999 13:44:42 -0400
Date: Wed, 19 May 1999 09:22:17 +0200 Merging Customers with different ST rates applicable to them
Date: Tue, 27 Jul 1999 21:19:01 -0700 (PDT)
Date: Wed, 28 Jul 1999 11:09:35 +0530 Customers under Credit Hold
Date: Fri, 11 Jun 1999 16:01:39 -0700 (PDT)
Date: Fri, 11 Jun 1999 17:09:12 -0600
Date: Sun, 13 Jun 1999 09:05:55 -0400 Different Customer Names
Date: Thu, 24 Jun 99 15:40:04 -0700
Date: Thu, 24 Jun 1999 15:40:45 -0500
Date: Fri, 25 Jun 1999 08:17:21 -0600 (MDT)
From: "Marni Baggett" mbaggett@brk.photronics.com Related Customers - Invoice
Date: Mon, 28 Jun 1999 10:08:43 -0600
Date: Mon, 28 Jun 1999 17:08:27 -0400 Changing Customer Profile Class
Date: Wed, 30 Jun 1999 13:40:26 -0600
Date: Wed, 30 Jun 1999 16:05:41 -0400 Customer Calls not getting saved
Date: Tue, 13 Jul 1999 08:26:25 -0500
Date: Tue, 13 Jul 1999 17:19:00 -0700 Information required on profile - Tax: Use Tax PL/SQL Vendor
Date: Tue, 20 Jul 1999 16:56:18 +0200
Date: Tue, 20 Jul 1999 15:18:31 GMT Use Customer Interface to update Customer information
Date: Wed, 04 Aug 1999 15:47:03 -0700
Date: Wed, 4 Aug 1999 15:10:50 -0700
Date: Wed, 04 Aug 1999 16:18:22 -0700
Date: Wed, 4 Aug 1999 15:43:48 -0700
Sender: oraapps-l@cpa.qc.ca
From: "Basanta Kumar Dash"
Subject: Automatic customer numbering
Hi,
Does anybody know how to set up the starting number for automatic
customer numbering. By default system is starting with 1000. We are on
Rel 11, Win NT.
Regards,
Basanta.
From: "Ary, Diane"
Subject: RE: Automatic customer numbering
First, go the the Define Systems Options Form in AR and make sure that
automatic customer numbering is turned to Yes.
Then go to the Application Developer (AOL), go to the Register Sequence
form. Query up the sequence name for Customer Numbers. There is a start
with field, that you can start your customer numbers with.
Diane Ary
e:mail: dary@moorman.com
work phone: (217) 231-2271
fax: (217) 223-1915
pager: (800) 581-0328
cell phone: (217) 257-2062
home phone:(217) 222-5803
What is the impact of changing the customer numbering sequence, when
customers already exist? The reason for the question is that a customer
interface (that cached 30,000 customer numbers) has failed and we dont
really want to skip 30,000 numbers if we don't have to.
Thanks
Judy
From: Nanda Kishore nkishore@csac.com
Subject: Re: AR: Customer Numbering Sequence
No impact at all; but you are better off using your own numbering (manual
customer numbering) so that you do not run into this everytime the customer
i/f errors. After you are done with your customer interface, you may
want to go back to automatic customer numbering and MAY have to bump the
sequence to highest customer number + 1. Also, you may want to set the
cache size to zero (nocache) - the default is 20 and that could result in
break in sequence when you are entering customers manually.
Thanks,
Nanda
Nanda Kishore
Computer Systems Authority
Certified Vertex Implementor
From: "Vetter, Bryce" BVetter@FSC.Follett.com
Subject: Automatic Customer Numbering
Hi,
I'm trying to find out where the sequence for Austomatic Customer
Numbering is set. I know where the flag is set, but I'm stumped at
where the initial number is set. I've checked uner AR setup, and
couldn't find it. I've looked under sysadmin, document, categories,
for Receivables document sequences. that wasn't it. I've looked also
under Application Developer:Application:Database:Sequence under the
ra_customer_num_s but you are unable to update this column. I've
called Oracle support and they initally don't know, but will get back
to me....
I would have thought this was an easy question. I don't want to go
thru the backend and manually change the sequence number. If anybody
knows how to set this up thru the apps, I would appreciate it.
Thanks,
Bryce
From: "Vainberg, Lily" Lily_Vainberg@compuware.com
Subject: RE: Automatic Customer Numbering
Hi,
You cannot change it within setups. The only way to do that is to change the
database sequence. It's one of the RA... sequences - there is a bunch of
them, so you'll need to do some research. Keep in mind, that you might want
to update two sequences - one for customer numbering, another for Customer
reference numbering - if you want to keep them in-synch.
However, I don't know whether or not Oracle is going to support it.
Good luck,
Lily
From: "Landa, Mark (c)" U25MIBG@Carlson.com
Subject: RE: Automatic Customer Numbering
If I remember correctly the sequence you are looking for is called
"RA_TRX_NUMBER_1024_102_S". However, I do not believe there is a way to
modify it through the Apps Forms. We set it to not cache sequence entries
to prevent gaps.
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: Automatic Customer Numbering
Mark, Due to no cache, You guys have nay performance problem?
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: RE: Automatic Customer Numbering
Bryce -
The sequence name is AR.RA_CUSTOMERS_NUM_S, you can view the details of all
sequences from the table DBA_SEQUENCES.
You have two options:
*drop the sequence and recreate with the initial number you are wanting to
alter it to
*or alter the increment_by to to be the difference in today's value and the
value you want and select .NEXTVAL (and dont forget to change it back to
increment_by 1 afterwards!)
Im not aware of being able to change this value through the screens.
Amber
--------------------------------
Amber Allen-Sauer
Allen-Sauer Consulting, INC
email: amber@allen-sauer.com
web: http://www.allen-sauer.com
From: "Mark W. Farnham" mwf@rsiz.com
Cc: "'gsharpe@terascape.com'" gsharpe@terascape.com
Subject: RE: Automatic Customer Numbering
On the general issue of cache/nocache on sequences:
Whether the sequence will be a bottleneck is related to the i/o capacity
where the system tablespace file (or files) are located. Except for upgrade
time (where the dictionary is busy) and dynamic space allocation (which
should be minimal in a well configured environment), the system tablespace
should be quite quiescent.
Except for sequences! There is currently no routine mechanism to locate
sys.seq$ outside the system tablespace or on a high performance solution
such as solid state drives. Whether this is a performance problem at a
given location is a complex question related to the general need for
placement tuning of your disk farm for maximum parallel performance rather
than the statistical "smear it wide over all drives" approach to avoiding
hot drives. Delivering performance to the objects with high performance
requirements requires placement tuning.
In the case of sequences, unless you engage in extraordinary means at
database set up time, you will have many sequences stored per database
block. So if you're creating a few customers online via the forms you will
probably be okay a lot of the time. But let's say some of the other
internal id sequences such as check ids, payment line ids, and the like are
in the same database block (and they usually are), and a check run is in
progress. All of a sudden you are in competition for this one little
database block containing many sequences. There is potential for widely
varying throughput of seemingly unrelated applications.
Whether or not this is a meaningful performance handicap at a given time at
a given site is a complex mix of workload and overlaps. Using the cache
option on sequences will grant some relief of the potential bottleneck at
the cost of gaps in the sequences when certain events such as unexpected
shutdowns occur.
Good luck
Mark W. Farnham
President
Rightsizing, Inc.
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: Automatic Customer Numbering
I understand if something goes wrong with the system and it shutdown the
instance then we are loosing the sequence number which has a cache( what
ever number loaded in memory) on it. But what about normal shutdown for cold
backup?
Also to get the performance hit and to be ready to have gap in sequence is
80% - 20% ratio.
This is my opinion, Feel free to shares ur's.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
From: "Landa, Mark (c)" U25MIBG@Carlson.com
Subject: RE: Automatic Customer Numbering
Has anyone ever tried to quantify at what point not caching a sequence
causes performance problems and to what extent? As Mark pointed out, it is
not that easy of an exercise. I would say at least for this installation it
is not causing a noticeable difference at this time. In additions, rather
than setting the sequence to nocache, there is also the option of pinning
the sequence using:
"dbms_shared_pool.keep('owner.seq_name','Q')" which will keep the cached
sequence entries from being aged out of the SGA.
From: Kevin Johnson kevin_t_johnson@yahoo.com
Subject: AR: Customers Start Date
This is a question about a Customer Conversion using the standard
Oracle Customer Interface.
Is there any way to use the Legacy system customer start date as the
start date within Oracle?
We have only seen the standard customer interface using the system date
as the start date.
Any help would be appreciated.
From: srmeka@amrion.com
Subject: RE: Customer Interface - Start Date
Hi.,
We are useing Customer information descriptive flex field for this
purpose.
Thanks.,
SrinivasMeka
Subject: AR: changing customer's zip code
Does anyone know if v.11.02 allows the modification of the Zip Code field in the
Customersaddresses (alt region)? I could swear we were able to do this in
10.7SC, but I get an error now when I do this (something about there being open
transactions with this address.....).....ANY ideas?
thanks,
marni baggett
mbaggett@brk.photronics.com
From: cbricker@gfsiinc.com
Subject: Re: AR: changing customer's zip code
The documentation I have is as follows:
Receivables will not let you modify the city, state, county, country or postal
code components of a customer's address if both the following are true:
the system option Allow Change to Printed Transactions is set to No
at least one printed, posted, or applied transaction exists for this
bill-to or ship-to site in Receivables and that transaction has at least one
associated tax line
I hope this helps.
Cathy Bricker
Gear For Sports
From: oracle applications usit-oracle@usit.co.in
Subject: By mistake Customer Merged
Hi all,
My client by mistake has merged two wrong customer, can we again
seperate them by any method, program or backend.
Please help.
thanks & regards
Mahesh Goswami
USIT
From: Steve Bradley sbradley@sprynet.com
Subject: RE: By mistake Customer Merged
I have a SQL script I developed to unmerge AP vendors that were
accidentally merged. My script uses the AP_DUPLICATE_VENDOR table to find
the original merge record and looks for invoices with the same
LAST_UPDATE_DATE as the merge archive record and belonging to the merged
vendor. You are welcome to look at it and see if it could be modified to
work in AR. I believe the RA_CUSTOMER_MERGES or RA_CUSTOMER_MERGE_HEADERS
serves the same purpose in AR as the AP_DUPLICATE_VENDOR table in AP.
Respectfully,
Steve Bradley, CPA
OASIS Consulting Group, Inc.
Office 404-352-8387
Fax 404-609-9856
Pager 888-912-2569
From: Rose Mettler rmettler@mdp.com
Subject: RE: By mistake Customer Merged
Steve,
We are currently using 10.7 SC Prod 16.1. I would be interested in seeing
your SQL script to unmerge AP vendors. We were led to believe by Oracle
Support that this was impossible.
Thanks
Rose
From: Steve Bradley sbradley@sprynet.com
Subject: RE: By mistake Customer Merged
I am not surprised Oracle Support would say you cannot unmerge AP vendors.
They do not approve of direct update of the tables which is what this
script does. I would have told you the same thing a couple of months ago
prior to me developing this script to correct a client error.
Oracle Payables does not keep an audit trail of invoices merged. It does
however keep a list of all the vendor merge records: source and destination
vendors and sites. The trick is to find the invoices related to the vendor
merge archive record. My script does this by using the LAST_UPDATE_DATE of
the vendor merge archive record in AP_DUPLICATE_VENDORS_ALL. This row is
updated by the merge process to show how many invoices and PO_HEADERS were
changed. The merged invoices have the same LAST_UPDATE_DATE as the merge
archive record. This makes it very easy to find the merged vendors.
The only time this will not work is when the invoice has been changed after
the merge process. It will have a different LAST_UPDATE_DATE and therefore
not unmerged. It is highly unlikely that any other invoice with the same
destination vendor/site combination would have the same LAST_UPDATE_DATE as
the merge process and not have been merged. My script changes any
PO_HEADERS affected by the merge error and reactivates the original vendor
site which is disabled by the merge process.
Respectfully,
Steve Bradley, CPA
OASIS Consulting Group, Inc.
Office 404-352-8387
Fax 404-609-9856
Pager 888-912-2569
From: "Packey, Brian" Brian.Packey@psc.bellhowell.com
Cc: "Lenard, Joe" Joe.Lenard@psc.bellhowell.com,
Subject: Customer Merge
A few years ago we implemented Oracle Financials and did a partial
customer conversion at that time. We are currently implementing Oracle
Order Enter, MFg, Service and several other modules and have found it
necessary to reconvert all of our customer base from our legacy systems with
different customer numbers. As a result of open invoices balances, we need
to merge the previous customer records with the newly created records. We
understand how the Oracle Customer Merge utility works but wanted to find a
way to not have to visit the merge screen and enter the information in for
several thousand customers. Has anyone automated this or had a similiar
situation.
Thanks in advance for your help
Brian Packey
Project Summit Conversions & Interfaces Analyst
Bell & Howell Publication Systems Services
Direct Dial (330) 659-1962
Email: brian.packey@psc.bellhowell.com
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: RE: Customer Merge
Brian,
If you are using a character mode version you can use Excel to cut & paste
large amounts of data into any Oracle screens. Its would look something like
this for the customer merge:
ColumnA--------------------Column B----------------------
\NSCM\ZNNo--------Customer's Name to be merged
Column C----------------------------------Column D
Customer's Name to be merged with-----\fq
Column E------- Column F-------- Column G
\fq-------------------\fq-----------------\zp\ss\rn
Moving from one column to the next initiates a 'TAB' effect in the forms and
the '\' backslash commands are exactly the same as if you typed them in the
screen. So \NCCM\ZN is \Navigate Setup Customer Merge \Zone Next and populates
the first column on that zone to 'No'.
This works best with large amounts of data if you load the data details to be
merged in one sheet, and then create a second sheet that has a formula that
concatenates the real data with the Oracle commands.
How much you can cut&paste at once depends on how fast you Oracle sytem is, so
Id try working up to a large amount, like doing a couple hundred at a time. If
you past in too much keystrokes can be lost and it will probably mess up your
data. I usually like to save the \Screen Save until a paste has completed
successfully, but the particular screen you need requires you to save before
moving to the next record. But it wont submit the customer merge until you
change and save the value 'Activate MergeYes' at the end.
Also, I have never tried it but you should be able to load/manipulate data into
the ra_customer_merge_headers (holds the customer's info), ra_customer_merge
tables (holds the address info) and then initiate the from the Customer Merge
screen. Id do alot of testing with this method, comparing the records of those
loaded from your script to those populated through the screen. But since you
arent actually doing the merge yourself, you are just populating the table that
the merge will use when it merges I think it would work okay.
Hope this helps you out!
Amber
--------------------------------
Allen-Sauer Consulting, INC
email: amber@allen-sauer.com
web: http://www.allen-sauer.com
From: =?iso-8859-1?q?sameer=20verma?= samvam11@yahoo.com
Subject: Customer Merge**URGENT***
Hi All
I would like to know what are the precautions to be taken when
merging customers and customer sites if they are located in places
where sales tax is different.
I'll be glad if somebody could list down the steps needed to do the
customer merge.
Thanks
sam
From: rohit.sharma/Polaris@polaris.co.in
Subject: Re: Customer Merge**URGENT***
Dear Sam,
When you are merging customer the purpose of merger is if you have opened
same
customer twice and have invoiced from both the customer site. If the same
customer has two diffre nt ship to sites but both are opened by mistake with
diffrent customers which you want to merge into one. So if ship to site is
diffrent in both Customer then you have to create a new site with the same
address in merge to-customer and map the original site from-customer with
new
created site in the to-customer and merge.
Example:
You have a Customer name ABC with a ship to site having address #123, main
street New York and by mistake the same customer is opened again with the
name
ABCD but its ship to site is diffrent with address 123- Main Street, San
francisco.Butthis actual customer whose name should be ABC is having two
ship
to sites and you have created Invoices in both the customers.If you want to
merge the customer ABCD into Customer ABC and want to keep the transactions
of
ship to site 123- main street San francisco in the same site address so that
you
can charge diffrent location sales tax. In such situation you have first
open a
new ship to site in Customer ABC with the san francisco Address and then map
this ship to site of Customer ABCD with the new created ship to site with
address of san francisco in Customer ABC and then run the merger and in this
case all the transaction of from to address will merge to new address and
you
can keep on working in one Customer name ABC with two ship to sites
pls free free to ask any question with regads to this
Rohit
From: Nirmal Kumar appsdev_99@yahoo.com
Subject: Hi Folks! A doubt on AR.
Hi folks,
How can i identify customers under credit hold?
Which table do i need it look for it?
Could anyone help me on it?
Thank You.
Nirmal
From: kbrown@es.com
Subject: RE: Hi Folks! A doubt on AR.
select * from ar_customer_profiles
WHERE credit_hold ='Y'
Kristie
From: "Brown, Sharon" SBrown@VisualNetworks.com
Subject: RE: Hi Folks! A doubt on AR.
You might want to try the "Orders on Credit Hold Report". It lists all
orders by customer that are on credit hold. I would think the logic would
be similar for placing orders on credit hold as to what is found in this
report.
Thanks,
Sharon
===================
Sharon C. Brown
Application Administrator
Visual Networks, Inc.
(301) 296-2676
SBrown@VisualNetworks.com
From: oracleapps oracleapps@leco.com
Subject: Different Customer Names
Hi,
We are implementing AR on 10.7 NCA. I have a quesiton on setting up
customers in Oracle. We currently have Customers with different Bill-to,
ship-to names(but same customer-id) on our legacy systems. But Oracle provides
for only one customer name for a customer-id. How can we implement this
functionality and carry over our legacy conventions to Oracle ? Is it possible
to implement this functionality without customizations to Oracle Reports ? If
not what all needs to be changed to achieve this. I appreciate any inputs on
this matter.
Thanks for your help,
Fran Nelson,
fran_nelson@leco.com
From: "Mandadi, Harish" HMandadi@obiwan.intecom.com
Subject: RE: Different Customer Names
I think one customer can have multiple addresses.
Hope this helps!!
Thanks!
-Harish
From: Letitia Pryor Letitia.Pryor@Central.Sun.COM
Subject: Re: Different Customer Names
Fran,
I have worked at three places now that use the first line of the address
(ra_addresses.address1) for the customer name. If the name was the same,
then they still entered it on the first address line. If you choose to do
this, then you would need to modify reports the reference the address lines.
At the very minimal you would have to modify all reports going to external
customers, i.e. Invoice Report, Statements, Dunning Letters....
Hope this helps. Letitia Pryor Sun MicroSystems 303.272.6837
Subject: Re: Different Customer Names
Date: Mon, 28 Jun 1999 10:18:07 -0400
Fran,
Our company does exactly what Letitia describes in her email. We have a custom manufacturing
system that uses the AR Customer Master File & a custom, SigForms, Invoice print-program
(actually, we now have an HTML invoice print program that our IS dept wrote). All programs
look to the first line of the address for the Customer name (for orders, invoices, etc.).
Marni Baggett
Photronics, Inc.
mbaggett@brk.photronics.com
From: "Jed W. Petrovich" jwpetrov@uswest.net
Subject: Invoice question
Hello:
I'm wondering if anyone has done this...
I need to be able to run invoices so that "related" customer transaction
appear on the same invoice. Is there a set up rule for this or would this
require a whole new custom invoice? For example:
***
Invoice
Bill to: Customer A
1 Customer A - Monthly fee $100.00
2 Customer Aa - Monthly fee $150.00
3 Customer Ab - Monthly fee $100.00
***
In the above example Customers Aa and Ab are related to A. Also, all
customers have a different customer number. The format above is just an
example. The exact format is not as important to me as getting the billing
information combined on one invoice.
Thanks,
Jed
From: cayetano@us.ibm.com
Subject: Re: Invoice question
This may help...
Try using the batch source name field to distinguish your different transaction
types.
We are in the process of creating an interface that will handle this and other
situations. We use the batch source name field to identify transactions of the
same type and source them together into a holding table. At month-end, an
invoice is created by processing all transactions with the batch source name
specified.
Josie
Josie Cayetano, Consultant
Cayetano@us.ibm.com
IBM Oracle Consulting Practice
(704) 596-0462
From: "Jed W. Petrovich" jwpetrov@uswest.net
Subject: Changing Customer Profile Class
Hello:
I have noted that when I create a new customer using the "Customer -
Standard" form, I am allowed to select a "Profile Class" under
Classification. However, when I save the customer information and then try
to change the Profile Class, I get the "Field is protected against update."
message. Is there a way to change this or is it really set in stone?
My concern is that we are going to be using Customer Numbers that are
assigned by another entity. If one of the users enter a new customer and
number and then save with the incorrect profile, this could be a real
problem. Anyone else had problems with this?
Thanks,
Jed
From: Chuck Shaw cshaw@keystonefoods.com
Subject: Re: Changing Customer Profile Class
Jed:
You can correct profile classes in the maintain customer profiles
screen. The path in 10.7 character is Navigate Setup Customer Profile
Maintain.
Hope this helps.
From: Patty Phelan patty.phelan@jmedpharma.com
Subject: AR: Customer Calls
Intermittantly, several of my users have experienced problems saving
notes under the "Customer Calls" screen. It seems to be occurring more
often recently is is very annoying if they have entered a lot of data.
They receive the following message:
FRM 40735 - Trigger raised unhandled exception no data found.
They cannot save the info. I thought it might be the trailing blanks
problem, but I can't verify. Since I can't recreate this problem on
demand, Oracle is not much help. We are on version 10.7 SC 16.1 with
Oracle 7.3.3.5 (Solaris). Patch levels are AR-Q and OE-G. Any ideas?
Thanks,
Patty Phelan
Director Infomation Technology
From: Tina.Thousand@weac.com
Subject: Re:AR: Customer Calls
Patty
We have experienced similar errors when users are trying to overwrite an
existing contact.
To avoid this problem... users should first attempt to select a
contact name from the pick list (LOV). Users do this to avoid
attempting to overwrite an existing contact. If name does not exist
on the pick list (LOV) then the user can type it in.
Hope that helps!
Tina Thousand
Ernst & Young, LLP
christina.thousand@ey.com
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: New profile option in OA financial rel. 11.03
Hi,
Does anyone know what the following profile option means on rel. 11.03:
Tax: Use Tax PL/SQL Vendor
we don't have any documentation for it.
-- Suzie Roth
MIS (Ext. 7151)
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: New profile option in OA financial rel. 11.03
Hi,
As far as i know it is related to the Tax vendor extensions.The system
option Tax vendor in ar also decides this.
There is a .pdf file called Receivables Tax manual in rel 11 u can go thru
that to get inputs on Tax vendors.Basically when Tax gets calculated in AR
it is thru a tax engine this enjgine first checks whether a tax vendor
exists or not if no then it uses the AR tax rates.If an external vendor
exists then the data for this vendor is stored in views which are precisely
Vertex,Oracle,etc.This is what I could gather .Rest u can go thru the Oracle
Receivables Tax manual.pdf file.
Regards,
Sunil Wahi
From: deepa sood dsood@us.oracle.com
Subject: Customer Interface
Hi All,
I had a question on Customer Interface.
Is it possible to use the customer interface to update customer
information in Oracle.
Thanks,
Deepa
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: Customer Interface
Yes.
the column insert_update_flag in ra_customer_interface_all is for
this purpose. Set it to 'U'.
From: deepa sood dsood@us.oracle.com
Subject: Re: Customer Interface
Can you also update items using the Item import ?
From: "Halcyon" jimll@halcyon.com
Subject: Re: Customer Interface
Yes,
Check the open interfaces manuals because not all the fields are updatable.
Jim Leavitt