ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
PURCHASE ACCOUNTING

APP-14720 concurrent program POCISO returned error

Date: Wed, 18 Aug 1999 12:40:32 -0400
From: "Avrami, Louis" louis_avrami@es.adp.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: PO: APP-14720 concurrent program POCISO returned error

Hello all,

We're having a production problem, trying to create internal requisitions on our Release 10.7 SmartClient 16.1, RDBMS 7.3.4.4, AIX 4.3.2 instance.

Here's the error we're receiving:

APP-14720 concurrent program POCISO returned error
CAUSE: POCISO encountered an internal error
ACTION:
APP-00882 cannot open file \d04\app\applmgr\10.7\msg\5.0.161\mesg\usaeng.msb for
APP-14064 POCISO-110: ORA-00001: unique constraint
(OE.SO_LINES_INTERFACE_U1) vi

If anyone can offer any insights on how to clear this up, it would be greatly appreciated.

Thanks,
Lou Avrami ( louis_avrami@es.adp.com )

Date: Fri, 20 Aug 1999 13:01:22 -0400
From: "Mark W. Farnham" mwf@rsiz.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: APP-14720 concurrent program POCISO returned error

Two problems:

1) The messages file is not where it is supposed to be, and if it was you might possibly have more information.
2) Fortunately, in this case, it appears that the underlying cause is visible despite the problem with the message file: Please examine the columns which make up index/unique constraint OE.SO_LINES_INTERFACE_U1. Create internal requisitions is trying to a duplicate of the key defined by this set of columns. I don't have the tech reference handy. It may be just one column.

If this constraint is relying on a sequence number, then somehow the sequence got set back and you need to bump the sequence number ahead to avoid the problem.

If this constraint is due to the abortion of a prior run and clean up of the OE.SO_LINES_INTERFACE table was somehow incomplete, then you need to take a look at that table. If you decide to clean it up by hand, make sure you get an export of that single table before you do anything to it.

You'll probably want to carefully consider what documentation of this you will need regarding this situation for your next audit.

This sort of thing is not supposed to happen, so support should help you untangle it if you have support.

Good luck,
Mark

Categories are restricted

Date: Wed, 18 Aug 1999 10:40:56 -0700
From: "sean smith" kiowasean@zdnetmail.com
To: oraapps-l@cpa.qc.ca
Subject: PO - Categories are "Restricted"

We are on 10.7C with manufacturing, PO and Inventory as well as all the core financials. We have used categories extensively for some time. Recently, when entering PO's without item numbers, when we attempt to select certain categories on the PO Lines, we get an error message stating that the Category we have chosen is "Restricted."

In the category definition screens, the categories are not disabled (disable date is blank.) But still, the system tells us the category is restricted. Where else to look?

PO Approval - next in heirarchy cannot approve

Date: Thu, 19 Aug 1999 11:47:52 +0500
From: fariha afreen fafreen@ora-tech.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Approve Button disabled

hello everyone,

When a PO is raised & approved by the first person in the position hierarchy, the systen works fine.Now,when this PO is forwarded to the next person in the hierarchy, he is unable to approve this PO from the notifications summary.Instead, he can only forward it further in the hierarchy.

Any ideas??????

thanks in advance for any help.
fariha

Date: Thu, 19 Aug 1999 14:18:17 +0700
From: Argon Usman argon@newmail.net
To: oraapps-l@cpa.qc.ca
Subject: Re: Approve Button disabled

Can he approve it from the Respond button in Notification Summary?

Date: Thu, 19 Aug 1999 09:04:16 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Approve Button disabled

Hi,

You are having problem with the funciotn that is disabled for this user. Which version of ORacle Apps are you in ?

There is a new featuer in assigning menus to resp.s in Apps 11.0.2. When assign the main menu to a user, you can mention which are the functions that are not to be assigned to / not to be seen by the user.

Go to "Define Resp.s" screena and you will find out in multi record block at the bottom where this function has been added to avoid for that partilcular Resp.

Remove/delete that line and the persopn will be able to see the buttons.

Thanks, -chakrapani

Approval Heirarchy feature for Purchase requisitions

