rvtptcontrol failed
Date: Thu, 9 Sep 1999 17:52:07 -0400
From: Cavazos Fausto-FFC007 Fausto.Cavazos@motorola.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: PO: Help required! rvtptcontrol failed-
PO gurus,
After saving a receipt transaction the following message appears on the
screen and the transaction does not get registered.
rvtptcontrol failed-
Has anyone come across something similar?
Your help is appreciated.
(And YES, OWWS is working on it...)
Thanks.
Fausto
Date: Thu, 9 Sep 1999 15:09:35 -0700
From: "Borra, Sravanthi" SBorra@dreamworks.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Help required! rvtptcontrol failed-
I work on 10.7NCA.I encountered the same error when i trying to enter some
transactions in the enter receipts window.
i entered a transaction for an inventory item since we dont implement
inventory module this error occured. Once we changed the inventory item to
non_inventory items no errors were encountered during the transactions
Thanks
Sravanthi
Date: Fri, 10 Sep 1999 16:37:55 -0500
From: "MCAVOY, Brian J." bmcavoy@shl.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Help required! rvtptcontrol failed-
Check to see if the receiving manager is running.
Brian McAvoy
Consultant
EDS
Client phone # 973-491-8614
Date: Sat, 11 Sep 1999 11:11:44 -0400
From: Cavazos Fausto-FFC007 Fausto.Cavazos@motorola.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Help required! rvtptcontrol failed-
The receiving manager is running.
The weird part about this problem is that they have been receiving
without a problem for about a year.
We are going to load some patches we got from OWWS.
Date: Sun, 12 Sep 1999 14:19:29 +0700
From: "Nagamohan U." umohan@irs.co.id
To: oraapps-l@cpa.qc.ca
Subject: RE: Help required! rvtptcontrol failed-
Hi
This error is a result of a number of reasons based on the transaction being
performed. More info is needed to get this problem resolved.
1. At which transaction this error appears? Receiving or Delivering?
2. Is the PO's destination Inventory or Expense?
3. Please check whether there are records in the CST_ITEM_COSTS and
CST_ITEM_COST_DETAILS tables for the item(s) for which the PO has been
raised?
4. If there are records, what is the value for INVENTORY_ASSET_FLAG in
the CST_ITEM_COSTS table?
5. See to it that there are no problems with the UOM of the item code
for which this transaction is being made.
6. Check the RCV_TRANSACTIONS_INTERFACE for records stuck because of
errors.
We have been facing and are facing this problem for quite some time now.
1. First because of some problem, when we load the items through
interface, records into the cost tables are inserted. If they are inserted
the Item_cost field remained null. Or there was some problem with the
inventory_asset_flag field in the table. WE had to apply a small server
patch (an insert statement) to solve this problem. With this we thought this
will not occur again.
2. But recently there was one more case reported. One item was received
and delivered to one locator against a PO. Later the quantity has been moved
to other locator. Now the users are trying to correct the transactions made
against this PO. This error pops up because there is no quantity left in the
locator to which quantity was originally delivered.
3. One more case is that the PO was made in one UOM other than the
Primary UOM. At the time of making the PO, conversion exists between these
UOMs. But later that has been disabled. After the conversion was disabled,
users were trying to perform the receipt transaction. Error pops up.
4. We are in the middle of solving another problem. Receipt is made,
but the material is rejected. Now I want to return the material to Vendor.
For no reason this error pops up. Similar transaction is working fine in
training database. But gives error in the Prod. Database. Yet to find a
solution.
So the lesson is it depends on a number of factors which are some times
unique each time. Have consider the PO, Item in the PO, UOM of the PO,
account codes in the PO, destination of the PO, cost if the items, locator,
records in the RCV_SUPPLY table, receiving transaction manager etc., etc.,.
If you still have any problem you can feel free to contact me.
Hope this helps you.
Regards/Nagamohan
Date: Sun, 12 Sep 1999 07:09:36 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Help required! rvtptcontrol failed-
Hi!
Have you done any changes to the flexbuilder for purchasing? We encountered
the same problem when we made changes.
Ravi
Date: Sun, 12 Sep 1999 22:23:48 -0700 (PDT)
From: kartik iyer mukul061292@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: PO: Help required! rvtptcontrol failed-
Dear Fausto,
Have you tried with the Material transaction manager
running again? If not try this, should work .
Thanks
Kartik
Relicon Dubai
Date: Mon, 13 Sep 1999 10:48:13 -0400
From: Mary Anne MacLeod mmacleod@mcgh.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: PO: Help required! rvtptcontrol failed-
This required a patch to correct - our DBA applied and it solved our
problem. We are 10.7 NCA
Mary Anne MacLeod
MCGH Oracle Project Coordinator
Date: Mon, 13 Sep 1999 11:07:24 -0400
From: Cavazos Fausto-FFC007 Fausto.Cavazos@motorola.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Help required! rvtptcontrol failed-
Thanks to all for your answers.
After trying some of your suggestions we were not able to fix the problem,
so we decided
to load the MiniPack to upgrade to 11.0.2 (The application was 11.0.1
......)
That solved the problem. (At least for now) but I'll keep in mind your
suggestions in case this happens again in the future.
Thanks Again.
Fausto Cavazos
Query of Requisition thru PO - problems in
Date: Mon, 13 Sep 1999 17:43:47 -0500
From: "Raman, Binoy" braman@usa.capgemini.com
To: oraapps-l@cpa.qc.ca
Subject: AP/PO : Requisition Lines
I am trying to check if this is standard functionality or a bug or a setup
problem. We
are on Rel 11.0.2
We have Requisitions auto-created to POs and AP Invoices matched to the POs.
This is the
problem :
Inquire a PO matched invoice using Invoice Overview (APXIWALL), click 'View
PO' button. This
opens up the PO Inquiry form (POXPOVPO) with the shipment matched to the
invoice. Click
on 'Special' menu, all sub-menus are disabled.
Inquire the same PO Number using the Inquire PO (POXPOVPO) form directly,
check the 'Shipments' radio
button in the Results. Now under the 'Special' menu, the 'Requisitions'
sub-menu is enabled. There are
other sub-menus enabled also.
The restriction is that we cannot 'jump' from Invoice to Requisition, we
have to open up the PO form, enter
the PO Number and go to Requisitions. The responsibilty that I am using has
capability to inquire
POs, Releases,Reqs, RFQs and Quotes, so execute privilege on the associated
Functions do not
seem to be the problem.
I tried forcing the 'Requisitions' (SPECIAL8) to be ENABLED using
CUSTOM.pll, it works, i.e. I can navigate to
the Requisitions from Invoice Overview thru View PO. So this CAN work if
enabled.
Does anyone have a solution ? Is this standard functionality ? Oracle
Support says this is standard functionality.
Binoy Raman.
Taxes in PO
Date: Tue, 14 Sep 1999 10:26:29 +1000
From: Ruby Khaw r.khaw@qut.edu.au
To: Ross Gorham oraapps-l@cpa.qc.ca
Subject: Taxes (GST) in PO and Payables
Hello all
I am conducting preliminary tests on the tax functionality in Oracle
Purchasing rel 11.0.2 in preparation for the introduction of GST. I have 2
questions (so far!):
(1) When a PO is raised, the system does not calculate a separate line for
tax even though the goods or services is to be input-taxed (the appropriate
tax name is defaulting at the Purchase Order shipment level. Is this how
the system is meant to work i.e. no entries are created for taxes?
(2) In Payables, when matching an invoice against PO, I cannot get the tax
name to default from the tax name default "PO for Matched Invoice" but I
can get the tax name to default from "Financials Options". What have I done
wrong?
TIA
Regards,
Ruby
LOV for item field not available
--- Jennifer Knice JKnice@cerbpyro.com wrote:
Hello all,
I am using purchasing Release 11.0.2 and I was
wondering if anyone had
experienced the following: When I navigate into the
Item field at the
requisition line of PO line level, I am not able to
invoke an LOV (i.e. the
icon is available, Ctrl + L returns an error, etc.).
Items are defined
correctly because I am able to type the item number
and get all the
associated fields to populate. Does anyone have any
thoughts?
Jennifer Knice
Date: Mon, 4 Oct 1999 06:17:31 -0700 (PDT)
From: kartik iyer mukul061292@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: LOV not available for item field on requisition or PO
DERA Jennifer,
Check if the items are assigned to the
organisation you are creating po FOR.
Thanks,
Kartik ,
Relicon, Dubai
Date: 11 Oct 99 16:58:28 MDT
From: vv vv venvivek@usa.net
To: oraapps-l@cpa.qc.ca
Subject: Re: [LOV not available for item field on requisition or PO]
Hi.
Is that happening to the Vanilla oracle or ur doin any customization on that.
Please let me know. So i can help U.
Regards.
Vivek.
Purchase price other than List Price
Date: Tue, 05 Oct 1999 22:07:53 GMT
From: bbain@ec.rockwell.com
To: oraapps-l@cpa.qc.ca
Subject: PO: Blanket Purchase Agreements
I am having a problem with list price and blanket purchase agreements.
We are running 10.7 SC GUI version.
In attempting to create a blanket purchase agreement, the list price for an
item is being pulled from the item master record. In some cases, the list
price may need to be changed on the purchase agreement. I can change the
price, save the record, approve the purchase order and everything looks
fine. However, when I go back to view the order, the price has defaulted
back to the original list price. I know that I can change the list price
on the item master record and then create the blanket agreement, however
this does not solve the problem. Has anyone had this problem before and
help me out with the solution?
One other issue regarding blanket agreements - in Oracle character, when an
agreement was created, the total value of that agreement (the unit price
multiplied by the quantity agreed) was displayed on the order header. In
this GUI version of Oracle the total is being displayed as 0. Is this
correct or do I have another problem?
Appreciate any feedback anyone can give me.
Beth
Beth Bain
IT/Business Process Re-Engineering
Forward PO programmatically
Date: Wed, 6 Oct 1999 15:28:34 -0500
From: ramesh_subramanian@dresser-rand.com
To: oraapps-l@cpa.qc.ca
Subject: Reg : Function to forward PO Document
Is anybody can help me out to find the Oracle function to forward a PO
document
? I am trying to automate the process of forwarding a PO document through
program instead of doing from PO form manually. We are using ORACLE APPS
11.0.2.
Thanks in advance
Ramesh.S
Order Number for a Purchase Requisition
From: prince suthakar [SMTP:prince_sutha@hotmail.com]
Sent: Friday, October 15, 1999 10:56 PM
To: Multiple recipients of list
Subject: order num from PR
Hello,
How do i get order number for purchase requisition?
TIA
prince
Date: Sun, 17 Oct 1999 15:27:59 -0400
From: Steve Harper steve.harper@pragmatek.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: order num from PR
If you are asking about the order number for a dropship purchase req, the
data is in a table: SO_DROP_SHIP_SOURCES. It relates all of the
information from the original Sales Order through the Purchase Req and
Purchase Order.
Steve Harper
PRAGMATEK Consulting Group, Ltd.
Vendor Interface to PO
From: Mr A.Sasidhar [SMTP:coolsasi@usa.net]
Hai All,
I am doing vendor interface to PO.
I any body done this before,Can u share the scripts.
Or is there any site where such scripts are dumped .
Thanks in advance.
sasi
Date: Mon, 18 Oct 1999 10:52:38 +0200
From: Nimrod Bar-Guy brnimrod@pcit-ltd.co.il
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Hi sasi,
we did it few tims on different sites, using SmartDB.
this is good tool using for data migration.
Nimrod
TM-SVC Lock Handle Failed
From: DIPANKAR BASU dipankar_99@yahoo.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Sent: Friday, October 15, 1999 6:49 PM
Subject: Purchasing Receipts Problem : Technical
Hi everybody,
We are in the process of installing R11.0.3 In
Purchasing module Receipts function, we are getting
the following error :
APP-00204: Concurrent Manager encountered an error
while running the spawned concurrent program.
Receiving Transaction Manager - RCVOLTM for your
concurrent request 7. TM-SVC LOCK HANDLE FAILED.
Has anybody encountered this problem before? Any help
appreciated.
TIA
Dipankar
Date: Mon, 18 Oct 1999 09:07:44 -0700
From: "Cris" cmcintyre@email.msn.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Purchasing Receipts Problem : Technical
Check to see if the Receiving Transaction manager is running.
Cris
Purchase Order Summary - Second Query on
From: Bruce Overway [mailto:Bruce.Overway@haworth.com]
Sent: Wednesday, October 20, 1999 11:42 AM
To: Multiple recipients of list
Subject: General Purchasing Question
Hi. I'm new to the list, and thought I'd ask a question that's been
nagging at me since we implemented Apps six months ago...
I have a question re: the way Purcase Order Summary (POS) works. My
understanding is that POS inquires are good for one query only. Once you
get the info you are looking for, you need to back out of all the POS
forms and start all over from Navigator if you have another inquiry. This
(to me anyway) seems ludicrous. I've been told by Oracle Support that
this is functional?!?! Is the way things are supposed to be? Do things
get better w/R11x?
Thx.
Date: Wed, 20 Oct 1999 14:02:18 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: General Purchasing Question
This is not exactly true. By the way we are running 10.7 SC so that will be
my point of reference. After you have performed your first inquiry whether
it be headers, lines or what have you...all you need to do is back out to
the Find Purchase Orders screen and use the clear record button in your tool
bar. This will allow you to perform your next inquiry. We have never had to
go all the way out to the navigator. Hope this helped.
Date: Wed, 20 Oct 1999 15:24:42 -0400
From: "Bruce Overway" Bruce.Overway@haworth.com
To: oraapps-l@cpa.qc.ca
Subject: RE: General Purchasing Question
Thanks for your answer Mike.
Sorry I didn't provide release info. We are running 10.7 NCA. The way
you are doing it is the way I would expect it to work. Maybe I need to
contact Oracle Support again.
Date: Wed, 20 Oct 1999 12:49:05 -0700
From: Karen Blackwell KBlackwell@rockshox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: General Purchasing Question
We are also on 10.7NCA and I just took a look at this function. It works (on
my system) the way you would expect it to. Once the initial query is
complete, you can return to the Find form, press the clear button and then
provide the information for the next query. We are on Patch Set G of PO
if that helps at all.
HTH
Karen
Date: Wed, 20 Oct 1999 15:40:41 -0400
From: Darlene_D_Dougherty@CORP.CNG.COM
To: oraapps-l@cpa.qc.ca
Subject: RE: General Purchasing Question
We too are on 10.7 , I query other purchase orders via uttilizing the
flashlight ability,, make sure your cursor is on the po number , hit the
flashlight on the menu,, enter the new p/o number and viola.
Date: Wed, 20 Oct 1999 15:29:06 -0700
From: "Cris" cmcintyre@email.msn.com
To: oraapps-l@cpa.qc.ca
Subject: Re: General Purchasing Question
Bruce,
You can put yourself in query mode at any place in the summary. If you want
the lines for a specific PO go to the lines screen, enter query, put in the
po and run query.
Hope this helps,
Cris
Date: Wed, 20 Oct 1999 22:12:00 -0700 (PDT)
From: kartik iyer mukul061292@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: General Purchasing Question
Bruce,
When you come to the PO summary screen you can
select the required PO and open it by pressing the
open button in the same screen .After finishing with
this po you can close the PO and the control is back
to the summary for you to choose another PO .This is
the way the Summary screen works.
Thanks,
Kartik
Date: Thu, 21 Oct 1999 12:30:17 +0700
From: "Nagamohan U." umohan@irs.co.id
To: oraapps-l@cpa.qc.ca
Subject: RE: General Purchasing Question
Hi
You have four more screens after entering the PO in the Find screen.
Headers, Lines, Shipments, Distributions.
In all these screens you find the PO number field. You can press F7 in any
of these four screens and enter PO and press F8. It will query only that POs
information in that relevant screen.
Regards/Nagamohan
Thursday, October 21, 1999
Date: Thu, 21 Oct 1999 11:07:03 -0500
From: "Magnuson, Todd" magnusont@FairbanksMorse.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: General Purchasing Question
Hi Bruce,
Welcome aboard. The problem that you describe is very familiar. I have had,
and still have difficulty with the same issue. We did find that the problem
only occurs when the user has a "folder" defined. When I removed the folder
we could go back to the "find" screen and bring up a different (or the same
record) again. We still need resolution on the problem as the folder tools
are very helpful to customize the presentation of the results. I thought we
had a tar open, but I can't seem to find it today. Please let me know if you
find that your problem is also isolated to users with folder tools defined.
HTH
Todd Magnuson
Date: Fri, 22 Oct 1999 07:17:57 -0400
From: "Bruce Overway" Bruce.Overway@haworth.com
To: magnusont@FairbanksMorse.com
Cc: oraapps-l@cpa.qc.ca
Subject: RE: General Purchasing Question
Bingo! I also have Folders defined. When I remove them, things are back
to the way I would expect. I have since recommended our users remove any
saved Folders they may be using. I will also contact Oracle Support again
to log a TAR.
Thanks Todd!
Date: Fri, 22 Oct 1999 08:42:53 -0400
From: Steve Harper steve.harper@pragmatek.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: General Purchasing Question
Hi Bruce and Todd,
If the problem occurs only when there is a user-defined folder, check what
AutoQuery settings your users are saving the folders with. When you define
a folder you can save it in one of three settings:
1) Always -- automatically execute the same query whenever you retrieve the
form
2) Never -- don't execute any query automatically
3) Ask Each Time -- prompt the user. This is the default, but users may
fly right past the prompting screen, so are automatically executing the
same query over again.
The solution is open the folder, make some type of change, and do a Save As
to force the Autoquery option to reappear.
Hope this helps.
Steve Harper
PRAGMATEK Consulting Group, Ltd.
From: tom prado-irwin [SMTP:tprado-irwin@Quark.Com]
Sent: Friday, October 29, 1999 12:49 PM
To: Multiple recipients of list
Subject: Customized folders problem fix
I have discovered that whenever I saved a folder that was customized
using
the folder tools I was inadvertently saving the currently active
query as
well. Resetting the folder query as the last step before saving
changes
seems to have eliminated the problem. Now my Purchasing Summary
custom
folders are working properly.
Date: Sat, 30 Oct 1999 07:14:45 -0500
From: "Magnuson, Todd" magnusont@FairbanksMorse.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Cc: "'Bruce Overway'" Bruce.Overway@haworth.com
Subject: RE: Customized folders problem fix
Tom,
Thanks much - Good Fix. I tried this and it also fixed the problem for me. I
thought that the "Auto query - Never" setting should do the same thing (as
it does in other modules), but your fix works just fine.
Thanks again,
Todd Magnuson
PO approval - FRM-40735 error
Date: Wed, 20 Oct 1999 11:43:59 -0500
From: Tom Wyatt tom.wyatt@sitel.com
Subject: Purchase Order Forms and Approvals
Has anyone had a problem with receiving a FRM-40735 error when initially
going into the Purchase Order Form? The application allows me to enter my
PO line, but then upon approval, I receive yet another error which is
FRM-41015 cannot find item...Invalid ID??? Has anyone experienced either of
these problems?
We are on version 11.0.3 of the application.
Date: Wed, 20 Oct 1999 22:22:41 -0700 (PDT)
From: kartik iyer mukul061292@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Purchase Order Forms and Approvals
Dear Tom,
Check the following:
1.Approval groups
2.Approval assignments.
3.The Buyer as an employee definition
4.Position for the Employee/ buyer
5.Document types assigned to the Buyer in the
assignment and try aproving.
6.Position hierarchy.
In case you need more help ask me.
Thanks,
Kartik
Buyers - defining
From: fariha afreen fafreen@ora-tech.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Sent: יום שני 25 אוקטובר 1999 12:00
Subject: Defining Buyers
We are on release 11.
When we click buyers screen, the following message appears:
APP-14142: get_po_parameters_10 : ORA-01403: no data found.
When we say OK to this message,the screen opens but the employess
defined in do not come in the LOV.
I guess we are missing some basic setups. Any idea???
Also, the Approval Assignment screen does not open & the following
message appears:
APP-01388: Cannot read value for profile option AFLOG_MODULE in routine
&ROUTINE
Cause: You attempted to read a profile option that either does not exist
or was set to be not readable.
Any help would be highly appreciated!!!
Thanks,
Fariha
Date: Mon, 25 Oct 1999 14:59:53 +0200
From: "Gilad A." gilade@rafael.co.il
To: oraapps-l@cpa.qc.ca
Subject: Re: Defining Buyers
1. check that in your responsibility, the MO:Operating Unit profile option
is defined.
2. fill the financial options ( especially, the Business Group ) in
Purchasing-Setup-Organizations-Financial Options.
Let me know if that works.
Gilad.
Charge Account - posting directly to
From: DIPANKAR BASU [SMTP:dipankar_99@yahoo.com]
Sent: Tuesday, October 26, 1999 8:57 AM
To: Multiple recipients of list
Subject: Purchasing/AP
Hi Gurus,
We are in the midst of an 11.0 installation. Even
though we have defined a Charge Account and a AP
Accrual account in PO, the final accounting in GL
after the entire Purchasing cycle reads :
Dr. AP Accrual Account
Cr. Cash
whereas what we want as final is obviously
Dr. Asset/Expense
Cr. Cash
Is there a profile option we are missing, which is why
the accounting entries are taking effect from AP
onwards and not from PO?
Any help appreciated.
TIA
Dipankar
Date: Tue, 26 Oct 1999 13:43:52 +0930
From: "Irani, Kermiz" Kermiz.Irani@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Purchasing/AP
Looks like you are missing the receipt GL transactions. Have you done the
receipt? Is the Receipt accrual option set to Perpetual or period-end?
Rgds,
Kermiz.
Date: Tue, 26 Oct 1999 11:32:46 +0700
From: "Nagamohan U." umohan@irs.co.id
To: oraapps-l@cpa.qc.ca
Subject: RE: Purchasing/AP
Hi Dipankar
Try doing the distribution level matching. Then automatically charge account
given in the PO will come to the invoice distributions.
You have to enable this option in the Set Up options of the payables.
Regards/Nagamohan
Tuesday, October 26, 1999