December 26, 2011

Set who Columns

Set who columns in pre-insert trigger in block level trigger

FND_STANDARD.SET_WHO;


The WHO columns are

CREATED BY,
CREATION_DATE,
LAST_UPDATE_BY,
LAST_UPDATED_DATE


at
Labels:

3 comments:

  1. AnonymousMarch 20, 2012 at 3:19 AM

    how to use this trigger

    ReplyDelete
    Replies
    1. MeeraMarch 20, 2012 at 3:37 AM

      Call it in Pre-Insert trigger,If your custom table has all the above mentioned WHO columns then it will be updated automatically.

      Delete
  2. MeeraMarch 20, 2012 at 3:36 AM

    This comment has been removed by the author.

    ReplyDelete

Thanks for your comments submitted.,will review and Post soon! by admin.

Subscribe to: Post Comments (Atom)

How I Identified 45 Configuration Gaps in an Oracle HCM Implementation — A Structured Approach

During a recent Oracle Fusion HCM implementation, I led a gap analysis that surfaced 45 configuration issues between the client's legacy...

  • Custom Report Notes:
    While Registering the report to instance we need to make sure od date format: 1.The default type is YYYY/MM/DD HH24:MI:SS   go to propert...
  • Order To Cash
    Order to cash normally refer to the process in which taking customer sale order via different sales channel like email, internet, sales pers...
  • Number into word
    This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...