Webservice operations
The operations of package xxen_webservices, published through ORDS and the EBS Integrated SOA Gateway. See Calling Blitz Report over REST for authentication and request format.
Summary
| Operation | ORDS endpoint | Description |
|---|---|---|
| installed_languages | POST xxen/installed_languages/ | Lists active Oracle EBS languages |
| upload_lov_records | POST xxen/upload_lov_records/ | Returns the lov values |
| validate_upload_records | POST xxen/validate_upload_records/ | Validates the upload records |
| stage_upload_rows | POST xxen/stage_upload_rows/ | Stages upload rows for a Blitz Upload run without an upload file: record 1 carries the sql column name per sheet position, records above 1 the row values, both newline separated |
| upload_default_value | POST xxen/upload_default_value/ | Returns the default values |
| session_cookie | POST xxen/session_cookie/ | Get session details |
| upload_file | POST xxen/upload_file/ | Uploads the file |
| user_responsibilities | POST xxen/user_responsibilities/ | Lists the user responsibilities |
| fsg_lov_records | POST xxen/fsg_lov_records/ | Returns the lov values |
| fsg_function_records | POST xxen/fsg_function_records/ | Returns the lov values |
| fsg_records | POST xxen/fsg_records/ | Returns the lov values |
| view_transaction | POST xxen/view_transaction/ | Returns the hyperlink for subledger transaction |
| update_fsg_profile_values | POST xxen/update_fsg_profile_values/ | Updates the FSG profile option values at user level |
| autofill_values | POST xxen/autofill_values/ | Returns autofill values for multiple columns in bulk |
| report_list | POST xxen/report_list/ | Returns list of reports accessible to user (regular reports and uploads) |
| report_metadata | POST xxen/report_metadata/ | Returns report metadata including parameters and templates |
| report_param_lov | POST xxen/report_param_lov/ | Returns LOV values for report parameters (single or comma-separated IDs) |
| run_report | POST xxen/run_report/ | Executes a report and returns the output as base64 encoded blob |
| report_file | POST xxen/report_file/ | Executes a report and returns its output file as the run screen downloads it, base64 encoded with its file name and row count |
| email_report | POST xxen/email_report/ | Submits a report as a concurrent request that emails its output |
| report_batch | POST xxen/report_batch/ | Returns a specific batch of report output for large results |
| validate_required_params | POST xxen/validate_required_params/ | Validates the required_parameters expression before running a report |
| version_info | POST xxen/version_info/ | Returns Blitz Report version and build date |
| template_columns | POST xxen/template_columns/ | Returns template details and column configuration for editing |
| save_template | POST xxen/save_template/ | Saves a new or updates an existing template with column configuration |
| copy_template | POST xxen/copy_template/ | Copies an existing template with all column configuration, pivot settings, and Excel files |
| drilldowns | POST xxen/drilldowns/ | Returns existing drilldown configurations for a report |
| report_columns | POST xxen/report_columns/ | Returns column names from a report for drilldown column selection |
| save_drilldown | POST xxen/save_drilldown/ | Creates or updates a drilldown assignment with parameter mappings |
| delete_drilldown | POST xxen/delete_drilldown/ | Deletes a drilldown assignment and its parameter mappings |
| lov_catalogue | POST xxen/lov_catalogue/ | Returns the catalogue of all shared LOVs (xxen_report_parameter_lovs) for cell-LOV attachment in the add-in |
| cell_lov_records | POST xxen/cell_lov_records/ | Returns LOV row values for a given LOV GUID (used by the add-in cell-LOV attachment feature) |
| submit_upload | POST xxen/submit_upload/ | Submits the Blitz Upload processing concurrent request for an upload file previously loaded into fnd_lobs via upload_file, or for rows previously staged via stage_upload_rows |
| upload_status | POST xxen/upload_status/ | Returns the phase and status of an upload processing concurrent request and the row level success/error counts |
| email_upload_result | POST xxen/email_upload_result/ | Attaches an email address to a running upload, to which the upload result workbook is sent once the rows are processed |
| run_upload_result | POST xxen/run_upload_result/ | Executes the upload result report for a completed webservice originated upload run and returns the batched report payload |
| purge_upload_run | POST xxen/purge_upload_run/ | Purges the retained upload data of a webservice originated upload run after the add-in fetched the result |
| save_param_defaults | POST xxen/save_param_defaults/ | Saves the run screen parameter values as user or template parameter defaults |
| clear_param_defaults | POST xxen/clear_param_defaults/ | Clears the user or template parameter defaults of a report |
Operations
installed_languages
POST xxen/installed_languages/
function installed_languages(p_user_name in varchar2 default null, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Lists active Oracle EBS languages
| Parameter | Description |
|---|---|
| p_user_name | Optional user name for automatic language derivation |
| p_nls_language | Optional NLS language for display name translation |
upload_lov_records
POST xxen/upload_lov_records/
function upload_lov_records(p_report_id in number, p_run_id in number, p_column_binds in xxen_upload_column_binds_tab) return xxen_upload_clob_arr
Returns the lov values
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_run_id | Accepts the run id |
| p_column_binds | Accepts the column binds |
validate_upload_records
POST xxen/validate_upload_records/
function validate_upload_records(p_report_id in number, p_run_id in number, p_records in xxen_upload_records_tab) return xxen_upload_clob_arr
Validates the upload records
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_run_id | Accepts the run id |
| p_records | Accepts the records to be validated |
stage_upload_rows
POST xxen/stage_upload_rows/
function stage_upload_rows(p_report_id in number, p_run_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_records in xxen_upload_records_tab, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Stages upload rows for a Blitz Upload run without an upload file: record 1 carries the sql column name per sheet position, records above 1 the row values, both newline separated
| Parameter | Description |
|---|---|
| p_report_id | Accepts the upload report id |
| p_run_id | Upload run id returned by the first call, null to create the run |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_records | Accepts the records to be staged |
| p_nls_language | Optional NLS language for the session |
upload_default_value
POST xxen/upload_default_value/
function upload_default_value(p_report_id in number, p_run_id in number, p_column_binds in xxen_upload_column_binds_tab) return xxen_upload_clob_arr
Returns the default values
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_run_id | Accepts the run id |
| p_column_binds | Accepts the column binds |
session_cookie
POST xxen/session_cookie/
function session_cookie return xxen_upload_clob_arr
Get session details
upload_file
POST xxen/upload_file/
function upload_file(p_files in xxen_upload_file_tab) return xxen_upload_clob_arr
Uploads the file
| Parameter | Description |
|---|---|
| p_files | Accepts the files |
user_responsibilities
POST xxen/user_responsibilities/
function user_responsibilities(p_user_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Lists the user responsibilities
| Parameter | Description |
|---|---|
| p_user_name | Accepts the user name |
| p_nls_language | Optional NLS language for the session |
fsg_lov_records
POST xxen/fsg_lov_records/
function fsg_lov_records(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_identifier in varchar2, p_binds in xxen_webservice_binds_tab_type) return xxen_webservice_table_array
Returns the lov values
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_identifier | Accepts the column name |
| p_binds | Accepts the lov binds |
fsg_function_records
POST xxen/fsg_function_records/
function fsg_function_records(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_identifier in varchar2, p_binds in xxen_webservice_binds_tab_type) return xxen_webservice_table_array
Returns the lov values
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_identifier | Accepts the column name |
| p_binds | Accepts the lov binds |
fsg_records
POST xxen/fsg_records/
function fsg_records(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_identifier in varchar2, p_binds in xxen_webservice_records_type) return xxen_webservice_data_arr
Returns the lov values
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_identifier | Accepts the column name |
| p_binds | Accepts the drilldown binds |
view_transaction
POST xxen/view_transaction/
function view_transaction(p_application_name in varchar2, p_user_name in varchar2, p_ledger in number, p_responsibility_key in varchar2, p_security_group in varchar2, p_source_name in varchar2, p_event_id in number) return xxen_webservice_data_arr
Returns the hyperlink for subledger transaction
| Parameter | Description |
|---|---|
| p_application_name | Accepts the application short name |
| p_user_name | Accepts the user name |
| p_ledger | Accepts the ledger id |
| p_responsibility_key | Accepts the responsibility key |
| p_security_group | Accepts the security group |
| p_source_name | Accepts the source name |
| p_event_id | Accepts the event id |
update_fsg_profile_values
POST xxen/update_fsg_profile_values/
function update_fsg_profile_values(p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_binds in xxen_webservice_binds_tab_type) return xxen_webservice_table_array
Updates the FSG profile option values at user level
| Parameter | Description |
|---|---|
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_binds | Accepts the binds |
autofill_values
POST xxen/autofill_values/
function autofill_values(p_report_id in number, p_run_id in number, p_records in xxen_upload_records_tab) return xxen_upload_clob_arr
Returns autofill values for multiple columns in bulk
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_run_id | Accepts the run id |
| p_records | Accepts the records containing column metadata and values |
report_list
POST xxen/report_list/
function report_list(p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_search_text in varchar2 default null, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Returns list of reports accessible to user (regular reports and uploads)
| Parameter | Description |
|---|---|
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_search_text | Optional search text filter |
| p_nls_language | Optional NLS language for the session |
report_metadata
POST xxen/report_metadata/
function report_metadata(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null, p_template_name in varchar2 default null) return xxen_upload_clob_arr
Returns report metadata including parameters and templates
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
| p_template_name | Optional template name to align the upload column metadata with the templates output |
report_param_lov
POST xxen/report_param_lov/
function report_param_lov(p_report_id in number, p_parameter_id in varchar2, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_binds in xxen_webservice_binds_tab_type, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Returns LOV values for report parameters (single or comma-separated IDs)
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_parameter_id | Accepts the parameter id (single or comma-separated) |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_binds | Accepts the dependency binds |
| p_nls_language | Optional NLS language for the session |
run_report
POST xxen/run_report/
function run_report(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_parameters in xxen_webservice_binds_tab_type, p_template_name in varchar2 default null, p_apply_defaults in varchar2 default 'Y', p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Executes a report and returns the output as base64 encoded blob
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_parameters | Accepts the parameter values |
| p_template_name | Optional template name |
| p_apply_defaults | Y to apply defaults for missing params (drilldowns), N for Run Screen |
| p_nls_language | Optional NLS language for the session |
report_file
POST xxen/report_file/
function report_file(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_parameters in xxen_webservice_binds_tab_type, p_template_name in varchar2 default null, p_apply_defaults in varchar2 default 'Y', p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Executes a report and returns its output file as the run screen downloads it, base64 encoded with its file name and row count
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_parameters | Accepts the parameter values |
| p_template_name | Optional template name |
| p_apply_defaults | Y to apply defaults for missing params, N to run with the values passed only |
| p_nls_language | Optional NLS language for the session |
email_report
POST xxen/email_report/
function email_report(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_parameters in xxen_webservice_binds_tab_type, p_email in varchar2, p_template_name in varchar2 default null, p_apply_defaults in varchar2 default 'Y', p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Submits a report as a concurrent request that emails its output
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_parameters | Accepts the parameter values |
| p_email | Accepts the email addresses, separated by semicolon |
| p_template_name | Optional template name |
| p_apply_defaults | Y to apply defaults for missing params (drilldowns), N for Run Screen |
| p_nls_language | Optional NLS language for the session |
report_batch
POST xxen/report_batch/
function report_batch(p_run_id in number, p_batch_number in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Returns a specific batch of report output for large results
| Parameter | Description |
|---|---|
| p_run_id | Accepts the run id from the initial run_report call |
| p_batch_number | Accepts the batch number to fetch (1-based) |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
validate_required_params
POST xxen/validate_required_params/
function validate_required_params(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_binds in xxen_webservice_binds_tab_type, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Validates the required_parameters expression before running a report
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_binds | Accepts the parameter values to validate |
| p_nls_language | Optional NLS language for the session |
version_info
POST xxen/version_info/
function version_info(p_dummy in varchar2 default null) return xxen_upload_clob_arr
Returns Blitz Report version and build date
| Parameter | Description |
|---|---|
| p_dummy | Dummy parameter (ISG requires at least one parameter) |
template_columns
POST xxen/template_columns/
function template_columns(p_report_id in number, p_template_name in varchar2, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null, p_organization_id in number default null) return xxen_upload_clob_arr
Returns template details and column configuration for editing
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_template_name | Accepts the template name (empty for new template) |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
| p_organization_id | Optional inventory organization id (MFG_ORGANIZATION_ID) for organization dependent parameter defaults |
save_template
POST xxen/save_template/
function save_template(p_report_id in number, p_template_name in varchar2, p_description in varchar2, p_global_default in varchar2, p_distinct_flag in varchar2, p_dynamic_columns in varchar2, p_columns_json in clob, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Saves a new or updates an existing template with column configuration
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_template_name | Accepts the template name |
| p_description | Accepts the template description |
| p_global_default | Y/N flag for global default template |
| p_distinct_flag | Y/N flag for distinct records |
| p_dynamic_columns | Y/N flag for dynamic columns |
| p_columns_json | JSON array of column configuration |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
copy_template
POST xxen/copy_template/
function copy_template(p_source_template_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Copies an existing template with all column configuration, pivot settings, and Excel files
| Parameter | Description |
|---|---|
| p_source_template_id | Accepts the source template id to copy |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
drilldowns
POST xxen/drilldowns/
function drilldowns(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Returns existing drilldown configurations for a report
| Parameter | Description |
|---|---|
| p_report_id | Accepts the parent report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
report_columns
POST xxen/report_columns/
function report_columns(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Returns column names from a report for drilldown column selection
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
save_drilldown
POST xxen/save_drilldown/
function save_drilldown(p_assignment_id in number, p_source_report_id in number, p_child_report_id in number, p_drilldown_column in varchar2, p_param_mappings in clob, p_template_id in number, p_matching_column in varchar2, p_matching_value in varchar2, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Creates or updates a drilldown assignment with parameter mappings
| Parameter | Description |
|---|---|
| p_assignment_id | Accepts the assignment id (null for new) |
| p_source_report_id | Accepts the parent/source report id |
| p_child_report_id | Accepts the child/target report id |
| p_drilldown_column | Accepts the clickable column name |
| p_param_mappings | Accepts the parameter mappings as JSON array |
| p_template_id | Accepts the template id for the drilldown report (null for default) |
| p_matching_column | Accepts the column name to match against for conditional drilldowns |
| p_matching_value | Accepts the value pattern to match (supports % wildcards) |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
delete_drilldown
POST xxen/delete_drilldown/
function delete_drilldown(p_assignment_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Deletes a drilldown assignment and its parameter mappings
| Parameter | Description |
|---|---|
| p_assignment_id | Accepts the assignment id to delete |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
lov_catalogue
POST xxen/lov_catalogue/
function lov_catalogue(p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Returns the catalogue of all shared LOVs (xxen_report_parameter_lovs) for cell-LOV attachment in the add-in
| Parameter | Description |
|---|---|
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
cell_lov_records
POST xxen/cell_lov_records/
function cell_lov_records(p_lov_guid in varchar2, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_search_text in varchar2 default null, p_max_rows in pls_integer default 1000, p_binds in xxen_webservice_binds_tab_type default null, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Returns LOV row values for a given LOV GUID (used by the add-in cell-LOV attachment feature)
| Parameter | Description |
|---|---|
| p_lov_guid | Hex GUID of the LOV (raw(16) rendered as 32-char hex) |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_search_text | Optional text to filter rows by value |
| p_max_rows | Maximum rows to return (default 1000) |
| p_binds | Optional dependency binds for :$flex$/:$column$ resolution |
| p_nls_language | Optional NLS language for the session |
submit_upload
POST xxen/submit_upload/
function submit_upload(p_report_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_file_id in number, p_template_name in varchar2 default null, p_nls_language in varchar2 default null, p_run_id in number default null, p_template_id in number default null, p_source_run_id in number default null, p_file_name in varchar2 default null) return xxen_upload_clob_arr
Submits the Blitz Upload processing concurrent request for an upload file previously loaded into fnd_lobs via upload_file, or for rows previously staged via stage_upload_rows
| Parameter | Description |
|---|---|
| p_report_id | Accepts the upload report id |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_file_id | fnd_lobs file id of the upload file, null for a staged run |
| p_template_name | Optional template name |
| p_nls_language | Optional NLS language for the session |
| p_run_id | Upload run id returned by stage_upload_rows |
| p_template_id | Optional template id of a staged run |
| p_source_run_id | Optional run id of the download the staged rows were built from, its parameter values serve the upload |
| p_file_name | Optional file name shown for a staged run |
upload_status
POST xxen/upload_status/
function upload_status(p_request_id in number, p_run_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Returns the phase and status of an upload processing concurrent request and the row level success/error counts
| Parameter | Description |
|---|---|
| p_request_id | Concurrent request id returned by submit_upload |
| p_run_id | Upload run id returned by submit_upload |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
email_upload_result
POST xxen/email_upload_result/
function email_upload_result(p_run_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_email in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Attaches an email address to a running upload, to which the upload result workbook is sent once the rows are processed
| Parameter | Description |
|---|---|
| p_run_id | Upload run id returned by submit_upload |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_email | Accepts the email addresses, separated by semicolon |
| p_nls_language | Optional NLS language for the session |
run_upload_result
POST xxen/run_upload_result/
function run_upload_result(p_run_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Executes the upload result report for a completed webservice originated upload run and returns the batched report payload
| Parameter | Description |
|---|---|
| p_run_id | Upload run id returned by submit_upload |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
purge_upload_run
POST xxen/purge_upload_run/
function purge_upload_run(p_run_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Purges the retained upload data of a webservice originated upload run after the add-in fetched the result
| Parameter | Description |
|---|---|
| p_run_id | Upload run id returned by submit_upload |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
save_param_defaults
POST xxen/save_param_defaults/
function save_param_defaults(p_report_id in number, p_template_id in number, p_parameters in xxen_webservice_binds_tab_type, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Saves the run screen parameter values as user or template parameter defaults
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_template_id | Accepts the template id for template defaults, empty for user defaults |
| p_parameters | Accepts the parameter values |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
clear_param_defaults
POST xxen/clear_param_defaults/
function clear_param_defaults(p_report_id in number, p_template_id in number, p_user_name in varchar2, p_responsibility_key in varchar2, p_application_name in varchar2, p_nls_language in varchar2 default null) return xxen_upload_clob_arr
Clears the user or template parameter defaults of a report
| Parameter | Description |
|---|---|
| p_report_id | Accepts the report id |
| p_template_id | Accepts the template id for template defaults, empty for user defaults |
| p_user_name | Accepts the user name |
| p_responsibility_key | Accepts the responsibility key |
| p_application_name | Accepts Application Name |
| p_nls_language | Optional NLS language for the session |
Generated from Blitz Report 3.3.7 on .