Unable to Receive - open period problem
Date: Mon, 2 Aug 1999 10:14:46 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: PO: Urgent: Unable to receive
My users are getting the error message: "APP-14376 "please enter a GL date
within an open purchasing period? Cause used GL date wrong - action, use
control purchasing periods form to open the period corresponding to the date
you entered."
My accounting manager has verified the period is open for receiving. Yet my
users are still unable to receive. Any advice, where to look? What are we
missing???
Thanks!
Karen Blackwell
DBA/System Administrator
RockShox, Inc.
408.570-4912 phone
408.435.7468 fax
Date: Mon, 02 Aug 1999 13:26:32 -0400
From: Jason Pickens JPickens@mercury.umis.upenn.edu
Subject: Re: PO: Urgent: Unable to receive
Make sure the period is open in Purchasing as well as in GL.
Date: Mon, 02 Aug 1999 13:19:26 -0400
From: Jennifer Knice JKnice@cerbpyro.com
Subject: RE: Urgent: Unable to receive
Hello,
Open for receiving means that the Inventory Period is 'Open', not the
purchasing period. To open the Purchasing Period, login as Purchasing
Superuser - Setup - Financials - Accounting - Control Purchasing Periods
Jennifer Knice
Senior Consultant
Austin Solutions
769 Susquehanna Ave
Franklin Lakes, NJ 07417
(201) 891-1460 - Office
(973) 593-6544 - Client Site
Date: Mon, 2 Aug 1999 11:06:10 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: PO: Urgent: Unable to receive
Thank you all for your help!!! I believed it was a problem with the GL
period. Once we opened GL, all is fine.
My accounting manager tells me in hte past, he would leave the "new" GL
period closed until the 2nd or 3rd business day. Does anyone know if and
when this might have changed? We did apply Inventory Patch Set B during
July -- which *may* have affected this.
Thanks again to all who responded with their advice!
Karen Blackwell
DBA/System Administrator
RockShox, Inc.
408.570-4912 phone
408.435.7468 fax
Date: Tue, 3 Aug 1999 09:54:17 +0000
From: shafiqr@sa.ibm.com
Subject: RE: Urgent: Unable to receive
We are 10.7 GUI using (INV,PO,AP,AR,GL). Please let me know the correct
sequence of opening and closing the Accounting periods. Does it really
matter which period should be opened or closed first.
Thanks
Shafiq ur Rehman
IBM/Lucent TEP6 Project
PO Box 818,Riyadh 11421,KSA
Phone: +966 1 4194962 x 337
email:shafiq_rehman@hotmail.com
Date: Tue, 3 Aug 1999 09:27:19 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: Urgent: Unable to receive
Both the PO & GL Periods are required to be open.
Thanks Much
:-) I used to have a handle on life, but it broke.
Craig Riffel
Date: Tue, 3 Aug 1999 08:17:19 -0500
From: "MCAVOY, Brian J." bmcavoy@shl.com
Subject: RE: Urgent: Unable to receive
Hi, you may want to take a look at an OAUG paper about opening and closing
periods, not sure which conference(s), but it seemed to be 3 or 4 ago if I
remember right. It gives some good insight on the process.
Brian McAvoy
Consultant
EDS
Client phone # 973-491-8614
Email bmcavoy@shl.com
On approval of a PO Workflow not sending an EML notification
Date: Tue, 03 Aug 1999 07:57:46 -0600
From: Steph Rutherford SRUTHERF@westerngas.com
Subject: RE:PO Approval Process
I am currently testing an upgrade from 10.7 character to 11.02 and cannot
get workflow to send an e-mail message to users when a PO is submitted for
approval. We are using the workflow embedded with the apps with no
customization.
I do know that the notification mailer is running and that Unix Sendmail is
working. I have gone through the Workflow set up steps. Does anyone have
any suggestions as to what I may be missing?
Running APPS 11.02
HP-Unix 11.032
Database 8.051
Any suggestions are greatly appreciated.
Thanks
Date: Tue, 03 Aug 1999 10:51:49 -0400
From: Jennifer Knice JKnice@cerbpyro.com
Subject: RE: PO Approval Process
What errors are you receiving in the Notification Mailer concurrent program
log?
Jennifer Knice
Senior Consultant
Austin Solutions
769 Susquehanna Ave
Franklin Lakes, NJ 07417
(201) 891-1460 - Office
(973) 593-6544 - Client Site
Date: Wed, 4 Aug 1999 07:27:57 -0700 (PDT)
From: Jason Chan jchan14@yahoo.com
Subject: RE: PO Approval Process
Call Oracle Support. We had to apply a few patches before the email
notifications of PO approval process would work properly all the way
through. I have included a couple of related Bug texts that I could
find.
Jason Chan
i2 Technologies
oooooooooooooooooooooooo
o o
o BUG fnd 849385 o
o o
oooooooooooooooooooooooo
BUG DESCRIPTION
---------------
Instead of lock only one row at a time when fetch notification , we now
use cursor to fetch a bunch of them and store in our memory. This
reduce
the database hit and inrease the performacne.
Within this same patch, I have also included the patch for MIME codeset
conversion in our sendmail mailer. The sendmail mailer now correctly
encode a message and set the right MIME header. Then decode the
incoming
message. This is for bug 679956.
This patch also include fix for 639569.
oooooooooooooooooooooooo
o o
o BUG po 799989 o
o o
oooooooooooooooooooooooo
BUG DESCRIPTION
---------------
Approval workflow fails in getting next PO manager and the check in
whether the
document is pre-approved or not.
Please apply 11.0.1 before this fix.
Multiple POs exceeding budget
Date: Wed, 4 Aug 1999 02:30:16 EDT
From: ConwayChas@aol.com
Subject: PO: Coding PRs/POs
Folks,
We have 2 types of contracts that are proving to be rather painful.
1. Multiple POs exceed budget.
For example, we cut Blanket POs for 5 law firms where we will decide later
who gets how much. We budget, say $1 million total for legal fees and any of
the firms could get up to to that $1 million by the end of the year. How do
you budget or code to get past funds control ( 5 x 1million in POs vs 1
million budget)? Turn funds checking off when entering those POs?
2. Coding not known at beginning of year.
Using the above example, we know we will spend $1 million on legal fees, but
do not know what project will incur the cost. We could budget centrally but
we want to make sure that each project is responsible for its legal
expenses.
How do we get the expenditures to the correct project during the year?
Month
end adjustments? Delete and re-enter each PO line/distribution? Is there an
easier way?
Any help would certainly be appreciated.
Thanks
How to get Invoice total for a PO
Date: Wed, 04 Aug 1999 09:56:39 CDT
From: "ALAUKIK DHIMAR" al_dhimar@hotmail.com
Subject: Enter invoice for total on PO
Hi! All,
Does anyone know how to refrence an invoice total for a particular
PO? I have created standard PO(approved and reserved) and created invoice
from the payable.
Thanks,
ORA 00054 - Resource Busy
Date: Wed, 21 Jul 1999 16:11:54 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
Subject: Purchasing 10.7 sc
We are attempting to turn on the purchasable flag for a part and received
the following message:
ORA-00054 Resource busy and acquire with NOWAIT specified.
Any ideas from our experts?
We have never seen this before...nor have anything in our problem log data
base.
Thanks in advance.
Date: Wed, 21 Jul 1999 18:05:17 -0500
From: "Shockey, David" DShockey@jwrinc.com
Subject: RE: Purchasing 10.7 sc
I've seen this before. Get your DBA to check for locks on affected
tables. He should be able to release the locks by killing the
session/process holding them. If not, you'll need to bounce the
instance.
PO - Receipts Interface Table
Date: Fri, 6 Aug 1999 09:15:49 -0400
From: "Sikorski, Paul" psikorski@cm-corp.com
Subject: Looking for Purchase Order Receipts Interface Table
We have a third party bar coding application which receives material against
a purchase order. We need to bring the data into Oracle.
Can someone help us identify the interface table? Thank you.
Paul
Date: Mon, 9 Aug 1999 05:49:27 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
Subject: Re: Looking for Purchase Order Receipts Interface Table
Hi ,
The interface tables are
1.rcv_headers_interface
2.rcv_transactions_interface
Hope this helps,
Murthy.
Automatically Print Requisition and PO on submit for approval
Date: Mon, 09 Aug 1999 09:40:35 +0700
From: Argon Usman argon@newmail.net
Subject: PO: Print Requisition and Purchase Order
Hi All,
Is there a setup in PO Rel. 11 for printing Requisition and Purchase
Order automatically at the time the user submit for approval?
Thanks in advance,
Argon I. Usman
Consultant
PT Jati Piranti Solusindo
Menara Rajawali 12th Fl.
Kawasan Mega Kuningan Lot 5.1
Jakarta
12950
Indonesia
Phone:(6221)5761850
Fax:(6221)5761848
Enter Deliver-to person
Date: Mon, 9 Aug 1999 11:00:11 -0400
From: "Schmidt, Bob" bschmidt@AAFINTL.com
Subject: PUR:Deliver to question
The AP person came to me with a question about the "Deliver-To Person"
on the Receiving Transaction Register. It appears that this is
defaulted from the requestor name in the Distributions screen. It seems
to me that the requestor and deliver to person are typically not the
same. Is there a place to enter the Deliver-To Person somewhere?
Thanks
Bob Schmidt
bschmidt@aafintl.com
EDS
502.637.0446
502.637.0520 (F)
Date: Thu, 12 Aug 1999 14:07:22 +0300
From: "Nasir Valiya Veetil" vnasir@england.com
Subject: Re: PUR:Deliver to question
Yes you can change the deliver to person. You are telling to the system the
name of the person to whom it is delivered in the Receiving Transaction
window. This entry is in the field Person in the line zone. Requestor name
is defaulted here.
Nasir V
API to bring in Material Receipt
Date: Tue, 10 Aug 1999 09:45:45 -0400
From: "Musku, Jagan" jagan@cm-corp.com
Subject: Looking for API to Bing in Material Receipt
Hi All,
We are on 10.7 SC161 and want to use third party software for Material
Receipt Transactions entry.
The PO's are in Oracle, so we need to bring in Receipt information into
Oracle. I understand that
Oracle has not provided the so called interface tables.Can anyone suggest
how to tackle this?
Your help would be highly appreciated.
Thanks,
Jagan
Requisition Import
Date: Tue, 10 Aug 1999 08:10:20 -0700
From: Todd Manley tmanley@zilog.com
To: "Oracle Applications Forum (E-mail)" oraapps-l@cpa.qc.ca
Subject: PO: Requisition Import
Hello-
Good morning PO experts (and/or anybody else who can help)! I am
experiencing a problem with the Requisition Import. The import is erring
out and I have applied the most recent bug fix, patch 753028. This didn't
help and I'm still receiving the following error in the request log:
+-----------------------------------------------------------------+
Oracle Purchasing: Version : 8.0.167 - Development Copyright (c)
Oracle Corporation 1979, 1991. All rights reserved.
REQIMPORT module: Requisition Import
+----------------------------------------------------------------+
Current system time is 10-AUG-1999 07:59:36
+--------------------------------------------------------------+
APP-14720 Concurrent program POCIRM returned error Cause: POCIRM encountered
an internal error.
Parameters: REQIMPORT,INV,,CATEGORY,,N, Action: Note both this error number
and the actions you are trying to perform. Contact your system administrator
for assistance. Previous Messages (for Support Purposes)
APP-00606 Cannot read value for profile option REQIMP_AUTORELEASE
APP-00606 Cannot read value for profile option ORG_ID
APP-14064 POCIRM-222: ORA-00001: unique constraint
(PO.PO_REQUISITION_HEADERS_U1
+------------------------------------------------------------+
Concurrent request completed Current system time is 10-AUG-1999 08:03:42
+-----------------------------------------------------------+
From what I read in the readme for the patch, it looks like the system
profiles for REQIMP_AUTORELEASE and ORG_ID do not need to be specified for
this import to work correctly. If anybody can help me I'd be very happy.
-Thanks, Todd
Todd Manley
ZiLOG
408.558.8962
tmanley@zilog.com
Oxford Brookes University.url
Date: Tue, 10 Aug 1999 11:48:24 -0400
From: Jason Pickens JPickens@mercury.umis.upenn.edu
Subject: Re: PO: Requisition Import
What version are you running 10.7nca or 11nca?
Date: Tue, 10 Aug 1999 08:56:33 -0700
From: Todd Manley tmanley@zilog.com
Cc: "'Jason Pickens'" JPickens@mercury.umis.upenn.edu
Subject: RE: PO: Requisition Import
10.7nca
-Thanks, Todd
Date: Tue, 10 Aug 1999 12:08:39 -0400
From: Jason Pickens JPickens@mercury.umis.upenn.edu
To: Todd Manley tmanley@zilog.com
Cc: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Re: PO: Requisition Import
The req import must have a default of some kind in it. No will suffice if I
understand that you are not interested in the reqs autoapproving.
Receipt process not updating Sub-inventory
Date: Thu, 12 Aug 1999 00:14:25 EDT
From: Debasisc@aol.com
Subject: PO- Receipt problem
Hi,
We are implementing Rel 11.0.3 and experiencing the following problem during
Po-Receipt process.We are using average costing.
1. In the receiving transaction screen, the item inspection works properly
but, the delivery to a sub-inventory shows the following note:
rvtptcontrol failed
RVTII-060: Subroutine inltpu() returned error
Cause: Subroutine inltpu() returned internal error
Along with this note, the system shows that the records have been saved,
although the sub-inventory does not show any update of stock neither the
deliver transactions are shown in the "view receiving transaction" screen.
I will appreciate if someone can provide me with a solution to this problem.
Thanks
Debasis
PO for construction of a building, spreading across 3 years
Date: Thu, 12 Aug 1999 02:10:48 PDT
From: "seth umar" sepora32@hotmail.com
Subject: PO: How to create PO from building construction
Hi,
I have a question on issuing PO for a building
construction. Here's a scenerio.
1. We need to issue a PO (20 mil) to a contractor for a building
that will take two and a half year to complete.
Over this 2 1/2 year, payments will be made 5-6 times. This payments
will be spread using budget from 3 different years.
We are using encumbrance acct. We do not carry forward our encumbrance.
My questions:
1. If we issue the 20 mil PO this year, it will encumber 20 mil of our
budget this year. But we don't have that in amount in our budget.
We may only be able to make only 2 payments this year (and the contractor
itself may send us only 2 invoices). Next, 2 more invoices/payments next
year
(using next year's budget) and the rest the following year--followed by 10%
retention
only to be paid 1 year upon completion. Anybody out there has stg similar or
any
suggestions on how to handle this issue?
2. Currently when I match an invoice (partial payment let say $10)
to a PO ($30), I must enter in quantity 10/30 = '0.333333333333', then
only it'll accept. I cannot simply enter $10 amount to match and the
quantity calculate itself. Is there stg wrong in my set up?
3. When I created a PO for service, the amount become automatically
$1.00. I cannot overwrite this. Any advise?
We are using 10.7, SC16.0
Thanks in advance.
Seth
Date: Thu, 12 Aug 1999 13:29:52 +0300
From: "Nasir Valiya Veetil" vnasir@england.com
Subject: Re: PO: How to create PO from building construction
I can reply to your Q2 & 3
First of all it is not a good Idea to create PO with a value base Quantity
(Line Type) for purchasing of services like constructing a building. It is
not logical to receive a fraction of the building. Quantity based is for
buying materials that can be counted.
You use quantity based line items only when you know the quantity and price
of the line you are ordering. For example, you might buy a dozen Chairs for
$500.
You use amount-based line items when you are ordering a service/contract
like building construction. For example, you order $2 Ml of Building
Contract over the next 2 years.
Building construction is a contract based on amount. your PO value base
should be amount. So you create the PO as service and give the amount in the
quantity field. When you are entering amount based document lines in
Purchase Orders or requisition window, system will sets the price to 1. You
simply provide the total amount (20-Ml) as the quantity. Then, when you
record your receipts, you can enter the amount you have received as a
quantity. For example, if you have incurred $7 Ml of $20 Ml charge, you
record a quantity of $7 Ml. Then this amount will be available for the PO
matching in you AP.
Nasir V
Date: Sun, 15 Aug 1999 07:21:49 -0700 (PDT)
From: kartik iyer mukul061292@yahoo.com
Subject: Re: PO: How to create PO from building construction
Hi!Seth Umer,
Why don"t you try balnket or contract agreement pruchase order and
release the payments in installemnt as you are aware of the amount.as
far as the encunbrabce is concerned , the limit and the time period can
be set.You can give avalid date for the purchase order.I hope this will
help you.Thgis is as far as Release 11 is concerned.
Thanks ,
kartik
Customizing PO Account Generator for
Date: Thu, 12 Aug 1999 13:35:37 +0300 Discounts in PO
Date: Fri, 13 Aug 1999 16:20:05 BST Unable to view Sales Order for a requisition
Date: Mon, 16 Aug 1999 12:20:49 -0400 Approval Groups
Date: Tue, 17 Aug 1999 08:30:44 -0700
Date: Tue, 17 Aug 1999 12:01:11 -0500 Retainage in Contract PO
Date: Tue, 17 Aug 1999 16:10:26 -0400 (EDT)
Date: Wed, 18 Aug 1999 09:06:33 -0500
From: Siva Siva@nrec.com.kw
Subject: Customization of PO Account Generator
Dear All,
I need your help in customizing the PO Account Generator. I am working on
Rel 11.
My Accounting flexfield structure consists of company,site,dept and account
segments. I want to get values for site and dept from the expense account
assigned to the employee who is raising the purchase orders. We have
configured a similar requirement in 10.7 SC using Flexbuilder, but I am
unable to do so using the Account Generator.
I have completed the following steps till now towards customizing the
Account Generator:
1. Created a view called EMP_SITE_DEPT_V based on per_people_f and
Per_assignments_f with the following columns:
2. Created a value set called EMP_SITE_DEPT with type TABLE validated based
on the the view created in step1. I have selected person_id as the column
and site and dept as additional columns. The result of site and dept columns
are being passed to site_output and dept_output respectively.
I have tried assigning constant values to site and dept and got the expected
results. But I am unable to progress any further in customizing the Account
generator to derive values for Site and dept based on the employee entering
the Purchase Order.
Thanks in Advance.
Sanjay
From: "John Evens" evens_john1@hotmail.com
Subject: discount details in the PO
Hi,
Can any body tell me how to handle discount on PO. I want to enter discount
details in the PO.
John
From: John Sweeney jsweeney@goaa.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Cc: Carolyn DeSimone cdesimone@goaa.org
Subject: PO-Viewing sales order from a requisition
We are running Financials 10.7 SC161/RDBMS 8.0.5 on Sun Solaris. We are
using (amongst others) Govt Purch, Oracle Order Entry, and Oracle Inventory.
Using the Requisition Summary menu option (Purchasing Super User GUI
responsibility), we attempt to View Sales Order (from the Special menu) for
a requisition line that does have a sales order associated with it. We keep
getting the message "function not available".
The responsibility we are using to attempt this (and we tried many of them,
seeded and custom) does not specifically exclude this function. I have also
tried to include view sales orders, Orders view, and Order Lines view
funtions on the Requisition Summary Subfunctions menu. No help.
I didn't see any profile options that looked like they would help us. Nor
did I see any Purchasing set-up options that would help.
Can anyone offer any suggestions on this dilemna. Thanks in advance.
John Sweeney
GOAA, IT Department
407-825-3280
From: "Miller, Ann" Ann.Miller@glenayre.com
Subject: PO - Approval Groups
I am in 10.7 PROD 16.1 SC.
I am trying to make a very intricate Approval Group that will allow more
than one item range AND more than one account range. Each account range and
item range will also require a different document total. Has anyone tried
this?
From: "HANCOCK, David" dhancock@shl.com
Subject: RE: PO - Approval Groups
Ann:
Have you tried using the "exclude" parameter? There shouldn't be a problem
with different limits on totals. If your ranges overlap, the most
restrictive will apply.
Dave Hancock
From: Siva Shanmugham CMCISRS@NJTRANSIT.STATE.NJ.US
Subject: PO/AP Govt Financials : RETAINAGE in Contract PO
Hi All,
Our client has a requirement for Retainage Option in Contract Purchase
orders
- which looks like a major customization.
The requirement is summarized below:
Contract Purchase orders are subject to a retainage at the time of payments.
A
fixed amount/ percentage of the PO amount will be retained at the time of
payment. Once the contract is accomplished, the retained amount will be
released to the Vendor.
Can some one throw light on how to go about this customization?
If the list users had come across this, please share your experiences.
Example:
Contract PO Amount: $ 10000
Retainage %: 5% = $500
(Assuming 10 monthly payments made)
Monthly Invoice Amount $1000.
Based on monthly retainage, the invoice amount should be automatically
reduced
to (1000 - 5% of 1000) = $950.
At the time of matching, I need to create a Credit line that accounts for
the
retainage amount of $50. This credit line will show up at the Invoice
distribution level.
Monthly payments to vendor will be $950.
Once the contract is complete, the retainage amount (totaling $500) will be
released to the vendor.
(The retainage amount will be coded to a separate account)
Some of the issues that need to be addressed:
1. Can I customize the descriptive flex field at PO Header information with
Retainage amount?
2. When an invoice is raised against the Contract PO, I can match this
invoice
against the PO. If I need to bring the Descriptive FF information from PO to
AP, I need to populate the PO Line and shipment level descriptive flex
fields
with the retainage information from the PO header level (so that the User
will
understand how the retainage amount was arrived at). How can this be done?
3. At the time of matching, the retainage amount should automatically be
deducted from the Invoice amount. Can I show up this retainage amount as a
credit line in the Invoice distribution level? (so that the distribution
total will be the same as Invoice total.)
I hope my case is clear.
We are on 10.7 NCA.
Thanks in advance for any help.
Siva
Work - 973 491 8613
From: "Debbie Griffin" dgriffin@fnal.gov
To: ORaapps-l@cpa.qc.ca
Subject: PO/AP Govt Financials : RETAINAGE in Contract PO
We are in 10.7 character, and we use retainage, but we do it through debit
memos to avoid customization.
We do have a PO header DFF with an indicator as to whether the PO requires
retention and the percentage.
We enter the invoice and match it to the charge account at the full value.
Then we create a debit memo for the retention amount and credit our
retention account. We have a AP distribution level DFF where we reference
the PO number. Then we have a custom report that identifies all the open
retentions, by using the PO header DFF and the AP distribution DFF. I think
this works for us because our vendors our pretty good about indicating the
retention amount on their invoices. Also, our AP clerks are familiar with
the vendors that require retention. We have expanded the information that
appears when using invoice type "PO Default" to include the retention
percentage that is in the PO Header DFF.
Hope this helps. By the way, Retention is the NO. 1 enhancement request
for AP GOVT FINANCIALS.
-- Debbie Griffin
Fermilab
dgriffin@fnal.gov
630-840-8754