Date: Fri, 20 Aug 1999 14:44:52 -0700
From: "GILL, TONY" TGILL@ISD.COM
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: RE: Email address of the discussion group

Greetings-

It would be appreciated if you would forward this message to an oracle user(s) who is currently utilizing the approval hiearchy feature for purchase requistions on Oracle. I am currently in the process of implementing this feature here at my company and I'd like some feed back as to how this feature has worked so far.

What challenges have you faced in this implementation? How did you handle the problem of routing purchase requisitions when the proper people are out of the office? How did you handle the problem of purchase requisitions being submitted incorrectly such as insufficient information?

A reply would be appreciated.

Thanks, Tony Gill

Date: Mon, 23 Aug 1999 21:56:43 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Purchase Requisitions

Tony,

i have setup purchase module in 10.7sc & 11.0.3. No problems.
In case you need any specifics let me know.
Ravi

Requisition - error on save

Date: Mon, 23 Aug 1999 01:30:53 -0700 (PDT)
From: kartik iyer mukul061292@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Requisitions in Purchasing

Hi,
There is a problem with the following:
1.The requisitions button is clicked in the Purchasing The details are entered.While saving an error occurs:
"Please choose an existing combination"
All the other functions can be carried out
2.In BOM also the same error occurs while creating a New Bill. Has any one come accross this problem and found a solution ? I have checked all the profiles and the Document types,the Assignment Groups , Assignment etc.

This is very very urgent Please send the solution if available immediately

Thanks,
Regards Kartik

Date: Mon, 23 Aug 1999 10:44:11 +0200
From: Clive Calder CliveC@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Requisitions in Purchasing

Hi

This error message normally occurs when the inventory item is not assigned or is not active. Alternatively, the item attributes may not be correct.

Regards
Clive Calder

Date: Mon, 23 Aug 1999 12:35:02 +0100
From: alexandre.gravelin@degremont.com
To: mukul061292@yahoo.com
Cc: oraapps-l@cpa.qc.ca
Subject: =?ISO-8859-1?Q?R=E9f._:_Requisitions_in_Purchasing?=

I had the same problem,

It's seems that the problem is due to the item category flex key

I've solved the problem by creating several categories for the PO category set, and checking the option "enforce value list" for the category set (and adding the categories as values of course)

Regards Alexandre

Date: Tue, 24 Aug 1999 09:28:37 +0700
From: Argon Usman argon@newmail.net
To: oraapps-l@cpa.qc.ca
Subject: Re: Requisitions in Purchasing

If you are on Rel 11, You might want to check your flexbuilder, whether your Company Accounting Flexfield exist, if it isn't there, it's a bug, you can ask Oracle Support for the patch.

Regards,
--
Argon I. Usman Consultant

Date: Mon, 23 Aug 1999 10:04:10 EDT
From: "Senthil Anand" sa272@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Requisitions in Purchasing

Hi,

Check the validity of ur categories.. usually default Purchasing categories

Senthil

Date: Sat, 24 Jul 1999 07:22:14 -0500
From: "Danette Fedock"danette_fedock@ccmail.c-tec.com
To: oraapps-l@cpa.qc.ca
Subject: Re[2]: Requisitions in Purchasing

If the code combination being created by flexbuilder does not exist, you will get this error.

Patchset N

Date: Mon, 23 Aug 1999 15:19:07 -0400
From: Jeffrey Beckstrom JBECKSTROM@gcrta.org
To: OraApps-DBA@cpa.qc.ca, OraApps-L@cpa.qc.ca, oranca-l@doug.org,
Subject: po patchset n

Will are attempting to install patchset N. The driver is getting an error attempting to access a object called fnd_concurrent.init_request. This object does not exist in fnd_concurrent package. Has anybody successfully installed this patchset.

Date: Mon, 23 Aug 1999 16:01:44 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: po patchset n

I think you got release 11 patch on 10.7.
Madhu

PO Requisition interface and dynamic insertion

Date: Tue, 24 Aug 1999 17:04:58 CEST
From: "massimo carniel" gneppo@hotmail.com
Subject: PO: Requisition Interface & dynamic insertion

