Search from 700 + Posts

Dec 14, 2009

fnd_standard.set_who

What is   -   fnd_standard.set_who

This is API provide by Oracle to return you the values of WHO columns .WHO columns are columns that tell you who has
1.Created/Update the value in a tables.

For all the standard table provide by in Oracle Applications , oracle has following WHO columns
1.Created_by
2.Last_Updated_by
3.Creation_date
4.Last_Update_date
5.Last_Update_login

7 comments:

  1. Hello ,

    I am using Apps version 12.0.0 and database version 10.2.0.4.0 .
    I am not getting this API .
    Am I missing something .??

    Thanks,
    DK.

    ReplyDelete
  2. Hi DK

    this API is part of application from days of 11.0.3.
    It is not part of database package,It is part of FDRCSID.pll.

    Hope that helps.

    ReplyDelete
  3. Hi,

    We are on 11.2.0.2 and Apps 12.1.3
    I do not find this FDRCSID.pll under AU_TOP/resource

    ReplyDelete
  4. Guys

    why you want to look at this pll, you can use the package fnd_standard.set_who in your forms.

    If this would have missing then
    1.Created_by
    2.Last_Updated_by
    3.Creation_date
    4.Last_Update_date
    5.Last_Update_login
    would have not populated properly.

    You need to look closely.Open any of the Oracle Standard Form and navigate to any of the the above 5 filed and you can see fnd_standard.set_who

    Hope that hels.


    Regards
    e

    ReplyDelete
  5. I am developing a new custom form based on a custom table which has the WHO columns.
    I have the following in the PRE-INSERT and PRE-UPDATE triggers at the block level
    fnd_standard.set_who;

    But I do not see the who columns populated.
    Please let me know if I am missing something.

    ReplyDelete
  6. Since system is not raising error when you call fnd_standard.set_who from forms trigger , so my take is everything is good from this API point of view (trust me).

    Only reason that it is not working for you is - you are missing to put this API fnd_standard.set_who in few more places.Google it and I am sure you will get some hits

    ReplyDelete
  7. you need to have the who columns in your data block also to have everything working probably..

    ReplyDelete