We have a requirement to execute custom event using a custom command in Aurena and I can only see 5 options when it comes to commands which shown below
Is this possible in IFS Aurena? If so how can I do this.
Application version: Apps10 UPD9
This topic has been closed for comments
Userlevel 6
+15
Hi
You cannot directly execute a custom event from a command in Aurena or in IEE.
A custom event is triggered when there is an INSERT/UPDATE/DELETE operation on the relevant table.
I would recommend you to write a custom action in the projection with a similar logic as the custom event action logic and then use the Execute Action option.
Cheers !
Dhananjaya.
Thank you for the answer
I need to create a function to generate project from a business opportunity and in IEE I could do this using a custom menu with following code
declare
info_ varchar2(32000);
objid_ varchar2(32000);
objversion_ varchar2(32000);
attr_ varchar2(32000);
attr_cf_ varchar2(32000);
project_id_ varchar2(100);
begin
Client_SYS.Clear_Attr(attr_);
--Client_SYS.Add_To_Attr('PROJECT_ID', '', attr_);
Client_SYS.Add_To_Attr('NAME','PR-' || &OPPORTUNITY_NO, attr_);
Client_SYS.Add_To_Attr('MANAGER', '*', attr_);
Client_SYS.Add_To_Attr('COMPANY', &COMPANY, attr_);
Client_SYS.Add_To_Attr('CALENDAR_ID', '*', attr_);
Client_SYS.Add_To_Attr('ACCESS_ON_OFF', '0', attr_);
Client_SYS.Add_To_Attr('BASELINE_REVISION_NUMBER', '0', attr_);
Client_SYS.Add_To_Attr('EARNED_VALUE_METHOD_DB', 'PLANNED', attr_);
-- Call the procedure
Project_API.New(info_,
objid_,
objversion_,
attr_,
'DO');
Client_SYS.Clear_Attr(attr_cf_);
Client_SYS.Add_To_Attr('CF$_SOURCE_BO', &OPPORTUNITY_NO, attr_cf_);
Client_SYS.Add_To_Attr('CF$_TITLE', &CF$_TITLE, attr_cf_);
Project_CFP.Cf_New__(info_,
objid_,
attr_cf_,
attr_,
'DO');
end;
------------------------------------------------------------------------------------------------------------------------------------
But when it comes to Aurena I could only use standard methods in the database and I’m stuck on how to pass the attribute string to these methods since in Aurena actions (ExecuteActions) there is no place to define attribute string based on what I see.
Can this be done in Aurena currently? If So, how could I do this?
Hi
Please refer the below post, could be what you are looking for.
- Nalaka -
Thank you
This was helpful. Do you know if there any functionality in Aurena where we can define custom PLSQL methods (connected to commands in Aurena)? Similar to what we can do in IEE Custom Menus
Userlevel 7
+14
+1
It seems like partner accounts do not have access to the links
Hi
This is the information that
To create custom commands (buttons) in Aurena that run a method, passing parameters from the page:
- Go to Projection Configuration and define the Custom Action, referencing a PLSQL package and method.
- Define an instance of the custom command using the Page Designer.
- If the method exists within a custom/utility package (can be found within the Projection Configuration area) and you are able to find the custom package/method.
- However you may not find the parameters even after a dictionary cache refresh.
- You will need to run the script mentioned in Scripts/Logs section after deploying the custom package, to get IFS to recognize the parameters in the method.
Script:
DEFINE GRANTEE = IFSSYS
PROMPT Granting to &GRANTEE
BEGIN
Installation_SYS.Grant_Ifssys(TRUE);
END;
/
PROMPT Refreshing Dictionary_SYS
EXEC Dictionary_SYS.Rebuild_Dictionary_Storage_(1, 'COMPUTE');
PROMPT Refreshing Reference_SYS
EXEC Reference_SYS.Refresh_Active_List__(2);
PROMPT Reinitialize packages
-- This command disables Installation_Mode in Dictionary_SYS
EXEC Dbms_Session.Modify_Package_State(Dbms_Session.Reinitialize);
/
PROMPT Refreshing Security_SYS
EXEC Security_SYS.Refresh_Active_List__(3);
/
- Nalaka -
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.