Hi Gurus,
according to your experience, should the requisition open interface dynamically create CODE_COMBINATION_IDs, while receiving charge account segments? If yes, under any particular condition?

Thanks Massimo

Attirbutes of Requisition to populate PO attributes

Date: Wed, 25 Aug 1999 22:51:51 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
Subject: Purchasing Question ....

HI All,

When I create a requisition , I feed some of the DFF attribute columns. Once I approve and go to Autocreate PO screen , I see all requisition over there. I want to carry forward attribute columns what I entered in Requisition screen.

Is there any way to do that?

Any help would be appreciated.
Thanks.

Date: Thu, 26 Aug 1999 10:27:03 +0930
From: "Irani, Kermiz" Kermiz.Irani@boral.com.au
Subject: RE: Purchasing Question ....

Its not standard functionality as far as I know. If you do mod. it, keep in mind that requisition lines can consolidate on a PO so if you did want to transfer it to the PO, the PO distribution is really the only unique place. I have not checked the autocreate screen for what it displays. What exactly are you trying to do with it?

Regards, Kermiz.

Date: Wed, 25 Aug 1999 18:19:05 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
Subject: RE: Purchasing Question ....

Dear Jayanti,

The mentioned problem may not be a problem at all. If you want to see the DFF details after Auto Creation, should you not have same DFF structure at the target location i.e. PO?

Requisition Headers relates to PO Headers
Requisition Lines relates to PO Lines
..... ..... ..... ..... ..... .....

Make sure that you have the exactly same DFF structures at the respective places,i.e. say Requisition Headers DFF Structure = PO Header DFF Structure. Once that is done, the Requisition DFF details will show up at the PO DFF level on AutoCreation.

You can go one step ahead. The same DFF details can be carried forward to the respective DFFs in Supplier Invoice. Try that.

Prasanna Jena
KAY Software Inc.,
Silicon Valley.

Date: Thu, 26 Aug 1999 8:57:21 +0100
From: alexandre.gravelin@degremont.com
To: vijaay@hotmail.com
Subject: =?ISO-8859-1?Q?R=E9f._:_Purchasing_Question_....?=

We have the same needs Unfortunatly the only way to carry forward the Req Line DFF to PO line DFF is to develop a customisation

This customisation can be a simple trigger, but you have to be carrefull in case of grouping several req lines on a single PO line You do you want to do with the DFF in this case ??

Hope this help
Alexandre GRAVELIN
Paris

Date: Thu, 26 Aug 1999 16:44:42 +0930
From: "Agatep, Joel" Joel.Agatep@boral.com.au
Subject: RE: Purchasing Question ....

Hi

We are using 10.7SC and I seemed to experience the same problem. I filled up the DFF attribute fields in the requisition interface table, run the import which creates the requisitions with the DFF attributes intact. However, when I run the autocreate to create the PO, the DFF's seem to disappear. I have not found the reason why.

Joel

Date: Thu, 26 Aug 1999 16:29:09 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
Subject: RE: Purchasing Question ....

Thanks for your reply Irani.

Basically User will be entering FileNet Number in Attribute1 of DFF which is used to show Filenet image from external system. That's why we have added one button to call the image from external Imaging system which uses this Filenet number (attribute1 of DFF).

But once user create PO using autocreate screen and if thet want to open filenet Image from Imaging system, they can't. Because there is no value in attribute1 of DFF of autocreate screen even though that screen shows all requisitions. User has to go back to Requisition screen and find out Filenet number and come back to autocreate screen and enter that number in Attribute1 of Autocreate screen and then only he can view that image over there.

I hope I explained it properly.

Any help would be appreciated.
Thanks.

Date: Thu, 26 Aug 1999 16:53:57 EDT
From: "Raj P" raj_orapps@hotmail.com
Cc: vijjaay@hotmail.com
Subject: RE: Purchasing Question ....

Hi

REquisition distribution DFF will go forward to Po distribution dff when u run auto create po program..

You will have to enable attribute(s) in both requisition DFF and Po distribution DFF.

Raj

Date: Thu, 26 Aug 1999 22:54:50 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
Subject: RE: Purchasing Question ....

