1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

API to Update Result Flexfield (Quality Manager > Results > Results)

Discussion in 'Oracle Apps Technical' started by chester04, Jan 22, 2014.

  1. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Hi,

    Anyone knows if there's an API to update the Result flexfield in Results form (Quality Manager > Results > Results)?

    Thank you.

    BR,
    Chester
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Chester check the following it may help you....

    Link

    check 25 th page....
     
  3. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Thank you Jagadekara...

    But I found this API but not sure if this API is used to update Results flexfield from Results Form (Quality Manager > Results > Results)
    - GMI_LotUpdate_PUB
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Chester,

    Go to that form and tell me the table name
     
  5. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Hi Jagadekara,

    Table Name: GMD_SAMPLES

    BR,
    Chester
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi there is no field of result in that table. Can you tell me the field name?
     
  7. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Hi Jagadekara,

    I'm not sure if Results field will be setup as flexfield or the correct table name is GMD_RESULTS.
    Thank you.

    BR,
    Chester
     
  8. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi chek this...

    GMD_RESULTS_PUB

    I am not sure but check it once... It may help you....
     
  9. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Hi,

    Need another help.

    GMD_RESULTS_PUB.RECORD_RESULTS was able to update the table GMD_RESULTS including DFF for sample that does not have result but not sure if it can update result with existing value.

    Thank you.