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 !!
PO - Purchase Agreement
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
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
- Moderador
- Posts: 5026
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
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:
There are the interface tables: po_headers_interface, po_lines_interface, etc.
select *
from apps.po_headers_all
where type_lookup_code='BLANKET'
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.
PO_LINE_LOCATIONS_ALL
PO_Distributions_all
PO_RELEASES_ALL
I am still testing.
When you're right here.
- dr_gori
- Moderador
- Posts: 5026
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
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 ...
and after validating, it logs the errors in the PO_Interface_errors.
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 ...
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
Opa gori vlw.
Do you know what the Po_Releases_All interface would be?
Hugs.
Do you know what the Po_Releases_All interface would be?
Hugs.
- dr_gori
- Moderador
- Posts: 5026
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
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!
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!
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 ...
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 ...
Oops, I had forgotten, but tonight I give you a beleza return?
vlw
vlw
- Porva
- Rank: DBA Sênior
- Posts: 342
- Joined: Mon, 29 Jan 2007 7:36 am
- Location: São Paulo/SP
Rafael S. Nunes
São Paulo/SP
São Paulo/SP
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
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
Oops man.
Give me your personal email so I can send what I have beleza?
vlw.
Give me your personal email so I can send what I have beleza?
vlw.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 1 guest