Thanks for responses. My question is : Does Requisition Header Program go forward to PO Header Program? Because we are entering Attribute1 of Requisition Header and not Requisition Distribution.

Any response would be appreciated.
Thanks a lot.

Date: Fri, 27 Aug 1999 09:22:32 EDT
From: "Raj P" raj_orapps@hotmail.com
Subject: RE: Purchasing Question ....

Hi

The requisition header DFf will not go forward to PO header DFF thru autocreate po program, the reason being you have the facility to group many requisitions to one PO thru PO autocreate program.

Rajagopalan

Date: Tue, 31 Aug 1999 00:10:58 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Purchasing Question ....

Hi All,
As per my testing, I tried to create PO by selecting Requisition line of Autocreate Screen and I had same DFF at Requisition as well as PO level, still it didn't transfer DFF from Requisition to PO. May be I am something missing.

I am planning to write on-insert Database trigger on PO_HEADERS_ALL table but I am not getting link column between PO_HEADERS_ALL table and PO_REQUISITION_HEADERS_ALL.

Does anybody has clue on this?

Thanks a lot.

Date: Tue, 31 Aug 1999 14:17:59 +0100
From: alexandre.gravelin@degremont.com
To: vijaay@hotmail.com
Cc: oraapps-l@cpa.qc.ca
Subject: =?ISO-8859-1?Q?R=E9f._:_RE:_Purchasing_Question_....?=

The link between the PO and the requisition is located on the PO distribution

This is the only way to find the requisition line, becasue PO allows you to consolidated several Req lines on 1 single PO and also on 1 PO line or shipment Only the distributions match one to one the req line

So, for your trigger, you have to find a distribution that is linked to the req you wants the DFF from, them find the req line id, and then the req header id and your original value for DFF

If you have several distributions on the same PO with several source req, you will have to chose on of them

Hope this help
Alexandre GRAVELIN
FRANCE

DFF values to default from Req. line to Distn level

Date: Thu, 26 Aug 1999 18:04:54 +0930
From: "Irani, Kermiz" Kermiz.Irani@boral.com.au
Subject: AOL: Defaulting info into DFFs & display only

Hi,
We have a context sensitive DFF setup at the requisition line level. We also have a DFF setup at the requisition distribution level. If the user has entered the info at the line level, we do not want them to bother with the distribution level DFF, however, we do need that info in the distribution level DFF as our custom report selects of the distribution level DFF.

I was wondering if there was a way to get the line level DFF info into the Distribution level DFF. At the moment, I have setup the distribution level DFF segment to have a sql statement default type where I am selecting from the form field at the line level DFF. However, it does not seem to take on the value entered at the line level UNLESS I actually go into the Distribution level DFF on the screen. I want it to take the value WITHOUT anyone actually going to the distribution level DFF.
Any suggestions, please?
I do realise, I can amend the customisation but I am trying to avoid that if I can use std functionality.

While on the subject of DFFs, is there a way to make a segment display ONLY? The info in there is coming via an interface and we want the users to see it but not change it.

Any help will be appreciated.
Thanks, Kermiz.

Cancelling POs

Date: Thu, 26 Aug 1999 08:32:24 PDT
From: "prince suthakar" prince_sutha@hotmail.com
Subject: po cancel help

Hello Po Guru,

Problem1. How to cancel the Pos. and some po's paid half amount.

Exp: Po for 1000, paid 500. Balance amount po should cancel.

Could you please help me out.

Problem2. My user cancel some po's. When I see in Po query screen closure status is OPEN. In cancel field is ok status. This is correct. If it is not correct how should cancel the proper step.

Problem 3 How to change the status open to closed

Please help me . very urgent.

Thanks
Prince

Date: Thu, 26 Aug 1999 12:10:40 -0400
From: Ken_Rosenbaum@lcc.com
Subject: Re: po cancel help

To cancel a PO:

Go to the po summary screen. Select the PO. Select special, control, cancel PO.

Date: Fri, 27 Aug 1999 21:36:37 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
Subject: Re: po cancel help

prince,

Monitoring the po is possible throgh the purchase summary option. In that screen choose special/control and you will have various alternates like cancel,close for invoice, close for receiving etc. You can apply this to po you want.

