Execution Order of Computed columns in report
I am developing a report which queries several columns. In the resulting group I also created several computed columns. Some of the computed columns are based on the results of other computed columns in the same group. As long as the PL/SQL for all of the dependent computed columns is ran after the computed columns they're dependent on, then the report should run fine. My question is, will they? How do I know the sequence the computed columns' PL/SQL will execute in?
From a preliminary test I can't tell what determines the order. I put in code to output to the log the name of the computed field that is being run so I could see the order things were happening in. I ran it several times and the order is consistent, however the order isn't alphabetic nor does it match the sequence of the columns in the group.