This content has been marked as final. Show 4 replies
There is no API for Releases.
As a workaround, based on the Release data you have, populate the requisition interface table. Make sure you have created appropriate requisitions / ASL entries and sourcing rules beforehand.
Then import requisitions.
Schedule the Create Release program - it will automatically create Blanket Releases for you.
Hope this helps,
As a specific solution you may use the following packages/function in R11i :
• PO_RELEASES_SV4.get_release_num, to get the last release number,
• PO_LINE_LOCATIONS_PKG_S3.get_max_shipment_num, to get the last shipment_num of a release,
• PO_RELEASES_PKG_S0.Insert_Row to create a release,
• PO_LINE_LOCATIONS_PKG_s0.Insert_Row to create a shipment line
Beware, these packages are not public, so they may potentially be updated through a patch / upgrade.
As previously said by Sandeep Gandhi, the best solution is to use requisitions, but you need to manage the corresponding setup.
All APIs are listed at http://etrm.oracle.com
All APIs are listed in "Oracle Integration Repository" website.
Oracle Integration Repository
The code of the APIs and the dependencies can be found in the eTRM website.