ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
PURCHASE ACCOUNTING

Internal POs without Inventory

Date: Thu, 22 Jul 1999 17:51:55 +0100
From: c073 c073.bbs@btinternet.com
To: to@btinternet.com, OraApps-L@cpa.qc.ca
Subject: PO: Internal Purchase Orders without inventory

Does anyone out there use the Purchasing module without Inventory yet manage to produce internal Purchase Orders?

Any information will be of help
Ian Gardner
Britannia Building Society

Date: Thu, 22 Jul 1999 14:02:01 -0500
From: "MCAVOY, Brian J." bmcavoy@shl.com
Subject: RE: Internal Purchase Orders without inventory

You need the inventory module installed to generate internal req's, at least in 10.7.

Brian McAvoy
Consultant
EDS
pager 888-319-3433
bmcavoy@shl.com

Unordered receipts - inventory not updated

Date: Mon, 28 Jun 1999 03:17:12 PDT
From: ravi chandran johnny_ravi@hotmail.com
Subject: RE: unordered receipts- purchases

Hi! eveybody.

We received some items through this option. Afterwards, we amended an purchase order and added the items received as unordered. We want to match unordered item option & matched the unordered item with the purchase order.

our doubt is why the inventory did not get updated after the above transaction? has anyone had similar problems?

Thanks in advance for your assistance.
Ravi

PO approving heirarchy

Date: Sun, 25 Jul 1999 06:32:51 PDT
From: "siddharta ganguly" pintu_100@hotmail.com
Subject: PO: Purchasing Hierarchy

Hi all,

We r on R11, NT. Hope someone has solved such aproblem.
Our Purchasing Approval group & Hierarchy structure is something like this:

Chief Executive- All cost centres- Highest Position.

Under him, there are 2 Directors. And Director - Managers - Asistant Manager- User.

Director (C&S)-CC 200-299---Director (Marketing)- CC 300-399
---------||-------------------------------------||
Manager (Admin & CS)------Manager (Mktng & BP)
----- CC 213-214 ---------------- CC 312-313
||----------------------------------------||
AM (Admin) - CC 213.---------AM (BP) - CC 312

Routing Method- Hierarchy.

Now, the Admin user, by mistake, entered,in a purchgase doc, a charge account with CC 301, the document flowed to his AM (Admin). She tried to approve it; but couldn't do it. Without throwing up any message to her that she has not been able to approve it, it flowed to Manager (Admin). Similar things happened in every case till it reaches the Chief Executive who has the authority and has been able to approve it. Is there some way available thru which I'll be able to restrict the flow of such a doc to the immediate approver who will get a message about his inability to approve the doc and the doc will come back to the user with a mesage like 'No approver found....' in the Notification summary so that he can reassign it to an appropriate approver in Marketing division?

Thanks a lot in anticipation, Jayanta.

Notifications cannot be seen after applying Patchset PO.M

Date: Mon, 26 Jul 1999 11:51:16 -0400
From: "Ynes Coiscou, TRI" YCoiscou@tricom.com.dov Subject: Patch PO.M Notifications

Hello :
We have applied patchset PO.M and as expected we are having 2 major problem in Purchasing:
1. Notifications can't been seen, I'm getting error frm-40350 query has not record.
2. Organization transfer (intransit ) are set up as direct reception but it's working as standard reception ignoring the set up.

Have any of you face this problem? How did you solve it?
TIA
Ynes Coiscou
Sub Gerente Sistemas Financieros
MIS, Tricom
Tel. (809) 476-4622
Mail:ycoiscou@tricom.com.do

Date: Tue, 27 Jul 1999 08:46:18 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: Patch PO.M Notifications

There are four recommended patches to be applied after PO.M. Have you applied these as well?

839898 Server After appling PO patchset 16M (bug 805382), popchpo.sql overwrites[PARA]the view definition contained in porep.odf 80.81
851798 Server Enter Receipts form now queries up correctly
852233 Server Add outer join between po_headers_archive and hr_employees
784340 Client was possible to create releases for an unapproved Blanket purchase agreement using the autocreate form.

