EBS Customizations (MOSC)

MOSC Banner

What possible risks it would have to create a trigger on wip_requirement_operations

edited Apr 30, 2018 3:59AM in EBS Customizations (MOSC) 10 commentsAnswered

Hi ,

I want to create a trigger on table wip_requirement_operations. The purpose is to help with the performance issue in this table.  Once the trigger is on, it would transfer some data into other tables.

But we do not know what risks it may have to our systems? Please give some advice.

here is  the brief trigger i have made.

Create Or Replace Package chwm_data_pkg Is

-- Private type declarations

  Procedure popup_job_list(p_organization_id   Number,

                           p_wip_entity_id     Number,

                           p_inventory_item_id Number,

                           p_operation_seq_num Number,

                           p_action_type       Varchar2);

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center