PO - Purchase Agreement

[LordElfo]

Hey guys.
Does anyone know how do I customize a receipt of a purchase agreement?
I insert directly in the po.po_releases_all or have any interface for this?
VLW Personal !!

[LordElfo]

Looking at IPROC VI that has a field called "contract number" inside the "Non-Catalog Request" tab.
I did a test with it but it creates only the requisition and not a release.
I need to make it when you create a request it already releases the value in the contract.
Someone?
personal vlw

[dr_gori]

Note that it is not only in the PO_RELEASES_ALL that has to insert. In the other PO tables it also needs to be all registered, see:

Select all

select * 
from apps.po_headers_all 
where type_lookup_code='BLANKET'

There are the interface tables: po_headers_interface, po_lines_interface, etc.

[LordElfo]

I did a test here and I am currently inserting in
PO_LINE_LOCATIONS_ALL
PO_Distributions_all
PO_RELEASES_ALL

I am still testing.
When you're right here.

[dr_gori]

But are you inserting directly into the PO tables?
take a look at the Open-Interface of the PO.

Dai You insert what you need in the interface tables, runs it and the routine Core makes all necessary validations not to get trash in the system ...

Select all

PO_ATTR_VALUES_INTERFACE 
PO_ATTR_VALUES_TLP_INTERFACE 
PO_DISTRIBUTIONS_INTERFACE 
PO_HEADERS_INTERFACE 
PO_LINE_LOCATIONS_INTERFACE 
PO_LINES_INTERFACE 
PO_PRICE_DIFF_INTERFACE 
PO_REQ_DIST_INTERFACE_ALL 
PO_REQUISITIONS_INTERFACE_ALL 
PO_RESCHEDULE_INTERFACE

and after validating, it logs the errors in the PO_Interface_errors.

[LordElfo]

Opa gori vlw.
Do you know what the Po_Releases_All interface would be?
Hugs.

[dr_gori]

Take a look at this manual: http://download.oracle.com/docs/cd/A859 ... mfgoim.pdf
It contains many technical details of PDOI (Purchasing Document Open Interface). Page 9.x

I'm not sure, but I think for releases do not have an import via pdoi ... if you find out, post there for us!

[Porva]

Personal

Someone managed to solve this problem?

I am with the same need

thanks

[LordElfo]

Oops face ... at the time I solved ... Fail my not posted here was bad ...

But I remember that I had to create methods copy of po_reqapproval_init1 or por_custom_pkg ... and type Instead of calling the existing already called my altered ...
I changed the company but I'll take a look at my email to v if I find the documentation of what I did at the time ...

[Porva]

Please lord, I still need to resume this subject, maybe it will help me a lot

thanks

[LordElfo]

Oops, I had forgotten, but tonight I give you a beleza return?
vlw

[Porva]

beleza BROTHER, I'm waiting


Releases of a particular organization to another, there they thought in the hypothesis of doing open interface, but by the I'vê been researching on the net and even with what you were arguing here, it is not possible via hi.

But as soon as you can, send me your solution that can help,

thanks

[LordElfo]

Oops man.
Give me your personal email so I can send what I have beleza?
vlw.

[Porva]

rafanunes1981@hotmail.com

rafanunes1981@gmail.com


Thanks