PON_BID_HEADERS
PON_BID_HEADERS stores responses to negotiations. This tables stores header level information, such as response number, trading partner and contact information, business terms and conditions, currency, et cetera. Oracle Sourcing creates a record in this table for every response to a negotiation. The STATUS column indicates whether the response is: - the most recent available in the marketplace (ACTIVE) - a disqualified response (DISQUALIFIED) - an old response (ARCHIVED)
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PON_BID_HEADERS_PK |
BID_NUMBER |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
BID_NUMBER | NUMBER | 18 | Yes | System-generated unique number | ||
AUCTION_HEADER_ID | NUMBER | 18 | Yes | Auction Header Identifier | ||
BIDDERS_BID_NUMBER | VARCHAR2 | 25 | Bidder provided bid number | |||
TRADING_PARTNER_CONTACT_ID | NUMBER | 18 | Identifier for contact person of bidder trading partner | |||
TRADING_PARTNER_ID | NUMBER | 18 | Identifier for bidder trading partner | |||
BID_STATUS | VARCHAR2 | 25 | Bid status | |||
TYPE_OF_RESPONSE | VARCHAR2 | 25 | Specifies the type of the response as PRIMARY or ALTERNATE. | |||
AWARD_STATUS | VARCHAR2 | 25 | Award status | |||
BID_EXPIRATION_DATE | DATE | Date when the bid expires. | ||||
PUBLISH_DATE | DATE | Date on which bid is published | ||||
CANCELLED_DATE | DATE | Date on which bid is cancelled | ||||
DISQUALIFY_REASON | VARCHAR2 | 240 | Disqualify reason given by auctioneer if auctioneer disqualifies bid | |||
SUBMIT_STAGE | VARCHAR2 | 20 | Stores TECHNICAL/COMMERCIAL to mark the surrogate response in a two stage negotiation | |||
NOTE_TO_AUCTION_OWNER | VARCHAR2 | 4000 | Note to auction owner | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
BID_CURRENCY_CODE | VARCHAR2 | 15 | Currency code for bid | |||
RATE | NUMBER | Currency conversion rate | ||||
RATE_TYPE | VARCHAR2 | 30 | Currency conversion rate type | |||
RATE_DATE | DATE | Date of currency conversion rate | ||||
MIN_BID_CHANGE | NUMBER | Minimum bid change if proxy bidding is allowed | ||||
PROXY_BID_FLAG | VARCHAR2 | 1 | Y or N flag to indicate that proxy bid is allowed | |||
NUMBER_PRICE_DECIMALS | NUMBER | Precision in bid price | ||||
PO_AGREED_AMOUNT | NUMBER | Purchase order agreed amount | ||||
CANCEL_REASON | VARCHAR2 | 240 | Reason for cancelling bid | |||
VENDOR_ID | NUMBER | 18 | stores the vendor id of the bidder | |||
VENDOR_SITE_ID | NUMBER | 18 | stores vendor site id used to create the po | |||
RATE_DSP | NUMBER | Display value of rate shown to bidders | ||||
DRAFT_LOCKED | VARCHAR2 | 1 | Y or N flag to indicate if the draft is locked by a user. | |||
DRAFT_LOCKED_BY | NUMBER | 18 | Trading partner id of the lock owner | |||
DRAFT_LOCKED_BY_CONTACT_ID | NUMBER | 18 | Trading partner contact id of the lock owner | |||
DRAFT_LOCKED_DATE | DATE | Date and Time when the draft was locked | ||||
DRAFT_UNLOCKED_BY | NUMBER | 18 | Trading partner id of the person who unlocked | |||
DRAFT_UNLOCKED_BY_CONTACT_ID | NUMBER | 18 | Trading partner contact id of the person who unlocked the draft | |||
DRAFT_UNLOCKED_DATE | DATE | Date and Time when the draft was unlocked | ||||
VENDOR_SITE_CODE | VARCHAR2 | 240 | Stores the vendor_site_code of the supplier. | |||
INTERNAL_NOTE | VARCHAR2 | 4000 | Stores a buyer entered internal note for each supplier | |||
SHORTLIST_FLAG | VARCHAR2 | 1 | Stores Y if a supplier is on the shortlist, 'N' otherwise | |||
ATTRIBUTE_LINE_NUMBER | NUMBER | Yes | Internal column - Always stores a -1 denoting the line_number for header level attributes | |||
NOTE_TO_SUPPLIER | VARCHAR2 | 4000 | Stores the note to supplier entered during the award process | |||
TOTAL_AWARD_AMOUNT | NUMBER | Stores the calculated award amount for the supplier | ||||
SURROG_BID_CREATED_PERSON_ID | NUMBER | 18 | Person id of the buyer user creating the surrogate bid | |||
SURROG_BID_RECEIPT_DATE | DATE | Timestamp when the buyer received paper details | ||||
SURROG_BID_ONLINE_ENTRY_DATE | DATE | Timestamp when the buyer entered the bid on behalf of supplier. | ||||
SURROG_BID_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if the bid is a surrogate bid entered by the buyer on behalf of a supplier. | |||
COLOR_SEQUENCE_ID | NUMBER | This will contain a running sequence number within a negotiation. It can contain values greater than the number of permitted colors. In the case of a rebid, the sequence is retained. The permitted colors are contained in PON_COLORS. | ||||
AWARD_DATE | DATE | Date of award. This will be populated only when the negotiation does not have any lines. | ||||
PARTIAL_RESPONSE_FLAG | VARCHAR2 | 1 | 'Y' if the supplier has bid partial quantities or on partial lines | |||
INCUMBENT_FLAG | VARCHAR2 | 1 | Indicates whether the bid came from an incumbent supplier | |||
SCORE_OVERRIDEN_FLAG | VARCHAR2 | 1 | Indicates if the team score for a response has been overridden. This flag will be set only for negotiations enabled for team scoring. | |||
SCORE_OVERRIDEN_DATE | DATE | The date on which the score for a response has been overridden when team scoring is enabled. If team scoring is not enabled then this column will store the date when scores were last saved. | ||||
SCORE_OVERRIDE_TP_CONTACT_ID | NUMBER | 18 | Trading partner contact id of the person who last overrode the team scores. | Obsolete | ||
SCORE_OVERRIDE_PERSON_ID | NUMBER | 18 | Person Id of the team member who last overrode the team score for a response. | |||
OVERRIDEN_SCORE | NUMBER | Overridden score for a given response. This column will hold a value only if team scoring is enabled for the negotiation. | ||||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
REQUEST_DATE | DATE | Date/Time when concurrent request was submitted for bidding flow. | ||||
REQUESTED_BY | NUMBER | The user id of the person who made the concurrent request. | ||||
IMPORT_FILE_NAME | VARCHAR2 | 255 | The spreadsheet file name that is used for importing. | |||
OLD_NOTE_TO_AUCTION_OWNER | VARCHAR2 | 4000 | Note to negotiation owner from source bid. | |||
OLD_BIDDERS_BID_NUMBER | VARCHAR2 | 25 | Bidder specified bidder number from source bid | |||
OLD_BID_EXPIRATION_DATE | DATE | Expiration date from source bid. | ||||
OLD_BID_STATUS | VARCHAR2 | 25 | Bid status from source bid. | |||
OLD_MIN_BID_CHANGE | NUMBER | Minimum bid decrement from source bid. | ||||
OLD_SURROG_BID_RECEIPT_DATE | DATE | Surrogate Bid receipt date from source bid | ||||
SURROG_METHOD_OF_RESPONSE | VARCHAR2 | 30 | Method of response by supplier for surrogate bid | |||
DISPLAY_PRICE_FACTORS_FLAG | VARCHAR2 | 1 | Indicates whether this negotiation has applicable price factors | |||
OLD_BID_NUMBER | NUMBER | 18 | The bid number where the old values are populated from | |||
BUYER_BID_TOTAL | NUMBER | Bid total in buyer's currency. | ||||
SHORTLIST_BUYER_ID | NUMBER | 18 | Stores the person_id of the user who changed the shortlist status | |||
CURRENT_TOTAL_SPEND | NUMBER | Stores current spend for this Quote | ||||
FIXED_INCENTIVE | NUMBER | Stores the fixed incentive for this Quote | ||||
CURRENT_REBATE | NUMBER | Stores the current rebate percentage | ||||
HAS_REBATE_TIERS | VARCHAR2 | 1 | Indicates whether rebate tiers have been entered | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program | |||
PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the application name spawning the concurrent request. | |||
TECHNICAL_SHORTLIST_FLAG | VARCHAR2 | 1 | Y/N indicates if the bid has been shortlisted during the technical evaluation or not. | |||
BID_CURRENCY_MIN_BID_CHANGE | NUMBER | Minimum bid change in response currency if proxy bidding is allowed | ||||
OLD_BID_CURR_MIN_BID_CHANGE | NUMBER | Minimum bid change in response currency from source bid if proxy bidding is allowed | ||||
SURROG_DRAFT_LOCK_PERSON_ID | NUMBER | 18 | Person id of the buyer who has the lock on the surrogate bid | |||
SURROG_DRAFT_UNLOCK_PERSON_ID | NUMBER | 18 | Person id of the buyer who unlocked the draft surrogate bid | |||
MAX_INTERNAL_LINE_NUM | NUMBER | Holds the maximum value of LINE_NUMBER in the bid. | ||||
ORIGINAL_BID_NUMBER | NUMBER | 18 | Bid number corresponding to the first bid in a series of revising bids. | |||
POQ_TRANSFER_STATUS | VARCHAR2 | 30 | Yes | Indicates if pre-defined requirement responses have been transferred to Supplier Qualification. This column can have 3 possible values: 'NOT_TRANSFERRED', 'TRANSFERRED_TECHNICAL' and 'TRANSFERRED' | ||
SCORING_STATUS | VARCHAR2 | 30 | Status of scoring progress for the response when team scoring is not enabled. The possible values are NOT_STARTED, IN_PROGRESS, SUBMITTED. For 2 stage negotiations this column stores the scoring status of commercial stage. | |||
TECHNICAL_SCORING_STATUS | VARCHAR2 | 30 | Status of scoring progress for the response during technical stage when team scoring is not enabled. The possible values are NOT_STARTED, IN_PROGRESS, SUBMITTED. Populated only for 2 stage negotiations. | |||
SCORE_OVERRIDE_REASON | VARCHAR2 | 4000 | Reason for which the scores are overridden. | |||
BUYER_BID_TRANSFORMED_TOTAL | NUMBER | Transformed Bid total in buyer's currency. | ||||
TRANSFORMED_RANK | NUMBER | Transformed Rank for this particular bid | ||||
OVERALL_RANK | NUMBER | Not currently used. Replaced with "COMPOSITE_RANK" column for Overall response rank based on Requirements Composite Score feature. | ||||
CONTRACT_ID | NUMBER | 18 | Identifier for contracts | |||
CONTRACT_LINES_FLAG | VARCHAR2 | 1 | Indicates whether lines awarded to a supplier are added to contract created for the bid | |||
CONTRACT_ERROR_MSG | VARCHAR2 | 2000 | Error code along with message returned by contracts add lines API | |||
ACTION_CODE | VARCHAR2 | 20 | This will have value COPY,for copying the existing response. Will have value 'REVISE', for revising existing response. Otherwise null. | |||
SOURCE_BID_NUMBER | NUMBER | 18 | The bid number from which this bid is originated. | |||
JOB_PARAMS | CLOB | Stores the parameters like translated strings, status, required indicator or any informative params in xml format that are required when invoking ESS Job. | ||||
HAS_LINES_INSERTED_FLAG | VARCHAR2 | 1 | Flag to indicate whether lines required for response are inserted. | |||
PRE_BID_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if the bid is submitted during preview status of the negotiation. | |||
COMPOSITE_SCORE | NUMBER | Stores composite score of response. | ||||
COMPOSITE_RANK | NUMBER | Stores Composite Rank which is calculated based on response requirement score weightages. | ||||
RELATIVE_SCORE | NUMBER | Relative score of ORR composite score | ||||
IS_CREATED_FROM_REST | VARCHAR2 | 1 | Y/N flag to indicate whether this response is created from REST Service. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PON_BID_HEADERS | pon_auction_headers_all | AUCTION_HEADER_ID |
PON_BID_HEADERS | per_persons | SURROG_BID_CREATED_PERSON_ID |
PON_BID_HEADERS | per_persons | SHORTLIST_BUYER_ID |
PON_BID_HEADERS | pon_bid_headers | OLD_BID_NUMBER |
PON_BID_HEADERS | per_persons | SURROG_DRAFT_LOCK_PERSON_ID |
PON_BID_HEADERS | per_persons | SURROG_DRAFT_UNLOCK_PERSON_ID |
PON_BID_HEADERS | hz_parties | TRADING_PARTNER_ID |
PON_BID_HEADERS | hz_parties | TRADING_PARTNER_CONTACT_ID |
PON_BID_HEADERS | poz_suppliers | VENDOR_ID |
PON_BID_HEADERS | per_persons | SCORE_OVERRIDE_PERSON_ID |
PON_BID_HEADERS | hz_parties | DRAFT_LOCKED_BY |
PON_BID_HEADERS | hz_parties | DRAFT_LOCKED_BY_CONTACT_ID |
PON_BID_HEADERS | hz_parties | DRAFT_UNLOCKED_BY |
PON_BID_HEADERS | hz_parties | DRAFT_UNLOCKED_BY_CONTACT_ID |
pon_bid_item_prices | pon_bid_headers | BID_NUMBER |
pon_bid_item_prices | pon_bid_headers | TRIGGER_BID_NUMBER |
pon_auction_summary | pon_bid_headers | BID_NUMBER |
pon_bid_po_numbers | pon_bid_headers | BID_NUMBER |
pon_bid_requirements | pon_bid_headers | BID_NUMBER |
pon_bid_po_numbers_history | pon_bid_headers | BID_NUMBER |
pon_bid_po_org_assignments | pon_bid_headers | BID_NUMBER |
pon_bid_po_lines | pon_bid_headers | BID_NUMBER |
pon_bid_sections | pon_bid_headers | BID_NUMBER |
pon_bid_shipments | pon_bid_headers | BID_NUMBER |
pon_team_requirement_scores | pon_bid_headers | BID_NUMBER |
pon_bid_requirement_values | pon_bid_headers | BID_NUMBER |
pon_bid_po_lines_history | pon_bid_headers | BID_NUMBER |
pon_bid_headers | pon_bid_headers | OLD_BID_NUMBER |
pon_auction_item_prices_all | pon_bid_headers | BEST_BID_NUMBER |
pon_auction_item_prices_all | pon_bid_headers | BEST_BID_BID_NUMBER |
pon_team_bid_scores | pon_bid_headers | BID_NUMBER |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PON_BID_HEADERS_N1 | Non Unique | Default | TRADING_PARTNER_CONTACT_ID, BID_STATUS |
PON_BID_HEADERS_N10 | Non Unique | Default | ORIGINAL_BID_NUMBER |
PON_BID_HEADERS_N2 | Non Unique | Default | TRADING_PARTNER_ID, BID_STATUS |
PON_BID_HEADERS_N5 | Non Unique | Default | AUCTION_HEADER_ID, BID_STATUS |
PON_BID_HEADERS_N6 | Non Unique | Default | VENDOR_ID, TRADING_PARTNER_ID |
PON_BID_HEADERS_N7 | Non Unique | Default | LAST_UPDATE_DATE |
PON_BID_HEADERS_N8 | Non Unique | Default | TRUNC("PUBLISH_DATE") |
PON_BID_HEADERS_N9 | Non Unique | Default | TRUNC("BID_EXPIRATION_DATE") |
PON_BID_HEADERS_U1 | Unique | Default | BID_NUMBER |