Deletion of GL Cross Ref - Reason Code Actions Should Reflect In IM_TRAN_CODE Table (Doc ID 2248686.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle Retail Invoice Matching - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

Deletion of GL cross reference- Reason code actions should reflect in IM_TRAN_CODE table.When user add's a GL cross reference - Reason code action, it will be saved in IM_GL_CROSS_REF and IM_TRAN_CODE table(to make it available for GL segment mapping of Reason codes). But when user deletes the same GL cross reference - Reason code action, it is getting deleted from IM_GL_CROSS_REF table but the data is still there in IM_TRAN_CODE though there are no tran code mapping done.

Steps To Recreate:
1. Login to ReIM Application.
2. Foundation data--> Gl cross reference .
3. Create new transaction for Reason code actions, data got inserted into im_tran_code,im_gl_cross_Ref tables.
4. Try to delete the created gl cross reference, it deletes the data only from im_gl_cross_Ref but not from im_tran_code table. 

.

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