Graham.

How to drill down from GL to a Receipt against PO">

Date: Tue, 27 Jul 1999 16:17:14 PDT
From: "Greg Dietrich" gc_dietrich@hotmail.com
Subject: PO: YE - Tracing GL Batches to a Receipt **URGENT**

Hi All,

We are using Gov't Purchasing Rel 10.7 SC 16.1. We're set-up to accrual expense items 'On Receipt.'

Using this set-up, every time we create a receiving transaction (RECEIVE, DELIVER, CORRECT, etc...) a concurrent request is submitted, which then creates a GL patch (Type: Purchasing, Category: Receiving). The current request ID is included in the batch name, which is nice, but doesn't really help too much when trying to trace a GL Batch back to a receipt. I need to do this for some YE recociliation purposes.

The only way I've been able to do this through the front-end is to review the Journal Entries to get the line description (which is the item description on the receipt). With this information I then go to the 'Receiving Transaction Summary' screen and search for receipts created on the same date as the batch that have the same item description. This method works ok, but is tedious and not 100% accurate all or the time (i.e - it becomes a nightmare when the same item has many receiving tx on the same day).

So, I'm trying to right a script to get this info via the back-end. How can I join the appropriate tables to to do this. I was thinking I could join rcv_transactions to fnd_concurrent_request, but I can't see how those tables would join. So, I went a head an create a script that effectively does the same thing that as my tedious front-end process (Script included at bottom).

I'm not very happy with the results, and I know there's got to be a better way to join these tables. Any help you could provide will be greatly appreciated.

Thanks in advance.
Regards,
Greg
********************************
****Sample of Script************
********************************
select substr(a.receipt_num,1,7) receipt,
substr(d.transaction_type,1,11) type,
substr(d.transaction_date,1,11) tdate,
substr(c.name,1,30) batch_name,
substr(g.segment1,1,4) || '-' || substr(g.segment2,1,6) || '-' ||
substr(g.segment3,1,6) || '-' || substr(g.segment4,1,6) || '-' ||
substr(g.segment5,1,5) || '-' || substr(g.segment6,1,6) || '-' ||
substr(g.segment7,1,5) acct,
b.entered_dr debit,
b.entered_cr credit
from rcv_shipment_headers a,
gl_je_lines b,
gl_je_batches c,
rcv_transactions d,
gl_je_headers e,
rcv_shipment_lines f,
gl_code_combinations g
where a.shipment_header_id = d.shipment_header_id and
a.shipment_header_id = f.shipment_header_id and
substr(b.description,1,50) = substr(f.item_description,1,50) and
d.transaction_date = b.effective_date and
b.je_header_id = e.je_header_id and
e.je_batch_id = c.je_batch_id and
b.code_combination_id = g.code_combination_id
********************************
****End of Script************
********************************

Conversion of Open POs

Date: Thu, 29 Jul 1999 00:53:42 MYT-8
From: philip@aleytys.pc.my
Subject: PO:10.7SC: Purchase Orders Interface.

Hi there y'all

We are migrating from 9.4 to 10.7SC. I've managed to migrate the PO_VENDOR and associated SITE information via PL/SQL.

Now I am attempting to bring over all open PO's. The Open Interface manual apparently says to populate the PO_HEADERS / PO_LINES / PO_LINE_LOCATIONS / PO_DISTRIBUTIONS_ALL / (and one other table which name escapes me at the moment) directly. Anybody done this? The Open Interface manual docuements only the columns needed to match to invoices. I need to do receipts against these PO's as well.

However I notice that there are two tables in the PO schema: PO_HEADERS_INTERFACE and PO_LINES_INTERFACE, but I can't find any documentation on this. Note this is 10.7 SC. Refering to 11x functionality is intresting but I need something rather more immediate.

Philip

Date: Wed, 28 Jul 1999 14:48:36 -0500
From: "Shockey, David" DShockey@jwrinc.com
Subject: RE: 10.7SC: Purchase Orders Interface.

