You are browsing the archive for Concurrent Requests & Reports.

Generate and Store Sourcing response spreadsheet

 

NAME: Generate and Store Sourcing response spreadsheet
SHORT CODE: PON_EXPORT_RESPONSE
MODULE: Oracle Sourcing

Description: Generates and stores the Zip file containing Sourcing response spreadsheet
Navigation: Oracle Sourcing Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_AUCTION_HEADER_ID :
  • P_REQUESTED_BY_USER_NAME :
  • P_REQUESTED_BY_USER_ID :
  • P_BID_CURRENCY_CODE :
  • P_RATE :
  • P_PRECISION :
  • P_DEFAULT_BID_NUMBER :
  • P_DEFAULT_BID_AUCTION_ID :
  • P_DEFAULT_BID_STATUS :
  • P_IS_PREV_DOC_BID_DEFAULTED :
  • P_PREV_ACTIVE_BID_NUMBER :
  • P_SUPPLIER_TRADING_PARTNER_ID :
  • P_SUPPLIER_VENDOR_SITE_ID :
  • P_SUPPLIER_SEQUENCE_NUMBER :
  • P_INSTRUCTION_FILE_ID :
  • P_IS_SURROGATE_BID :
  • P_FILE_FORMAT :

 

Generate and Store Sourcing Analysis/Award Spreadsheet

 

NAME: Generate and Store Sourcing Analysis/Award Spreadsheet
SHORT CODE: PON_EXPORT_AWARD
MODULE: Oracle Sourcing

Description: Award By Spreadsheet: Export
Navigation: Oracle Sourcing Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_AUCTION_HEADER_ID : auction_header_id of the current negotiation
  • P_DOWNLOAD_BID_STATUS : the status of the bids being downloaded (active, shortlisted, all, etc.)
  • P_EXPORT_SCENARIO : either auto-award spreadsheet or normal spreadsheet
  • P_REQUEST_ID :
  • P_REQUESTED_BY_USER_ID : fnd_user.user_id of the person who submitted this request
  • P_REQUESTED_BY_USER_NAME : fnd_user.user_name of the person who submitted this request
  • P_REQUESTED_BY_USER_TYPE : either buyer or supplier users can export a spreadsheet
  • P_REQUESTED_BY_DATE : date/time when this request was submitted
  • P_HAS_AWARD_PRIVILEGE : Indicates whether this person can award the negotiation
  • P_INSTRUCTION_FILE_ID : file_id of the instruction file that was saved in fnd_lobs at run time
  • P_INSTRUCTION_FILE_NAME : file_name of the instruction file
  • P_REQUEST_ACTION_TYPE : used to determine the type of email we will send to the request

 

Download PDF for Super Large Negotiations

 

NAME: Download PDF for Super Large Negotiations
SHORT CODE: PON_DOWLOAD_PDF
MODULE: Oracle Sourcing

Description: Download the PDF for Super Large Negotiations
Navigation: Oracle Sourcing Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_AUCTION_HEADER_ID : The auction header id
  • P_CLIENT_TIME_ZONE : The client time zone
  • P_SERVER_TIME_ZONE : The server time zone
  • P_DATE_FORMAT_MASK : The date format mask
  • P_TRADING_PARTNER_ID : The trading partner id
  • P_TRADING_PARTNER_NAME : The trading partner name
  • P_VENDOR_SITE_ID : The vendor site id
  • P_USER_VIEW : The user view – supplier/buyer
  • P_HAS_CONTRACTS_ACCESS : If the user has access to contracts
  • P_PRINT_WITH_CONTRACTS : If the negotiation should be printed with contracts
  • P_FILE_NAME : The name of the generated file
  • P_LANGUAGE : The language in which the pdf should be generated
  • P_USER_ID : The user id of the person who initiated the request
  • P_USER_NAME : The user name of the person who initiated the request
  • P_REQUESTED_SUPPLIER_ID : The Supplier Id of the Prospective Supplier from pos_supplier_registrations
  • P_REQUESTED_SUPPLIER_NAME : The Supplier