Skip to main content

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.

​@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 ?

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.

​@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.

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!

​@davidh3891 I’m glad you sorted this out.

Reply


Terms & ConditionsCookie settings