• State Not Answered
  • Replies 3 replies
  • Subscribers 93 subscribers
  • Views 297 views
  • Users 0 members are here
Options
Related

Personwantorg table value in UNSAccountb table

pavithra
4 months ago

Hello All,

8.1.4v

Target system is Oracle DB. I want to publish few column values from personwantsorg table to unsaccountb table. So, I created a new column(as a foreign key of personwantorg table) in unsaccountb table and tried to get the value but it isn't working. I wanted to populate the orderdate, personordered's(objectGUID of unsaccountb table) value and activation date from personwantsorg table in unsaccounb table. Can anyone help me with this?

Thanks,

Pavithra

 

  • 0 4 months ago

    Hello,

    "tried to get the value " - what were your steps?  How are you trying to accomplish this?

    trevor

  • 0 4 months ago in reply to Trevor Pike

    Hi  ,

    I created an attribute in UNSAccountB table as a foreign key of the Personwantsorg table and tried to get the value of personwantsorg table in UNSAccountB table using the below line.
    Value = $FK(ccc_UID_PersonWantsOrg).DisplayOrg$
    It was compiled without any errors, but when I ran the template in the object browser it was empty.

    I wanted to get the orderdate, personordered's(objectGUID value of unsaccountb table), and activation date from personwantsorg table.
    Pls, how can I achieve this if its not the right way.

    Thanks,

  • 0 3 months ago in reply to pavithra

    This works for me.  If I look up a user account in manager, from the custom tab I can then select a value for CCC_UID_PersonWantsOrg, for the values that exist in PersonWantsOrg.  If that's what you're trying to accomplish?

    Are there existing values in PersonWantsOrg?

    Trevor