There have been two "enhancements" that have made the item import (INCOIN) process unusable in 12.2.8 as compared to 12.0.6.
This all sounds well and good, doesn't it? But take this situation. We've been running Oracle EBS for 9 years. We have five deactivated inventory organizations. Buyers come and go - the buyers that were active on the items when the organizations were disabled are now no longer with the company. So what happens when I attempt to update my master item for any attribute? Complete failure.
I cannot update the master org item because it triggers an update to the child org item and the child org's buyer is invalid.
I cannot update the invalid buyer on the child org directly because the org is disabled.
SR with oracle and the answer is that this is working as designed. The only work-arounds I've found are fairly distasteful. 1) do a direct update to the table for the disabled child org to remove the offending values (definitely not an Oracle recommended solution) or 2) continually re-enable the disabled child orgs so that we can do updates to the master and then disable them again.
I need to be able to update my item master and with the current functionality, I cannot do so programmatically. How are people working around this issue?
I posted an idea and the solution was to apply the patch: Patch 28568329:R12.ITM.D provides the needed correction to make the item import functional again.
The associated knowledgebase article has been updated to provide better documentation of the fix that this patch provides. The original analyst on my SR thought this patch caused the issue but in actuality, it corrected it.