Internal requisitions
Date: Wed, 14 Jul 1999 10:29:54 -0500
From: "MCAVOY, Brian J." bmcavoy@shl.com
Subject: Internal req's
I'm running the min-max planning report and in it I'm trying to generate
internal req's, I get the message on the report that states ' unable to
generate requisition'. The purchase req's get generated fine but not the
internal. Can't see to find out why it can't generate the req's...any
suggestions?
Thanks.
Brian McAvoy
Consultant
EDS
pager 888-319-3433
x-------------x
Date: Wed, 14 Jul 1999 12:50:27 -0500
Date: Wed, 14 Jul 1999 23:07:02 -0400
From: "Downey, Dawn E" dedowney@kpmg.com
Subject: RE: Internal req's
What version are you running? Also, what version of the MinMax Report are
you running?
If you're running an older version of the report, it requires that the
requesting org be setup as a customer (and be given a location) in the OE
module...
There are also some other specific requirements that need to be done such
as:
In Purchasing, make sure the "Internal Requisition" document type is setup
(activated) and make sure that it has an approval assignment attached to
it...
In Inventory, make sure the Items you are trying to general an internal req
for are "Internal Order Enabled"...this appears to be true even if the item
is supplier sourced.
I believe any version 50.41 (???) or lower, there is a patch which will give
you an upgrade on the report which will eliminate the need for the OE
Customer setup....
If you want the internal req to just go straight to the Internal Order
process without approval, make sure the people who are running the report
have approval authority for the Internal Requisition document type and
ensure the document type has the attribute "Owner Can Approve"
checked...This way you can group the Min-Max Report, ReqImport, (Order
Import - if going to another operating unit's org), and Generate Internal
Order process into one report set and it'll all just run at one time, in
order and leave minimal manual work...You could then schedule an automatic
re-submission of the report group on a pre-set basis....
Let me know if there is any further information I can provide....You can
reach me direct via email...
Good luck!!
Dawn
Dawn Elise Downey
Senior Consultant - Oracle
KPMG LLP
Boston, MA
Office: 617-988-5629
Pager: 888-692-1071
Date: Wed, 14 Jul 1999 23:23:55 -0400
From: "Downey, Dawn E" dedowney@kpmg.com
Subject: RE: Generating internal vs. purchase req's
Brian:
Internal Reqs and Purchase Reqs are two different document types...
I would setup the internals as follows:
Setup the Internal Requisition document type as "Owner Can Approve".
For those people who will be running the Min-Max Report generating Internal
Requisitions, ensure that the position/job assigned to them has the Internal
Requisition document type attached to it as part of the approval assignment,
with the appropriate dollar amount limits and account code
restrictions...that way, when the report is run, those reqs will go through
automatically approved and be ready to made into Internal Orders (assuming
same operating unit; otherwise, you'd have to run OrderImport to bring the
req into the correct OU as well)....
For the Purchase Requisitions:
Setup the Internal Requisition document is so that the "Owner Can Approve"
checkbox is not checked...that way, it'll have to go through an approval
process...now, the only thing is how to get it into the appropriate
hierarchy...I am unsure how to do this in an automated fashion...I'd have to
look into it further...I can't think of a way of the top of my head at the
moment. Will the hierarchy differ dependent on the item being purchased?
That might make it more complicated...Again, I'll have to think on it a
little more.
Also, bear in mind, in this response...I am taking the term "external" and
assuming that you mean supplier-sourced, as opposed to sourced from an
organization outside of the organization within a specific operating unit...
This is probably confusing how I've written it...if so, I apologize..
Please feel free to email me direct with more specific questions or if I can
clarify anything...Also, it would be helpful to know what version of Oracle
you are working on.
Hope this helped somewhat...
Regards-
Dawn
Dawn Elise Downey
Senior Consultant - Oracle
KPMG LLP
Boston, MA
Office: 617-988-5629
Pager: 888-692-1071
Date: Mon, 19 Jul 1999 12:23:53 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: Internal req's
Hi,
Check out the item sourcing,this again is set at 4 levels check all the
levels.Check out whether the item attribute "Internal order enabled" is set
to yes.
Check out the Shipping networks.
Check whether the Item is also defined in the Organization which is the
source for this Item.
I suppose u might have done all these setups but they might help.
Regards,
Sunil Wahi
How to increase width of field Quantity on a PO
Date: Thu, 15 Jul 1999 14:28:27 -0400
From: "Annette Anost" aanost@goodegg.com
Subject: PO: Expand quantity field on po form
We are currently in release 11.02 and need to expand the quantity field on
the purchase order form. This field allows 7 digits and we require 9. Is
this a form development or a Standard Value Rule hidden somewhere?
Thanks in advance for your assistance.
Annette Anost
aanost@goodegg.com
Unable to enter Financial Option form
Date: Thu, 15 Jul 1999 19:36:39 +0000 (GMT)
From: "K. Shashi" kshashi001@yahoo.com
Subject: URGENT:Purchasing profile options ,calendar,financial options
Hi
I am having the following problems with PO setup
The define financials options form is not enterable and raises a when
new form instance trigger when i navigate to it from either purchasing
or PO This is release 11.0.28
I need to setup the business group there
it also raises an eroor global multi currency flag not found
I am also unable to access the approval group forms since i guess i
cannot set up the business group here
Purchasing people please help me
On our installation of release 11 of Purchasing and Accounts Payable, we
are
unable to display the calendar information when looking under the
'Control
Purchasing Periods' form, POXSCPP, and AP Accounting Periods, form
APXSUMPS). GL set of books, calendars, and currencies due exist and
are
opened. When viewing calendar information in Purchasing and AP, it
does
exist. What step or steps are we missing in order to allow this
information
to be displayed?
Thank you in advance for your help!
Problem in creating or querying an Inventory Organization
Date: Fri, 16 Jul 1999 13:14:40 +0500
From: fariha afreen fafreen@ora-tech.com
Subject: INVENTORY ORGANISATION----URGENT
Hi all,
I am working on Purchasing 10.7. While defining organisations or
querying existing organisations, when i click the "Others" button & try
to go to inventory information for inventory classification, a messgae
appears saying that this function is not currently available.Any Ideas
!!!!!
It was working fine previously.This is only happening today, we have'nt
changed any setup/profile options.
Any help would be greatly appreciated.
Regards,
fariha
Date: Fri, 16 Jul 1999 14:48:24 +0530
From: "Chitti Babu" cbabu@satyam.net.in
Subject: Re: INVENTORY ORGANISATION----URGENT
Hi
Please choose Inventory GUI responsibility to define Organizations.
Thanks
Chitti
Date: Fri, 16 Jul 1999 14:47:35 +0500
From: fariha afreen fafreen@ora-tech.com
Subject: Re: INVENTORY ORGANISATION----URGENT
Chitti,
Thanks for your help.I know u can do it through inventory responsibility but
i wanted to try this out thru purchasing resposibility cause it says in the
manual that this can be done thru purchasing as welll
thanks,
fariha
Date: Fri, 16 Jul 1999 16:22:25 +0700
From: "Nagamohan U." umohan@irs.co.id
Subject: RE: INVENTORY ORGANISATION----URGENT
Hi Fariha
For the responsibility through which you are trying to access these
organization parameters function (Inventory Information) is excluded.
Go to the System Admin and query up the responsibility. Check that the
function would have been excluded. Delete that line from the exclusions.
Hope this helps.
Regards/Nagamohan
Date: Fri, 16 Jul 1999 14:45:17 +0500
From: fariha afreen fafreen@ora-tech.com
Subject: Re: INVENTORY ORGANISATION----URGENT
Nagamohan,
Thanks for the tip. But i have checked through sys admin. there is no such
exclusion.
Thanks,
fariha
Date: Fri, 16 Jul 1999 04:31:51 PDT
From: "Shrikant Purker" shrikantpurker@hotmail.com
Subject: Re: INVENTORY ORGANISATION----URGENT
Fariha,
You get such messages in the GUI version when the cursor is at the header
and you try to click the buttons. Try positioning on the lines and then
click. I am assuming you are on GUI
Regards
SMP
Date: Sat, 17 Jul 1999 10:03:46 +0530
From: "Chitti Babu" cbabu@satyam.net.in
Subject: Re: INVENTORY ORGANISATION----URGENT
Hi
There will be a profile or some security function attached to Inventory
Responsibility which controls this action (defining Items). Go through
Sysadmin Responsibility and check . Alternatively you can create custom
responsibility to get actions , navigations that are required by users in
stead of changing default responsibilities.
Hope this helps
Thanks
Chitti
Problem with printing of PO attatchments in Word / Excel format
Date: Fri, 16 Jul 1999 13:37:19 +0100
From: alexandre.gravelin@degremont.com
Subject: Print PO Attachements
In PO when you attach a Long Text with the attachement type 'TO SUPPLIER',
the Long Text is automatically printed with the PO Document
It is working well with the Long Texts, but I didn't succed in doing this
with Word or Excel documents
Does somebody have any experience of that ? Is it possible or not ?
We've also planned to develop a special report for PO=2E Does anybody have
an experience of printing Attached documents in a customized report ?
Thank for any help
Alexandre Gravelin
Manufacturing Senior consultant
France
Date: Fri, 16 Jul 1999 08:59:40 -0400
From: Jennifer Knice JKnice@cerbpyro.com
Subject: RE: Print PO Attachements
Hello,
Unfortunately, my understanding is that Oracle only prints text attachments
(attachment type of 'long text' or 'short text' not the attachment type of
'file'). Therefore, Oracle is not designed to print attached files such as
Excel spreadsheets.
Jennifer Knice
Senior Consultant
Austin Solutions
769 Susquehanna Ave
Franklin Lakes, NJ 07417
(201) 891-1460 - Office
(973) 593-6544 - Client Site
PO import from legacy system
Date: Sun, 18 Jul 1999 03:07:25 PDT
From: "siddharta ganguly" pintu_100@hotmail.com
Subject: PO: Purchase Order Import
Hi All,
We are on R11.0.3, NT.
We want to import PO from Feeder System. I didn't find any concurrent
programme available for this purpose as available for Req. Import. Also, I
need to bring Purchase Agreement data, as entered in Excel, to Purchase
Order form In Oracle Purchasing. I am thinking of doing this either by PO
Import (if available) thru Interface table or directly into form, hoping
that the former will be much easier. I do hope somebody in this forum might
have done somethings like these.
Any help will be greatly appreciated.
Thanks in advance,
Jayanta.
Report of unpaid POs
Date: Mon, 19 Jul 1999 08:50:04 -0400 (EDT)
From: abdulfattah abdulkarim abdulfattah_a@yahoo.com
Subject: Unpaid POs
HI,
I received request from our end users to print report for unpaid POs.
Does PO/ AP provide such standard report.
We are 10.7 SC.
Appreciate Your feedback.
Abdul
Date: Mon, 19 Jul 1999 06:49:13 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: Unpaid POs
Hi,
I think Invoice Aging Report, available in AP, can solve your problem.
Ravi K.
Date: Tue, 20 Jul 1999 11:41:47 -0500
From: Carolyn Walker cwalker@mdp.com
Subject: Re: Unpaid POs
You could run the Open Buyer's report. All those with a status of Closed for Receiving and Open have not been paid yet unless the invoice was not matched to the PO.
You could also go into PO summary and ask for those with a status of Closed for Receiving and again for Open Orders and export the information to Excel.
Error on navigaing to Purchasing Options Form
Date: Mon, 19 Jul 1999 18:47:11 -0400 (EDT)
From: "K. Shashi" kshashi001@yahoo.com
Subject: Purchasing options
Hi Purchasing Gurus,
I am getting an error with Purchasing options when i try to navigate
into the form
get_window_org_sob_020 exact fetch returns more rows than expected
this error occurs in the purchasing options form
Thanks
Date: Mon, 19 Jul 1999 17:20:20 -0600
From: kbrown@es.com
Subject: RE: Purchasing options
Looks like a set of books type of error
...org_sob_20. I haven't seen this particular error before but your Set of
Books setups might be where you start.
Date: Thu, 22 Jul 1999 12:46:33 -0500
From: Mandar Dewoolkar-G1606C Mandar_Dewoolkar-G1606C@email.mot.com
Subject: Re: Purchasing options
I think the Purchasing Options form goes after PO_SYSTEM_PARAMETERS
table which should have only 1 record. Check this table to confirm.
Hope this helps.
Mandar
Date: Tue, 27 Jul 1999 22:28:35 +0100
From: "Erik Nijlant" nlnijla2@ey.nl
Subject: Re: Purchasing options
Hi Mandar,
We ran into the same problem with one of our clients after we had applied PO
mega patch M. OCS had a hard time resolving this issue but finally managed
after
running the following scripts:
Identifying problem:
select current_max_unique_identifier, org_id
from po_unique_identifier_cont_all
where table_name = 'PO_VENDORS';
select rownum, set_of_books_id, org_id
from ap_system_parameters_all
select rownum, org_id
from po_system_parameters_all
select rownum, set_of_books_id, org_id
from financials_system_params_all
Output from these queries:
CURRENT_MAX_UNIQUE_IDENTIFIER------ORG_ID
----------------------------- ----------
0--------------------------------------------------------- -3114
12601
ROWNUM-- SET_OF_BOOKS_ID ----- ORG_ID
---------- --------------- ----------
1---------------------1----------------------------- 102
ROWNUM---- ORG_ID
---------- ----------
1---------------- 102
Script to fix the problem:
update po_unique_identifier_cont_all
set org_id = 102
where org_id = -3114 and
table_name = 'RCV_SHIPMENT_HEADERS' or table_name = 'PO_VENDORS';
delete po_unique_identifier_cont_all
where org_id is null;
Regards,
Erik Nijlant
EY Oracle Service Line Netherlands
Batch approving POs
Date: Tue, 20 Jul 1999 16:59:49 +0100
From: "Das, Manoj (UK99)" Manoj.Das@UK.Honeywell.com
Subject: Batch approving Purchase Orders
Dear all
My client want to bacth approve Purchase Orders from a concurrent program.
Please could anyone tell me if the following steps are enough to approve
PO's.
- Create a corresponding row in PO_NOTIFICATIONS
- Create tow rows in PO_ACTIONS_HISTORY
(1st row with ACTION_CODE = SUBMIT
2nd row with ACTION_CODE = APPROVE)
Any help will be much appreciated.
Manoj :-)
Vendor import
Date: Wed, 21 Jul 1999 03:41:05 MYT-8
From: philip@aleytys.pc.my
Subject: PO: PO Vendors - Import? (10.7 SC)
Dear All,
I'm looking into importing approximately 1200 vendor into Purchasing.
There doesn't seem to be an open interface table available. Has anybody
tried populating the PO_VENDORS/PO_VENDOR_SITES_ALL/PO_VENDOR_CONTACTS
etc tables directly? Thanks!
Philip
Date: Tue, 20 Jul 1999 21:56:20 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: PO: PO Vendors - Import? (10.7 SC)
Hi Philip
We used a custom interface tables for the purpose. The task was achieved
through SQL Loader.
The following tables will be populated in the application for the conversion
of vendors:
· po_vendors
· po_vendor_sites
· po_vendor_contacts
Dependencies:
Following is a list of tables that need to be populated before vendor data
can be converted:
Foreign key dependencies:
· ap_distribution_sets
· ap_terms
· fnd_currencies
· gl_code_combinations
· gl_sets_of_books
· hr_locations
· org_freight
Quick code dependencies:
· po_lookup_codes for credit status, organization type, pay date basis, qty
receiving exception, receipt days exception, vendor type, witholding status
Use of sequence generators:
· po_unique_identifier_control
Below is the order in which the tables need to be populated for the
conversion of vendor data:
1. xxx_ap_vendors (custom interface table)
2. yyy_po_vendors (custom interface table)
3. po_vendors
4. po_vendor_sites
5. po_vendor_contacts
Hope this helps.
Ananth
Senior Applications Consultant
Date: Tue, 20 Jul 1999 15:28:39 -0700
From: "sean smith" kiowasean@zdnetmail.com
Subject: Re: PO: PO Vendors - Import? (10.7 SC)
We import vendors all the time (about 9,000 per week.)
We've not had any problems other than initially not populating all the fields we should have like 1099 data. Just make sure your functional folks carefully examine your results in test and are sure they will meet your requirements.
Date: Tue, 20 Jul 1999 16:06:41 -0700
From: "Heman Randhawa" hRandhawa@mvsn.com
Subject: Re: PO: PO Vendors - Import? (10.7 SC)
Can you explain the process in little more depth. We are just implementing AP and have about 500 vendors.
Thanks
Heman
Date: Tue, 20 Jul 1999 19:45:08 -0400
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Re: PO: PO Vendors - Import? (10.7 SC)
Sean,
If you would like to share that script for reference, it would be very
helpful to many funtional/technical people out there. I realize every
situation is different, however a base script to start with would be
terrific guidance.
Thank you,
Bill
Date: Wed, 21 Jul 1999 16:43:47 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply(2): PO: PO Vendors - Import? (10.7 SC)
Heman:
For somehthing like 500 vendors, you could get the job done by using an
Excel Macro.
Ananth
Senior Applications Consultant
Date: Wed, 21 Jul 1999 20:51:23 MYT-8
From: philip@aleytys.pc.my
To: "sean smith" kiowasean@zdnetmail.com, oraapps-l@cpa.qc.ca
Subject: Re: PO: PO Vendors - Import? (10.7 SC)
Hi Sean,
We don't use 1099 and VAT and EDI other such stuff. I looked at the data
created when entering vendors hrough the forms. If certain columns are
blank/null then would it be safe to assume that I don't need to populate
those columns?
Philip
Date: Wed, 21 Jul 1999 10:38:28 PDT
From: "Pandya Maruti" vijaay@hotmail.com
Subject: Re: PO: PO Vendors - Import? (10.7 SC)
May be you can map legacy data and make sure what columns will be coming
from Legacy.
1. create temp table to store these data coming from legacy.
2. write sql loader program to populate the above temp table.
3. write procedure to populate PO tables from above table.
Make sure 1099 data to populate in procedure.
I have done this custom import two times for two projects.
Good Luck.
Date: Thu, 22 Jul 1999 11:29:11 +0100 (BST)
From: =?iso-8859-1?q?Mohan=20Dutt?= mohan_at_pwc@yahoo.co.uk
Subject: Re: PO: PO Vendors - Import? (10.7 SC)
hi,
We have imported employees from a legacy system and then created them
as suppliers by populating the po_vendors, po_vendor_sites and
po_vendor_contacts table through pre-insert trigger. So whenever a new
employee joins the organisation and the legacy HR database is updated,
our employee master and supplier master table also gets updated.
Do let me know if you need any details.
Quickpick Vs default vendor
Date: Tue, 9 Feb 1999 10:04:04 -0500 (EST)
From: "Tony Marchegiano" TMarchegiano@mail.nbme.org
Subject: RCV: Enter Receipts
Hi all,
I'm not sure if this made it to the list the first time, so I'm
resending the following question:
In the Receiver responsibility, when in the enter receipts form,
the Source Type field displays a value, plus the PICK lamp appears on the
screen. Can someone tell me if this field is populated through a setup
step in Purchasing; or is this field
populated via the upgrade steps ?? In our instance, the field
is defaulting to Supplier, with the Quickpick only showing Supplier,
whereas we need to have Vendor default in this field. We are running a
development instance of 10.7 character mode.
Thanks
Tony Marchegiano
NBME
tmarchegiano@mail.nbme.org=20
AP unable to invoice against Finally closed PO
Date: Wed, 21 Jul 1999 11:54:37 +0800
From: Lee Joseph-EMLY54 Joseph.Lee.Tat.Kee@motorola.com
Subject: PO Final Close - AP Approval cannot proceed
Hi All,
Need your help/advise on the below issue.
we have a PO which was fully receipt and invoice was created. Then, the
buyer realized that the unit price was incorrect and get Finance to reverse
the invoice. After Finance reversed the invoice, the buyer did a "Finally
Close" to the PO BEFORE Finance can keyin the correct unit price. Now,
Finance cannot create the invoice to pay for this receipt.
I have called Oracle support (TAR# below). Their suggestion was to raise a
manual invoice, cr accounts payable and dr uninvoiced po receipts. But this
would leave the receipt quantity and billed quantity unmatched forever !
Pls help, thanks.
Regards,
Joseph Lee
Date: Wed, 21 Jul 1999 07:19:28 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
Subject: RE: PO Final Close - AP Approval cannot proceed
I believe that once you are at Finally Close that you have pretty much hit
the wall and that the only alternative is the manual invoice.
Approving POs from concurrent process
Date: Thu, 22 Jul 1999 09:36:07 +0100
From: "Das, Manoj (UK99)" Manoj.Das@UK.Honeywell.com
Subject: Approving PO's from a concurrent process
Has anyone done this before?
Any help will be much appreciated.
Manoj