Oracle APPS Consultancy
SSS Oracle APPS Consultancy
Title
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment