I have requirement where Serialized Push Items are to be issue to the Parent Work Order after move transaction and completions transaction is done.
Kindly let me know how to achieve this through Pl/SQL. I mean are there any API's designed to perform this action.
A push item will get issued when the move order is transacted (not when completion is done).
Are you doing a pick release and transacting the move order?
There are move order transaction apis that will accept serial numbers.
Look at Create and transact Move Order R12
Other way is by doing via WIP material transaction to issue serial controlled push item..by selecting specific component..and it should open up wip issue form..there you need to associate serial number