@Kevin M-Oracle I don't understand where else I need to add the parameter. I have specified the declaration both in the interface and in the code - in the body of the package procedure and function. I provided the code above, as well as the first screenshot of the parameter declaration in the BI.

@Kevin M-Oracle hi this is my code that I run, all variables are declared, but the problem still occurs ```sql create PACKAGE PKG_VKASIAN_TEST AS FUNCTION CALC_REAL_CASH_EXPIRE_TEST ( R_DATE DATE )RETURN NUMBER; PROCEDURE CALC_REAL_CASH_EXPIRE_TEST_2( R_DATE DATE, P_UPDATED_ROW_COUNT OUT NUMBER ); FUNCTION…

@Kevin M-Oracle this is my code that I run, all variables are declared, but the problem still occurs create PACKAGE PKG_VKASIAN_TEST AS FUNCTION CALC_REAL_CASH_EXPIRE_TEST ( R_DATE DATE )RETURN NUMBER; PROCEDURE CALC_REAL_CASH_EXPIRE_TEST_2( R_DATE DATE, P_UPDATED_ROW_COUNT OUT NUMBER ); FUNCTION CHECK_RESULT_TEST( R_DATE…

I use Oracle BI Administration Tool, Version 12.3 it's all a repository. in the properties, you can make a copy of this repository, is it possible to set it to automatic creation?

Kevin M-Oracle declaring a parameter didn't help. I have a script in the data model where the :RDATE parameter is used, and parameters are declared in the function I call. If, for example, my parameter in the data model is changed to TRUNC(SYSDATE), and the value is passed to the TRUNC(SYSDATE) function, then everything…

Gianni Ceresa Product - OAS Version 12

@Sumanth V -Oracle the screenshot provided is all I have and the data from the database(

I create a report in excel and send it using bursting. Is it possible to count the number of rows in the report? if you look at the logs, the number of formed lines is stored there, is it possible to somehow put them in a letter or in an attachment of a letter? is it possible to somehow write this quantity into a variable…

Good day! Yes, I think we have solved this issue! Thanks for your help and quick response!

Сan you use a trigger to capture the moment when the script has worked and add something of your own, for example, sending an empty file?