重新打开库存会计期代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】重新打开库存会计期

作者:Dezai.CN / 发布于2013/4/8/ 2518

重新打开库存会计期


	Solution
	-- To implement the solution, please execute the following steps::
	1. Ensure that you have taken a backup of your system before applying the recommended solution.
	2. Run the following scripts in a TEST environment first:
	a) Backup the table org_acct_periods
	create table org_acct_periods_83192
	as select * from org_acct_periods;

	b) Find affected periods.
	select organization_id, acct_period_id, period_close_date
	from org_acct_periods
	where open_flag = 'P';

	c) Verify there are no records in MTL_PER_CLOSE_DTLS, MTL_PERIOD_SUMMARY,
	CST_PERIOD_CLOSE_SUMMARY tables
	for the affected periods and mark the period as unsummarized.

	select count(*)
	from MTL_PER_CLOSE_DTLS
	where organization_id in (<org_ids from (1b)>)
	and acct_period_id in (<period_ids from (1b)>);
	select count(*)
	from MTL_PERIOD_SUMMARY
	where organization_id in (<org_ids from (1b)>)
	and acct_period_id in (<period_ids from (1b)>);
	select count(*)
	from CST_PERIOD_CLOSE_SUMMARY
	where organization_id in (<org_ids from (1b)>)
	and acct_period_id in (<period_ids from (1b)>);
	[If there are records in the above, make a backup copy of the table and
	delete the records, first from MTL_PER_CLOSE_DTLS then from
	MTL_PERIOD_SUMMARY and then from CST_PERIOD_CLOSE SUMMARY]
	Run the following SQL to mark the periods as 'Unsummarized':
	.
	UPDATE org_acct_periods
	SET summarized_flag = 'N'
	WHERE organization_id in (<org_ids from (1b)>)
	and acct_period_id in (<period_ids from (1b)>);
	AND summarized_flag = 'Y';
	d) Run the following script to reset the period status so that the Close accounting period process can be re-submitted for them:
	update org_acct_periods
	set open_flag = 'Y',
	period_close_date = NULL
	where organization_id in (<org_ids from (1b)>)
	and acct_period_id in (<period_ids from (1b)>)
	and open_flag = 'P';

	3. Once the scripts complete, confirm that the data is corrected.
	You can use the following SQL to confirm:
	select count(*)
	from org_acct_periods
	where open_flag = 'P';
	4. If you are satisfied with the results, issue a commit.
	5. Re-submit the Close accounting period process for one organization at a time. Confirm that it
	completes successfully. Be sure it launches a Transfer
	transactions to GL concurrent request which should also complete normally
	6. Confirm that the data is corrected when viewed in the Oracle Applications.
	You can use the following steps:
	Accounting Close Cycle > Inventory Accounting Periods
	Inventory Accounting Period

	7. Migrate the solution as appropriate to other environments.

试试其它关键字

　打开库存会计期　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)