EP LOAD fails after applying patch Patch: 18048597 - ISSUES WITH EP_LOAD_ITEMS PROCEDURE

Hi Gurus,

I had an issue while loading the customer locations so Oracle suggested the Patch: 18048597 - ISSUES WITH EP_LOAD_ITEMS PROCEDURE, after applying the patch ep_load_locations is successful but EP_load_sales is failing.

I veriifed the db_exception_log and found below error messages. I request the gurus to help on this critical issue.

   

ERR_DATE	PROC_NAME	ERR_MSG
19-JAN-2015 09.51.33 AM	DYMANIC_DDL	-6550 ORA-06550: line 1, column 7: PLS-00905: object DM.DYN_PROPORT_SALES_1 is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored BEGIN DYN_PROPORT_SALES_1(' WHERE 1 = 1'); END;
19-JAN-2015 09.51.33 AM	PROPORT	-20003 ORA-20003:  Error in PROCEDURE PROPORT line 1205