Page 1 of 1

Open Periods

Posted: Thu Feb 16, 2012 11:18 am
by ksuresh109
Hi Guys..

Do we need to Open the Inventory Periods and Purchasing Periods to Raise a Purchase Requisition.Leave Reply if any One knows...

Posted: Sat Feb 18, 2012 5:48 am
by rafeekg209
Hello,
please refere to SQL statment to open the inventory period

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;
Regards
Rafeek Goha
Oracle Supply Chain Consultant