We have some custom portlets that we've built that are based on the PPA_WIP and PPA_WIP_VALUES table. We have a join that joins the PPA_WIP_VALUES.TRANSO field to the PPA_WIP. APPLYTO field. Normally the TRANSO and APPLYTO are the same but in the case of WIP Adjustments we want the APPLYTO so that's why we join on that.
We have started to notice that there are now several thousand transactions where the APPLYTO value is 0. This has only started happening recently.
Any idea what would cause that?
Haven't come across this so I wonder if something went wrong/lost during adjustment? I'd try tracing the last updated date into the app log and see if there's any error around the time of WIP adjustment