Asset Lifecycle Management - PSFT (MOSC)

MOSC Banner

How do I gain access to INTFC_FINPHY_SS_A table used by the Component Interface?

edited Feb 22, 2016 12:14PM in Asset Lifecycle Management - PSFT (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center