How do I gain access to INTFC_FINPHY_SS_A table used by the Component Interface?
We are using the AM CI to convert and import data into PS AM 9.2, PT 8.53. The CI uses INTFC_FINPHY_SS_A table which is a 'consolidation" of INTFC_FIN and INTFC_PHY_A tables. Our customer needs to be able to setup some assets with a single acquisition row and multiple depreciation rows. While searching in the individual tables we found the "INTFC_FIN_MSG - Interface Fin Message Table" that has a "CF_SEQNO - Chartfield Sequence Number" field that would allows us to specify 2 separate distributions below the Book Section . We created a couple of test assets with 2 distributions lines and when loaded we get a "unique constraint" error (See attached document). Has anyone run into this situation? IS there a way to use the AM CI to load assets with a single acquisition row and multiple depreciation rows? Would appreciate your input