Changing Receipt Date
Date: Sun, 13 Jun 1999 21:10:57 -0700 (PDT)
From: FMT firas70@yahoo.com
Subject: Wrong date for reciept !
Hi,
We have entered a PO in a date that is 3 periods
prior to the current date .. the promised date,
shipment and distribution date are the same.
When creating a reciept, The end-user entered it
in the current date and did not enter the actual
date of recieval!
We are looking for the best way to change the
reciept date to suite the actual date which is the
PO date.
One of the propesed solutions is to return the
materials to supplier and creating a new reciept?
Any Comments ??
Firas Al Tamimi
ADWEA
Vendor Rescheduling
Date: Mon, 14 Jun 1999 19:37:36 +0300
From: "Cohen, Dan" Dan_Cohen@icomverse.com
Subject: PO:Vendor Rescheduling
We are working on Release 11.02
In our PO life cycle we use to maintain the vendor date and the promised
date many times due to lots of changes in the supplements of our vendors the
demands of our customers. In every such a change the revision of the PO is
increased and the status is changed to 'requires re-approval'. This fact
causes us to deal with a lot of re-approvals during the day.
We are looking for a resolution which will enable us to decide at what
changes the PO status will be changed to 'requires re-approval', and to be
able to decide that in particular tolerances of changes the PO status will
remain 'approved'.
Any information will be appreciated.
Regards,
Danny Cohen
Date: Wed, 23 Jun 1999 10:03:08 +0100
From: Peter Wolyniec pwolyniec@edenconsulting.co.uk
Subject: RE: Vendor Rescheduling
Hi Danny,
You're problem is well catered for in Workflow, which as a r11 site you are
using within Purchasing.
You need to setup the Workflow Builder so you can modify the existing
workflows that operate underneath your Purchasing environment. I believe
the one you're interested in is the PO Approval workflow. You can change
the tolerances to suit your needs with the builder and then make sure that
that workflow is assigned to all required document types.
Hope this helps.
Pete W.
Date: Wed, 23 Jun 1999 20:00:08 +0300
From: "Cohen, Dan" Dan_Cohen@icomverse.com
Subject: RE: Vendor Rescheduling
Peter,
As I understand, according to your suggestion we have to change the code in
the system, is it right? Our policy is to prevent coding of customizations
as much as we can. Is there any workaround that Oracle suggest without
customization?
Regards,
Danny Cohen
Contractural Vs Expected Shipment Date
Date: Mon, 14 Jun 1999 22:55:02 +0300
From: "Dina Rotem (h)" dinar@rafael.co.il
Subject: PO: Contractural Vs Expected Shipment Date
We are implementing Manufacturing, Purchasing & Payables in release.
Our business requirement is to record on a purchase order shipment the
due date which was agreed with the supplier and defined as the
contractual date. Changes of that date should be done only by a change
order mode, where both parties agreed to change that date.
The business procedures are to track the supplier performance by
comparing the actual receiving date with the contractual date. In some
cases the supplier would be fined for late delivery, meaning he will be
getting penalties deducted from his invoices.
On the other end the planner would want to know the expected date of
delivery, as soon as possible. The buyer may know of expected dates for
the future shipments, and should hence change promised date on the PO,
so MRP will be able to get that.
However, changes in the promised date are treated as expected date for
planning purposes, and should not be affecting the contractual date.
How do you maintain the contractual date on Oracle Purchasing? Does the
need-by-date a good solution for that?
Dina
Charge Account Generator error
Charge Account Generator error on creating a PO
Date: Fri, 18 Jun 1999 20:04:52 +0530
From: Chandrashekar S SSChandra@inf.com
Subject: PO Charge Account Generator error
Hi all,
We recently upgraded PO module from 10.7SC -11.0.1 -11.0.2.
We chose the second option i.e "Apply Patches to Individual Modules"
to upgrade from 11.0.1 to 11.0.2.
When we try to create a PO, Account Generator is supposed to automatically
generate the PO Charge Account. But this is not happening. Instead we have
to manually enter the code combination for PO Charge Account. After entering
this, the PO Variance Account & PO Accraul Accounts are created
automatically.
Can somebody explain this behaviour ? Is this a known bug ? Are there any
patches to be applied ?
Further we want to customize the "Build PO Charge Account" procress.
According to R11 release notes, all 8 item types of PO have consolidated
into
two Item types namely "PO Account Generator" & another for PO requisitions.
In the Account Assignments screen of AOL, these two Item types do not
appear. instead the old 8 item types appear.
Our doubt is which Item Type needs to be customized ? The old "PO Charge
Account Generator" or the new "PO Account Generator" ?
Any inputs on these would be greatly appreciated.
Chandrashekar.S
Date: Mon, 21 Jun 1999 14:26:31 -0700 (PDT)
From: Jason Chan jchan14@yahoo.com
Subject: Re: PO Charge Account Generator error
Without knowing the way your PO module and WF are set up, I don't know
why the PO Charge Account is not being generated. However, the reason
for the Variance Account and Accrual Account to be generated is that
they automatically default to the Charge Account code combination
unless specifically replaced. So, the Variance and Accrual Account
Generators are working as designed.
As far as customizing the PO Charge Account Generator, you need to do
the customization in the consolidated "PO Account Generator"!! Any
changes you made to the individual account generators will be a waste
of time. The fact that the consolidated "PO Account Generator" and "PO
Req Account Generator" do not appear in the Account Assignment screen
is a known bug. Oracle Support has a patch to seed these two Account
Generators so they will show up in the screen.
I hope this info will help.
Jason Chan
i2 Technologies
Date: Sat, 26 Jun 1999 13:35:15 +0530
From: Dilip Fauzdar DilipFauzdar@inf.com
Subject: RE: PO Charge Account Generator error
Dear Jason,
We contacted the Oracle for Patch as per your advice.Oracle sent
us the patch 848186.But even after applying this patch we are not able to
see consolidated PO item types in ACCOUNT ASSIGNMENT screen.We are on
Release 11 on Sun Solarisis.Is this the correct patch.If you have the
correct patch then can you send the *.zip file to us.
Thank you very much for your help.
regards
dilip
Infosys Technologies ltd, India
Charge Account error on Receiving goods
Date: Fri, 18 Jun 1999 09:21:38 PDT
From: Piero Bertuzzi pbertuz@hotmail.com
Subject: Problems With Flexbuilder in Receiving Goods URGENT
We have implemented Oracle Purchasing in release 10.7SC version 16.1 We have
customized the Purchase Order Charge Account with the flexbuilder.
The Charge Account was generate correctly from the flexbuilder function and
the order can be approved.
The problem appears when we receive goods through
the Receiving Form.
The program decreases correctly the Organization Expense account but
increases the Expense Account Defined in Master Items, instead of the
Purchase Order Charge Account.
Any suggestion is appreciated.
Thanks
Piero Bertuzzi
Oracle Manufacturing Consultant
Engisoft S.p.A. Milan (Italy)
Building Charge Accounts
Date: Mon, 21 Jun 1999 16:14:00 -0500
From: Tom Wyatt tom.wyatt@sitel.com
Subject: Flexbuilder Help
If there is anyone out there who can assist me in building my PO Charge
Account utilizing flexbuilder, could you please respond to me directly. I
am
trying to utilize a descriptive FF attribute to place a value in my AFF and
I am receiving a Circular Reference error and OWWS is providing no
assistance.
Thank you.
View note - not visible in AP
Date: Fri, 18 Jun 1999 11:26:20 -0600
From: "Newitt, Mike/COR" mnewitt@CH2M.com
Subject: AP: View note attached to PO when matching
10.7 NCA
The Purchasing ref manual says a note to Payables can be attached to a PO
and viewed in AP when matching the PO to an invoice. I attached the note to
the PO successfully (to both header and line levels) with the proper 'To
Payables' usage, but can't see it anywhere in AP when entering an invoice
and matching the invoice to the PO. Anyone have this working? If so, where
exactly in the invoice entry form can the attachment be viewed?
Debit Note & Receipt amount mismatch
Date: Mon, 21 Jun 1999 12:42:00 +0500
From: dhirajr@calpst.niit.co.in
Subject: PO and AP
Hi guys....
I just wanted to know how this situation is handled in Oraccle Apps...
pls help.
In Ap while raqising aN invoice i match it with the PO and the Reciept
Not then subsequently i raise a Debit note against that invoice and
reduce the amount.... which would have its impact in the Receipt note as
it would be recd at the original rate and hence it would be
overvalued.... will Oracle apps automatically rectify the valuation of
the material to the rectified rate? pls let me know
regards
Date: Mon, 21 Jun 1999 07:20:26 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: PO and AP
Dhiraj,
You may be able to do that if you match your debit memo to the
purchase order shipment. Otherwise, the impact is limited only to the
invoice distributions.
HTH.
Ravi K.
Date: Tue, 22 Jun 1999 10:27:48 +300500
From: BPL-UPTRON_Team@india.notes.pwa.co.in
Subject: Re: PO and AP
In such scenario raise a debit note and rematch it to PO with negative
qunatity in case you wan't to treat as a return and if you just wan't to
treat it as a price correction, in that case do shipment price correction.
If this correction is in relation to return of material, than first return
the material and then perform this, since AP doesn't have anyimpact on
valuation.
Hope this helps
Navin Gupta
Unable to Approve PO after Reserving it (App 14056 error)
Date: Mon, 21 Jun 1999 17:30:56 PDT
From: Pandya Maruti vijaay@hotmail.com
Subject: PO APPROVE ...
Hi All,
My user is facing a strange problem. She has created the Purchase
requisition and RESERVED it and FORWARDED to the APPROVER. Everything looks
OK till this stage and user has created many requisitions this way. But when
Approver tries to Approve that document, he gets error :
APP-14056 : User Exit # PO REQUEST_ACTION returned error
Can anybody help in this ?
Thanks in advance.
Pandya .
Date: Tue, 22 Jun 1999 04:48:16 PDT
From: Greg Dietrich gc_dietrich@hotmail.com
To: vijaay@hotmail.com, oraapps-l@cpa.qc.ca
Subject: Re: PO APPROVE ...
Hi Pandya,
We're facing this problem as well, but not when approving requisitions. We
get the same error message when trying to approve PO's and Blanket Releases.
It's strange b/c the same users have created and approved many POs and
releases without any issues, but some documents get this error.
I have a TAR open with Oracle Support on this, but they haven't been very
helpful. The 14056 message is very generic and they have thousands of hits
on it when they do a query of their database. It's seems like every client
has had to find a different way to resolve the problem. Support sent me a
checklist of 10 things to look at, none of which were applicable to us.
(I've included the list at bottom)
We have found a partial resolution to this problem. In our environment we
are interfacing with Indus's Enterprise MPAC software. We determined that
we were only getting this error on POs and Releases that were created from
Requisition that originated in E-MPAC and came through to Oracle via the
interface. When drilling deeper we found that the requisitions on the
E-MPAC side were not matching to the requisition on the Oracle side. There
was an integration issue and the req had actually failed in the interface.
We were able to go back to E-MPAC and resend the req through. This solved
the problem.
But, we still have POs and releases that continue to get the error which are
related to requisitions that did NOT fail the import. We are stilling
trying to resolve these.
If you are creating reqs in another system that interfaces with Oracle, I
would start by validating that the integration is working properly. If
there is no integration, I think the UOM item mentioned in the note by
Oracle Support (see #8 below) is the most interesting. Make sure that your
UOM are consistant and valid.
If you have further questions you can email me directly at
gregdiet@us.ibm.com or call me at 313.628.2516.
Regards,
Greg
******START OF NOTE FROM ORACLE SUPPORT********
Many ct who encountered this error (APP-14056) got issues resolved by going
through
the following checlist.
1. Increase the value of maxextents for two indexes on the MTL_SUPPLY
table (NV.MTL_SUPPLY_N11 and INV.MTL_SUPPLY_N12).
2. Check the MTL_SUPPLY table for invalid entries.
3. Check document setup to ensure that the forwarding method is defined.
If using Hierarchy, choose "Hierarchy" else choose "Direct".
If blank, set the forwarding method to "Direct" of "Hierarchy".
4. If using the Profile Option "PO: Document Approval Mode" is set to
"Document Approval Manager", you may want to switch to "Standard User Exit".
5. Check the following in SQLPLUS. They should only return one row each:
SQLselect count (*) from sys.dual;
SQLselect count (*) from system.dual;
If you get more than one row, delete the extra row.
6. Value for Owner can approve may be null instead of being Yes/No.
(Navigation: Setup/Purchasing/Document Types)
Try turning setting on in GUI.
7. Turn Hierarchy off and back on again; from the Control alternative
region in the Purchasing Options form select none for Security
Hierarchy. Save, logoff, log back on, turn Hierarchy back on,
run the Fill Hierarchy report.
8. Make sure the unit of measure (UOM) is set.
9. Check Document Type Menu in GUI (under Purchasing)
Select Requisition, Purchase
Check attributes
Check Owner can Approve
Fill in Forward Method
10. Check to see that the sequence MRP_RELIEF_INTERFACE_S is not less
than the TRANSACTION_ID in the MRP_RELIEF_INTERFACE table as follows:
SQL select TRANSACTION_ID from mrp_relief_interface;
SQL select SEQUENCE_NAME, MAX_VALUE, LAST_NUMBER from
dba_sequences
where SEQUENCE_NAME like 'MRP_RELIEF_INTERFACE_S';
The following will bump the sequence number by the increment
setup for the sequence.
SQL select MRP_RELIEF_INTERFACE_S.nextval from dual;
Thanks,
Joe
*******END OF NOTE FROM ORACLE SUPPORT********
Date: Tue, 22 Jun 1999 07:14:35 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
Subject: RE: PO APPROVE ...
When we see a APP-14056 it generally has meant that the user failed to
provide a need-by-date.
Date: Wed, 23 Jun 1999 12:35:02 +0200
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: RE: PO APPROVE ...
Pandya -
Be sure and do \Help, Error, Database to get the specific error that is
occurring. It could have been any number of errors or custom raise application
messages and only by doing the above will you see the full error message.
Has your company added any triggers to po_headers_all or customized the PO or
PO Approval screen?
Amber
--------------------------------
Amber Allen-Sauer
Allen-Sauer Consulting, INC
email: amber@allen-sauer.com
web: http://www.allen-sauer.com
Special Pricing for Inventory Purchases
Date: Tue, 22 Jun 1999 12:17:53 -0400
From: "Teresa K. Purdy" TPurdy@datavision.com
Subject: Special Pricing for Inventory Purchases
Hello All -
We are a computer hardware distributor implementing 11.0.2 NT. We often
receive special pricing on standard products from our vendors on inventory
that we purchase in large quantities for specific customer orders. We have 2
issues:
How will Purchasing know to buy this standard product at a special price for
this specific customer order? Requisitions are currently generated from the
min/max planning because the demand for this product comes from OE.
We have a second issue with respect to the average cost that is impacted by
purchasing at different price points. Any suggestions as to solutions for
this issue?
Thanks!!!
Teresa K. Purdy
Datavision - Prologix, Inc.
215.442.7400 x1
Date: Tue, 22 Jun 1999 10:19:25 PDT
From: Ananth Swaminath ananth999@hotmail.com
Subject: Reply: Special Pricing for Inventory Purchases
Hi Teresa
Have you examined the Drop Shipment functionality?
Ananth
Senior Applications Consultant
PO Release Printing Problem
Subject: PO: PO Release Printing Problem
Date: 6/9/99 4:10 PM
When we attempt to print a release the whole contract prints. Some of our
contracts can be a hundred pages. Oracle does not have a current solution
for this problem. Has anyone come up with a custom solution? We print a
lot of release and do not want to print the contract. Any help would be
appreciated.
Date: Tue, 22 Jun 1999 14:17:34 -0500
From: Mandar Dewoolkar-G1606C Mandar_Dewoolkar-G1606C@email.mot.com
Subject: Re: PO: PO Release Printing Problem
We have a custom PO print program that doesnot print the Blanket
Orders. It just prints Standard orders and Releases. You could do
something like that and have another program that prints just the
Contracts.
Mandar
Vendor rescheduling
Date: Wed, 23 Jun 1999 11:13:10 +0300
From: "Cohen, Dan" Dan_Cohen@icomverse.com
Subject: PO:Vendor Rescheduling
We are working on Release 11.02
In our PO life cycle we use to maintain the vendor date and the promised
date many times due to lots of changes in the supplements of our vendors and
the demands of our customers. In every such a change the revision of the PO
is increased and the status is changed to 'requires re-approval'. This fact
causes us to deal with a lot of re-approvals during the day.
We are looking for a resolution which will enable us to decide at what
changes the PO status will be changed to 'requires re-approval', and to be
able to decide that in defined tolerances of changes in the vendor date the
PO status will remain 'approved'.
Any information will be appreciated.
Regards,
Danny Cohen
From: Dina Rotem [SMTP:dinar@rafael.co.il]
Sent: Wednesday, June 23, 1999 6:58 PM
To: Dan_Cohen@icomverse.com
Subject: PO:Vendor Rescheduling
Danny Shalom
We in Rafael are concerned with the same issue, and looking for
solutions.
Are you live on production with Purchasing already?
You mentioned in your mail a term "vendor date". What do you mean
by that? Which Oracle field is reflecting that?
Do you use a concept of "contractual date" which is different from
the promised date? If so, how did you implemented that?
Best Regards
Dina
Date: Thu, 24 Jun 1999 09:24:38 +0300
From: "Cohen, Dan" Dan_Cohen@icomverse.com
Subject: RE: Vendor Rescheduling
Hi Dina,
1) We are in production with Manufacturing (most of the modules) And
Finance (GL, AP, AR) since March '99.
2) The 'Vendor Date' I talk about is a flexfield that updates the
promised date. The problem is actually the changes in the Promised Date
whenever we reschedule the PO line.
3) The difference between the Vendor Date and the Promised Date is
shipment time (different in import and local PO's).
Regards,
Danny Cohen
Use of Requisition Template
Date: Wed, 23 Jun 1999 19:55:51 PDT
From: Basanta Kumar Dash dashbk@hotmail.com
Subject: PO: Use of Requisition Template
Hi All,
Does anybody know how to make use of requisition template in Rel 11. I know
we can use it through Web Requisition. But, I cannot find anything in the
standard PO Screens. I want to make use of the template to reserve PO number
for emergency PRs.
Is there any other way that PO numbers can be reserved for emergency PRs
without using Web Requisitions?
Thanks in advance.
Regards,
Basanta.