Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
-
ksuresh109
- Posts: 6
- Joined: Mon Aug 15, 2011 10:15 am
- Location: India
Post
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...
-
rafeekg209
- Posts: 68
- Joined: Sun Jul 06, 2008 8:55 am
- Location: Egypt
-
Contact:
Post
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
Users browsing this forum: No registered users and 1 guest