PeopleSoft Views and Build Dependencies
Praj 28 Apr 2009 07:50
I stumbled across this fantastic post about setting dependencies when building PeopleSoft Views on the Blogging About Oracle Applications site.
Essentially, in your record type properties, you can set a build sequence number. PeopleSoft builds views based on this sequence number by first building all views with sequence 0, then all views with sequence 1, then all views with sequence 2 and so on.
If you have two views: PS_XYZ_VW and PS_ABC_VW where the view PS_ABC_VW depends on the view PS_XYZ_VW because it uses PS_XYZ_VW in its view sql then set the build sequence like this:
- PS_XYZ_VW build sequence 0 (build first)
- PS_ABC_VW build sequence 1 (build second)
This will override the fact that alphabetically, PS_ABC_VW is before PS_XYZ_VW and will be built first by default (and fail).