There are some interface tables that do nothing... yet. I've been told that they are part of future interfaces.

All I've ever heard from Oracle is that if you load tables directly you will be subject to having support withdrawn. We keyed ours in, but I've talked with people who did load the PO tables directly with no ill effects. Get some expert advice before you do it.

If you use any _ALL tables then you should use all of the others.

How to ascertain whether a PO is fully paid - across maybe multiple invoices

Date: Wed, 28 Jul 1999 17:17:57 -0400
From: mrosm mrosm@stratos.net
Subject: PO: Paid POs AP: Paid POs

Hi,

Can anyone tell me what is the best way to ascertain whether or not all lines from a PO have been paid given that all PO lines are not on the same invoice? We use Oracle Payables. However, there are still some Oracle who use Legacy systems. I'd like to create a query to ascertain the Paid PO status.

Thank you, mrosm

Creating PO Releases with Autosourcing

Date: Wed, 28 Jul 1999 17:29:18 -0400
From: Pravin_Kumar@FirstEnergyCorp.com
Subject: PUR Creating Releases with Autosourcing (10.7SC)

All,

I am creating releases automatically with the Create Release process, using auto-sourcing rules.

The problem is that the Create Release (concurrent) process groups requisition lines that are sourced to the same Blanket PO into the same Release.

We would like to keep all the lines on a Release restricted to one SHIP-TO location.

Are there any options to the create release process that will let us do this? Is this requirement achieveable only through customization ?

Pravin Kumar
Oracle Apps, Functional Consultant

In PO_HEADERS_ALL Table headers have Closed Date but Closed_code open

Date: Thu, 29 Jul 1999 14:44:16 -0500
From: Larry.Leser@IFLYATA.COM
Subject: PO: PO Headers with Closed Date with CLOSED_CODE = OPEN

I have stumbled across this today in our database, I haven't been able to find anything indicating whether it is correct or incorrect.

I found 99 rows in the PO_HEADERS_ALL table that have a valid 'CLOSED_DATE' but where the 'CLOSED_CODE' = OPEN.

Has anyone seen this before?
Is it correct, as in a previously used field that is no longer used?
Any knowledge would be appreciated.
Larry Leser
American Trans Air, Inc.
Phone: (317) 390-7977
Larry.Leser@IFLYATA.COM

Date: Thu, 29 Jul 1999 13:19:16 -0700
From: "Miller, Ann" Ann.Miller@glenayre.com
Subject: RE: PO Headers with Closed Date with CLOSED_CODE = OPEN

We logged a case with Oracle on this some time ago and had to get scripts to clean things up, the TAR # was 11683878.6, the problem is in cancelling lines or PO's at the header level. The only way around this in the application is to close the PO, do not cancel it. Apparently there was also a presentation at the October '98 OAUG on this very subject, it includes all the scripts that are necessary.

Ann Miller
Business Systems Analyst
e-mail to pager: 754356@vanpage.glenvan.glenayre.com
Phone: 604-293-4356
Pager: 604-642-7249

Changing Buyer Name in a PO with Approver Name remaining same

Date: Thu, 29 Jul 1999 21:51:29 PDT
From: "siddharta ganguly" pintu_100@hotmail.com
Subject: PO: Change in Buyer Name in Enter PO Form

Hi All,

In the Enter Purchase Order form, I change the buyer to somebody else, having approvers different from that of mine. In that case, the PO is going to the buyer's approver instead of that of mine. What change I need to do in the setup so that the PO goes to my approver even if the buyer si different? Please help me in this regard, as the requirement here demands such a thing. We r on R11.0.1,NT.

TIA.
Regards,
Jayanta.

Entering Employee information

Subject: [orahrms-l] Enter a person in PO
From: Siva Shanmugham CMCISRS@njtransit.state.nj.us
Date: Tue, 20 Apr 1999 10:16:25 -0400 (EDT)

Hi All,

