Dears,
Any idea on this THREESIXTY_RAM_LOAD_HISTORY table structure and data inside this table.
This table contains huge records, and we need to delete the records.
let us know the impact on both FSM and PSO after records deleted.
Thanks,
Narsing
Dears,
Any idea on this THREESIXTY_RAM_LOAD_HISTORY table structure and data inside this table.
This table contains huge records, and we need to delete the records.
let us know the impact on both FSM and PSO after records deleted.
Thanks,
Narsing
Hi
The interface between FSM and PSO consists of both “transfer once” data and real time updates. The transfer once principle is based on table that keeps track of which records has been transferred. This principle is both to limit unneeded traffic in interface but also to protect data in PSO where data from FSM are often enriched such as resources.
The table keeping track of the already transferred data is called threesixty_ram_load_history
In case all skill records for some reason needs to be retransferred e.g. this can be achieved by having an administrator run be low delete statement.
DELETE FROM THREESIXTY_RAM_LOAD_HISTORY WHERE ram_object_type= 'RAM_SKILL'
When new load job is run the skills will transfer again (verify if cleanup in ARP is needed as well prior to this).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.