Purchasing Receiving Accrual Records Missing

richardliu1123

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>-->

 

 

 b4170487.rar    CA6ZG1AR.zip