In 9.1, there are 2 queries to feed AP checks and advices BIP reports. In 9.2, there is only 1. How

In 9.1, the data for the checks and advices come from 2 separate queries - APY2021_CRYSTAL_CHECKS_C and APY2021_CRYSTAL_CHECKS_A. These queries include the selection on PYMNT_ADVICE.PMNT_OVERFLOW_ID = 'ADVICE' or not equal 'ADVICE'. In this way the data from the queries is already segregated before it gets to the BI report. 

Now, in 9.2, the checks and advices come from the same query - APY2021_CRYSTAL_CHECKS. The selection of data rows is in the BI report itself.

There is an "If Check" and an "If Advice" field at the top of each delivered Oracle template - CHECK1_CHECK and CHECK1_ADVICE. For example, the code in the "If Check" is <?if:Pymnt_Ovfl!='ADVICE'?>. I've copied each of these into my custom check and advice templates.