Fixed Assets - EBS (MOSC)

MOSC Banner

webadi customisation: i want to fill a column through a select command during upload regarding anoth

edited Jun 12, 2013 4:46AM in Fixed Assets - EBS (MOSC) 1 commentAnswered
 Hi,

I'm working on customisation for upload through webadi. It's working fine except one thing. I've customised an interface col to force a column asset_id to be filled thanks another column asset_number entered in spreadsheet through a sql command. I use a sql in default_value to retrieve that value. But i get an error when i upload. Does someone know how to do this?

DEFAULT_TYPE = "SQL"

DEFAULT_VALUE =

"SELECT ASSET_ID FROM FA.FA_ADDITIONS_B WHERE ASSET_NUMBER = '$table$.TEST.ASSET_NUMBER'  "

I get the following error : 4/1/11 2:18 PM ERROR BneBaseSQL.executeQuery: Exception while running query. Error Code: 1006, Message: ORA-01006: bind variable does not exist

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