Hope this helps.
Ravi

Requisition Form does not open

Date: Sat, 28 Aug 1999 02:32:22 -0700 (PDT)
From: kartik iyer mukul061292@yahoo.com
HiFriends ,
The Requisition form in the Purchase module does not open. It gives the following message :
Please choose an existing combination.The system defined accounting flexfields were compiled in the flexbuilder and setup was done .In spite of this the form does not open .Also new accounting flexfield for XXX trading was created and compiled .Still the problem exists. If anyone has faced this problem and found the solution please shoot back as it is quite urgent.

Thanks,
Kartik
Functional Consultant
Relicon , Dubai

Date: Mon, 30 Aug 1999 11:30:23 +0700
From: Argon Usman argon@newmail.net
To: oraapps-l@cpa.qc.ca
Subject: Re:

Which release are you using? If it is rel. 11.0.3, please try to look at your account generator process. Check whether your company accounting flexfield has a complete set of processes (it should be 8 of them). If it doesn't, please call Oracle Support for patch as it is a known bug.

good luck,
--
Argon I. Usman
Consultant

GRN - Cancellation of

Date: Sun, 29 Aug 1999 07:05:02 +0500
From: "Amir Anwer" amiranwr@pienet.net
Subject: PO - Cancelation of GRN

Hi all

We are on 10.7 SC.

Is it possible to cancel a GRN i.e. receipt when all of its items with full quantities are 'Returned to Vendor'?

Any pointer or advise will be a great help.
Regards

Inventory Orgs in LOV - restrict No. of

Date: Mon, 30 Aug 1999 11:05:23 +0200
From: *Hassid Marco Marco.Hassid@infostrada.it
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: PO: Destination Organization

Hi everybody,
we're implementing INV, PO and AP, Rel. 11.02. We have three Inventory Orgs, plus the Master Organization. When creating a Requisition or a Purchase Order, the List of Values for Destination Organization shows all the four Orgs while the users would like to see just the three real organizations and not the master, both for lines with items and for lines with description, category and UOM (one-time items). As far as you know, is there any way to limit the List of

Values?
Thanks in advance
Marco

Date: Tue, 31 Aug 1999 03:17:48 +0100
From: "SRS FreeZone" srs@freezone.co.uk
To: oraapps-l@cpa.qc.ca
Subject: Re: PO: Destination Organization

Marco,

If there is no way from within PO, then it can be done by using Custom-PLL to not include the master org in the LOV. Custom-PLL does not alter your form itself and does not affect your support terms.

Steve.

Date: Tue, 31 Aug 1999 07:38:51 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: PO: Destination Organization

Marco,

There is a form on the INV SuperUser menu called Organization Access (Setup.. Organizations..Organization Access). This screen allows you to restrict Organization access by responsibility.

Date: Tue, 31 Aug 1999 21:40:56 -0400
From: dfortnam@whittman-hart.com
To: oraapps-l@cpa.qc.ca
Subject: RE: PO: Destination Organization

Be careful using this functionality; it is an all or nothing type of entry. Once you restrict access to one responsibility, all other responsibilities have no organization access unless it is specifically entered for each responsibility needing organization access.

Doug Fortnam
Whittman-Hart/Boston

po_vendor_sites_all - copy from one org to another

Date: Mon, 30 Aug 1999 13:44:33 -0400
From: "Sankala, Dinesh" Dinesh.Sankala@lgeenergy.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca

hi
i've a question , here the client wants the data in the po_vendor_sites_all in one organization copied into another organization(new one). But when the data is copied and when we tried to query the data in the applications we are getting an error like exact fetch returns more than one row. It is querying on ap_vendor_sites_v.

we have data like this in PO_VENDOR_SITES_ALL :

Org idVendor_site_code_alt

1 11111111
2 1111111

The form ( Supplier Entry ) and zone Sites which is based on the view AP_VENDOR_SITES_V

any help will be greatly appreciated
malay

Date: Mon, 30 Aug 1999 11:20:59 PDT
From: "Ronald Young" ronaldyoung@hotmail.com
To: oraapps-l@cpa.qc.ca

How did you copy the record??? Using SQL*PLUS??????