ERPDataAccessAssignmentExtract

A data access assignment represents data access assignments to a user in a given role.

Expand all

Collapse all

Business Views

** Available for extracting data

• dataAccessAssignmentExtract**

  A data access assignment represents data access assignments to a user in a given role.

  Label, Plural Label

  Data Access Assignment, Data Access Assignments

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • inherited
    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • inherited
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • inherited
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • inherited
    • not nullable
  • userGuid (string)

    Identifier for the user's entry in Oracle Identity Management.

    Label

    User GUID

    Properties

    • inherited
    • searchable
    • not nullable
  • userRoleDataAssignmentId (int64)

    Identifier for the user role data assignment.

    Label

    User Role Data Assignment ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • accessSet (DataAccessSet)

    A data access set secures access to the ledger data in General ledger. It contains the name of the data access set, description, chart of account, calendar, and period type information.

    Business Object

    DataAccessSet

    Expand all

    Collapse all

    Fields

    • accessSetId (int64)

      Unique identifier of the data access set.

      Label

      Access Set ID

      Properties

      • searchable
      • sortable
      • not nullable

  • book (AssetBook)

    A book represents the grouping in which fixed assets of the entity are recorded, tracked, depreciated, reported, and accounted for in the primary ledger.

    Business Object

    AssetBook

    Expand all

    Collapse all

    Fields

    • bookControlId (int64)

      The name of the asset book.

      Label

      Book ID

      Properties

      • searchable
      • sortable

  • businessUnit (BusinessUnit)

    A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • controlBudget (ControlBudget)

    A control budget contains structural information, such as the budget chart of accounts and budget calendar, and budgetary control validation options, such as whether a transaction with insufficient funds should be stopped or allowed to continue with or without warning and how much tolerance can be factored into the validation. Separate control budgets are used to record budget and consumption balances that are structured by different budget chart of accounts, budget calendar, or period range.

    Business Object

    ControlBudget

    Expand all

    Collapse all

    Fields

    • controlBudgetId (int64)

      The unique identifier of the control budget.

      Label

      Control Budget ID

      Properties

      • searchable
      • sortable
      • not nullable

  • costOrganization (CostOrganization)

    Details about the cost organization such as the cost organization ID, name, code, effective dates, status, and associated legal entity ID.

    Business Object

    CostOrganization

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of the organization.

      Label

      Organization ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • intercompanyOrganization (IntercompanyOrganization)

    An intercompany organization contains details about the providers and receivers of intercompany transactions, including the associated legal entity and business unit for each organization. These organizations serve as both the initiator and the recipient of intercompany transactions.

    Business Object

    IntercompanyOrganization

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for intercompany organization.

      Label

      Intercompany Organization ID

      Properties

      • searchable
      • sortable
      • not nullable

  • inventoryOrganization (OrganizationConfiguration)

    The organization configuration defines the high-level input values for a facility, such as a location, time zone, management business unit, and primary ledger. The configuration also specifies the use of the facility in SCM applications, such as indicating if it's used for manufacturing or integrated to other Oracle Fusion Cloud products. The configuration also specifies default values used in Oracle Fusion Cloud Inventory Management and Oracle Product Hub. For example, whether the warehouse accepts substitute items or supports inventory tracking by financial projects.

    Business Object

    OrganizationConfiguration

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely identifies the item or inventory organization. It's a primary key that the application generates when it creates an item or inventory organization.

      Label

      ID

      Properties

      • searchable
      • not nullable

  • ledger (Ledger)

    A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

  • manufacturingOrganization (PlantConfiguration)

    The plant configuration defines the high-level inputs and defaults for the facility when it's used for manufacturing or maintenance. The configuration specifies many defaults for work definition setup and work execution. For example, the production calendar to use for the plant, and the default subinventory to use for completed products.

    Business Object

    PlantConfiguration

    Expand all

    Collapse all

    Fields

    • organizationId (int64)

      Value that uniquely identifies the item or inventory organization. It's a primary key that the application generates when it creates an item or inventory organization.

      Label

      Organization ID

      Properties

      • searchable
      • sortable
      • not nullable

  • set (SetIdSet)

    The set is a logical group used for partitioning and sharing reference data across transactional entities, depending on the business context. The common set indicates that data isn't partitioned and is globally shared.

    Business Object

    SetIdSet

    Expand all

    Collapse all

    Fields

    • setId (int64)

      The unique identifier of the set ID set.

      Label

      Set ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top