R12 (12.1.2) with DB Rel 11gR1 - Conversion issues...
So, before calling the API, the pl/sql table contains at least half a million entries with this the process is struck for at least 4 to 5 hours. If the asset has less than 30K records, the process completes in less than 5 minutes. Sometimes, flush shared_pool helps to move further quickly and we do not want to flush the shared pool when running requests in Production environment.