PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

[AWE] Approval Criteria Failure due to NEXT not in DB

edited Aug 2, 2019 6:38PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 14 commentsAnswered ✓

A requisition, on submission for approval, FAILED to route using the correct Approval Process Definition and instead used the DEFAULT definition. The trace showed that the reason it failed to use the expected definition was that it selected against the CRITERIA defined as a view (just a projection) of the REQ_HDR table, and in its where clause passed NEXT as the REQ_ID, and since there was no NEXT in the database (there wouldn't be) the criteria was automatically false.

This means that the component processor hadn't yet applied the autonumber logic and saved the record to the database (even in an uncommited state) before starting the approval process.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center