Unable To Upload Bids In Procurement as Admin or as a Carrier. (Doc ID 558403.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Sourcing - Version: 5.5.04
This problem can occur on any platform.

Symptoms

-- Problem Statement:
You are attempting to upload procurement bids to a view. The view is P_CARRIER_RESPONSE.
and are getting the error below:

ORA-01733: virtual column not allowed here.

-- Steps To Reproduce:
1. Click on Business Process Automation
2. Click Integration -> Intergration Manager
3. Click Upload an XML/CSV Transmission
4. Click Browse and select the appropriate CSV file
5. Click Upload
6. After this you can see the ORA-01733 virtual column not allowed here message

-- Business Impact:
Unable to run future bid projects.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms