This discussion is archived
2 Replies Latest reply: Jul 8, 2013 12:00 AM by 983229 RSS

Is there a standard web service to retrieve all projects updated on a specific day?

10ea743b-34f9-4210-8895-2859c27fa2f5 Newbie
Currently Being Moderated

Hi, we're using the Projects module. Is there a standard web service to retrieve all projects last updated on a specific day, such as today, yesterday, or something else? Currently we're creating a custom service, but find it difficult to figure how when a project was last updated, as we have to go through all tasks, all sub tasks, and so on, and find the latest update date. Each time a task or sub task is updated, we should consider this project as updated.

 

Thanks for any suggestions.

  • 1. Re: Is there a standard web service to retrieve all projects updated on a specific day?
    Dina Rotem Guru
    Currently Being Moderated

    Hi

     

    I don't think there is a web service for that.

    However, you might consider implementing the audit tables for the projects, task, classifications and key members basic tables.

    When you enable the audit table, the system is automatically recording any insert, deletion or update of the base table, along with the time stamp and user details.

    Developing a service to read from the audit tables might be easier, and less time consuming.

     

    Dina

  • 2. Re: Is there a standard web service to retrieve all projects updated on a specific day?
    983229 Newbie
    Currently Being Moderated

    Hi,

    FND: Record History Enabled is the profile option to get the who columns in OAF page, which was introduced in R12.(12.1.1)
    May be you might need to a clear cache or oacore bounce to take the profile option change effect.

    In an advanced table.

    Overview

    --------------

    Within Oracle Application Framework (OAF) pages there are times when a user needs to see who created or updated a record.

     

     

    This information is generally saved in the "WHO columns" of the database tables that are linked to an OAF page through BC4J Entity Objects (EOs). The standard WHO columns represented are as follows.

    * Name of the user who created the row
    * Date of creation
    * Name of user who updated the row
    * Date when row was last updated

    Clicking the Record History icon brings up the Record History popup window that displays the WHO column values of the current row.


    Regards

    Raghavender K

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points