PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Loading larget trees (UNSPC codes) causes problems where the TREE_NODE_NUM and TREE_NODE_NUM_END ran

edited Jan 27, 2016 10:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

Loading larget trees (UNSPC codes) causes problems where the TREE_NODE_NUM and TREE_NODE_NUM_END range gets too small and you get a duplicate insert into the PSTREELEAF table.  The delivered code (behind the scenes) attempts to save off values from PSTREENODE in a table called PSX_TREENODEUPD and then insert them back in after repairing itself but it loses thousands of valuse when this duplicate insert happens,  Does anyone know how to load a UNSPSC tree?  I captured the code that executes online when changing a item category value where it asks if you want to insert into the tree,  I put it

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