Code 72C Record Is Missing in the CODE_DETAIL Table for Code_Type GLST, GLRT, and GLMT

(Doc ID 2399613.1)

Last updated on MAY 29, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.

This article will be updated as official patch information becomes available.

Actual Behavior
---------------

Find that there is no 72C record in the CODE_DETAIL table for code_type in ('GLST','GLRT','GLMT').

Expected Behavior
-----------------------
There should be a record 72C because the Interface to General Ledger of Item/Loc Level Transactions (FIFGLDN1.PC) will abort when you perform the accounting of a cost variation with TRAN_CODE 72.

Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Check the CODE_DETAIL table for code_type GLRT using the SQL: "select * from code_detail where code_type = 'GLST' and (code like 'q%' or code like 'r%');"
2. Notice that no records would be returned for code 72C.


Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms