My Oracle Support Banner

Non Physcial Item Not Present in ITM_NON_PHYS_ITEM Due to: "An update was run against datasource: [Local] that had no effect" (Doc ID 2829956.1)

Last updated on OCTOBER 02, 2023

Applies to:

Oracle Retail Xstore Office Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

In Xstore V19.0:

Specific non-physical items are not present in the non-physical-item table and users are unable to apply them through .MNT.

These specific items show up in the itm_item table, but not in the itm_non_phys_item table.

When looking at logs users see the below WARN message:

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
Cause
Solution


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