1.
We are trying to bring in Employee info to make PO and AP operational. We do not have the HR module installed. When I create a new employee in the 'Enter Person' screen, I am not able to choose any of the Orgs defined in Inventory.

I added the classification 'HR Organization' for the Inventory Orgs already set up. This allows me choose this organization when defining assignments for the employee.

But the system allows me to choose any location for the employee, irrespective of the organization that is assigned. Can some one point out whether I am missing some thing?

Any set up issues in the Organization set up for HR organization?

2.
Is it possible to use any of the existing Oracle HR APIs for importing Employee details into
PER_PEOPLE_F, PER_ASSIGNMENTS_F and PER_ADDRESSES?

Thanks in advance,
regards,
sivaraj

Subject: RE: [orahrms-l] Enter a person in PO
From: "Driver, Paul" p.driver@ic.ac.uk
Date: Tue, 20 Apr 1999 15:42:05 +0100

Hi

I seem to recall that in INVENTORY there is a security screen where you can allow only certain responsibilities to 'see' organizations. It may be worth checking that first.

Cheers
Paul Driver

Subject: RE: [orahrms-l] Enter a person in PO
From: "Matson, Mark J." MatsonMJ@bvsg.com
Date: Tue, 20 Apr 1999 10:34:30 -0500

Sivaraj,

I presented a paper at the last two OAUG Conferences discussing this topic. A copy of the paper and code can be found at
target="_new">http://www.bvsg.com/papers/oracle.html.
I hope this answers some of your questions.

Mahalo (Thanks).
Mark J. Matson
BV Solutions Group
A Black & Veatch Company

To: kenschwartz kenschwartz@mindspring.com, orahrms-l orahrms-l@mail-list.com
Subject: Re: [orahrms-l] Enter a person in PO
From: Siva Shanmugham CMCISRS@njtransit.state.nj.us
Date: Tue, 20 Apr 1999 11:43:52 -0400 (EDT)

Ken,
Thanks for your reply.
To add up to my case:

I have say
loc1 - org 1
org 2

loc2 org 3
org 4
org 5

All these Org.s are set up as Inventory Org. When I create a Purchase Req, the location-organization is automatically validate by Oracle.

When I added 'HR Organization' classification to this Inventory Org 'Org 1', I can see this when I define assignments for an employee. Else the setup business group is the default org. for all employees.

The system allows me to choose any location ( loc 1 or Loc 2) despite Org 1 belonging to loc 1. If this is the way it works, will it have any bearing on other modules like PO/AP?

1.
For ex: If EXPENSE_CHECK_SEND_TO_ADDRESS is set to (O)ffice, will the system pick up this loc 1 address?

2.
Is there any impact on receiving transactions for materials? Is there anything like the Receiver should belong to the location into which the material is received?

I am worried about the implications of Employee assignment on his/her ability to perform Material transactions (PO/INV) and Expense checks(AP).

Can some one throw light on this?

thanks in advance,
regards
sivaraj

Subject: RE: [orahrms-l] Enter a person in PO
From: Marianne Brooks mbrooks@standard.com
Date: Wed, 21 Apr 1999 07:34:41 -0700

Siva,
Yes, the system will display either location despite Org 1 belonging to loc 1. Think of it this way: loc 1 is defined as the default location for that org, but you can put an employee in any location regardless of their org. This is to address the requirement for some companies that a single location support multiple organizations within their enterprise.

I can't address your other questions, other than to say that if you use Expense Express, AP should take the default expense account on the individual's assignment as the default expense account, but you didn't ask that! :-)

Marianne Brooks
Meridian Technology Group

Default charge Account for user/ responsibility

Date: Sun, 01 Aug 1999 20:25:33 PDT
From: "siddharta ganguly" pintu_100@hotmail.com
Subject: PO: Default charge Account for user/ responsibility

Hi All,

Can somebody tell me a way by which I can default a particular charge account into purchasing documents for a particular user/ responsibility? Here some users mostly use specific charge accounts only and so need these to default. Any help will be greatly appreciated.

