免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1309 | 回复: 0

Purchasing Receiving Accrual Records Missing [复制链接]

论坛徽章:
0
发表于 2011-12-20 09:48 |显示全部楼层


Purchasing Receiving Accrual Records Missing in GL_INTERFACE/GL Tables [ID 364575.1]
  修改时间 19-MAY-2010     类型 HOWTO     状态 PUBLISHED  

Applies to: Oracle Purchasing - Version: 11.5.10 to 11.5.10.4 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Goal

Various manifestations of the problem

After performing the Purchase Order receipt or after running the Receipt Accrual-Period end program, accounting entries can be viewed in Receiving subledger. But these entries are neither available in gl_interface nor in GL. 

OR

Inadvertently deleted transactions with user_je_category_name= 'Receiving' and user_je_source_name = 'Purchasing' from GL_INTERFACE have not yet been imported to GL.

Solution

1)  Find the missing records by running the following SQL>

SELECT *
FROM rcv_receiving_sub_ledger rsl
WHERE rsl.set_of_books_id = &primary_sob_id
AND rsl.period_name = '&period_name'
AND rsl.accrual_method_flag = 'O'
AND not exists
(select 1
from gl_je_headers gjh, gl_import_references gir
where gjh.set_of_books_id = &&primary_sob_id
and gjh.je_source = 'Purchasing'
and gjh.je_category = 'Receiving'
and gjh.actual_flag = rsl.actual_flag
and gjh.je_header_id = gir.je_header_id
and gir.gl_sl_link_table = 'RSL'
and gir.gl_sl_link_id = rsl.gl_sl_link_id)
AND not exists
(select 1
from gl_interface gl
where gl.set_of_books_id = &primary_sob_id
and gl.user_je_source_name = 'Purchasing'
and gl.user_je_category_name = 'Receiving'
and gl.actual_flag = rsl.actual_flag
and gl.gl_sl_link_table = 'RSL'
and gl.gl_sl_link_id =rsl.gl_sl_link_id);

Note: In rcv_receiving_sub_ledger both period_end accruals and on line accruals have je_category_name ='Accrual'. The Column that distinguishes between On Line Accruals and Period End Accruals is Accrual_Method_flag. The Flag is 'O' for On line Accruals and 'P' for Period End Accruals.

If records are retrieved from sql above perform the following in test instance first before moving to Production.

2)  Backup gl_interface_table as follows:
create table gl_interface_bak as select * from gl_interface;

3)  Apply Patch 7835266

Script b4170487.sql provided in the patch will re-create any missing receiving accounting transactions into gl_interface table. 

4) Perform Journal import for the source Purchasing so that the accounting entries pertaining to PO receiving transactions will be shown in GL

ReferencesBUG:4170487 - DATA FIX: OHS: ACCOUNTING ENTRIES MISSING FROM GL
BUG:7835266 - PATCH 4170487 HANGS ON B4170487.SQL

显示相关信息 相关的

产品
  • Oracle E-Business Suite > Procurement > Procurement > Oracle Purchasing
关键字
GL_INTERFACE; GL_IMPORT_REFERENCES; GL_JE_HEADERS; RCV_RECEIVING_SUB_LEDGER; B4170487.SQL; DATA FIX

<A href='https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=HOWTO&id=364575.1&clickstreamSession=75a442202c347adf19425fe24ebec19439c476a5827a02e603f9d6fa0abb0694&addClickInfo=返回页首返回页首

var rateArticleSuccess = "您的评级已发送到 Oracle"; var rateArticleFailure = "无法为文档评级"; checkArticleRatingStatus(); <!--364575.1</EMMOS_CONTEXT_STRING>-->
 
 
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

SACC2021中国系统架构师大会

【数字转型 架构重塑】2021年5月20日-22日第十三届中国系统架构师大会将在云端进行网络直播。

大会为期3天的议程,涉及20+专场,近120个主题,完整迁移到线上进行网络直播对会议组织来说绝非易事;但考虑到云端会议的直播形式可以实现全国各地技术爱好者的参与,也使ITPUB作为技术共享交流平台得到更好的普及,我们决定迎难而上。
http://sacc.it168.com/


大会官网>>
  

北京盛拓优讯信息技术有限公司. 版权所有 16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP