Invoke PL/SQL procedure from IFB

We have a PL.SQL procedure to sync opportunity team with account team. Yes we could have used Assignment manager but because of bug introduced in 8.0 we had to write up the custom pl.sql proc for the team sync.

One thing I had to make sure is that pl.sql scheduled job does not conflict with EIM rcr. To fix this I thought of developing a shell script that would run the pl.sql proc and EIM in sequence.Not a shell script pro so had do some research before I can develop this. When I was discussing on the same with my manager he introuduced me to a cool feature on IFB that would do it.

I tried this out and it works like a charm. So here is how you can do it.

TYPE = IMPORT
BATCH = 0723002010
TABLE = EIM_OPTY
SESSION SQL = "BEGIN INTEGRATION.TEAM_UPDATE; COMMIT; END;"

After this I included the EIM imports and delete process commands. Now I need to schedule just the RCR and not dependent on one more scheduled job.