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

Mouadji Niang

Summary

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

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.

 

Venkat Thota - BIP

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

Mouadji Niang

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

<?xml version="1.0" encoding="UTF-8"?>

<!-- -->

<DATA_DS><PERIOD_NAME>Feb-18</PERIOD_NAME>

<G_1>

<COST_RATE>8</COST_RATE><TRANSACTION_TYPE_NAME>PC</TRANSACTION_TYPE_NAME><PAPERIOD>Feb-18</PAPERIOD><LEGAL_ENTITY>AU</LEGAL_ENTITY><RA_INVOICE_NUMBER>26</RA_INVOICE_NUMBER><INVOICE_DATE>2018-02-28</INVOICE_DATE><INVOICE_YEAR>2018</INVOICE_YEAR><INVOICE_MONTH>02</INVOICE_MONTH><CLIENT_NAME>COMMISSION C</CLIENT_NAME><CONTRACT_NUMBER_NAME>Construction 2</CONTRACT_NUMBER_NAME><TOTAL_AMOUNT>683.22</TOTAL_AMOUNT><SALES_TAX1>29.71</SALES_TAX1><SALES_TAX2>59.27</SALES_TAX2><SUBTOTAL_BEFORE_TXS>594.23</SUBTOTAL_BEFORE_TXS><TOTAL_GROSS_MARGIN>-5.77</TOTAL_GROSS_MARGIN><MARGIN_RATE>-.0097</MARGIN_RATE><SALES_DIRECTOR/><TRANSACTION_DATE>2018-02-02</TRANSACTION_DATE><TRANSACTION_YEAR>2018</TRANSACTION_YEAR><TRANSACTION_MONTH>02</TRANSACTION_MONTH><QUANTITY>7.5</QUANTITY><PAID>600</PAID><BILL_RATE>79.23</BILL_RATE><PROJECT_NUMBER_NAME>C 1</PROJECT_NUMBER_NAME><PROJECT_TASK>C 1u</PROJECT_TASK><CONSULTANT>Dan</CONSULTANT><STATUS>Sub-Contractor</STATUS><PRACTICE>Hours </PRACTICE><REGION>Other - 999</REGION><BENEFITS>Not Defined</BENEFITS><GL_EXPENSE_ACCOUNT>100-00000-000-00-000-000-0000</GL_EXPENSE_ACCOUNT><GL_REVENUE_ACCOUNT>000-0000-000-00-000-000-0000</GL_REVENUE_ACCOUNT><SUB_CONTRACTOR>000000000000000</SUB_CONTRACTOR><TRANSACTION_NUMBER>0000000</TRANSACTION_NUMBER>

</G_1>

</DATA_DS>

Dir_Pal

post ur sample query which ur using and sample xml

YGUTTIKONDA

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.