My Oracle Support Banner

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

Last updated on AUGUST 25, 2022

Applies to:

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


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. 





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

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