Campus Solutions - PSFT (MOSC)

MOSC Banner

Table structure in Tools vs SQL server

edited Aug 16, 2019 5:00AM in Campus Solutions - PSFT (MOSC) 2 commentsAnswered

When working in a development database it was noticed that the voucher staging table structure in Tools did not always follow the SQL structure in terms of field ordering.

Example: The  Lease payment date field was listed in tools at position 7 and and in SQL at position 82. As expected it caused a date to integer insert error when doing a straight wild card insert.

Has anyone else come across this structure issue? We can overcome the insert error but we wanted to be sure the structure was not being changed internally for some other purpose. 

Thanks in advance

Sunder

Director Data Analytics

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

PSFT Campus Solutions Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center