I need to add new Resource to our existing Routings. The number of records is more than 10,000. So I need to create an anonymous block for it. But I am not sure which Interface tables/ APIs to be used for inserting them. If someone can guide me how can this be achieved, I'd really appreciate. If you can provide me with a sample code for it, that would be the best.
Thanks in advance.
You need use BOM_OP_ROUTINGS_INTERFACE and BOM_OP_RESOURCES_INTERFACE interface tables to perform the mentioned activity.
The program "Bill and Routing Interface" will process the records from the above interface tables.
Metalink note 131898.1 contains the sample code and detailed explanation.