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 |