TIA.
Regards,
Jayanta.

Date: Mon, 02 Aug 1999 11:13:32 -0700
From: "sean smith" kiowasean@zdnetmail.com
Subject: RE: Default charge Account for user/ responsibility

In 10.7 on the Employee setup screen, under "Assignments" there is a field called Default Expense Account. I've not used this, but online help suggests that this would default in to requisitions.

Date: Mon, 2 Aug 1999 14:02:48 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
Cc: "'pintu_100@hotmail.com'" pintu_100@hotmail.com
Subject: RE: ORAAPPS-L digest 3495

If this is for the creation of a purchase order, I believe that this will only work for an expense PO. The default expense account will default based on the "requestor" entered in the PO Distributions zone. You could setup fictitious employees to make this functionality work to you advantage. Assuming that you may want the expense account to be dependant on the requestor and one person may enter PO's relating to a variety of expense accounts. We do not use requisitions, so I cannot comment on that. You may be able to use flexbuilder to accomplish your goal, also.

HTH, Stan

Date: Mon, 2 Aug 1999 16:48:39 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: Default charge Account for user/ responsibility

We set up the Employee Default Expense Account in our test system...this provides a default expense account when you enter an employee expense reimbursement in the expense reimbursement template....it has nothing to do providing a default for entered POs or invoices by a particular user or responsibility.

Have you considered short-hand aliases?
Kathy Farmer
Scott County

Date: Mon, 2 Aug 1999 17:11:26 -0500
From: Tom Wyatt tom.wyatt@sitel.com
Subject: RE: Default charge Account for user/ responsibility

Then why does it state Purchase Order Information????? Just mislabeled???

Date: Mon, 2 Aug 1999 18:04:47 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: Default charge Account for user/ responsibility

Hi all:

Why? Just to throw us off I guess and to give us that kind of warm, fuzzy feeling we get we finally figure out the answer to an Oracle imponderable, "it looks like it should do 'x' but it doesn't, hmmmm, what does it do?"

Seriously, based on your question I went back into our test system to look at the HR setup; it's definitely related to the Invoices/Entry/Expense Reports function. Whatever you enter for the employee in the assignment-purchase order information alt area (full or partial AFF) shows up as a default when you enter an expense report for that employee. Maybe there's a way to also access that as a default for PO entry, but I didn't see it.

I'm thinking someone out there has met Jayanta's requirement previously.
Kathy

Date: Mon, 09 Aug 1999 12:48:58 -0300
From: Ken Heckbert kheckbert@ccgw.cc.hollandc.pe.ca
Subject: Default charge Account for user/ responsibility -Reply

You can use the information in the Default distribution field when entering Purchase Requistions and Purchase Orders, but you first have to add some customized rules to FlexBuilder. If you have access to the OAUG members-only section on the OAUG website, there are 3 or 4 excellent papers that explain how to customize Flexbuilder for this. If you don't have access, you can always buy the conference proceedings on CD, for not very much money.

Since you can use this information on PO's (with some customization) there's nothing really incorrect with the information Oracle has provided. It's just takes a little effort to set it up.

Ken

Date: Wed, 11 Aug 1999 08:41:02 -0500
From: Vijay.Govathoti@fritolay.com
Subject: RE: Default charge Account for user/ responsibility

It uses the expense account on the employee setup for requisitions created on the WEB ...
If there is none, it uses the expense account on the item setup...
Regards Vijay

Date: Sat, 14 Aug 1999 22:44:07 -0700
From: "Saranath P" saran_p@mailcity.com
Cc: satyam@sri.lanka.net
Subject: RE: Default charge Account for user/ responsibility

You can configure your flexbuilder to pick up segment values from the Default expense account assigned to the Employee. This has to be done by defining additional parameters. Though i've not worked on this, i remember having seen a document on OAUG. This talks about how the Cost Centre segment was defaulted from the Employee Account assignment to the Purchasing documents.

Hope it helps.
Prabu B