Cancel Shipment problem
Date: Thu, 24 Jun 1999 07:59:51 -0400
From: "Brown, Sharon" SBrown@VisualNetworks.com
Subject: Purchasing Cancel Shipment problem
Hey PO Gurus,
Yesterday our NT system went down unexpectedly (no surprise there)! Anyway,
one of my buyers was in the middle of a cancel remaining on a shipment
operation. The cancel took for the shipment. I can look in the
po_line_locations table and all looks OK. However, the outstanding and
unreceived distribution for the shipment does not show that it is cancelled.
We can not re-approve the PO because of course the distributions do not
match the shipments.
In the past (many times), I have just updated the quantity_cancelled field
and the gl_cancelled_date to reflect the cancel operations. This seemed to
work at my old job (10.7 character). However, it has not worked here (10.7
NCA GUI). The distributions still show up even when they have been reset as
cancelled. Am I missing something else here??? We do have the additional
burden of inventory steps. Is there something I need to do there??? Any
suggestions???? Maybe I need to reset the shipment and recancel???
HELP!!! .... It is quarter end and my users are frantic.
Thanks,
Sharon
===================
Sharon C. Brown
Application Administrator
Visual Networks, Inc.
(301) 296-2676
SBrown@VisualNetworks.com
Missing PO Total cost
Date: Thu, 24 Jun 1999 08:15:35 -0400
From: "Schmidt, Bob" bschmidt@AAFINTL.com
Cc: "Cundiff, Wanda" WCUNDIFF@AAFINTL.com,
Subject: PUR: Missing PO Total cost
Morning all !!
We are experiencing a problem where POs are entered and the item
extended price is not adding to the total PO cost as displayed on the
screen. When you print the PO it looks OK as the total (I presume) is
calculated by the PO report. When items of this type are received, the
transaction register and the AP screen indicate $0.00 for the unit
price. It also appears that the approval process is dictated by this
calculated PO total within the PO form and thus allows persons to
approve POs that are well below their approval limit. Has anyone else
seen this? Do you know of a fix? 10.7 SC / Windows NT 4.0 / Win 95
clients.
Thanks
Bob Schmidt
bschmidt@aafintl.com
EDS
502.637.0446
502.637.0520 (F)
Date: Thu, 24 Jun 1999 17:20:22 -0500
From: Mike Dennis mdennis@mdp.com
Subject: Re: PUR: Missing PO Total cost
We've experienced this on some of our purchase orders as well. We seemed
to pin this down on autocreated purchase orders when the buyer removed
and/or changed the need by and promised dates. This would change the
extended price on the shipment screen to zero. To fix the problem on a
specific purchase order, we did the following: change the quantity or
price, save the change, change the quantity or price back, save the change,
and then re-approve.
Mike Dennis
Meredith Corporation
mdennis@mdp.com
Date: Fri, 25 Jun 1999 07:59:02 -0400
From: "Schmidt, Bob" bschmidt@AAFINTL.com
Subject: RE: PUR: Missing PO Total cost
We have tried similar approaches. If we change an item and save, the PO
total on the screen is correct. However, when we approve it, the total
goes back to zero (or some number less that what it should be). I
thought it might have something to do with the distributions but I
haven't gotten any deeper with it.
Thanks
Bob Schmidt
bschmidt@aafintl.com
EDS
502.637.0446
502.637.0520 (F)
Date: Tue, 13 Jul 1999 09:04:50 -0400
From: "Schmidt, Bob" bschmidt@AAFINTL.com
Subject: RE: PUR: Missing PO Total cost
I also received this from Oracle Support:
"I have located a one-off client patch for bug 800041 which allowed a
blank unit price on a PO line and the purchase order to be approved with
a line where there was no price (no value). The header Total amount of
the Purchase order was not updated after the change of this wrong price.
(This is fixed in 16N). A one-off patch 806880 is available for 16L.
I have put patch 806880 on the ftp site at:"
Thanks
Bob Schmidt
bschmidt@aafintl.com
EDS
502.637.0446
502.637.0520 (F)
Receipt Traveller very slow
From: Larry L. Leser [SMTP:llesser@iquest.net]
Sent: Thursday, April 08, 1999 7:20 AM
Subject: Receipt Traveller
Has anyone had any trouble running the "Receipt Traveller" in 10.7
character.
We have the system set to run a receipt traveller when items are
received, but it runs for over 12 hours. Oracle support has been trying
to figure this one out for almost 4 weeks now, with no success.
Help is appreciated.
Date: Thu, 8 Apr 1999 09:24:35 -0500
From: "Vicha, Curt" vichac@Jostens.com
Subject: RE: Receipt Traveller
"Receipt Traveller" has one of the largest view in all of Apps
(RCV_DISTRIBUTIONS_PRINT), If your SHARED_POOL size in SGA is not very
large it will cause it to be parsed many times. Have seen it take 2-4
minutes to be parsed on a large HP with lots of memory, but many users that
bumps it out of SHARED_POOL (was using 4 cursors of 2-5mg each).
Requisition Import and Dynamic Insertion
Date: Wed, 1 Sep 1999 09:41:26 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: PO: Requistion Import and Dynamic Insertion
All, in 10.7 Dynamic Insertion is not included/enabled
with the PO Requisition Import.
Does anyone know if it included in R11?
Andy Schindler
NRC, Inc
Requisition Hold for pricing
Date: Wed, 1 Sep 1999 16:37:55 -0400
From: "Bill Keenan" billek@ccai.net
To: "Oracle Forum" OraApps-L@cpa.qc.ca
Subject: Requisition Hold for pricing
Hi,
Can anyone tell me if it is standard functionality if a requester puts a
requisition on hold, that a notification is sent directly to the buyer
alerting the buyer to price the requisitions item. It seems that this would
be something that the workflow manager could accomplish, correct? If so,
would you consider this a customization to the requisition approval workflow
process?
Thank you in advance for your help!
Annette
Requisition - not accepting Combo
Date: Tue, 7 Sep 1999 05:51:36 -0700 (PDT)
From: kartik iyer mukul061292@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Purchase requisition
While creating requisitions the following error occurs:
Choose an existing combination.
The procedure which was carried out for creating the requisition
was as follows:
1. The requisition menu was clicked and form comes up
2.Then the Supplier and site was entered.
3.A description was given for the requisition
4.The item was selected and the quantity were entered
5.The need by date was given
6.The organisation was given
7.The location was given
8.The subinventory was given.
When the distribution button was pressed the error occured
Even when tried to save, the same error occured.
Can anyone suggest what is meant by choose an existing combination?
It is urgent. The history also gives the same message ie "Choose an
existing combination."
Thanks
Regards,
Kartik
Consultant, Relicon, Dubai
Date: Tue, 7 Sep 1999 08:01:28 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Purchase requisition
Check the Category that was selected.
Date: Tue, 7 Sep 1999 20:16:23 +0700
From: "Nagamohan U." umohan@irs.co.id
To: oraapps-l@cpa.qc.ca
Subject: RE: Purchase requisition
Hi Kartik
When you select the item the category also gets defaulted in the Requisition
lines.
This error occurs when the category that is defaulting is not there in the
default category set attached to the Purchasing in Inventory.
Just go to the Category Set in Inventory (\setup\items\category sets) and
call the default category set attached to Purchasing. Add the Category that
is defaulting in the requisition for that particular item to the Category
set.
This should solve your problem.
Regards/Nagamohan
Date: Tue, 07 Sep 1999 09:50:52 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Purchase requisition
Dear Karthik,
I do not remember the exact cause. But it relates to either Item Flexfield
in Purchasing or Item Categories flexfield in Inventory.
Prasanna Jena
Date: Tue, 07 Sep 1999 14:27:24 -0500
From: Carolyn Walker cwalker@mdp.com
To: oraapps-l@cpa.qc.ca, mukul061292@yahoo.com
Subject: Re: Purchase requisition
It sounds like you selected an item from the item catalog. When this item
was entered in the catalog, was an expense account assigned to that item.
If so, check the expense account and make sure it is enabled and that it is
an existing combination.
Date: Tue, 7 Sep 1999 14:54:46 -0700 (PDT)
From: Jay Patel-ERP Consultant jpmrp@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Purchase requisition
Karthik,
Also, check to see if dynamic insertion is "on" in G/L, if it is not,
you are not allowing dynamic building of account numbers, therefore
when flexbuilder builds account numbers for requisitions (there are 3
or 4), based on your rules it may be building an account number that
does not exist and therefore possibly gives you the error you
indicated.
Hope this helps...
Jay
Date: Tue, 07 Sep 1999 18:52:20 PDT
From: "siddharta ganguly" pintu_100@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Purchase requisition
Hi Karthik,
I faced the same problem earlier and solved it with the help of one of this
forum member. Please check whether the category of the item, which u r
choosing in the Requisition, is present in the Category Set (Setup - Items
- Categories - Category set) window. It seems weird; but it really doesn't
matter whether u have ticked the 'Enforce list of valid categories' checkbox
on or not.
Hope this will help you.
Jayanta K. Bhattacharyya.
Date: Thu, 9 Sep 1999 01:25:24 +0300
From: Nasir Valiya Valiya@NGHA.MED.SA
To: oraapps-l@cpa.qc.ca
Subject: RE: ORAAPPS-L digest 3646
Please check the Category you entered in the requisition. This error
message "Choose an
existing combination." normally pops up when the Item category combination
on the requisition is an inactive, not defined, non existing one.
Nasir V
Patchset N error on applying
Date: Wed, 8 Sep 1999 18:31:48 +0700
From: "Nagamohan U." umohan@irs.co.id
To: oraapps-l@cpa.qc.ca
Cc: "Srivastava Pradeep (Path)" pradeep@irs.co.id,
Subject: PO: Patch Set N Patch#864603
Hi all
We tried to apply the patch set N in PO to fix a problem in requisition
template. But at the time of applying the Patch#864603 we encountered the
following error.
Start time for statement below is: Wed Sep 08 1999 12:35:06
begin ad_inst.do_apps_ddl(:a, :b); end;
Schema is "PO", SQL statement is:
GRANT ALL ON PO.PO_REQ_DIST_INTERFACE_ALL TO APPS WITH GRANT OPTION
ORACLE Error in aicdad():
ORA-06550: line 1, column 10:
PLS-00302: component 'APPS_DDL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYSTEM.AD_INST", line 108
ORA-06512: at line 1
AutoPatch error:
Unable to compare or correct tables or indexes or keys
because of the error above
Error in aiccep(): aicce2() failed
Due to this error that adpatch failed.
Has anybody encountered this problem. Please share your experiences.
Regards/Nagamohan
Pre-approved PO not available for acceptance
Date: Fri, 10 Sep 1999 14:59:51 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
To: "'Oracle Apps Forum'" OraApps-L@cpa.qc.ca
Subject: PO: Pre-Approved Status
We have a few POs in our system that seem to be stuck in a 'Pre-Approved'
status. The buyer was able to approve the POs and then forward them (buyer
was temporary employee, and is no longer set up as a buyer) to the next
level in the Hierarchy.
The POs now show a status of 'Pre-Approved'. The Action History shows that
they should be in the notification queue of the Materials Mgmt director
(next step in hierarchy, from the buyer), but they are not in his
notification queue. He has tried to enter Acceptances for these POs, but
this does not change the status of the POs. These POs cannot be opened or
canceled either.
There were other POs created by this buyer during the same time period
(August) with the same Category/Subcategory, same line types, that went to
the materials mgmt director's queue for Acceptance, he was able to enter
acceptances and the POs went to Approved status with no problems.
Has anyone come across anything similar to this before?
Thank you in advance,
Sarah Aronovici
Oracle Systems Analyst
Augsburg Fortress Publishers
612.330.3363
Date: Sun, 12 Sep 1999 22:53:25 -0500
From: "HANCOCK, David" dhancock@shl.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: PO: Pre-Approved Status
Sarah,
Looks like you have encumbrance accounting turned on. In this case,
the buyer chose "Approve" Document, instead of "Approve and Reserve"
Document. To correct problem, forward document to someone that has
authority to Approve and Reserve, and have them "Reserve" only. The
document with then be reserved and approved. Done. Next time this happens,
if you want to teach the buyer a lesson, I would forward all of these POs
back to him/her, with instructions to now Reserve the PO. He/she will get
the message that POs must be approved and reserved for internal efficiency
reasons.
Dave Hancock
888-319-1178
Date: Mon, 13 Sep 1999 11:19:09 +0200
From: Mike Bennet MikeB@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Pre-Approved Status
Advise your users that there is no need to forward a PO once approved. This
action of approving and forwarding results in the PO being "pre-approved".
You could use the option to change the inbox and forward these POs to the
intended approver.
Regards
Mike
Date: Mon, 13 Sep 1999 06:56:57 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
To: "'HANCOCK, David'" dhancock@shl.com,
Subject: RE: PO: Pre-Approved Status
David,
Thanks for the information, but we do not have encumbrance accounting turned
on.
Thanks,
Sarah Aronovici
Date: Mon, 13 Sep 1999 07:30:57 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
To: "'Mike Bennet'" MikeB@langeberg.co.za,
Subject: RE: Pre-Approved Status
Mike,
Thanks for the reply. One of the problems that we are having with these
documents is that they are not available in anyone's approval queue.
Therefore I can't forward them to another approver.
Thanks,
Sarah Aronovici
Date: Mon, 13 Sep 1999 20:11:26 +0700
From: "Nagamohan U." umohan@irs.co.id
To: oraapps-l@cpa.qc.ca
Subject: RE: PO: Pre-Approved Status
Hi
A quick check. Just run the following scripts. Do they return any records?
select EMPLOYEE_ID, ACTION_LOOKUP_CODE from po_notifications_all
where OBJECT_ID=&your_po_header_id
select NOTIFICATION_ID, APPLICATION_ID, EMPLOYEE_ID, STATUS, DOC_NUMBER
from fnd_notifications
where OBJECT_ID=&Your_po_header_id
select ACTION_CODE, employee_id from po_action_history
where OBJECT_ID=&Your_po_header_id
He has tried to enter Acceptances for these POs, but this does not
change the status of the POs
I am not sure Accepting the POs changes the status to Approved. More over
from where is he trying to accept the POs? From Purchase Order Summary
Screen or some where else?
These POs cannot be opened or canceled either
The POs cannot be opened because the owner of the PO i.e., the Buyer is no
longer exists as buyer. Your document control set up is controlling this.
You have two options two open them.
1. Enabling that temporary employee as buyer again and attach this
employee your user name and open the POs and control them.
2. Change the Document control set up(security level and access level)
to access these POs.
Regards/Nagamohan
Date: Mon, 13 Sep 1999 08:37:41 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
To: "'Oracle Apps Forum'" OraApps-L@cpa.qc.ca,
Subject: RE: PO: Pre-Approved Status
I ran the scripts that you suggested. The first two returned no records. The
last script returned the action history for each document, showing the last
entry for each document without an action code.
I enabled the buyer, associated that employee with my user, and then tried
to open these POs. It did not allow me to open the POs. I think it is not
allowing me to open the PO header because of the status. But I can't get the
status changed.
Thank you,
Sarah Aronovici
Date: Mon, 13 Sep 1999 09:07:25 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
To: "'HANCOCK, David'" dhancock@shl.com,
Subject: RE: PO: Pre-Approved Status
I have checked in GL and PO. Following are the results:
GL: Reserve for Encumbrance: Null
Enable Budgetary Control: Null
Encumbrance Types: Enabled (seeded
types only)
PO: Use Requisition Encumbrance: Null
Requisition Encumbrance Type: Null
Reserve at Requisition
Completion: Null
Use PO Encumbrance: Null
PO Encumbrance Type: Null
Invoice Encumbrance Type: Null
Unless there is something else that I'm not aware of, it still looks to me
like we do not have encumbrance accounting turned on.
Thank you,
Sarah Aronovici
Date: Mon, 13 Sep 1999 16:55:41 +0200
From: "German Palomar Santa Maria" palomarg@grupocp.es
To: oraapps-l@cpa.qc.ca
Subject: PO: Preapproved status
Try working in character mode
German
Date: Mon, 13 Sep 1999 14:06:53 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
To: "'HANCOCK, David'" dhancock@shl.com,
Subject: RE: PO: Pre-Approved Status
'Reserve' is not an available option in the Approval form.
There were not updates to the Financial Options during the time period these
POs were created (POs before and after went through approval process without
any problems).
Thanks,
Sarah Aronovici
Oracle Systems Analyst
Augsburg Fortress Publishers
612.330.3363
Document Approval Manager - Scheduling
Date: Sun, 12 Sep 1999 09:32:33 GMT
From: "GopalaKrishna Surapaneni" srisri47@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: PO: Scheduling PO
Hi All,
Is it required to schedule the PO Document Approval Manager and Shipping
Manager to be activated every 5 or 10 minutes and if so, how can this be
done and what fequency is advisable.
Thanks in Advance.
Gopal