6 Replies Latest reply on Jul 14, 2014 5:40 AM by Jon632

    How a table's records are deleted after commit without a trigger (but have a synonym)?



      I am tracing the behaviour of temporary tables of Advanced Pricing API price_request. When a call to this API is made, it creates multiple records into its temporary tables like qp_preq_lines_tmp_t but the moment I issue a commit, all the records are deleted, this is done within one session. This table has no triggers defined and a synonym is defined in apps schema. It is probably because of the synonym... but how it happened? Can anyone explain how it was done?