Usecase: Here, we will create an OTBI Payable invoice report with a invoince number parameter named as P_INVOICE_NUM.
Implemented steps:
- Navigation >> Tools >> Reports & Analytics >> browse Catalog >> Create >> Analysis
- Select Subject area >> Payables Invoices - Transactions Real Time
- Select the required columns or fields from subject areas to selected columns sections
- Go to the Results tab and see the output.
- Go to Prompts tab >> create a variable prompt >> provide variable name as P_INVOICE_NUM >> user input as Choice List >> select invoice number as column >> ok
- Go back to Criteria tab >> add filter >> Invoice Number >> value as Presentation Variable >> put created Parameter name: P_INVOICE_NUM in Variable_Expr >> put a default value >> ok
- Go to the Results tab and see the output
- Save the report
- Go th catalog >>open report >> select value >> ok >> we can see the output.
Detailed screenshots:
No comments:
Post a Comment