Hi All,
The underlying view(s) for adding notes to Fixed Assets Objects screen are:
FIN_NOTE_TEXT
FA_OBJECT_NOTE
How do I combine these into one job, so once the notes are added into FIN_NOTE_TEXT, the note_id that’s generated gets automatically inserted into FA_OBJECT_NOTE?
+11
Hi
These 2 views are associated with FIN_NOTE_TEXT_API and FA_OBJECT_NOTE_API respectively.
So in simpler terms, you can call for the FA_OBJECT_NOTE_API.New___ method within the Insert___ procedure of the FIN_NOTE_TEXT_API. This a bit tricky thing and needs to be handled very carefully.
Or you can develop a custom procedures in both APIs to be called within once a new record is inserted in to FIN_NOTE_TEXT_API. This is not that tricky and safer if you know what you are doing.
Else you can use a trigger in FIN_NOTE_TEXT_Tab to call the FA_OBJECT_NOTE_API.New___ method or directly insert into FA_OBJECT_NOTE_Tab. This is not the best way and personally I advise you not to go this route.
I hope this helps.
Best Regards,
Charana
Hi
These 2 views are associated with FIN_NOTE_TEXT_API and FA_OBJECT_NOTE_API respectively.
So in simpler terms, you can call for the FA_OBJECT_NOTE_API.New___ method within the Insert___ procedure of the FIN_NOTE_TEXT_API. This a bit tricky thing and needs to be handled very carefully.
Or you can develop a custom procedures in both APIs to be called within once a new record is inserted in to FIN_NOTE_TEXT_API. This is not that tricky and safer if you know what you are doing.
Else you can use a trigger in FIN_NOTE_TEXT_Tab to call the FA_OBJECT_NOTE_API.New___ method or directly insert into FA_OBJECT_NOTE_Tab. This is not the best way and personally I advise you not to go this route.
I hope this helps.
Best Regards,
Charana
Thanks for responding mate.
I checked within the Insert___ procedure of the FIN_NOTE_TEXT_API and there was no mention of FA_OBJECT_NOTE_API.New___
We are not allowed to create or modify the API’s as client is strict about it.
+11
Then I believe, you can go for the 2nd option
“Or you can develop a custom procedures in both APIs to be called within once a new record is inserted in to FIN_NOTE_TEXT_API. This is not that tricky and safer if you know what you are doing.”
Can you look into this?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
