--会计期关闭打开问题:
--在12月30号被我关了,之后就不能打开,后来开了SR,一下是提供的解决方法
--在12月30号被我关了,之后就不能打开,后来开了SR,一下是提供的解决方法
select acct_period_id period,
open_flag,
period_name name,
period_start_date,
schedule_close_date,
period_close_date
from org_acct_periods
where organization_id = & org_id
order by 1 ,
2 ;
update org_acct_periods
set open_flag = ' Y ' ,
period_close_date = null ,
summarized_flag = ' N '
where organization_id = && org_id
and acct_period_id >= && acct_period_id;
delete mtl_period_summary
where organization_id = & org_id
and acct_period_id >= & acct_period_id;
delete mtl_period_cg_summary
where organization_id = & org_id
and acct_period_id >= & acct_period_id;
delete mtl_per_close_dtls
where organization_id = & org_id
and acct_period_id >= & acct_period_id;
delete cst_period_close_summary
where organization_id = & org_id
and acct_period_id >= & acct_period_id;