Projection - Custom Action - Not showing parameters

Hello Everyone,

I have added many custom actions to projections without any problem. However, I have this one now that will not populate the parameters that are in the PLSQL. What is really weird is that in the API Explorer it recognizes the parameters.

Has anyone seeing something like this and know how to resolve this?

I am getting this when I try to call the REST Service as labeled in the API Explorer, passing the parameter, and I can only think it is because the parameter isn’t showing up in the Projection.

"error": {

"code": "DATABASE_ERROR",

"message": "Database error occurred. Contact administrator.",

"details": r

{

"code": 6550,

"message": "ORA-06550: line 2, column 2:"

}

]

}

Appreciate anyone who may have an insight as to what may cause the parameter to not be showing up.

Thanks,

Derek Hansen

Page 1 / 1

I have the same error in aurena when adding and executing a custom action button:

IFS Web Version: 22.2.4.20230105140629.0
Date: 2023-05-25T12:52:48.840Z

Database error occurred. Contact administrator.
Error details: {"code":6550,"message":"ORA-06550: line 2, column 2:"}]

Hoping to bubble this to the top and get a response on this exception from the community. I too am having the same exact exception as the 2 individuals above.

I can confirm that I am using a PROCEDURE and only VARCHAR2 IN parameters, yet I still get the ORA-06550 exception: line2, column2.

If anyone has seen this exception in the past and knows how to resolve it, I would be very grateful. Thank you in advance.

I seem to be having the same issue. I’m using IFS Apps 10 Update 26, and have been unable to build a working custom action due to the same issues detailed above. Details of my setup are as follows...

I created a custom PLSQL package, with a very simple method using only 1 parameter; that being ObjKey. For testing purposes, I included just a single command in my method, to display a TOAST message…

On the Projection Configuration page, I added the Action and PL/SQL method. Clicking the down arrow on the left hand side of that record shows the arguments applicable to the action, but it always shows “no data” (was I right to expect a reference to my “arg_objkey” parameter here?)

I continued to create a Custom Page based on this projection, and added a Command button to call this action. When creating that button, I was able to map the parameter as expected…