Update runs long

Hi All,

 we have an update that runs 6 mins (attaching as good plan) in one database and the same runs more than 20 hours in another database (attaching as bad plan),though the process names are different it is doing the same 

b/w the indexes are created in different names but on the same columns on both the database,

i have transferred stats for ps_ca_acctg_ln_pc table but mad eno differences

it is doing an additional hash join semi and the orders are different in the bad plan

can anyone help

UPDATE PS_Q_PC_GL_FLDS_ALL_TMP7750412 A SET (A.JOURNAL_DATE,A.JOURNAL_ID,A.ACCOUNTING_PERIOD,A.FISCAL_YEAR)= ( SELECT B.JOURNAL_DATE,B.JOURNAL_ID ,B.ACCOUNTING_PERIOD ,B.FISCAL_YEAR FROM PS_CA_ACCTG_LN_PC B WHERE B.BUSINESS_UNIT_PC =A.BUSINESS_UNIT AND B.PROJECT_ID=A.PROJECT_ID AND B.ACTIVITY_ID=A.ACTIVITY_ID AND B.RESOURCE_ID=A.RESOURCE_ID AND B.CONTRACT_NUM = A.CONTRACT_NUM AND B.CONTRACT_LINE_NUM =A.CONTRACT_LINE_NUM AND B.GL_DISTRIB_STATUS='D' AND B.ANALYSIS_TYPE='BIL' AND B.DST_USE='UAR' ) WHERE A.ANALYSIS_TYPE='BIL' ANDA.SYSTEM_SOURCE IN ( SELECT SYSTEM_SOURCE FROM PS_Q_PC_GL_SS_MAP WHERE RECORDNAME='CA_ACCTG_LN_PC') AND EXISTS ( SELECT 'X' FROMPS_CA_ACCTG_LN_PC B WHERE B.BUSINESS_UNIT_PC =A.BUSINESS_UNIT AND B.PROJECT_ID =A.PROJECT_ID AND B.ACTIVITY_ID=A.ACTIVITY_ID ANDB.RESOURCE_ID=A.RESOURCE_ID AND B.CONTRACT_NUM = A.CONTRACT_NUM AND B.CONTRACT_LINE_NUM = A.CONTRACT_LINE_NUM AND B.GL_DISTRIB_STATUS='D' ANDB.ANALYSIS_TYPE='BIL' AND B.DST_USE='UAR' )