My Oracle Support Banner

Code 72C Record Is Missing in the CODE_DETAIL Table for Code_Type GLST, GLRT, and GLMT (Doc ID 2399613.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

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.


Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.