You are browsing the archive for Concurrent Requests & Reports.

Create PO from Sourcing

 

NAME: Create PO from Sourcing
SHORT CODE: PON_CREATE_PO
MODULE: Oracle Sourcing

Description: Concurrent program to create PO from Sourcing award flow.
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 number of current negotiation
  • p_user_name : User name of the person creating PO (fnd_user.user_name)
  • p_user_id : User-id of the person creating PO (fnd_user.user_id)
  • p_formatted_name : Display name of the person creating PO (Formatted name for sending email)
  • p_auction_title : Title of the negotiation
  • p_organization_name : Org. name
  • p_resultout : To indicate whether PO creation was successful or failed

 

Copy Super Large Sourcing Negotiation

 

NAME: Copy Super Large Sourcing Negotiation
SHORT CODE: PON_COPY_NEGOTIATIONS
MODULE: Oracle Sourcing

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

Report Parameters:

  • p_api_version :
  • p_init_msg_list :
  • p_source_auction_header_id :
  • p_trading_partner_id :
  • p_trading_partner_contact_id :
  • p_language :
  • p_user_id :
  • p_doctype_id :
  • p_copy_type :
  • p_is_award_approval_reqd :
  • p_user_name :
  • p_mgr_id :
  • p_retain_clause :
  • p_update_clause :
  • p_retain_attachments :
  • p_large_auction_header_id :
  • p_style_id :

 

Generate award optimization scenario results

 

NAME: Generate award optimization scenario results
SHORT CODE: PON_AWARD_OPT_GENERATE
MODULE: Oracle Sourcing

Description: Award Optimization : Generate scenario results
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_SCENARIO_ID : internal scenario_id of the optimized scenario
  • P_SCENARIO_NUM : user-displayed scenario_number of the optimized scenario
  • P_REQUESTED_BY_USER_ID : fnd_user.user_id of the person who submitted this request
  • P_REQUESTED_DATE : date/time when this request was submitted
  • P_REQUESTED_BY_USER_NAME : fnd_user.user_name of the person who submitted this request
  • P_COST_CONSTRAINT_FLAG : Cost of constraint flag, Y if Cost of constraint, N if Award optimization
  • P_CONSTRAINT_TYPE : pon_optimize_constraints.constraint_type
  • P_INTERNAL_TYPE : Internal constraint type to indicate the user defined constraint
  • P_LINE_NUMBER : line number of the pon_optimize_constraints
  • P_SEQUENCE_NUMBER : sequence number of the pon_optimize_constraints