Results for “fnd_compiled_menu_functions”

2 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PON_BUYER_MANAGE_DELIV_V is an APPS-owned database view within the PON (Sourcing) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name, "Buyer Manage Delivery," indicates its purpose: to expose the set of bidding parties—identified by bid number and FND user—that a buyer is authorized to manage in the context of active or closed sourcing auctions. The view is classified as VALID in the ETRM metadata and is defined over ten referenced base objects spanning Sourcing, Oracle Application Object Library (FND), and Trading Community Architecture (HZ/TCA) schemas.

The view functions as a security and visibility filter. Rather than returning all bids, it restricts results to bids associated with the trading partner of an active or auction-closed negotiation, and refines this list according to the auction's bid visibility code (OPEN_BIDDING, SEALED_BIDDING, or SEALED_AUCTION) and its security level (PUBLIC by default). Where negotiation team membership applies, the view consults the FND menu and function compilation tables to determine which users hold the PON_AUC_VIEWNEG function, thereby distinguishing team members from non-members. This makes the view directly relevant to buyers and sourcing administrators who query which counterparties and internal users may participate in or view a negotiation's delivery and bid activity.

Underlying Base Objects

The view joins the following documented base objects (all exposed through APPS synonyms): PON_AUCTION_HEADERS_ALL (AH), PON_BID_HEADERS (BH), FND_USER, HZ_PARTIES (twice, aliased as USER_PARTIES and COMPANY_PARTIES), HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS, PON_NEG_TEAM_MEMBERS, FND_MENUS, FND_FORM_FUNCTIONS, and FND_COMPILED_MENU_FUNCTIONS.

  • PON_AUCTION_HEADERS_ALL / PON_BID_HEADERS supply the negotiation and bid header context, including auction status, bid status, trading partner, trading partner contact, visibility code, sealed auction status, and security level code.
  • FND_USER links the person party of the user to their party record and provides USER_ID for the result set.
  • HZ_PARTIES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS establish the employment relationship (POS_EMPLOYMENT / EMPLOYEE_OF) between a user and an enterprise party, validated against the current date range and the POS_PARTICIPANT_TYPE classification of ENTERPRISE.
  • PON_NEG_TEAM_MEMBERS identifies users assigned to a negotiation team via MENU_NAME and AUCTION_HEADER_ID.
  • FND_MENUS, FND_FORM_FUNCTIONS, FND_COMPILED_MENU_FUNCTIONS resolve whether a team member's menu includes the PON_AUC_VIEWNEG function. FND_COMPILED_MENU_FUNCTIONS is the flattened, compiled bridge between a menu and its functions, and is the object most directly tied to the user's search term.

Key Columns

  • BID_NUMBER — the public identifier of the bid header (BH.BID_NUMBER), used to reference a specific bid in reporting and UI lookups.
  • USER_ID — the FND_USER primary key identifying the user authorized under the view's visibility and security predicates.

The view's output is intentionally narrow: two columns supporting the buyer-facing delivery management screen and its authorization logic.

Common Use Cases and Queries

Typical uses include validating which users appear as authorized buyers or viewers for active negotiations, auditing sealed auction visibility, and troubleshooting why a user does or does not see a bid in the Sourcing UI. Because the team-membership logic depends on compiled menu functions, defects in menu compilation frequently manifest as user-visibility anomalies.

Sample query:

  • SELECT BID_NUMBER, USER_ID FROM APPS.PON_BUYER_MANAGE_DELIV_V ORDER BY BID_NUMBER, USER_ID;
  • SELECT BID_NUMBER, COUNT(*) FROM APPS.PON_BUYER_MANAGE_DELIV_V GROUP BY BID_NUMBER;

For diagnosis, the view can be joined to FND_USER on USER_ID to resolve user names, and its compiled-menu logic inspected against FND_COMPILED_MENU_FUNCTIONS to confirm that the PON_AUC_VIEWNEG function is correctly compiled for the relevant menus.