Location Tables PER_LOCATION_DETAILS_F_TL & PER_LOCATIONS are not in Sync
Summary
When Update a Location, Locations Tables are not in SyncContent
I have added a Location , below table are same Location Code .
When I update manually then Location code are not in Sync.
Does any one provide any inputs ?
| Location Code | SQL |
LOCATION_CODE / INTERNAL_LOCATION_CODE |
LOCATION_DETAILS_ID | OBJECT_VERSION_NUMBER | |
| Manually added | 066_1 | SELECT * FROM PER_LOCATION_DETAILS_F_TL WHERE LOCATION_CODE='066_1' | 066_1 | 300000006721174 | 1 |
| SELECT * FROM PER_LOCATIONS WHERE INTERNAL_LOCATION_CODE='066_1' | 066_1 | 300000006721175 | 1 | ||
| Manually Updated | 066_1-1 | SELECT * FROM PER_LOCATION_DETAILS_F_TL WHERE LOCATION_CODE like '066_1%' | 066_1 | 300000006721174 | 2 |
| SELECT * FROM PER_LOCATIONS WHERE INTERNAL_LOCATION_CODE |
Tagged:
0