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