How to apply GL SVS rules in custom BIP report on GL_BUDGET_BALANCES table

prathmore

Hi,

We have requirement to apply GL SVS rules on custom BIP report having GL_BUDGET_BALANCES table.

We followed instructions provided by oracle document (provides example of GL_CODE_COMBINATION table) to apply SVS .

But it is not working for GL_BUDGET_BALANCES.

Could you please help to resolve issue or provide any alternate solution to apply SVS on GL_BUDGET_BALANCES table.

SVS-SR_Error.PNG

SVS-SR_Flexfield defined.PNG

SVS-SR_query.PNG

BIPSettingsForSVS.pdf

Regards,

Prathamesh

Subha_Tripathy-Oracle

Hi @prathmore ,

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

Please let us know if the question is for which product FAW or OTBI?

Thanks

Subha