You are browsing the archive for Oracle Sourcing.

by oracleguru

Negotiation Response Reminder Notification

ORACLE APPS COMMUNITY > Tutorial > Procurement > Oracle Sourcing

 

NAME: Negotiation Response Reminder Notification
SHORT CODE: PONRMNTF
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_send_when : Value after open date, before close date, after preview date.
  • p_days_values : days when the notification needs to be sent in CSV format

 

No Comments »

by oracleguru

EMD Refund/Forfeit Concurrent Program

ORACLE APPS COMMUNITY > Tutorial > Procurement > Oracle Sourcing

 

NAME: EMD Refund/Forfeit Concurrent Program
SHORT CODE: EMD_REFUND_FORFEIT_CONC
MODULE: Oracle Sourcing

Description: EMD Refund/Forfeit Concurrent Program
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 : Api Version
  • p_emd_trx_group_id : Emd Transaction Group Id
  • p_auction_header_id : Auction Header Id
  • p_emd_trx_type : EMD Transaction Type (REFUND/FORFEIT)

 

No Comments »

by oracleguru

Sourcing Tables

ORACLE APPS COMMUNITY > Tutorial > Procurement > Oracle Sourcing

Oracle Sourcing Tables:

  • PON_ACCEPTANCES
  • PON_ACKNOWLEDGEMENTS
  • PON_ACTION_HISTORY
  • PON_APPLICATION_LOGO
  • PON_ATTACHMENTS_INTERFACE
  • PON_ATTRIBUTES_INTERFACE
  • PON_ATTRIBUTE_LISTS
  • PON_ATTRIBUTE_SCORES
  • PON_AUCTION_ATTRIBUTES
  • PON_AUCTION_CURRENCY_RATES
  • PON_AUCTION_EVENTS
  • PON_AUCTION_HEADERS_ALL
  • PON_AUCTION_ITEM_PRICES_ALL
  • PON_AUCTION_SECTIONS
  • PON_AUCTION_SHIPMENTS_ALL
  • PON_AUCTION_SUMMARY
  • PON_AUCTION_TEMPLATES
  • PON_AUC_ATTRIBUTES_INTERFACE
  • PON_AUC_BIZRULES
  • PON_AUC_BIZRULE_VALUES
  • PON_AUC_DOCTYPES
  • PON_AUC_DOCTYPES_TL
  • PON_AUC_DOCTYPE_RULES
  • PON_AUC_HEADERS_INTERFACE
  • PON_AUC_ITEMS_INTERFACE
  • PON_AUC_PAYMENTS_INTERFACE
  • PON_AUC_PAYMENTS_SHIPMENTS
  • PON_AUC_PRICE_DIFFER_INT
  • PON_AUC_PRICE_ELEMENTS_INT
  • PON_AUC_SHIPMENTS_INTERFACE
  • PON_AWARD_ALLOCATIONS
  • PON_AWARD_ITEMS_INTERFACE
  • PON_BACKING_REQUISITIONS
  • PON_BIDDERS_LISTS
  • PON_BIDDING_PARTIES
  • PON_BID_ATTRIBUTE_VALUES
  • PON_BID_ATTRIBUTE_VALUES_ARCH
  • PON_BID_ATTR_VALUES_INTERFACE
  • PON_BID_HEADERS
  • PON_BID_HEADERS_ARCH
  • PON_BID_ITEM_PRICES
  • PON_BID_ITEM_PRICES_ARCH
  • PON_BID_ITEM_PRICES_INTERFACE
  • PON_BID_PAYMENTS_INTERFACE
  • PON_BID_PAYMENTS_SHIPMENTS
  • PON_BID_PRICES_ARCH
  • PON_BID_PRICE_DIFFERENTIALS
  • PON_BID_PRICE_DIFFER_INT
  • PON_BID_PRICE_ELEMENTS
  • PON_BID_PRICE_ELEMENTS_INT
  • PON_BID_REBATES
  • PON_BID_SHIPMENTS
  • PON_BUNDLES
  • PON_BUNDLE_FILES
  • PON_CACHE_UPDATES
  • PON_COLORS
  • PON_CONTRACTS
  • PON_CONTRACTS_TL
  • PON_CUSTOM_BUNDLES
  • PON_CUSTOM_BUNDLE_FILES
  • PON_CUSTOM_IMAGES
  • PON_CUSTOM_LANGUAGES
  • PON_CUSTOM_MESSAGES
  • PON_DISCUSSIONS
  • PON_DOCTYPE_STYLES
  • PON_FIELDS
  • PON_FIELDS_TL
  • PON_FORMS_INSTANCES
  • PON_FORMS_SECTIONS
  • PON_FORMS_SECTIONS_TL
  • PON_FORM_FIELD_VALUES
  • PON_FORM_SECTION_COMPILED
  • PON_FORM_SECTION_FIELDS
  • PON_FPJ_DELETED_ATTRIBUTES
  • PON_FPK_DELETED_PRICE_ELEMENTS
  • PON_GLOBAL_BUTTON
  • PON_IMAGES
  • PON_INTERFACE_ERRORS
  • PON_ITEM_PRICES_INTERFACE
  • PON_LANGUAGE_SETTINGS
  • PON_LARGE_NEG_PF_VALUES
  • PON_NEGOTIATION_STYLES
  • PON_NEGOTIATION_STYLES_TL
  • PON_NEG_TEAM_MEMBERS
  • PON_NOTIF_GROUP_MEMBERS
  • PON_NOTIF_SUBSCRIPTION_GROUPS
  • PON_OFFER_COMMITMENTS
  • PON_OPTIMIZE_BID_CLASS
  • PON_OPTIMIZE_CONSTRAINTS
  • PON_OPTIMIZE_RESULTS
  • PON_OPTIMIZE_SCENARIOS
  • PON_PARTY_LINE_EXCLUSIONS
  • PON_PARTY_PREFERENCES
  • PON_PF_SUPPLIER_FORMULA
  • PON_PF_SUPPLIER_VALUES
  • PON_PRICE_DIFFERENTIALS
  • PON_PRICE_DIFFER_INTERFACE
  • PON_PRICE_ELEMENTS
  • PON_PRICE_ELEMENT_LISTS
  • PON_PRICE_ELEMENT_TYPES
  • PON_PRICE_ELEMENT_TYPES_TL
  • PON_SCORING_TEAMS
  • PON_SCORING_TEAM_MEMBERS
  • PON_SCORING_TEAM_SECTIONS
  • PON_SIDEBAR_ITEMS
  • PON_SUBTAB
  • PON_SUBTAB_PERM
  • PON_SUPPLIER_ACCESS
  • PON_SUPPLIER_ACTIVITIES
  • PON_SUPPLIER_PROVIDERS
  • PON_TAB_SETUP
  • PON_TEAM_MEMBER_ATTR_SCORES
  • PON_TEAM_MEMBER_BID_SCORES
  • PON_TE_RECIPIENTS
  • PON_TE_VIEW_AUDIT
  • PON_THREADS
  • PON_THREAD_ENTRIES
  • PON_WF_DEBUG

Tags: No Comments »