Inactive Address Being Sent to Global Transportation Management (GTM) as Sold_To Address During Order Export Compliance
(Doc ID 2830916.1)
Last updated on JUNE 02, 2023
Applies to:
Oracle Order Management - Version 12.1.3 to 12.2.12 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
-----------------------
Inactive address are being sent to Global Transportation Management (GTM) as Sold_To address during Order Export Compliance.
EXPECTED BEHAVIOR
--------------------------
Expectation is that inactive addresses are not sent to GTM.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Order organiizer
3. Create and book new sales order analyzer.
4. Records are being transferred from EBS to GTM through line level workflow: workflow node “Export Compliance Screening – Line” is calling function.
OE_EXPORT_COMPLIANCE_WF.ECS_REQUEST is calling ONT_ITM_PKG.Process_ITM_REQUEST.
5. ONT_ITM_PKG.Process_ITM_REQUEST is calling Create_Request which calls Get_Address (both of which are part of ONT_ITM_PKG)
6. Get_address has cursor C_SOLD_TO_ADDRESS which is fetching and sending Sold_To address to GTM.
7. Query GTM and see inactive address populated.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |