代码语言
.
CSharp
.
JS
Java
Asp.Net
C
MSSQL
PHP
Css
PLSQL
Python
Shell
EBS
ASP
Perl
ObjC
VB.Net
VBS
MYSQL
GO
Delphi
AS
DB2
Domino
Rails
ActionScript
Scala
代码分类
文件
系统
字符串
数据库
网络相关
图形/GUI
多媒体
算法
游戏
Jquery
Extjs
Android
HTML5
菜单
网页交互
WinForm
控件
企业应用
安全与加密
脚本/批处理
开放平台
其它
【
OracleEBS
】
重新打开库存会计期
作者:
Dezai.CN
/ 发布于
2013/4/8
/
2493
重新打开库存会计期
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.
试试其它关键字
打开库存会计期
同语言下
.
设置窗体的位置
.
初始化操作
.
在FORMS调用WEB页面
.
判断数据块的项是否为空
.
EBS 循环处理块记录
.
Oracle Form中调用并发请求生成报表并输出为PDF的方法
.
添加并发程序到指定职责API
.
EBS请求查询输出
.
删除 AP 发票相关脚本
.
ebs安全性
可能有用的
.
C#实现的html内容截取
.
List 切割成几份 工具类
.
SQL查询 多列合并成一行用逗号隔开
.
一行一行读取txt的内容
.
C#动态修改文件夹名称(FSO实现,不移动文件)
.
c# 移动文件或文件夹
.
c#图片添加水印
.
Java PDF转换成图片并输出给前台展示
.
网站后台修改图片尺寸代码
.
处理大图片在缩略图时的展示
Dezai.CN
贡献的其它代码
(
4037
)
.
多线程Socket服务器模块
.
生成随机密码
.
清除浮动样式
.
弹出窗口居中
.
抓取url的函数
.
使用base HTTP验证
.
div模拟iframe嵌入效果
.
通过header转向的方法
.
Session操作类
.
执行sqlite输入插入操作后获得自动编号的ID
Copyright © 2004 - 2024 dezai.cn. All Rights Reserved
站长博客
粤ICP备13059550号-3