Char mode crashes on query of various POs
Date: Wed, 23 Jun 1999 16:51:55 -0700
From: Steve Kessler SWKessler@lbl.gov
Subject: PO; char mode Forms2.4 crashes upon query of various POs
After we upgraded to version 10.7, we have had about
a half dozen cases where any attempt to query up the
PO in "Enter PO" or "Inquiry PO" will the underlying
Forms 2.4 runtime (character mode) with an
error message of "APP-00944 ...internal error".
Then the next thing you see is a Unix prompt!
The PO's that do this do it consistently and they are
simple PO's created from simple, single requisitions.
We are not using encumbrance. The requisitions
do not have notes. It happens with requisitions
created before and after the upgrade.
Oracle has been "working on the problem" (bug
#771399) and they say other shops have
experienced this bug. So, does this problem ring
a bell with anyone? Is, there some common
element (or denominator) that we can have our
users avoid till Oracle fixes this?
Steve Kessler
Lawrence Berkeley National Lab
SWKessler@lbl.gov
Date: Thu, 24 Jun 1999 08:28:26 -0400
From: Betty.Petro@dankasi.com
Subject: Re: PO; char mode Forms2.4 crashes upon query of various POs
We have experienced similar problems with our POs. After a long
Oracle support told us that the problem is being caused when the currency
code is left blank. This field is not
updatable so they did not know why in some cases this field is blank. They
gave us the attached
sql code to update the file: (See file below : ukpos.sql)
Once this is run you can then go and delete that PO that is giving you the
problem.
Oracle also said that this fix is in the 16K megapatch.
The bug number they gave us is 624607. We have not yet applied this patch.
Betty Petro
Document Services International
ukpos.sql
update PO_Headers_All set currency_code='GBP'
--select currency_code, segment1 from PO_Headers_All
where segment1='2212' and org_id='102';
update PO_Headers_All set currency_code='GBP'
--select currency_code, segment1 from PO_Headers_All
where segment1='2439' and org_id='102';
update PO_Headers_All set currency_code='GBP'
--select currency_code, segment1 from PO_Headers_All
where segment1='2398' and org_id='102';
commit;
Date: Thu, 24 Jun 1999 12:01:13 -0300
From: Ken Heckbert kheckbert@ccgw.cc.hollandc.pe.ca
Subject: PO; char mode Forms2.4 crashes upon query of various POs
Hi Steve,
At my previous place of employment, I was the one that
logged the TAR that resulted in bug#771399. Don't hold your
breath waiting for a solution, as that TAR has been open for
10 months now, and I'm not sure when it will be fixed. I
corresponded with another user that had the same problem,
but they just gave up and upgraded to GUI, where the
problem apparently does not occur.
Our problem seemed to stem from the reserving of funds.
Are you using budgetary control?
However, you should know that there is a different bug with
the same error message, and it was related (unlike our
problem) to specific PO's, and had something (I think) to do
with the FlexBuilder setup. You should not let WWS
assume that your problem is the same as 771399. Have
them look for the other bug as well. Unfortunately, I don't
remember the bug number.
Ken
Approving POs with a concurrent process
Date: Thu, 24 Jun 1999 19:10:17 +0200
From: Corrado Barbero corrado.barbero@oraplus.com
Subject: PO: Approving POs with a concurrent process
Hi guys,
we're importing POs from a legacy system, we use the requisition import,
then autocreate, then we'd like to approve automatically.
Following indications found on the list we're trying to use the function
po_document_actions_sv.po_request_action, but without success (exits
with error code 3).
Any hint?
TIA
Corrado Barbero
Corrado Barbero corrado.barbero@oraplus.com
Oraplus LTD Filiale Italiana Tel: (+39) 0392142381
http://www.oraplus.com Fax: (+39) 0392875070
Vendor tax reporting site
Date: Thu, 24 Jun 1999 15:30:55 -0400
From: mrosm mrosm@stratos.net
Subject: PO: Vendor tax reporting site
Hi,
Can anyone tell me what would be the best way to determine a vendor's home
site? I am missing tax i.ds for many vendors. I would like to send notice
to all home sites to request the tax id. For instance, their may be 7
sites for WalMart 1 being headquarters or the homesite. I would only want to send a notice to headquarters which would be 1 of the 7 sites. Is there a home site or headquarter flag in Purchasing?
Thanks for any assistance.
Autocreate PO - Performance Problem
Date: Thu, 24 Jun 1999 14:19:59 -0700 (PDT)
From: Rajeev Rai rajeev_rai@yahoo.com
Subject: Autocreate Purchase Orders -
We are having performance problems as it relates to the autocreation of
Purchase Orders. After entering ok to autocreate the Purchase Order it
can take up to 10 minutes to finish the task. We are on version 10.7
NCA, UNIX HPUX (Version 11). Does anyone know of any patches that have
been applied to fix this problem. We have applied the patches thus far
by Oracle but they have not fixed the problem.
===
Rajeev K. Rai
Application Integration Analyst
rajeev_rai@yahoo.com
Acceptance Date
Date: Sat, 26 Jun 1999 21:15:08 -0700 (PDT)
From: FMT firas70@yahoo.com
Subject: Acceptance Date - PO
Hi,
Any help on the following problem ?
- A PO entered to the system with all the periods in
Mar-99 (Including the Gl-Date) .. and every thing is fine
with the PO :)
- The reciept issued for the above PO is in the Mar-99
too and it is OK .
- When the user try to ACCEPT the materials .. the
default date is the current date (in Jun-99) and the system
refuses any date out of the range of Jun-99 !!!!
Note:
The whole operation have been entered in the June-99.
Thanks in Advance for any Hints ..
FIRAS AL TAMIMI
ADWEA
UAE
Date: Wed, 30 Jun 1999 07:56:58 -0700
From: "sean smith" kiowasean@zdnetmail.com
Subject: Re: Acceptance Date - PO
Perhaps June is the only open period in Purchasing?
Date: Thu, 1 Jul 1999 09:56:24 -0500
From: Mandar Dewoolkar-G1606C Mandar_Dewoolkar-G1606C@email.mot.com
Subject: Re: Acceptance Date - PO
Periods have to opened in multiple places for your receipts to work
correctly. Check if periods are open in Inventory, GL and Purchasing.
One of them must have got missed out. Hope this helps.
Mandar
Changing GL date on approved PO
Date: Sun, 27 Jun 1999 03:26:04 -0700 (PDT)
From: FMT firas70@yahoo.com
Subject: PO distribution GL_Date
Hi,
Here another issue !!
- Some PO's (50 no) has been entered using a promised
date, Shipment Date , GL-Date all in the current date.
- All PO has been reserved and Approved.
- A requirement to change this dates to a previous dates
as per the actual PO's.
- The task completed for all dates, But the Gl-Date is
disabled and can not be changed !!!
Any Comments ? Should we Cancel all the PO's ?
Note : we use ver 10.7 GUI , Client : 16.1SC
Significance of Need-by-Date
Date: Sun, 27 Jun 1999 19:54:56 +0300
From: "Dina Rotem (h)" dinar@rafael.co.il
Subject: PO: What is the Use of Need-By-Date
Oracle Purchasing has two dates on the PO line / shipment.
Oracle MRP is reading the Promised Date as the expected date of the
supply.
My question - What is the use of the other field, the Need-By-Date ?
Can this be considered as the contractual date of that line?
Dina
Date: Mon, 28 Jun 1999 10:49:27 +0300
From: "Cohen, Dan" Dan_Cohen@icomverse.com
Subject: RE: What is the Use of Need-By-Date
Dina,
The Need By Date in the PO is the original Need By Date in the PR.
Regards,
Danny Cohen
972-3-645 2016
972-51-23 2016
Interface Processes Unable to Derive GL Date
Date: Tue, 29 Jun 1999 14:23:45 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: PA: Interface Processes Unable to Derive GL Date (R11)
We are running the 'Interface Labor Costs to GL' process and encountered a
'could not create a valid GL date' error on the output reports. I have run
a trace file for analysis and am currently working with Oracle Support on a
resolution. The distribute process derive the PA Date successfully. I have
checked all the more simpler possible explanations and everything is in
order.
For anyone successfully running PA in Release 11 with PA Periods defined as
'weekly', did you encounter any problems initially with running the
interface processes?
Thanks in advance.
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Setup contractors to use PO
Date: Wed, 30 Jun 1999 11:03:28 -0700 (PDT)
From: abdulfattah abdulkarim abdulfattah_a@yahoo.com
Subject: Setup contractors to use PO
HI,
Appreciate your feedback to the following:
We are using Oracle Human Resources with Oracle Purchasing. The current
setup use Position Hierarchies for approval routing, document security
and to control approval authorization level.
Beside our defined HR employees we have contractors that are not part
of our hierarchies, but they need to use oracle purchasing to raise PR.
We defined Contractor in System Administrator responsibility as follow:
User Name: Contractor name
Password: His Password
Employ: We select one of our organization valid Employee.
Our current problem is when Contractor raise PR system will display the
employee name in Preparer filed of PR header.
This cause problem since this employee is not the actual person who
prepared this PR.
I would appreciate your assistance to find away to resolve this issue.
Regards
Abdulfattah
Date: Wed, 30 Jun 1999 16:40:20 -0400
From: Sistla.Viswanath@am.sony.com
Subject: RE: Setup contractors to use PO
How about creating a dummy employee for all contractors ?
vishy
Date: Thu, 1 Jul 1999 00:11:25 EDT
From: GWRR@aol.com
Subject: Re: Setup contractors to use PO
You can setup your contractors up with a type of external employee (or
whatever identifier you desire). Also attach this employee to an
organization (external or internal), with a position identifier you desire
and with the appropriate supervisor.
Gwen
Date: Thu, 1 Jul 1999 13:56:29 +0300
From: "Abdulfattah M. Abdulkarim" abdulkarima@luberef.com
Subject: RE: Setup contractors to use PO
vishy,
Thank you for your feedback.
Our user requirements is to show the original preparer for the PR. Setting
on employee will show one preparer for all PRs raised by the contractors.
Regards
Change price on Inventory items
Date: Wed, 30 Jun 1999 15:30:57 -0600
From: "Rosy Virani" Rosy.Virani@CRHA-Health.Ab.Ca
Subject: Re: ORAAPPS-L digest 3363
v
Hi All..
Can someone tell me whether one can change price on inventory items, on a PO line,
after received the items.
I tried to change the price, gave message field is protected against update..
Does anyone know if this a bug or this functionality of purchasing?
If it is functionality of Purchasing, Can you tell me how I go about changing the
price in PO to match with AP.
Thanks
Rosy.
Date: Wed, 30 Jun 1999 17:26:08 -0500
From: "MCAVOY, Brian J." bmcavoy@shl.com
Subject: RE: ORAAPPS-L digest 3363
Rosy, in order to change the PO price you need to reverse the receipt, then
change the price on the PO , then re-enter the receipt.
Brian McAvoy
Consultant
EDS
pager 888-319-3433
bmcavoy@shl.com
Date: Wed, 30 Jun 1999 16:39:08 -0600
From: kbrown@es.com
Subject: RE: ORAAPPS-L digest 3363
You can also match your invoices against the
purchase order line if you're hoping to collect purchase-price-variance by
changing the column Match Amount to the amount you have been invoiced for.
Kristie
Date: Wed, 7 Jul 1999 11:27:13 -0500
From: Sree Pulikataramv-G1942C Sree_Pulikataramv-G1942C@email.mot.com
Hi Brian,
We are also having a similar requirement to change the PO price after
receiving the item. I would like to know how to reverse a receipt in
Oracle once it is received. Do you mean a RMA or a correction. Would
you explain please?
Thanking in advance
Sreekumar
Application Consultant
Motorola Northbrook
Wrong vendor assigned to PO
Date: Thu, 1 Jul 1999 11:12:50 -0400
From: "MacLeod, Mary Anne" mmacleod@mcgh.org
Subject: PO - Wrong Vendor assisgned when PO is created
Situation: PO is built against the wrong supplier, this requires that the
PO be cancelled, receipts backed out and new PO issued with correct vendor
information. Can the PO vendor be changed once approved?
10.7 NCA
What are other companies doing regarding this?
thanks
Date: Thu, 1 Jul 1999 11:41:48 -0400
From: "Downey, Dawn E" dedowney@kpmg.com
Subject: RE: PO - Wrong Vendor assisgned when PO is created
No, this is a field which is protected from update once the PO is
approved....
I believe you would have to cancel the PO and and create a new one with the
correct vendor....I'd be interested to know if there was another way as
well...
Dawn Elise Downey
Consultant - Oracle
KPMG LLP
Boston, MA
Office: 617-988-5629
Client Site: 516-803-9581
Date: Thu, 1 Jul 1999 16:19:05 -0400
From: Carolyn DeSimone cdesimone@goaa.org
Subject: RE: PO - Wrong Vendor assisgned when PO is created
We had a long discussion with Oracle about this and determined that without
customization the vendor could not be changed once a purchase order is In
Process. Actually it is a good policy not to change the vendor. If the
problem was the result of the vendor being duplicated in the system, you
could merge the suppliers and select the PO check box to include purchase
orders from the wrong supplier to the correct supplier.
Carolyn DeSimone
Purchasing Oracle Implementation
Cdesimone@goaa.org
407-825-2028
Date: Mon, 5 Jul 1999 14:24:31 +0930
From: "Syme, Andrew" Andrew.Syme@boral.com.au
Subject: RE: PO - Wrong Vendor assisgned when PO is created
If no other Purchase Orders exist for this Vendor, you could Merge the PO
into the correct vendor.
v
Andrew Syme.
Modifying saved Purch. Reqn.
From: Jennifer Knice JKnice@cerbpyro.com
Subject: Saving Purchase Requisitions in 11.02
Hello all,
Has anyone experience the same problem in 11.02 - we enter a requisition
line and save it. We forgot to enter the supplier, so we click in the
supplier field, pull up the list of values and select a supplier. The
supplier field does not get populated nor does the record get updated. The
only was we can populate the field is if we requery the record. We are
having the same problem with the buyer field. Any thoughts?
Jennifer Knice
Senior Consultant
Austin Solutions
769 Susquehanna Ave
Franklin Lakes, NJ 07417
(201) 891-1460 - Office
(973) 593-6544 - Client Site
POs in Approve Doc. Form
Date: Tue, 6 Jul 1999 08:46:55 -0400
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Printing PO's in the Approve Document Form
Hi All,
We are in Purchasing, version 11.02, and we are unable to print a document
in the "Approve Documents" form. We have approval assignments set up, so we
have checked "Forward To" and filled in the appropriate approver's name. We
check the "Print" attribute, however when we submit the document we only get
a message that says "Document Submitted for Approval". We do not get a
message which states that a concurrent request has been submitted for the
print job.
So, we are unable to view the print job, or get the printed PO, as there is
no Concurrent Request being kicked off.
Has anyone encountered this? Is there a setup or profile option we missed,
or could this be a bug/patch?
Any help is greatly appreciated.
Thank you,
Bill
Accrue on Receipt Flag
Date: Thu, 8 Jul 1999 11:16:23 -0400
From: Mary Anne MacLeod mmacleod@mcgh.org
Subject: PO: Accrue on Receipt Flag
Vendors are set up on 3 way match. When a PO is built with a one-time item
(or an item that we do not pull from the item master), after the PO is
approved, the Accrue on Receipt flag gets de-selected. This flag is
located under Shipments in the alternate window - More. So it is not
something the end user is doing.
I have talked to Oracle Support and we have checked all the necessary set
up options. Further testing reveals if the type is Goods this does not
happen - only when the type is Expense. If it is Expense, the first line of
the PO is OK however the second line, the flag gets de-selected.
Any other companies experiencing this? We are 10.7 NCA 16.1, 7.3.3.5, Sun
Solaris.
thanks
Date: Fri, 9 Jul 1999 08:42:39 -0500
From: "HANCOCK, David" dhancock@shl.com
Subject: RE: PO: Accrue on Receipt Flag
Mary Anne,
I believe the answer lies in your setup, you can select accruals for expense
items as either Perpetual or Periodic. Remember items received for
stock/inventory can only be accrued on a Perpetual basis (in Oracle). It's
explained briefly in the Purchasing Reference Manual.
Dave Hancock
Over Receipt Tolerance not working
Date: Thu, 8 Jul 1999 16:17:06 -0500
From: Mandar Dewoolkar-G1606C Mandar_Dewoolkar-G1606C@email.mot.com
Subject: PO: Over Receipt Tolerance not working ??
Hi,
Problem
-------
Say we have a PO with quantity = 100.
Over Receipt Quantity Setup in the Receiving Controls is (Tolerance =
1 and Action = Reject) implying that any quantity more than 1 percent
of ordered quantity should be rejected.
If I were to enter 100, the receipt goes through fine. If I were to
enter 102, the Receipt screen stops me from proceeding. So far so
good.
But, if I enter 101 quantity, there's a problem. The Receipt screen
accepts it, but the transaction gets stuck in the
RCV_TRANSACTIONS_INTERFACE table with transaction status as ERROR !!
Shouldn't this transaction go through ???
Environment and Setups
----------------------
10.7SC Rel.16.1 (GUI). Recently upgraded to Y2K compliant patches.
Patch M for Purchasing.
Receipt Routing - "Direct Delivery".
RCV: Processing Mode - "Immediate"
This used to work perfectly well before the upgrade. Any suggestions /
patches etc ?
Thanks in advance.
Mandar
Date: Thu, 8 Jul 1999 19:36:19 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: PO: Over Receipt Tolerance not working ??
Mandar,
Obviously, this is a bug. Guess, I will give an obvious solution -
change your tolerance to 1.0001 or someting like that.
Ravi K.
Supplier Notes/Attachments conversion
Date: Thu, 08 Jul 1999 15:01:14 PDT
From: "Subroto Mukherjee" m_subroto@hotmail.com
Subject: Supplier Notes/Attachments conversion
Hi All,
Can someone point me out the entities that needs to be
populated, for po/supplier notes/attachments,
when we bring legacy data into Oracle.
Thanks
S
Date: Fri, 9 Jul 1999 08:57:55 -0400
From: "Kamdar, Rita R, CFCTR" rkamdar@att.com
Subject: RE: Supplier Notes/Attachments conversion
Hi, Suborto,
I have loaded reqstn/notes/attachments from other system into
Oracle Purchasing.
Let me know if u wud like further info on this.
Rita
732-457-3170
rkamdar@ems.att.com
Receiving against closed P.O.
Date: Fri, 9 Jul 1999 11:18:09 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
Subject: P.O. Receipts
We are running 10.7 SC. If I have a p.o. with an order quantity of 100, and
I receive 100 the p.o. closes. Great. However the next day or two another
shipment comes in against the original p.o. We are willing to take the
product...there are no other open orders...but with the p.o. closed how do I
receive it? Thanks in advance.
Michael S.
Date: Fri, 9 Jul 1999 12:25:46 EDT
From: Dkasper1@aol.com
Subject: Re: P.O. Receipts
Is the po closed or is the status closed for receiving.
You can overreive, eventhough the status is closed for receiving. This is a
status flag. It does not prevent you from performing a recipt against it.
Date: Fri, 09 Jul 99 09:34:12 -0800
From: cbarter@guthy-renker.com
Subject: Re: P.O. Receipts
As long as the PO has been closed for receiving only and not final
closed, by using special from the toolbar you can open the PO for
receiving and receive additional quantity against that PO.
Hope this helps you.
Chris
Date: Fri, 9 Jul 1999 15:58:22 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
Subject: RE: P.O. Receipts
Thanks...you brought me now to another question. I have read in the
reference manual about close...close for receiving what have you. But as I
am "playing" in our test system I am struggling getting to close status. I
have a p.o. for 100...received and delivered 100 but it is only closed for
receiving. When does it finally close?
Date: Fri, 09 Jul 99 14:11:39 -0800
From: cbarter@guthy-renker.com
Subject: Re[2]: P.O. Receipts
I'm not exactly sure when you would "final close" a PO. Once a PO has
been "final closed" you can no longer make any changes or
modifications of any kind. I believe that once AP does their final
match to that PO and there will be no additional receipts, that is the
point when you would "final close" the PO. I would guess and month
end or quarter ends. We are not final closing yet.
Good luck
Returning products against closed PO
Date: Sat, 10 Jul 1999 07:42:28 -0400
From: Paul Mallon pmallon@oasys-grp.com
Subject: RE:P.O. Recipts - RTV
Once a PO is closed (for acctg) can you open it again if you decided to
return product to vendor? What happens to invoices that have been paid
- manual adjustments?
Paul M.
PO status for receipt
Date: Mon, 12 Jul 1999 07:39:11 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
Subject: RE: P.O. Receipts
I know this must seem redundant for most of you and I am probably getting
hung up in terminology but...
P.O. for 100 pcs.
Deliver 97 pcs.
Receipt Close Tolerance is set for 10%
Receipt Close Point is Delivered
Why is it if I go to P.O. Summary under headers the p.o. status is Open,
under lines the status is Open but under shipments the status is Closed for
Receiving?
When or how does this go to final close?
Does this happen with invoice payment?
From: Dkasper1@aol.com [mailto:Dkasper1@aol.com]
Sent: Friday, July 09, 1999 9:55 AM
Subject: Re: P.O. Receipts
Is the po closed or is the status closed for receiving.
You can overreive, eventhough the status is closed for receiving. This is a
status flag. It does not prevent you from performing a recipt against it.
Date: Mon, 12 Jul 1999 20:51:59 CEST
From: "massimo carniel" gneppo@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: P.O. Receipts
Mike,
you can consider CLOSED status as 'CLOSED for receiving' + 'closed for
invoice'.
When your shipment will be completely (or something else, according to your
tolerance) received and invoiced, it will have a close status
of 'CLOSED'. You can obtain the same, or one of the previous, explicitely
from the purchase order summary form.
Each of those status are reversible.
If you Return to Vendor something belonging to an already CLOSE shipment,
the same shipment will be reopened according to your transaction.
If you have invoices matching that shipment, a block to payment will be
applied.
If they have been previuosly posted to GL, no action will take place.
(I apologize if there is something wrong in my last 2 sentences, I'm not so
skilled on accounting!!)
As I know, the only way to set a FINALLY CLOSE status is from the summary
form I mentioned above, and it is the only NON REVERSIBLE status.
Hope everything is correct and enough to satisfy your needs.
Have fun
Massimo