Planning Data Pull was erroring out with ORA-01403 No Data Found error.
All the settings like DB link, profile options, values in msc_apps_instances were ok.
On Akhilesh suggestion, we dropped and recreated the DB links - both from Source to APS and APS to Source.
It started working after that.
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps