Oracle APPS Consultancy
SSS Oracle APPS Consultancy
Title
(Move to ...)
Home
APPS
PLSQL
PO
OM
Inventory
AR
GL
Form
Forms Personlization
Report
▼
Thursday, 5 June 2014
GL Period Delete query
delete from gl_period_statuses where start_date >= '31-JAN-2014' and closing_status in ('F','N');
delete from gl_periods where period_set_name ='Global' and start_date >= '31-JAN-2014'
and period_type ='21' ;
delete from pa_periods_all where org_id in (111,222)
and start_date >= '31-JAN-2014' and status='N';
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment