Home › Discussions › Questions & Answers › FND vs XXEN API for PLSQL Submission

FND vs XXEN API for PLSQL Submission

Avatar photoCustomer Questions & Answers 5 replies

We are submitting Blitz Reports via PLSQL. Should we use the standard `fnd_request.submit_request` or the dedicated Blitz Report API, and what’s the key difference in argument handling?

5 replies

  • Support Enginatics

    The Oracle standard `fnd_request.submit_request` can be used. Arguments 1 through 15 specify the report name and runtime options (like email, output format, etc.). The actual **user-entered report parameters start from argument 16** onwards.

  • Avatar photoCustomer

    That positional argument mapping sounds rigid. Is there a more flexible method?

  • Support Enginatics

    Yes, the alternative is `xxen_api.report_submit_concurrent_`. This API allows referencing the report, parameter, and template names by name or ID instead of relying on argument position, which improves code readability and maintenance.

  • Avatar photoCustomer

    So if I use the Blitz Report API, I first submit the request and then set parameters?

  • Support Enginatics

    That is the typical flow. You first call `xxen_api.report_submit_concurrent_` to get a run ID, and then use procedures like `xxen_api.set_parameter_value_` and `xxen_api.set_runtime_option` referencing that run ID.

  • You must be logged in to reply to this post.