No parameters available when I try to run a report. My Data model has one parameter

Question

Summary

Content

My data Model has one parameter.

I created a rtf file by using Oracle Bi Publisher Desktop.

When I try to run a report : I have the message : No parameters available.

YGUTTIKONDA · Answer

try the following

In the datamodel can you navigate to the data tab and confirm you are able to see the parameter .. ??

Also check the report parameters

Click edit report and click parameters and confirm that the parameters are enabled.

Venkat Thota - BIP · Answer

please recreate data model and report in new folder and then try. post bip version.

Mouadji Niang · Answer

my query is select distinct(expeo.RAW_COST_RATE) as Cost_Rate, RACTL.NAME as TRANSACTION_TYPE_NAME, RCTA.TRX_NUMBER as Transaction_number, invoiceheadereo.pa_period_name PAPeriod, businessunitpeo.bu_name AS Legal_Entity, invoiceheadereo.ra_invoice_number, TO_CHAR(invoiceheadereo.invoice_date, 'YYYY-MM-DD') as invoice_date, substr(TO_CHAR(invoiceheadereo.invoice_date, 'YYYY-MM-DD'), 1,4) as Invoice_Year, substr(TO_CHAR(invoiceheadereo.invoice_date, 'YYYY-MM-DD'), 6,2) as Invoice_Month, partypeo.party_name AS Client_Name, contractheaderpeo.contract_number ||' / '|| contractheaderpeo.cognomen Contract_Number_Name, ROUND(disteo.invoice_curr_billed_amt + (disteo.invoice_curr_billed_amt*(select tax_rate from RA_CUSTOMER_TRX_LINES_ALL RACTL where RACTL.CUSTOMER_TRX_ID = invoiceheadereo.system_reference and line_type= 'TAX' and line_number = 1 and rownum=1) / 100) + (disteo.invoice_curr_billed_amt*(select tax_rate from RA_CUSTOMER_TRX_LINES_ALL RACTL where RACTL.CUSTOMER_TRX_ID = invoiceheadereo.system_reference and line_type= 'TAX' and line_number = 2 and rownum=1) / 100), 2) as Total_Amount, ROUND((disteo.invoice_curr_billed_amt*(select tax_rate from RA_CUSTOMER_TRX_LINES_ALL RACTL where RACTL.CUSTOMER_TRX_ID = invoiceheadereo.system_reference and line_type= 'TAX' and line_number = 1 and rownum=1) / 100), 2) Sales_Tax1, ROUND((disteo.invoice_curr_billed_amt*(select tax_rate from RA_CUSTOMER_TRX_LINES_ALL RACTL where RACTL.CUSTOMER_TRX_ID = invoiceheadereo.system_reference and line_type= 'TAX' and line_number = 2 and rownum=1) / 100), 2) Sales_Tax2, disteo.invoice_curr_billed_amt as subtotal_Before_Txs, ROUND(disteo.invoice_curr_billed_amt - (expeo.RAW_COST_RATE * quantity), 2) Total_Gross_margin, ROUND((disteo.invoice_curr_billed_amt - (expeo.RAW_COST_RATE * quantity)) / (disteo.invoice_curr_billed_amt), 4) as Margin_Rate, (SELECT first_name || ' ' || last_name FROM per_person_names_f per, okc_contacts con WHERE per.person_id = con.object1_id1 AND con.cro_code = 'VENDOR_CONTACT' AND rownum = 1 AND con.dnz_chr_id = contractheaderpeo.id) AS sales_director, TO_CHAR(TRANSACTION_DATE, 'YYYY-MM-DD') as transaction_date, substr(TO_CHAR(TRANSACTION_DATE, 'YYYY-MM-DD'), 1,4) as Transaction_Year, substr(TO_CHAR(TRANSACTION_DATE, 'YYYY-MM-DD'), 6,2) as Transaction_Month, quantity as Quantity, ROUND(expeo.RAW_COST_RATE * quantity, 2) Paid, nvl(disteo.bill_rate, 0) as Bill_Rate, prj.segment1 ||' / '|| prj.name Project_Number_NAME, trn_tsk.name Project_Task, PersonNameDPEO.FULL_NAME Consultant, DECODE(pptl.system_person_type, 'CWK', PPTL.USER_PERSON_TYPE, 'N/A') as Status, 'Not Defined' as Benefits, (SELECT gl_flexfields_pkg.get_description_sql(GCC.chart_of_accounts_id, 4, GCC.segment4) from xla_ae_headers aeh, xla_ae_lines ael, xla_distribution_links lnk,gl_code_combinations gcc , pjb_rev_distributions prd1 where lnk.ae_header_id = ael.ae_header_id AND lnk.ae_line_num = ael.ae_line_num AND aeh.ae_header_id = ael.ae_header_id AND ael.code_combination_id = gcc.code_combination_id AND expeo.expenditure_item_id = prd1.transaction_id(+) AND prd1.sla_event_id = aeh.event_id AND ael.entered_cr IS NOT NULL ) PRACTICE, (SELECT gl_flexfields_pkg.get_description_sql(GCC.chart_of_accounts_id, 5, GCC.segment5) from xla_ae_headers aeh, xla_ae_lines ael, xla_distribution_links lnk, gl_code_combinations gcc , pjb_rev_distributions prd1 where lnk.ae_header_id = ael.ae_header_id AND lnk.ae_line_num = ael.ae_line_num AND aeh.ae_header_id = ael.ae_header_id AND ael.code_combination_id = gcc.code_combination_id AND expeo.expenditure_item_id = prd1.transaction_id(+) AND prd1.sla_event_id = aeh.event_id AND ael.entered_cr IS NOT NULL) REGION, (SELECT gcc1.segment1 ||'-'|| gcc1.segment2 ||'-'|| gcc1.segment3 ||'-'|| gcc1.segment4 ||'-'|| gcc1.segment5 ||'-'|| gcc1.segment6 ||'-'||gcc1.segment7 from xla_ae_headers aeh1, xla_ae_lines ael1, xla_distribution_links lnk1, gl_code_combinations gcc1 , pjc_cost_dist_lines_all pcd where lnk1.ae_header_id = ael1.ae_header_id AND lnk1.ae_line_num = ael1.ae_line_num AND aeh1.ae_header_id = ael1.ae_header_id AND ael1.code_combination_id = gcc1.code_combination_id AND pcd.acct_event_id = aeh1.event_id AND pcd.expenditure_item_id = expeo.expenditure_item_id AND ael1.entered_dr IS NOT NULL) GL_EXPENSE_ACCOUNT, (SELECT gcc.segment1 ||'-'|| gcc.segment2 ||'-'|| gcc.segment3 ||'-'|| gcc.segment4 ||'-'|| gcc.segment5 ||'-'|| gcc.segment6 ||'-'||gcc.segment7 from xla_ae_headers aeh, xla_ae_lines ael, xla_distribution_links lnk, gl_code_combinations gcc , pjb_rev_distributions prd1 where lnk.ae_header_id = ael.ae_header_id AND lnk.ae_line_num = ael.ae_line_num AND aeh.ae_header_id = ael.ae_header_id AND ael.code_combination_id = gcc.code_combination_id AND expeo.expenditure_item_id = prd1.transaction_id(+) AND prd1.sla_event_id = aeh.event_id AND ael.entered_cr IS NOT NULL) GL_REVENUE_ACCOUNT, (SELECT DECODE(pptl.system_person_type, 'EMP','N/A','CWK',PPERSV.ATTRIBUTE_NUMBER2,PPERSV.ATTRIBUTE_NUMBER2) FROM PER_PERSONS_V PPERSV WHERE PPERSV.PERSON_ID =PersonNameDPEO.PERSON_ID) AS Sub_Contractor FROM pjb_invoice_headers invoiceheadereo, hz_parties partypeo, hz_cust_accounts customeraccountpeo, okc_k_headers_vl contractheaderpeo, pjb_invoice_lines invoicelineeo, fun_all_business_units_v businessunitpeo, pjb_inv_line_dists disteo, pjc_exp_items_all expeo, pjf_projects_all_vl prj, pjf_proj_elements_vl trn_tsk, RA_CUSTOMER_TRX_all RCTA, RA_CUST_TRX_TYPES_ALL RACTL, PER_PERSON_NAMES_F_V PersonNameDPEO, PER_ALL_ASSIGNMENTS_M PAAM, PER_PERSON_TYPES_vl PPTL WHERE(invoiceheadereo.contract_id = contractheaderpeo.id) and (ContractHeaderPEO.MAJOR_VERSION = pjb_billing_utils.GET_CNTRCT_MAJOR_VERSION('INV_PREVIEW',ContractHeaderPEO.ID)) and(invoiceheadereo.bill_to_cust_acct_id = customeraccountpeo.cust_account_id) and(customeraccountpeo.party_id = partypeo.party_id) and invoiceheadereo.invoice_id = invoicelineeo.invoice_id and(invoiceheadereo.org_id = businessunitpeo.bu_id) and invoiceheadereo.pa_period_name = :period_name and invoicelineeo.invoice_line_id = disteo.invoice_line_id My xml is Feb-18 8PCFeb-18AU262018-02-28201802COMMISSION CConstruction 2683.2229.7159.27594.23-5.77-.00972018-02-022018027.560079.23C 1C 1uDanSub-ContractorHours Other - 999Not Defined100-00000-000-00-000-000-0000000-0000-000-00-000-000-00000000000000000000000000