Denorm data export failing

Hello All,

Export workflow in demnatra which updates denorm table is failing at step appspoplulate denorm in test instance

with the below error 2016-11-23 15:02:35,309 GMT [WFProcess_40] FATAL workflow.general: ORA-01427: single-row subquery returns more than one row

ORA-06512: at "APPS.POPULATE_DENORM", line 38

ORA-06512: at line 1'.

I have compared the code to that of production the codes are same and return the same set of data in test instance

we are simultaneously working with Oracle.

Inputs are appreciated.

Thanks,

Nivedita