Technology Stack - EBS (MOSC)

MOSC Banner

Record_Status is 'Changed' After Post_Query Trigger

edited Aug 20, 2021 11:08AM in Technology Stack - EBS (MOSC) 15 commentsAnswered

Record_Status is 'Changed' After Post_Query Trigger due to which is keeps asking to Save record while closing the form having no changes.

Here is Post_Query Trigger

================

IF :xxhil_om_sanction_budget.ou_id IS NOT NULL THEN

  select distinct  parm_ou_name 

  into :xxhil_om_sanction_budget.NBT_ORG_CD               --NON DB ITEM

  from XXHIL_OM_ORG_V

  where parm_ou_id= :xxhil_om_sanction_budget.ou_id;

END IF;

IF :xxhil_om_sanction_budget.item_id IS NOT NULL THEN

    select  segment1

    into :xxhil_om_sanction_budget.NBT_ITEM_NAME          --NON DB ITEM

    from mtl_system_items_b

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