Skip to main content
Question

Projection - Custom Action - Not showing parameters


Forum|alt.badge.img+8
  • Do Gooder (Customer)
  • 25 replies

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": [

            {

                "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

4 replies

BytSamueW
Do Gooder (Partner)
Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 2 replies
  • May 25, 2023

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:"}]


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 1 reply
  • October 7, 2023

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.


Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 70 replies
  • February 10, 2025

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…

 

However, clicking the “Accept” command button instantly gives a Server Error…

Can anyone help with this? What are we doing wrong?

Thanks in advance,

  • Robin

BytSamueW
Do Gooder (Partner)
Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 2 replies
  • February 18, 2025

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings