Skip to main content
Solved

How to call a custom Projection Action from a Migration Job

  • July 22, 2025
  • 5 replies
  • 55 views

Forum|alt.badge.img+1

Hi,

I’m using a Migration Job to import some Customer Orders.  When Customer Orders are created in Aurena we have a custom action in place that creates a new Financial Project, and connects the new Customer Order to the Financial Project.  I can see this running in the Log Window, which shows that the action name is “Cf_CreateConnectFinancialProject” and the Projection is “CustomerOrderHandling”:

 

I can confirm that this Projection>Action exists by looking at the Projection in Enterprise Explorer:

 

What I’m stuck on is how I call this action from my Migration Job, as it claims the method doesn’t exist:

I’m familiar with how to call APIs but not Projection Actions.  Can anyone help please?

We’re running APPS 10 Release 25.

Best answer by Marcel.Ausan

@davidh3891 could you open the debugger and see the PL/SQL code that is invoked when the custom projection action is executed? There must be some PL/SQL procedure call.

5 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1306 replies
  • July 22, 2025

@davidh3891 normally each projection action should have a PL/SQL procedure behind. Could you please try with Customer_Order_Handling_SVC.CF_Create_Connect_Financial_Project ?


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 2 replies
  • July 22, 2025

Hi ​@Marcel.Ausan,

Thanks for your quick response.  That doesn’t work unfortunately (same error message).  In SQL Developer I can see the CUSTOMER_ORDER_HANDLING_SVC package but within that there’s no function or procedure called CF_Create_Connect_Financial_Project or similar.


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1306 replies
  • Answer
  • July 22, 2025

@davidh3891 could you open the debugger and see the PL/SQL code that is invoked when the custom projection action is executed? There must be some PL/SQL procedure call.


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 2 replies
  • July 22, 2025

Hi ​@Marcel.Ausan,

I had looked at the debugger but obviously not in enough detail.  Amongst the many chained errors there was a reference to a completely different custom API, and within that I’ve found the procedure I need.

Thank you!


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1306 replies
  • July 22, 2025

@davidh3891 I’m glad you sorted this out.