7Business Object Services

Account Combination Validation Service

Service to validate and create account combinations. Account combinations are used across Oracle Fusion Applications to record accounting information.

Life Cycle Status: Active

QName: {http://xmlns.oracle.com/apps/financials/generalLedger/accounts/codeCombinations/accountCombinationService/}AccountCombinationService

Service WSDL URL: https://servername/fscmService/AccountCombinationService?WSDL

Logical Business Objects

  • Financials : General Ledger : General Ledger Account

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Handles

Service Output

Handles

Service Input Parameters

Operations

validateAndCreateAccounts

Validates account combinations based on the ledger setup in Oracle Fusion Financials.

Life Cycle Status: Active

Request Payload

Element Name Type Description

validationInputRowList

Account Combinations for Validation

The account combinations that should be validated for use in a ledger.

Response Payload

Element Name Type Description

result

Validated Account Combinations

The validation status of each submitted account combination.

Security

The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

Service Operations to Privileges Mapping

Operation Name Privilege Code Privilege Name Privilege Description

All Operations

GL_MANAGE_GENERAL_LEDGER_ACCOUNT_COMBINATIONS_PRIV

Manage Oracle Fusion General Ledger Account Combinations

Allows management of the account combinations.

Privileges to Duty Roles Mapping

Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

GL_MANAGE_GENERAL_LEDGER_ACCOUNT_COMBINATIONS_PRIV

ORA_FUN_ENTERPRISE_STRUCTURES_ADMINISTRATION_DUTY

Enterprise Structures Administration

Administer all enterprise structure related setup objects including charts of accounts, calendars, currencies, ledgers, legal entities, legal jurisdictions and business units.

Duty Roles to Duty or Job Roles Mapping

Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

ORA_FUN_ENTERPRISE_STRUCTURES_ADMINISTRATION_DUTY

ORA_XLA_ACCOUNTING_HUB_ADMINISTRATION_DUTY

Accounting Hub Administration

Configures the accounting hub for a source system.

ORA_FUN_ENTERPRISE_STRUCTURES_ADMINISTRATION_DUTY

ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

Customer Account Inquiry

View customer account details.

ORA_FUN_ENTERPRISE_STRUCTURES_ADMINISTRATION_DUTY

ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

FSCM Load Interface Administration

Manages load interface file for import

ORA_FUN_ENTERPRISE_STRUCTURES_ADMINISTRATION_DUTY

ORA_FA_FIXED_ASSET_INQUIRY_DUTY

Fixed Asset Inquiry

Views asset information, transaction details, and accounting entries.

ORA_FUN_ENTERPRISE_STRUCTURES_ADMINISTRATION_DUTY

ORA_XLE_LEGAL_ENTITIES_ADMIN_DUTY

Legal Entities Administration

Manages legal entities, legal reporting units and registrations.

    Account Combinations for Validation

    Account combinations submitted for validation.

    QName: {http://xmlns.oracle.com/apps/financials/generalLedger/accounts/codeCombinations/accountCombinationService/}AccountValidationInput

    Relationships

    The following table describes how this service data object is related to other service data objects or business object services.

    Relationship Type Object or Service

    Handled by

    Account Combination Validation Service

    Attributes

    The following table describes attributes in the service data object.

    Name Type Description

    DynamicInsertion

    string

    The indicator for whether the account combination should be created. If the value is Yes, then the account combination is created after successful validation.

    EnabledFlag

    boolean

    Used to set the enabled flag for the combination. If enabled flag for the existing combination is "Y" and the input eneabled flag is false, update it in the combination as "N".

    FromDate

    {http://xmlns.oracle.com/adf/svc/types/}date-Date

    Used to store the start date of the account combination.

    LedgerName

    string

    The ledger whose setup is used to validate the submitted account combination.
    • Primary Key

    Segment1

    string

    Segment value 1 of the account combination.

    Segment10

    string

    Segment value 10 of the account combination.

    Segment11

    string

    Segment value 11 of the account combination.

    Segment12

    string

    Segment value 12 of the account combination.

    Segment13

    string

    Segment value 13 of the account combination.

    Segment14

    string

    Segment value 14 of the account combination.

    Segment15

    string

    Segment value 15 of the account combination.

    Segment16

    string

    Segment value 16 of the account combination.

    Segment17

    string

    Segment value 17 of the account combination.

    Segment18

    string

    Segment value 18 of the account combination.

    Segment19

    string

    Segment value 19 of the account combination.

    Segment2

    string

    Segment value 2 of the account combination.

    Segment20

    string

    Segment value 20 of the account combination.

    Segment21

    string

    Segment value 21 of the account combination.

    Segment22

    string

    Segment value 22 of the account combination.

    Segment23

    string

    Segment value 23 of the account combination.

    Segment24

    string

    Segment value 24 of the account combination.

    Segment25

    string

    Segment value 25 of the account combination.

    Segment26

    string

    Segment value 26 of the account combination.

    Segment27

    string

    Segment value 27 of the account combination.

    Segment28

    string

    Segment value 28 of the account combination.

    Segment29

    string

    Segment value 29 of the account combination.

    Segment3

    string

    Segment value 3 of the account combination.

    Segment30

    string

    Segment value 30 of the account combination.

    Segment4

    string

    Segment value 4 of the account combination.

    Segment5

    string

    Segment value 5 of the account combination.

    Segment6

    string

    Segment value 6 of the account combination.

    Segment7

    string

    Segment value 7 of the account combination.

    Segment8

    string

    Segment value 8 of the account combination.

    Segment9

    string

    Segment value 9 of the account combination.

    ToDate

    {http://xmlns.oracle.com/adf/svc/types/}date-Date

    Used to store the end date of the account combination.

      Validated Account Combinations

      Returns the validation status of the submitted account combinations and the code combination identifier if the account combination is valid.

      QName: {http://xmlns.oracle.com/apps/financials/generalLedger/accounts/codeCombinations/accountCombinationService/}AccountValidationOutput

      Relationships

      The following table describes how this service data object is related to other service data objects or business object services.

      Relationship Type Object or Service

      Handled by

      Account Combination Validation Service

      Attributes

      The following table describes attributes in the service data object.

      Name Type Description

      CcId

      long

      The unique identifier for the account combination.
      • Primary Key

      EnabledFlag

      boolean

      Enabled Flag for the combination.

      Error

      string

      error occurring during the creation process returs error on this tag.

      ErrorCode

      string

      error code for the returned error on this tag.

      FromDate

      {http://xmlns.oracle.com/adf/svc/types/}date-Date

      Used to store the start date of the account combination.

      LedgerName

      string

      The ledger whose setup is used to validate the submitted account combination.
      • Primary Key

      Segment1

      string

      Segment value 1 of the account combination.

      Segment10

      string

      Segment value 10 of the account combination.

      Segment11

      string

      Segment value 11 of the account combination.

      Segment12

      string

      Segment value 12 of the account combination.

      Segment13

      string

      Segment value 13 of the account combination.

      Segment14

      string

      Segment value 14 of the account combination.

      Segment15

      string

      Segment value 15 of the account combination.

      Segment16

      string

      Segment value 16 of the account combination.

      Segment17

      string

      Segment value 17 of the account combination.

      Segment18

      string

      Segment value 18 of the account combination.

      Segment19

      string

      Segment value 19 of the account combination.

      Segment2

      string

      Segment value 2 of the account combination.

      Segment20

      string

      Segment value 20 of the account combination.

      Segment21

      string

      Segment value 21 of the account combination.

      Segment22

      string

      Segment value 22 of the account combination.

      Segment23

      string

      Segment value 23 of the account combination.

      Segment24

      string

      Segment value 24 of the account combination.

      Segment25

      string

      Segment value 25 of the account combination.

      Segment26

      string

      Segment value 26 of the account combination.

      Segment27

      string

      Segment value 27 of the account combination.

      Segment28

      string

      Segment value 28 of the account combination.

      Segment29

      string

      Segment value 29 of the account combination.

      Segment3

      string

      Segment value 3 of the account combination.

      Segment30

      string

      Segment value 30 of the account combination.

      Segment4

      string

      Segment value 4 of the account combination.

      Segment5

      string

      Segment value 5 of the account combination.

      Segment6

      string

      Segment value 6 of the account combination.

      Segment7

      string

      Segment value 7 of the account combination.

      Segment8

      string

      Segment value 8 of the account combination.

      Segment9

      string

      Segment value 9 of the account combination.

      Status

      string

      The validation status of the account combination that was formed using the submitted segment values.

      ToDate

      {http://xmlns.oracle.com/adf/svc/types/}date-Date

      Used to store the end date of the account combination.

        Cash Position Service

        The cash positioning service is used by Smart View to create ad hoc transaction types in the cash position cube from cash positioning Smart View reports.

        Life Cycle Status: Active

        QName: {http://xmlns.oracle.com/apps/financials/cashManagement/cashPosition/inquiry/cashPositionService/}CashPositionService

        Service WSDL URL: https://servername/fscmService/CashPositionService?WSDL

        Logical Business Objects

        • Financials : Cash Management : Cash Positioning and Forecasting Source Transaction

        Operations

        createManualDimMember

        The service method used to create manual or ad hoc transaction type in the cash position cube.

        Life Cycle Status: Active

        Request Payload

        Element Name Type Description

        dimMemberName

        string

        Transaction type dimension member name parameter that holds the value of new ad hoc transaction type to be created.

        Response Payload

        Element Name Type Description

        result

        string

        The return value of the service method that creates the manual or ad hoc transaction type in the cube. Valid values include Success for successful execution or Error on a failed execution.

        getDfltObjAttrHints

        The service method that returns the UI hints for a given service data object and its attributes.

        Life Cycle Status: Active

        Request Payload

        Element Name Type Description

        viewName

        string

        The view name parameter of the service method.

        localeName

        string

        The locale name parameter of the service method.

        Response Payload

        Element Name Type Description

        result

        {http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

        The list of service data object attribute hints returned by the method.

        getServiceLastUpdateTime

        The service method that returns the last date and time when the service was updated.

        Life Cycle Status: Active

        Request Payload

        Response Payload

        Element Name Type Description

        result

        {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

        The last updated time stamp of the service.

        getEntityList

        The service method that returns a list of service data objects defined on the service interface.

        Life Cycle Status: Active

        Request Payload

        Response Payload

        Element Name Type Description

        result

        {http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

        The list of service data objects defined on the service.

        Security

        The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

        Service Operations to Privileges Mapping

        Operation Name Privilege Code Privilege Name Privilege Description

        All Operations

        ORA_CE_MANAGE_CASH_POSITIONING_AND_FORECASTING_TRANSACTIONS_PRIV

        Manage Cash Positioning and Forecasting Transactions

        Privileges to Duty Roles Mapping

        Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

        ORA_CE_MANAGE_CASH_POSITIONING_AND_FORECASTING_TRANSACTIONS_PRIV

        ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

        Cash Positioning and Forecasting Management

        Manages cash positioning and forecasting

        Duty Roles to Duty or Job Roles Mapping

        Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

        ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

        ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

        Customer Account Inquiry

        View customer account details.

        ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

        ORA_IBY_DISBURSEMENT_DATA_MANAGEMENT_DUTY

        Disbursement Data Management

        Manages supplier payments, customer refunds, and employee expense payments.

        ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

        ORA_IBY_DISBURSEMENT_PROCESS_MANAGEMENT_DUTY

        Disbursement Process Management

        Assigns payment process attributes to documents payable, resolves document and payment validation errors, and reviews proposed payments. Views items that were rejected or removed from a payment process request.

        ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

        ORA_XLA_SUBLEDGER_ACCOUNTING_MANAGER_DUTY

        Subledger Accounting Manager

        Creates accounting for transactions, reviews journal entries, and runs account analysis, journal entries, and period close exceptions reports.

        ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

        ORA_XLA_SUBLEDGER_ACCOUNTING_REPORTING_DUTY

        Subledger Accounting Reporting

        Runs all subledger accounting reports, and reviews journal entries.

        Collections Delinquency(Deprecated)

        An indicator that identifies delinquent customers based on open transactions.

        Life Cycle Status: Deprecated

        QName: {http://xmlns.oracle.com/apps/financials/collections/delinquency/delinquencyService/}DelinquencyService

        Service WSDL URL: https://servername/fscmService/DelinquencyService?WSDL

        Operations

        CreateDelinquentObject

        Create operation for Delinquent SDO.

        Life Cycle Status: Active

        Request Payload

        Element Name Type Description

        paymentScheduleId

        long

        Created Delinquent Payment Schedule SDO.

        Response Payload

        Element Name Type Description

        result

        string

        Created Delinquent SDO.

        Security

        The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

        Service Operations to Privileges Mapping

        Operation Name Privilege Code Privilege Name Privilege Description

        All Operations

        IEX_DETERMINE_COLLECTIONS_DELINQUENCY_PRIV

        Determine Collections Delinquency

        Allows a user to run the delinquency management batch program.

        Privileges to Duty Roles Mapping

        Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

        IEX_DETERMINE_COLLECTIONS_DELINQUENCY_PRIV

        ORA_IEX_COLLECTIONS_ADMINISTRATION_DUTY

        Collections Administration

        Maintains Collection setups.

        Create Intercompany Transaction

        The transactions that are entered by an intercompany accountant to record transactions within or across legal entities. For example, Legal Entity Vision USA is required to bill Legal Entity Vision UK for some equipment it ordered on behalf of Vision UK. Another example would be if the training department in Vision USA needs to charge the consulting department for training it imparted to the consultants.

        Life Cycle Status: Active

        QName: {http://xmlns.oracle.com/apps/financials/commonModules/intercompanyTransactions/intercompanyTransactionImportService/}IntercompanyTransactionImportService

        Service WSDL URL: https://servername/fscmService/IntercompanyTransactionImportService?WSDL

        Relationships

        The following table describes how this service data object is related to other service data objects or business object services.

        Operations

        importTransactions

        Creates intercompany transactions from data in the intercompany interface tables.

        Life Cycle Status: Active

        Request Payload

        Element Name Type Description

        transactionImportSource

        Intercompany Transaction

        The sources of the intercompany transactions that are to be imported.

        Response Payload

        Element Name Type Description

        result

        long

        This service operation returns the interface run identifier, which is used to identify transactions in the intercompany interface tables.

        getDfltObjAttrHints

        An operation to retrieve user interface hints, such as the service data object label and object attribute labels, for the specified service data object and locale. As a prerequisite, invoke the getEntityList operation defined on this service to get the list of possible values for the viewName request payload element.

        Life Cycle Status: Active

        Request Payload

        Element Name Type Description

        viewName

        string

        The service view usage name, an internal name for the service data object. Specify the value of the element from the getEntityList operation response payload.

        localeName

        string

        Gets the locale to use. The local name is in the ISO 639-1 format.

        Response Payload

        Element Name Type Description

        result

        {http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

        The label and user interface hints at the specified service data object and its attributes in a name-value pair format.

        getServiceLastUpdateTime

        Returns the date and time when the schema files referenced in the service were last changed.

        Life Cycle Status: Active

        Request Payload

        Response Payload

        Element Name Type Description

        result

        {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

        The date and time when the service last changed. This is in the ISO 8601 format.

        getEntityList

        Gets the list of data objects defined in this service.

        Life Cycle Status: Active

        Request Payload

        Response Payload

        Element Name Type Description

        result

        {http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

        Gets a list of data objects for the service including the name, internal name and Boolean values indicating whether create, update, merge and delete operations can be performed on the object.

        Security

        The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

        Service Operations to Privileges Mapping

        Operation Name Privilege Code Privilege Name Privilege Description

        All Operations

        FUN_IMPORT_INTERCOMPANY_TRANSACTION_PRIV

        Import Intercompany Transaction

        Allows submission of Import Intercompany Transactions process.

        Privileges to Duty Roles Mapping

        Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

        FUN_IMPORT_INTERCOMPANY_TRANSACTION_PRIV

        ORA_FUN_INTERCO_TRANSACTION_ENTRY_DUTY

        Intercompany Transactions Entry

        Create, update, approve, reject intercompany transactions and batches.

        Duty Roles to Duty or Job Roles Mapping

        Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

        ORA_FUN_INTERCO_TRANSACTION_ENTRY_DUTY

        ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

        Customer Account Inquiry

        View customer account details.

        ORA_FUN_INTERCO_TRANSACTION_ENTRY_DUTY

        ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

        FSCM Load Interface Administration

        Manages load interface file for import

        ORA_FUN_INTERCO_TRANSACTION_ENTRY_DUTY

        ORA_GL_GENERAL_ACCOUNTING_SETUP_REVIEW_DUTY

        General Accounting Setup Review

        Views set up for accounting and transaction calendars, Oracle Fusion General Ledger accounting period status, conversion rates and chart of accounts mapping rules.

        ORA_FUN_INTERCO_TRANSACTION_ENTRY_DUTY

        ORA_GL_GENERAL_LEDGER_REPORTING_DUTY

        General Ledger Reporting

        Provides access to all balances and transaction inquiry and reporting privileges for General Ledger.

        ORA_FUN_INTERCO_TRANSACTION_ENTRY_DUTY

        ORA_GL_JOURNAL_ENTRY_DUTY

        Journal Management

        Creates journal entries and allocations.

        ORA_FUN_INTERCO_TRANSACTION_ENTRY_DUTY

        ORA_AP_PAYABLES_INVOICE_INQUIRY_DUTY

        Payables Invoice Inquiry

        Views Oracle Fusion Payables invoices.

        ORA_FUN_INTERCO_TRANSACTION_ENTRY_DUTY

        ORA_XLA_SUBLEDGER_ACCOUNTING_REPORTING_DUTY

        Subledger Accounting Reporting

        Runs all subledger accounting reports, and reviews journal entries.

          Intercompany Transaction Batch Distribution Interface

          The intercompany batch distribution data to insert into the batch distribution interface table.

          QName: {http://xmlns.oracle.com/apps/financials/commonModules/intercompanyTransactions/intercompanyTransactionImportService/}BatchDistributionInterface

          Relationships

          The following table describes how this service data object is related to other service data objects or business object services.

          Relationship Type Object or Service

          Contained by

          Intercompany Transaction Batch Interface

          Handled by

          Create Intercompany Transaction

          Attributes

          The following table describes attributes in the service data object.

          Name Type Description

          Attribute1

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute10

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute11

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute12

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute13

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute14

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute15

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute2

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute3

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute4

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute5

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute6

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute7

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute8

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          Attribute9

          string

          Descriptive Flexfield: a segment of the user descriptive flexfield.

          AttributeCategory

          string

          Descriptive Flexfield: the definition of the structure of the user descriptive flexfield.

          BatchDistId

          long

          The unique identifier of the percentage rule applied to the transaction to generate the provider distribution amounts and accounts. For example, account 01-000-40110-00 is allocated 20 percent of the transaction amount and account 02-110-52330-00 is allocated 80 percent.
          • Primary Key

          BatchId

          long

          The unique identifier of a record that groups intercompany transactions into a batch.

          Ccid

          long

          The provider account combination.

          ImportStatusCode

          string

          The status of the process for importing and creating intercompany transactions.

          LineNumber

          long

          The line number of the percentage rule applied to a transaction. For example, line number 1 is for account 01-000-40110-00 allocated 20 percent of the transaction amount and line number 2 is for account 02-110-52330-00 allocated 80 percent.

          ObjectVersionNumber

          int

          Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

          Percentage

          decimal

          The percentages to be applied to the intercompany transaction amount to derive the provider distributions.

            Intercompany Transaction Batch Interface

            The intercompany batch data to insert into the batch interface table.

            QName: {http://xmlns.oracle.com/apps/financials/commonModules/intercompanyTransactions/intercompanyTransactionImportService/}TransactionBatchInterface

            Relationships

            The following table describes how this service data object is related to other service data objects or business object services.

            Attributes

            The following table describes attributes in the service data object.

            Name Type Description

            Attribute1

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute10

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute11

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute12

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute13

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute14

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute15

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute2

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute3

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute4

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute5

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute6

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute7

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute8

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            Attribute9

            string

            Descriptive Flexfield: a segment of the user descriptive flexfield.

            AttributeCategory

            string

            Descriptive Flexfield: the definition of the structure of the user descriptive flexfield.

            BatchDate

            {http://xmlns.oracle.com/adf/svc/types/}date-Date

            The batch date of the intercompany interface batch.

            BatchDistributionInterface3

            Intercompany Transaction Batch Distribution Interface

            The intercompany batch distribution data to insert into the batch distribution interface table.

            BatchId

            long

            The unique identifier of a record that groups intercompany transactions into a batch.
            • Primary Key

            BatchNumber

            string

            The identifier of the intercompany batch. The setting on the systems options setup determines if the batch number is automatically generated by the system or manually entered.

            ControlTotal

            decimal

            The control total amount of the intercompany interface batch.

            CurrencyCode

            string

            The currency of the intercompany batch.

            Description

            string

            The description of the intercompany batch.

            ExchangeRateType

            string

            The conversion rate type of the intercompany interface batch.

            FromLeId

            long

            The unique identifier of the legal entity associated with the provider organization of the intercompany batch.

            FromLeName

            string

            The name of the legal entity associated with the provider organization of the intercompany batch.

            FromLedgerId

            long

            The unique identifier of the ledger associated with the legal entity for the provider organization of the intercompany batch.

            FromRecurringBatchId

            long

            The recurring batch identifier.

            GlDate

            {http://xmlns.oracle.com/adf/svc/types/}date-Date

            The accounting date of the intercompany interface batch.

            GroupId

            long

            The group identifier of the intercompany interface batch.

            ImportStatusCode

            string

            The status of the process for importing and creating intercompany transactions.

            InitiatorId

            long

            The unique identifier of the provider organization of the intercompany batch.

            InitiatorName

            string

            The name of the provider organization of the intercompany batch.

            Note

            string

            The note attached to the intercompany interface batch.

            ObjectVersionNumber

            int

            Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

            RejectAllowedFlag

            boolean

            The indicator to specify if receivers are allowed to reject a transaction. Valid values are Y and N.

            RunningTotalCr

            decimal

            The running total credit of the intercompany interface batch.

            RunningTotalDr

            decimal

            The running total credit of the intercompany interface batch.

            Source

            string

            The source of the transaction.

            TransactionHeaderInterface1

            Intercompany Transaction Header Interface

            The intercompany transaction data to insert into the transaction interface table.

            TrxTypeCode

            string

            The transaction type code of the intercompany interface batch.

            TrxTypeId

            long

            The transaction type identifier of the intercompany interface batch.

            TrxTypeName

            string

            The transaction type name of the intercompany interface batch.

              Intercompany Transaction Distribution Line Interface

              The intercompany transaction distribution data to insert into the transaction distribution interface table.

              QName: {http://xmlns.oracle.com/apps/financials/commonModules/intercompanyTransactions/intercompanyTransactionImportService/}DistributionLineInterface

              Relationships

              The following table describes how this service data object is related to other service data objects or business object services.

              Relationship Type Object or Service

              Contained by

              Intercompany Transaction Header Interface

              Handled by

              Create Intercompany Transaction

              Attributes

              The following table describes attributes in the service data object.

              Name Type Description

              AmountCr

              decimal

              The provider credit distribution amount.

              AmountDr

              decimal

              The provider debit distribution amount.

              Attribute1

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute10

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute11

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute12

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute13

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute14

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute15

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute2

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute3

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute4

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute5

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute6

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute7

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute8

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              Attribute9

              string

              Descriptive Flexfield: a segment of the user descriptive flexfield.

              AttributeCategory

              string

              Descriptive Flexfield: the definition of the structure of the user descriptive flexfield.

              BatchDistId

              long

              The unique identifier of the percentage rule applied to the transaction to generate the provider distribution amounts and accounts. For example, account 01-000-40110-00 is allocated 20 percent of the transaction amount and account 02-110-52330-00 is allocated 80 percent.

              Ccid

              long

              The distribution account, such as the income account or the expense account.

              Description

              string

              The additional information about the distribution line, such as the description of the income or expense.

              DistId

              long

              The unique identifier of the distribution line for an intercompany transaction.
              • Primary Key

              DistNumber

              long

              The line number of the distribution for an intercompany transaction.

              DistributionType

              string

              The distribution type indicator is used in conjunction with the party type indicator to identify the line. Valid values for party type I are L for provider distribution line and R for provider intercompany receivables account line. Valid values for party type R are L for receiver distribution line and P for receiver intercompany payables account line.

              ImportStatusCode

              string

              The status of the process for importing and creating intercompany transactions.

              ObjectVersionNumber

              int

              Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

              PartyId

              decimal

              The unique party identifier for the intercompany organization.

              PartyType

              string

              The party type attribute indicates if the intercompany organization is a Provider or Receiver for the intercompany transaction. Valid values are I for Provider and R for Receiver.

              TrxId

              long

              The unique identifier of an intercompany transaction between a provider organization and a receiver organization.

                Intercompany Transaction Header Interface

                The intercompany transaction data to insert into the transaction interface table.

                QName: {http://xmlns.oracle.com/apps/financials/commonModules/intercompanyTransactions/intercompanyTransactionImportService/}TransactionHeaderInterface

                Relationships

                The following table describes how this service data object is related to other service data objects or business object services.

                Attributes

                The following table describes attributes in the service data object.

                Name Type Description

                Attribute1

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute10

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute11

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute12

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute13

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute14

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute15

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute2

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute3

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute4

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute5

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute6

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute7

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute8

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                Attribute9

                string

                Descriptive Flexfield: a segment of the user descriptive flexfield.

                AttributeCategory

                string

                Descriptive Flexfield: the definition of the structure of the user descriptive flexfield.

                BatchId

                long

                The unique identifier of a record that groups intercompany transactions into a batch.

                Description

                string

                The description of the transaction.

                DistributionLineInterface2

                Intercompany Transaction Distribution Line Interface

                The intercompany distribution data to insert into the distribution interface table.

                FromRecurringTrxId

                long

                The recurring transaction identifier.

                ImportStatusCode

                string

                The status of the process for importing and creating intercompany transactions.

                InitAmountCr

                decimal

                The intercompany transaction credit amount.

                InitAmountDr

                decimal

                The intercompany transaction debit amount.

                InitiatorInstanceFlag

                boolean

                The intercompany provider remote instance indicator.

                InvoicingRuleFlag

                boolean

                Indicates if a receivables invoice is created for the intercompany transaction.

                ObjectVersionNumber

                int

                Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

                RecipientId

                long

                The intercompany receiver organization identifier.

                RecipientInstanceFlag

                boolean

                The intercompany receiver remote instance indicator.

                RecipientName

                string

                The intercompany receiver organization name.

                ToLeId

                long

                The intercompany receiver ledger identifier.

                ToLeName

                string

                The intercompany receiver legal entity name.

                ToLedgerId

                long

                The intercompany receiver ledger identifier.

                TrxId

                long

                The unique identifier of an intercompany transaction between a provider organization and a receiver organization.
                • Primary Key

                TrxNumber

                string

                The number of an intercompany transaction between a provider organization and a receiver organization.

                  Intercompany Transaction

                  Details of the specifics of intercompany transactions that are to be imported. For example the source, whether imported transactions should be submitted and if the output report should only print rejected transactions.

                  QName: {http://xmlns.oracle.com/apps/financials/commonModules/intercompanyTransactions/intercompanyTransactionImportService/}TransactionImportSource

                  Relationships

                  The following table describes how this service data object is related to other service data objects or business object services.

                  Relationship Type Object or Service

                  Contains

                  Intercompany Transaction Batch Interface

                  Handled by

                  Create Intercompany Transaction

                  Attributes

                  The following table describes attributes in the service data object.

                  Name Type Description

                  PrintOnlyRejections

                  string

                  The indicator to specify if only rejected transactions should be printed on the output report.

                  Source

                  string

                  The source of the transaction.
                  • Primary Key

                  SubmitTransactionsOnImport

                  string

                  The indicator for whether the transactions should be submitted after they have been imported.

                  TransactionBatchInterface4

                  Intercompany Transaction Batch Interface

                  The intercompany batch data to insert into the batch interface table.

                    Credit Card

                    A payment instrument such as a credit card or debit card owned by a third party payer, typically a customer.

                    Life Cycle Status: Active

                    QName: {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/creditCardService/}CreditCardService

                    Service WSDL URL: https://servername/fscmService/CreditCardService?WSDL

                    Relationships

                    The following table describes how this service data object is related to other service data objects or business object services.

                    Relationship Type Object or Service

                    Handles

                    Credit Card SDO

                    Handles

                    Credit Card Attributes SDO

                    Operations

                    cardExist

                    Verifies whether a payment card is already registered in Fusion Payments.

                    Life Cycle Status: Active

                    Request Payload

                    Element Name Type Description

                    ccNumber

                    string

                    The credit card number. It must be numeric.

                    cardOwnerId

                    long

                    Party identifier for the owner of the payment card.

                    Response Payload

                    Element Name Type Description

                    result

                    {http://xmlns.oracle.com/adf/svc/types/}LongResult

                    Result of the operation including the card identifier.

                    getPaymentCardDetails

                    Get operation for credit card.

                    Life Cycle Status: Active

                    Request Payload

                    Element Name Type Description

                    instrid

                    long

                    Payment instrument identifier.

                    partyId

                    long

                    Party identifier for the owner of the payment card.

                    Response Payload

                    Element Name Type Description

                    result

                    {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/creditCardService/}CreditCardResult

                    Credit card identifier that matches the inbound key attributes.

                    processPaymentCard

                    Create or update operation for credit card. It will perform an update if the object exists, or an insert if the object does not exist.

                    Life Cycle Status: Active

                    Request Payload

                    Element Name Type Description

                    creditCard

                    Credit Card

                    Credit card to be created or updated.

                    Response Payload

                    Element Name Type Description

                    result

                    Credit Card

                    Result of the operation including the successfully created or updated Credit card and/or a list of warnings or informational messages.

                    findPaymentCard

                    Find operation for credit card.

                    Life Cycle Status: Active

                    Request Payload

                    Element Name Type Description

                    findCriteria

                    {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                    The criteria used to limit a query result, such as the filter (where clause) or the fetch size.

                    findControl

                    {http://xmlns.oracle.com/adf/svc/types/}FindControl

                    Find Control. Not currently used.

                    Response Payload

                    Element Name Type Description

                    result

                    Credit Card

                    Result of the operation including a list of credit cards that satisfy the inbound criteria and any warnings or informational messages encountered during the invocation.

                    getDfltObjAttrHints

                    Get default object attribute hints.

                    Life Cycle Status: Active

                    Request Payload

                    Element Name Type Description

                    viewName

                    string

                    View name.

                    localeName

                    string

                    Locale name.

                    Response Payload

                    Element Name Type Description

                    result

                    {http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

                    Return value.

                    getServiceLastUpdateTime

                    Get service last update time.

                    Life Cycle Status: Active

                    Request Payload

                    Response Payload

                    Element Name Type Description

                    result

                    {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                    Return value.

                    getEntityList

                    Get entity list.

                    Life Cycle Status: Active

                    Request Payload

                    Response Payload

                    Element Name Type Description

                    result

                    {http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

                    Return value.

                    Security

                    The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

                    Service Operations to Privileges Mapping

                    Operation Name Privilege Code Privilege Name Privilege Description

                    All Operations

                    IBY_MANAGE_PAYMENT_CARD_PRIV

                    Manage Payment Card

                    Allows management of payment cards.

                    cardExist

                    IBY_VIEW_PAYMENT_CARD_PRIV

                    View Payment Card

                    Allows viewing of payment cards.

                    getPaymentCardDetails

                    IBY_VIEW_PAYMENT_CARD_PRIV

                    View Payment Card

                    Allows viewing of payment cards.

                    findPaymentCard

                    IBY_VIEW_PAYMENT_CARD_PRIV

                    View Payment Card

                    Allows viewing of payment cards.

                    Privileges to Duty Roles Mapping

                    Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

                    IBY_MANAGE_PAYMENT_CARD_PRIV

                    ORA_FOM_ORDER_ENTRY_SPECIALIST_JOB

                    Order Entry Specialist

                    Individual who is responsible for creating new orders, updating existing orders, and creating order returns.

                    IBY_MANAGE_PAYMENT_CARD_PRIV

                    ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY

                    Customer Payment Instrument Management

                    Manages customer bank accounts and credit cards and other payment details.

                    IBY_VIEW_PAYMENT_CARD_PRIV

                    ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY

                    Customer Payment Instrument Management

                    Manages customer bank accounts and credit cards and other payment details.

                    Duty Roles to Duty or Job Roles Mapping

                    Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

                    ORA_FOM_ORDER_ENTRY_SPECIALIST_JOB

                    ORA_CMK_B2B_MESG_ADMIN_DUTY

                    B2B Messaging Administration

                    Manages collaboration messaging setup and administration tasks.

                    ORA_FOM_ORDER_ENTRY_SPECIALIST_JOB

                    ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

                    FSCM Load Interface Administration

                    Manages load interface file for import

                    ORA_FOM_ORDER_ENTRY_SPECIALIST_JOB

                    ORA_EGP_ITEM_INQUIRY_DUTY

                    Item Inquiry

                    Queries and views items in the enterprise.

                      Credit Card Attributes

                      Stores company-specific information that is captured for a credit card.

                      QName: {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/flex/creditCardDff/}CreditCard

                      Relationships

                      The following table describes how this service data object is related to other service data objects or business object services.

                      Relationship Type Object or Service

                      Contained by

                      Credit Card

                      Contained by

                      Credit Card

                      Handled by

                      Credit Card

                      Handled by

                      External Payer

                      Handled by

                      Credit Card

                      Attributes

                      The following table describes attributes in the service data object.

                      Name Type Description

                      Instrid

                      long

                      Identifier of the payment instrument.
                      • Primary Key

                      _FLEX_NumOfSegments

                      int

                      Total number of global segments and context-sensitive segments in the credit card flexfield.

                      __FLEX_Context

                      string

                      Context of credit card descriptive flexfields.

                        Credit Card

                        A payment instrument such as a credit card or debit card owned by a third party payer, typically a customer.

                        QName: {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/creditCardService/}CreditCard

                        Relationships

                        The following table describes how this service data object is related to other service data objects or business object services.

                        Relationship Type Object or Service

                        Contains

                        Credit Card Attributes SDO

                        Handled by

                        Credit Card

                        Attributes

                        The following table describes attributes in the service data object.

                        Name Type Description

                        Addressid

                        long

                        Card holder address identifier. This is a foreign key to HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID.

                        BillAddrTerritoryCode

                        string

                        Billing address territory code.

                        BillingAddrPostalCode

                        string

                        Billing address postal code.

                        CardIssuerCode

                        string

                        Card issuer code if known. Otherwise UNKNOWN.

                        CardIssuerName

                        string

                        Card issuer name.

                        CardOwnerId

                        long

                        Party identifier for the owner of the payment card.

                        CardPurpose

                        string

                        Purpose of the credit card from the lookup IBY_CARD_PURPOSE.

                        Ccnumber

                        string

                        Credit card number.

                        Chname

                        string

                        Cardholder name.

                        CreditCardDFFVLA

                        Credit Card Attributes

                        Context value.

                        Description

                        string

                        Description of the payment instrument.

                        EndDate

                        {http://xmlns.oracle.com/adf/svc/types/}date-Date

                        Date until which the credit card is available for use.

                        Expirydate

                        {http://xmlns.oracle.com/adf/svc/types/}date-Date

                        Expiration date of the credit card.

                        Finame

                        string

                        Financial institution name.

                        FormattedAddress

                        string

                        Formatted billing address.

                        InformationOnlyFlag

                        boolean

                        Option that indicates whether the credit card is an employee card, to be used only for expenses and not payments.

                        Instrid

                        long

                        Payment instrument identifier.
                        • Primary Key

                        InstrumentType

                        string

                        Payment instrument type.

                        MaskedCcNumber

                        string

                        Masked credit card number.

                        ObjectVersionNumber

                        int

                        Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

                        PartyName

                        string

                        Party name for the owner of the payment card.

                        PurchasecardFlag

                        boolean

                        Option that indicates whether the credit card is a company card.

                        PurchasecardSubtype

                        string

                        Company card subtype from the lookup IBY_PURCHASECARD_SUBTYPE.

                        StartDate

                        {http://xmlns.oracle.com/adf/svc/types/}date-Date

                        Date from which the credit card is available for use.

                          Credit Card

                          A payment instrument such as a credit card or debit card owned by a third party payer, typically a customer.

                          Life Cycle Status: Active

                          QName: {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/creditCardServiceV2/}CreditCardService

                          Service WSDL URL: https://servername/fscmService/CreditCardServiceV2?WSDL

                          Relationships

                          The following table describes how this service data object is related to other service data objects or business object services.

                          Relationship Type Object or Service

                          Handles

                          Credit Card Billing Address SDO

                          Handles

                          Credit Card SDO

                          Handles

                          Credit Card Attributes

                          Handles

                          Credit Card Tokenization SDO

                          Operations

                          confirmPaymentCardExistence

                          Confirm payment card existence.

                          Life Cycle Status: Active

                          Request Payload

                          Element Name Type Description

                          cardNumber

                          string

                          Card number.

                          cardOwnerId

                          long

                          Card owner identifier.

                          Response Payload

                          Element Name Type Description

                          result

                          long

                          Payment instrument identifier.

                          getTokenizationRequest

                          Get Tokenization Request.

                          Life Cycle Status: Active

                          Request Payload

                          Element Name Type Description

                          ccRow

                          Credit Card Tokenization

                          Credit card.

                          Response Payload

                          Element Name Type Description

                          result

                          Credit Card Tokenization

                          Credit card.

                          isTokenizationEnabled

                          Options that indicates whether payment card tokenization is enabled.

                          Life Cycle Status: Active

                          Request Payload

                          Response Payload

                          Element Name Type Description

                          result

                          boolean

                          Options that indicates whether payment card tokenization is enabled.

                          getPaymentCardDetails

                          GetByKey operation for the Credit Card SDO.

                          Life Cycle Status: Active

                          Request Payload

                          Element Name Type Description

                          instrid

                          long

                          Payment instrument identifier.

                          Response Payload

                          Element Name Type Description

                          result

                          Credit Card

                          Credit card.

                          findPaymentCard

                          Find payment card.

                          Life Cycle Status: Active

                          Request Payload

                          Element Name Type Description

                          findCriteria

                          {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                          Find criteria.

                          findControl

                          {http://xmlns.oracle.com/adf/svc/types/}FindControl

                          Find Control. Not currently used.

                          Response Payload

                          Element Name Type Description

                          result

                          Credit Card

                          List of payment cards.

                          findBillingAddressesByParty

                          Find existing billing addresses for a party.

                          Life Cycle Status: Active

                          Request Payload

                          Element Name Type Description

                          findCriteria

                          {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                          Find criteria.

                          PartyId

                          long

                          Party identifier.

                          findControl

                          {http://xmlns.oracle.com/adf/svc/types/}FindControl

                          Find criteria.

                          Response Payload

                          Element Name Type Description

                          result

                          Credit Card Billing Address

                          List of applicable billing addresses for a party.

                          getDfltObjAttrHints

                          Get default object attribute hints.

                          Life Cycle Status: Active

                          Request Payload

                          Element Name Type Description

                          viewName

                          string

                          View name.

                          localeName

                          string

                          Locale name.

                          Response Payload

                          Element Name Type Description

                          result

                          {http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

                          Return value.

                          getServiceLastUpdateTime

                          Get service last update time.

                          Life Cycle Status: Active

                          Request Payload

                          Response Payload

                          Element Name Type Description

                          result

                          {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                          Return value.

                          getEntityList

                          Get entity list.

                          Life Cycle Status: Active

                          Request Payload

                          Response Payload

                          Element Name Type Description

                          result

                          {http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

                          Return value.

                          Security

                          The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

                          Service Operations to Privileges Mapping

                          Operation Name Privilege Code Privilege Name Privilege Description

                          All Operations

                          IBY_MANAGE_PAYMENT_CARD_PRIV

                          Manage Payment Card

                          Allows management of payment cards.

                          Privileges to Duty Roles Mapping

                          Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

                          IBY_MANAGE_PAYMENT_CARD_PRIV

                          ORA_FOM_ORDER_ENTRY_SPECIALIST_JOB

                          Order Entry Specialist

                          Individual who is responsible for creating new orders, updating existing orders, and creating order returns.

                          IBY_MANAGE_PAYMENT_CARD_PRIV

                          ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY

                          Customer Payment Instrument Management

                          Manages customer bank accounts and credit cards and other payment details.

                          Duty Roles to Duty or Job Roles Mapping

                          Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

                          ORA_FOM_ORDER_ENTRY_SPECIALIST_JOB

                          ORA_CMK_B2B_MESG_ADMIN_DUTY

                          B2B Messaging Administration

                          Manages collaboration messaging setup and administration tasks.

                          ORA_FOM_ORDER_ENTRY_SPECIALIST_JOB

                          ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

                          FSCM Load Interface Administration

                          Manages load interface file for import

                          ORA_FOM_ORDER_ENTRY_SPECIALIST_JOB

                          ORA_EGP_ITEM_INQUIRY_DUTY

                          Item Inquiry

                          Queries and views items in the enterprise.

                            Credit Card Attributes

                            Stores company-specific information that is captured for a credit card.

                            QName: {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/flex/creditCardDff/}CreditCard

                            Relationships

                            The following table describes how this service data object is related to other service data objects or business object services.

                            Relationship Type Object or Service

                            Contained by

                            Credit Card

                            Contained by

                            Credit Card

                            Handled by

                            Credit Card

                            Handled by

                            External Payer

                            Handled by

                            Credit Card

                            Attributes

                            The following table describes attributes in the service data object.

                            Name Type Description

                            Instrid

                            long

                            Identifier of the payment instrument.
                            • Primary Key

                            _FLEX_NumOfSegments

                            int

                            Total number of global segments and context-sensitive segments in the credit card flexfield.

                            __FLEX_Context

                            string

                            Context of credit card descriptive flexfields.

                              Credit Card Billing Address

                              Credit card billing address.

                              QName: {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/creditCardServiceV2/}CreditCardBillAddress

                              Relationships

                              The following table describes how this service data object is related to other service data objects or business object services.

                              Relationship Type Object or Service

                              Handled by

                              Credit Card

                              Attributes

                              The following table describes attributes in the service data object.

                              Name Type Description

                              AddressFirstLine

                              string

                              Address first line.

                              AddressFourthLine

                              string

                              Address fourth line.

                              AddressSecondLine

                              string

                              Address second line.

                              AddressThirdLine

                              string

                              Address third line.

                              City

                              string

                              Billing city.

                              Country

                              string

                              Billing country.

                              County

                              string

                              Billing county.

                              FormattedAddress

                              string

                              Formatted address.

                              PartyId

                              long

                              Party identifier.

                              PartySiteUseId

                              long

                              Billing address identifier.
                              • Primary Key

                              PostalCode

                              string

                              Postal code.

                              Province

                              string

                              Billing province.

                              State

                              string

                              Billing state.

                                Credit Card

                                Stores the details of the credit card. For example, the name of the cardholder and the credit card number.

                                QName: {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/creditCardServiceV2/}CreditCard

                                Relationships

                                The following table describes how this service data object is related to other service data objects or business object services.

                                Relationship Type Object or Service

                                Contains

                                Credit Card Attributes

                                Contained by

                                Credit Card Assignment

                                Handled by

                                External Payer

                                Handled by

                                Credit Card

                                Attributes

                                The following table describes attributes in the service data object.

                                Name Type Description

                                Accttypeid

                                int

                                This column is no longer in use.

                                Addressid

                                long

                                Trading Community Hierarchy (TCA) identifier of the address. Will become a foreign key to HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID instead of HZ_LOCATIONS.LOCATION_ID ; changes to existing customer data will be implemented in an upgrade script.

                                BillAddrTerritoryCode

                                string

                                Territory code of the payer's billing address.

                                BillAddressCity

                                string

                                City of the billing address.

                                BillAddressCounty

                                string

                                County of the billing address.

                                BillAddressFirstLine

                                string

                                First line of the billing address.

                                BillAddressFourthLine

                                string

                                Fourth line of the billing address.

                                BillAddressProvince

                                string

                                Province of the billing address.

                                BillAddressSecondLine

                                string

                                Second line of the billing address.

                                BillAddressState

                                string

                                State of the billing address.

                                BillAddressThirdLine

                                string

                                Third line of the billing address.

                                BillingAddrPostalCode

                                string

                                Postal code of the payer's billing address.

                                CardIssuerCode

                                string

                                Card issuer code if known. Otherwise UNKNOWN.

                                CardIssuerName

                                string

                                The name of the bank that issues corporate credit cards.

                                CardMaskSetting

                                string

                                Credit card masking setting. Values taken from lookup IBY_PMT_INSTR_MASKING.

                                CardOwnerId

                                long

                                Trading Community Hierarchy (TCA) party identifier of the payer that owns the credit card.

                                CardPurpose

                                string

                                Purpose for which the credit card is used. Values are validated against lookup type IBY_CARD_PURPOSE

                                CardUnmaskLength

                                int

                                Number of digits exposed for masked credit card numbers.

                                CcIssuerRangeId

                                long

                                Identifier of the card issuer range. For example, the issuer ranges are provided by MasterCard and VISA.

                                CcNumberLength

                                int

                                Length of the credit card number.

                                Ccnumber

                                string

                                The numeric credit card number.

                                Chname

                                string

                                Name of the cardholder.

                                CreatedBy

                                string

                                Date and time of the creation of the record.

                                CreationDate

                                {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                User who created the record.

                                CreditCardDffVLA

                                Credit Card Attributes

                                Credit card descriptive flexfield.

                                Description

                                string

                                Description of the instrument.

                                EndDate

                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                Date to which card is available for use.

                                EndDateDisp

                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                Internal end date of the credit card that is displayed to the user.

                                ExpiredFlag

                                boolean

                                Indicates whether the credit card is expired.

                                Expirydate

                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                Expiration date of the card.

                                ExpirydateDisp

                                string

                                The date of expiration that is displayed on the credit card.

                                Finame

                                string

                                Name of the financial institution.

                                FormattedBillingAddress

                                string

                                Formatted billing address of the credit card.

                                InformationOnlyFlag

                                boolean

                                Yes or No indicates whether the credit card is registered for information use only.

                                Instrbuf

                                string

                                Name of the Instrument.

                                Instrid

                                long

                                Identifier of the payment instrument, which can be a credit card or a bank account.
                                • Primary Key

                                Instrname

                                string

                                This column is no longer in use.

                                InstrumentType

                                string

                                Type of payment instrument, such as credit card or bank account transfer.

                                LastUpdateDate

                                {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                User who last updated the record.

                                LastUpdateLogin

                                string

                                Session login associated with the user who last updated the record.

                                LastUpdatedBy

                                string

                                Date and time of the last record update.

                                MaskedCcNumber

                                string

                                Masked credit card number, which is used for display purposes.

                                ObjectVersionNumber

                                int

                                Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

                                PartyId

                                long

                                Identifier of the party on the credit card.

                                PartyName

                                string

                                Name of the party who owns the credit card.

                                PurchasecardFlag

                                boolean

                                Indicates whether the credit card is a purchase card.

                                PurchasecardSubtype

                                string

                                Subtype of a purchase card. The values are validated against lookup IBY_PURCHASECARD_SUBTYPE and include B (Business Card), C (Corporate Card), P (Purchase Card), and U (Unknown).

                                SingleUseFlag

                                boolean

                                Yes indicates whether the credit card is to be used only once.

                                StartDate

                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                Date from which card is available for use.

                                Subtype

                                string

                                This column is no longer in use.

                                TokenResponseBody

                                string

                                This column is no longer in use.

                                TokenResponseHeaders

                                string

                                This column is no longer in use.

                                  Credit Card Tokenization

                                  Credit card tokenize SDO.

                                  QName: {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/creditCardServiceV2/}CreditCardTokenize

                                  Relationships

                                  The following table describes how this service data object is related to other service data objects or business object services.

                                  Relationship Type Object or Service

                                  Handled by

                                  Credit Card

                                  Attributes

                                  The following table describes attributes in the service data object.

                                  Name Type Description

                                  Addressid

                                  string

                                  Card address identifier.

                                  CardIssuerCode

                                  string

                                  Card issuer code.

                                  CardOwnerId

                                  long

                                  Card owner identifier.

                                  CardPurpose

                                  string

                                  Card purpose.

                                  Chname

                                  string

                                  Cardholder name.

                                  Description

                                  string

                                  Card description.

                                  Expirydate

                                  {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                  Card expiry date.

                                  Finame

                                  string

                                  FI name.

                                  Instrid

                                  long

                                  Payment instrument identifier.
                                  • Primary Key

                                  PANLength

                                  int

                                  PAN length.

                                  PurchasecardFlag

                                  boolean

                                  Purchase card indicator.

                                  PurchasecardSubtype

                                  string

                                  Purchase card subtype

                                  SubstituteBodyFlag

                                  boolean

                                  Substitute body indicator.

                                  SubstituteHeadersFlag

                                  boolean

                                  Substitute headers indicator.

                                  TokenProviderURL

                                  string

                                  Token provider URL.

                                  TokenRequestBody

                                  string

                                  Token request body.

                                  TokenRequestHeaders

                                  string

                                  Token request headers.

                                    Customer Profile

                                    Service to create customer profiles to maintain characteristics of customer accounts, such as creditworthiness, business volume, payment cycles, and late charge policies. For each profile you can define information such as credit limits, payment terms, statement cycles, invoicing, and discount information. You can also define amount limits for your late charges and statements for each currency in which you do business.

                                    Life Cycle Status: Active

                                    QName: {http://xmlns.oracle.com/apps/financials/receivables/customers/customerProfileService/}CustomerProfileService

                                    Service WSDL URL: https://servername/fscmService/ReceivablesCustomerProfileService?WSDL

                                    Relationships

                                    The following table describes how this service data object is related to other service data objects or business object services.

                                    Operations

                                    getActiveCustomerProfile

                                    An operation to get active customer account profile or site profile.

                                    Life Cycle Status: Active

                                    Request Payload

                                    Element Name Type Description

                                    customerProfile

                                    Customer Profile

                                    Service Data Object to retrieve active customer account profile or site profile.

                                    Response Payload

                                    Element Name Type Description

                                    result

                                    Customer Profile

                                    Result Object that contains active customer account profile or site profile.

                                    createReferenceAccountsForBillToSite

                                    Service Operation to create bill-to site reference accounts for customer accounts. This setup is used for deriving account combinations for distributions on Receivables transactions, when AutoAccounting is set up to derive account combinations based on Bill-to Site.

                                    Life Cycle Status: Active

                                    Request Payload

                                    Element Name Type Description

                                    referenceAccounts

                                    Customer Bill-to Site Reference Accounts SDO

                                    Service Data Object to create Bill-To Site Reference Accounts.

                                    Response Payload

                                    Element Name Type Description

                                    result

                                    Customer Bill-to Site Reference Accounts SDO

                                    Result Object that contains Bill-To Site Reference Accounts.

                                    createCustomerProfile

                                    Asynchronous service for creating a customer profile.

                                    Life Cycle Status: Active

                                    Request Payload

                                    Element Name Type Description

                                    customerProfile

                                    Customer Profile

                                    Service data object for creating a customer profile.

                                    Response Payload

                                    Element Name Type Description

                                    result

                                    {http://xmlns.oracle.com/apps/financials/receivables/customers/customerProfileService/}CustomerProfileResult

                                    Result object for the create customer profile service.

                                    updateCustomerProfile

                                    Asynchronous service for updating a customer profile.

                                    Life Cycle Status: Active

                                    Request Payload

                                    Element Name Type Description

                                    customerProfile

                                    Customer Profile

                                    Service data object for updating a customer profile.

                                    Response Payload

                                    Element Name Type Description

                                    result

                                    {http://xmlns.oracle.com/apps/financials/receivables/customers/customerProfileService/}CustomerProfileResult

                                    Result object for the update customer profile service.

                                    getDfltObjAttrHints

                                    An operation to retrieve user interface hints, such as the service data object label and object attribute labels, for the specified service data object and locale. As a prerequisite, invoke the getEntityList operation defined on this service to get the list of possible values for the viewName request payload element.

                                    Life Cycle Status: Active

                                    Request Payload

                                    Element Name Type Description

                                    viewName

                                    string

                                    An operation to retrieve user interface hints, such as the service data object label and object attribute labels, for the specified service data object and locale. As a prerequisite, invoke the getEntityList operation defined on this service to get the list of possible values for the viewName request payload element.

                                    localeName

                                    string

                                    The locale to use when evaluating locale-based user interface hints. The localeName is in ISO 639-1 format.

                                    Response Payload

                                    Element Name Type Description

                                    result

                                    {http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

                                    The label and user interface hints for the specified service data object and its attributes in a name-value pair format.

                                    getServiceLastUpdateTime

                                    An operation that returns the date and time when the schema files referenced in the service definition last changed.

                                    Life Cycle Status: Active

                                    Request Payload

                                    Response Payload

                                    Element Name Type Description

                                    result

                                    {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                    The date and time when the service definition last changed in ISO 8601 format.

                                    getEntityList

                                    An operation to get the list of service data objects defined on this service.

                                    Life Cycle Status: Active

                                    Request Payload

                                    Response Payload

                                    Element Name Type Description

                                    result

                                    {http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

                                    A list of service data objects defined on this service. For each service data object, the result includes the QName, internal name, and Boolean values indicating whether create, update, merge, and delete operations can be performed on the object.

                                    Security

                                    The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

                                    Service Operations to Privileges Mapping

                                    Operation Name Privilege Code Privilege Name Privilege Description

                                    All Operations

                                    AR_CREATE_CUSTOMER_PRIV

                                    Create Customer

                                    Create new customers to record and account for transactions, transaction activities, and other attributes of the customer relationship.

                                    Privileges to Duty Roles Mapping

                                    Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

                                    AR_CREATE_CUSTOMER_PRIV

                                    ORA_AR_CUSTOMER_MAINTENANCE_DUTY

                                    Customer Maintenance

                                    Defines and maintains Receivables attributes of customer accounts and customer account sites.

                                    Duty Roles to Duty or Job Roles Mapping

                                    Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

                                    ORA_AR_CUSTOMER_MAINTENANCE_DUTY

                                    ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

                                    Customer Account Inquiry

                                    View customer account details.

                                    ORA_AR_CUSTOMER_MAINTENANCE_DUTY

                                    ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY

                                    Customer Payment Instrument Management

                                    Manages customer bank accounts and credit cards and other payment details.

                                    ORA_AR_CUSTOMER_MAINTENANCE_DUTY

                                    ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

                                    FSCM Load Interface Administration

                                    Manages load interface file for import

                                    ORA_AR_CUSTOMER_MAINTENANCE_DUTY

                                    ORA_ZX_REGISTRATION_PII_DUTY

                                    Party Taxpayer Identifier PII

                                    View personally identifiable information for tax registration number of type taxpayer ID.

                                    ORA_AR_CUSTOMER_MAINTENANCE_DUTY

                                    ORA_MANAGE_TRADING_COMMUNITY_IMPORT_BATCH_DUTY_FSCM

                                    Trading Community Import Batch Management

                                    Manages trading community data import batches.

                                    ORA_AR_CUSTOMER_MAINTENANCE_DUTY

                                    ORA_MANAGE_TRADING_COMMUNITY_IMPORT_PROCESS_DUTY_FSCM

                                    Trading Community Import Process Management

                                    Manages trading community data import batch processes.

                                      Customer Bill-to Site Reference Accounts SDO

                                      Service to create bill-to site reference accounts for customer accounts. This setup is used for deriving account combinations for distributions on Receivables transactions, when AutoAccounting is set up to derive account combinations based on Bill-to Site.

                                      QName: {http://xmlns.oracle.com/apps/financials/receivables/customers/customerProfileService/}CustomerSiteReferenceAccounts

                                      Relationships

                                      The following table describes how this service data object is related to other service data objects or business object services.

                                      Relationship Type Object or Service

                                      Handled by

                                      Customer Profile

                                      Attributes

                                      The following table describes attributes in the service data object.

                                      Name Type Description

                                      AutoInvoiceClearingAccountCodeCombination

                                      string

                                      Account code combination for the Autoinvoice Clearing account type. Segments of the code combination delimited by the separator as defined on the Chart of Accounts.

                                      BusinessUnit

                                      string

                                      A unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy.
                                      • Primary Key

                                      CustomerAccountNumber

                                      string

                                      Number that identifies a customer account.

                                      CustomerNumber

                                      string

                                      Number that identifies a customer party.

                                      CustomerSiteNumber

                                      string

                                      Number that identifies a customer account site.
                                      • Primary Key

                                      FreightAccountCodeCombination

                                      string

                                      Account code combination for the Freight account type. Segments of the code combination delimited by the separator as defined on the Chart of Accounts.

                                      ReceivableAccountCodeCombination

                                      string

                                      Account code combination for the Receivable account type. Segments of the code combination delimited by the separator as defined on the Chart of Accounts.

                                      RevenueAccountCodeCombination

                                      string

                                      Account code combination for the Revenue account type. Segments of the code combination delimited by the separator as defined on the Chart of Accounts.

                                      TaxAccountCodeCombination

                                      string

                                      Account code combination for the Tax account type. Segments of the code combination delimited by the separator as defined on the Chart of Accounts.

                                      UnbilledReceivableAccountCodeCombination

                                      string

                                      Account code combination for the Unbilled Receivable account type. Segments of the code combination delimited by the separator as defined on the Chart of Accounts.

                                      UnearnedRevenueAccountCodeCombination

                                      string

                                      Account code combination for the Unearned Revenue account type. Segments of the code combination delimited by the separator as defined on the Chart of Accounts.

                                        Customer Profile Flexfield

                                        The attribute that contains the customer profile descriptive flexfield information.

                                        QName: {http://xmlns.oracle.com/apps/financials/receivables/customerSetup/customerProfiles/model/flex/CustomerProfileDff/}CustomerProfileFLEX

                                        Relationships

                                        The following table describes how this service data object is related to other service data objects or business object services.

                                        Relationship Type Object or Service

                                        Contained by

                                        Customer Profile

                                        Handled by

                                        Customer Profile

                                        Attributes

                                        The following table describes attributes in the service data object.

                                        Name Type Description

                                        _FLEX_NumOfSegments

                                        int

                                        Number of segments for the Receivables customer profile descriptive flexfield.

                                        __FLEX_Context

                                        string

                                        Context for the Receivables customer profile descriptive flexfield.

                                          Customer Profile

                                          The attribute that creates and maintains business characteristics of a customer account, such as creditworthiness, business volume, payment cycles, and late charge policies.

                                          QName: {http://xmlns.oracle.com/apps/financials/receivables/customers/customerProfileService/}CustomerProfile

                                          Relationships

                                          The following table describes how this service data object is related to other service data objects or business object services.

                                          Relationship Type Object or Service

                                          Contains

                                          Customer Profile Flexfield

                                          Contains

                                          Receivables Customer Profile Global Flexfield

                                          Handled by

                                          Customer Profile

                                          Attributes

                                          The following table describes attributes in the service data object.

                                          Name Type Description

                                          AccountNumber

                                          string

                                          Number that identifies a customer account

                                          AccountStatusValue

                                          string

                                          Attribute that identifies the current status of a customer account.

                                          ApplicationExceptionRuleSet

                                          string

                                          Set of rules to apply for Application Exception

                                          AutoCashRuleSet

                                          string

                                          Set of rules to apply cash to update customer account balances for the customer.

                                          AutoMatchRuleSet

                                          string

                                          The name of a set of parameters that determine how receipts are applied automatically for the customer.

                                          AutoReceiptsIncludeDisputedItems

                                          string

                                          Check box to include debit items in dispute when creating automatic receipts for customers.

                                          BillLevel

                                          string

                                          Rating of customer creditworthiness.

                                          BillType

                                          string

                                          Rating of customer creditworthiness.

                                          ClearingDays

                                          int

                                          Indicates the number of days before receipts that belong to this customer (or site) can be cleared by the Automatic Clearing program.

                                          CollectorName

                                          string

                                          Company employee responsible for collecting past due amounts from customers.

                                          ConsolidatedInvoice

                                          string

                                          The field for Consolidate Invoice flag

                                          ConversionRateType

                                          string

                                          Default conversion rate type to use when the receipt and transaction currencies do not have a fixed-rate relationship for the customer.

                                          CreditAnalystName

                                          string

                                          The credit analyst assigned to a customer or customer account.

                                          CreditBalanceStatements

                                          string

                                          This check box is a profile class option to send statements to customers, even if they have a credit balance.

                                          CreditChecking

                                          string

                                          Check box. Option to perform a credit check on this customer.

                                          CreditClassificationValue

                                          string

                                          Measure of customer creditworthiness.

                                          CreditCurrencyCode

                                          string

                                          Credit currency code of customer, customer account or site profile.

                                          CreditHold

                                          string

                                          This is a check box that indicates whether a customer is on credit hold.

                                          CreditLimit

                                          decimal

                                          Credit limit of customer, customer account or site profile.

                                          CreditRatingValue

                                          string

                                          Rating of customer creditworthiness.

                                          CreditReviewCycleName

                                          string

                                          The credit review cycle assigned to a customer or customer account, such as annually, semiannually, or quarterly.

                                          CustomerAccountId

                                          long

                                          Unique identifier of the customer account.

                                          CustomerAccountProfileId

                                          long

                                          Unique Identifier of the Customer Profile. Do not provide any value during creation of a customer profile. The value will be derived by the system during the creation/updation of Customer Profile. It is optional to provide the value during the updation of Customer Profile.
                                          • Primary Key

                                          CustomerProfileFLEX

                                          Customer Profile Flexfield

                                          Service SDO that represents the descriptive flex field of the customer profile.

                                          CustomerProfileGdf

                                          Receivables Customer Profile Global Flexfield

                                          Service SDO that represents the global descriptive flex field of the customer profile.

                                          DiscountGraceDays

                                          int

                                          Number of days after the discount term date that a customer can still take discounts.

                                          DiscountTerms

                                          string

                                          Check box that indicates that a discount is allowed.

                                          DunningLetters

                                          string

                                          This check box is a profile class option to send dunning letters to customers with past due items.

                                          EffectiveEndDate

                                          {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                          End date for the date effective customer profile version.
                                          • Primary Key

                                          EffectiveStartDate

                                          {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                          Start date for the date effective customer profile version.
                                          • Primary Key

                                          GenerateBill

                                          string

                                          Method to use to print tax amounts on customer invoices for the customer.

                                          GroupingRule

                                          string

                                          Default grouping rule to use to group related transactions imported using AutoInvoice for the customer.

                                          LastCreditReviewDate

                                          {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                          The date when the last credit review took place for a customer or customer account.

                                          MatchByAutoupdate

                                          string

                                          Field represents Mathc By Autoupdate flag

                                          MatchReceiptsBy

                                          string

                                          Document reference used to match receipts with transactions for the customer.

                                          NextCreditReviewDate

                                          {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                          The date when the next credit review is due for a customer or customer account.

                                          OrderAmountLimit

                                          decimal

                                          Order amount limit of customer or Customer account profile.

                                          OverrideTerms

                                          string

                                          Check box that indicates override terms.

                                          PartyId

                                          long

                                          Unique identifier for the customer.

                                          PaymentTerms

                                          string

                                          Specifies the due date and discount date on open receivables.

                                          PercentCollectable

                                          decimal

                                          Percentage of this customer's account balance that you expect to collect on a regular basis.

                                          PreferredContactMethod

                                          string

                                          Customer preferred correspondence method for interacting with another party.

                                          PreferredDeliveryMethod

                                          string

                                          Preferred method of delivering transactions to the customer. Valid values are Paper, E-Mail, or XML.

                                          ProfileClassName

                                          string

                                          Profile class name from the customer profile class setup.

                                          ReminderRuleSet

                                          string

                                          Set of rules for unapplied cash amounts for the customer.

                                          RiskCodeValue

                                          string

                                          Code that identifies the credit risk of a customer.

                                          SendStatements

                                          string

                                          Profile class check box to send statements to customers.

                                          SiteNumber

                                          string

                                          Number that identifies a customer site

                                          StatementCycle

                                          string

                                          Period that determines when to send statements to customers.

                                          StatementDeliveryMethod

                                          string

                                          Preferred method of delivering statements to the customer. Valid values are Paper, E-Mail, or XML.

                                          Tolerance

                                          decimal

                                          Percentage that a customer can exceed the credit limit before taking action.

                                            Receivables Customer Profile Global Flexfield

                                            The attribute that contains the customer profile global flexfield information.

                                            QName: {http://xmlns.oracle.com/apps/financials/receivables/customerSetup/customerProfiles/model/flex/CustomerProfileGdf/}CustomerProfileGdf

                                            Relationships

                                            The following table describes how this service data object is related to other service data objects or business object services.

                                            Relationship Type Object or Service

                                            Contained by

                                            Customer Profile

                                            Handled by

                                            Customer Profile

                                            Attributes

                                            The following table describes attributes in the service data object.

                                            Name Type Description

                                            CustAccountProfileId

                                            long

                                            Unique identifier of the customer profile attached to the account.
                                            • Primary Key

                                            EffectiveEndDate

                                            {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                            Effective end date of the customer profile.
                                            • Primary Key

                                            EffectiveStartDate

                                            {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                            Effective start date of the customer profile.
                                            • Primary Key

                                            FLEX_PARAM_GLOBAL_COUNTRY_CODE

                                            string

                                            Country code of the customer profile global descriptive flexfield.

                                            _FLEX_NumOfSegments

                                            int

                                            Number of segments for the Receivables customer profile global descriptive flexfield.

                                            __FLEX_Context

                                            string

                                            Context for the Receivables customer profile global descriptive flexfield.

                                              ERP ICS Integration Service

                                              provides external web service operations for ERP ICS Integration

                                              Life Cycle Status: Active

                                              QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}ErpIcsIntegrationService

                                              Service WSDL URL: https://servername/fscmService/ErpIcsIntegrationService?WSDL

                                              Operations

                                              getInboundProcesses

                                              Returns the list of Import Process, UCM Account, Interface Id as a JSON Object

                                              Life Cycle Status: Active

                                              Request Payload

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              string

                                              JSON String which consists of UCM Account, Interface ID and Import Process

                                              ERP Integration Service

                                              Provides external operations for ERP integration scenarios to execute end-to-end inbound and outbound data flows. It also tracks the status of inbound and outbound data processes.

                                              Life Cycle Status: Active

                                              QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}ErpIntegrationService

                                              Service WSDL URL: https://servername/fscmService/ErpIntegrationService?WSDL

                                              Relationships

                                              The following table describes how this service data object is related to other service data objects or business object services.

                                              Relationship Type Object or Service

                                              Handles

                                              Document Information

                                              Handles

                                              Process Details SDO

                                              Handles

                                              Document Information SDO

                                              Operations

                                              getESSJobStatus

                                              Obtains the request status of the submitted Enterprise Scheduling Service job.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              requestId

                                              long

                                              The request ID of the submitted Enterprise Scheduling Service job.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              string

                                              Returns the current status of the Enterprise Scheduling Service job.

                                              submitESSJobRequest

                                              Submits an Enterprise Scheduling Service job request for the specified job definition.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              jobPackageName

                                              string

                                              The Enterprise Scheduling Service job package name for the job that must be submitted.

                                              jobDefinitionName

                                              string

                                              The Enterprise Scheduling Service job definition name for the job that must be submitted.

                                              paramList

                                              string

                                              List of parameters used to invoke the Enterprise Scheduling Service job. The order of the parameters is maintained per the list. The corresponding entry in the list should be blank when a given parameter is not passed.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              long

                                              Returns the request ID of the submitted Enterprise Scheduling Service job.

                                              submitJobWithOutput

                                              Submits an Enterprise Scheduling Service job to export and upload the job output to the Universal Content Management server.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              jobPackageName

                                              string

                                              The Enterprise Scheduling Service job package name for the job that must be submitted.

                                              jobDefinitionName

                                              string

                                              The Enterprise Scheduling Service job definition name for the job that must be submitted.

                                              callbackURL

                                              string

                                              The callback URL of the service implemented by customers to receive the Enterprise Scheduling Service job status on completion of the job.

                                              paramList

                                              string

                                              List of parameters used to invoke the Enterprise Scheduling Service job. The order of the parameters is maintained per the list. The corresponding entry in the list should be blank when a given parameter is not passed.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              long

                                              Returns the request ID of the submitted Enterprise Scheduling Service job.

                                              getDocumentIdsForFilePrefix

                                              Gets the document identifiers for files that match the file prefix and specified account. These files do not contain the specified comments.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              prefix

                                              string

                                              The file prefix to search for the files that start with a specified prefix.

                                              account

                                              string

                                              The account parameter to search for the files that belongs to a specified security account.

                                              comments

                                              string

                                              The parameter to pass the comments. Files that do not have the comments are retrieved.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              string

                                              Returns a list of document identifiers.

                                              getDocumentForDocumentId

                                              The operation to get the document that matches the given document identifier.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              DocumentId

                                              string

                                              The numeric document identifier of a file.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              Document Information

                                              Returns a list of elements, each containing the details of the downloaded files. The details include the document ID, file content, file name, content type, file title, author, security group, and account.

                                              getDocumentsForFilePrefix

                                              Gets the files that match the file prefix and specified account. These files do not contain the specified comments.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              prefix

                                              string

                                              The file prefix to search for the files that start with a specified prefix.

                                              account

                                              string

                                              The account parameter to search for the files that belongs to a specified security account.

                                              comments

                                              string

                                              The comments that are not present in the files.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              Document Information

                                              Returns a list of elements, each containing the details of the downloaded files. The details include the document ID, file content, file name, content type, file title, author, security group, and account.

                                              uploadFileToUcm

                                              Uploads a file to the Universal Content Management server based on the document specified.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              document

                                              Document Information

                                              List of elements, each containing the details of the file to be uploaded. The details include the file content, file name, content type, file title, author, security group, and account.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              string

                                              Returns the document ID of the uploaded file.

                                              downloadESSJobExecutionDetails

                                              Downloads the output of Enterprise Scheduling Service job and logs.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              requestId

                                              string

                                              The request ID of the submitted Enterprise Scheduling Service job.

                                              fileType

                                              string

                                              The file type to determine the execution details to download. Specify the file type as log to download the log and output file. Specify the file type as out to download the output file. When no file type is specified, both the log files and output files are downloaded.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              Document Information

                                              Returns a list of elements, each containing the details of the downloaded files. The details include the document ID, file content, file name, content type, file title, author, security group, and account.

                                              appendFileComment

                                              Appends the specified comments to a file.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              documentId

                                              string

                                              The numeric document identifier of a file.

                                              comments

                                              string

                                              Appends the specified comments to a file.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              void

                                              Returns the status code for the operation.

                                              downloadExportOutput

                                              The operation that downloads the output of an Enterprise Scheduling Service job.

                                              Life Cycle Status: Deprecated

                                              Request Payload

                                              Element Name Type Description

                                              requestId

                                              string

                                              The parameter to pass the request ID of the Enterprise Scheduling Service job.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              Document Information

                                              The output associated with a particular Enterprise Scheduling Service job that was executed.

                                              loadAndImportData

                                              Uploads a file to the Oracle Universal Content Management server based on the document specified and submits the Enterprise Scheduling Service jobs to import and process the uploaded file.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              document

                                              Document Information

                                              List of elements, each containing the details of the file to be uploaded. The details include the file content, file name, content type, file title, author, security group, and account.

                                              jobList

                                              Process Details

                                              List of elements, each containing the details of the Enterprise Scheduling Service job to be submitted to import and process the uploaded file. The details include the job definition name, job package name, and list of parameters.

                                              interfaceDetails

                                              string

                                              The interface whose data is to be loaded.

                                              notificationCode

                                              string

                                              A two-digit number that represents the manner and timing in which a notification is sent.

                                              callbackURL

                                              string

                                              The callback URL of the service implemented by customers to receive the Enterprise Scheduling Service job status on completion of the job.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              long

                                              Returns the response code containing error details.

                                              confirmExtractConsumption

                                              Retrieves the comment for a file from the Universal Content Management Server using a document identifier to retrieve the incremental date.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              jobName

                                              string

                                              Contains a combination of the job package name and job definition name, separated by a comma.

                                              documentIDs

                                              string

                                              List of elements, each containing the details of the file to be uploaded. The details include the file content, file name, content type, file title, author, security group, and account.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              string

                                              Returns the status code for the operation.

                                              updateInterfaceData

                                              This method updates error data in interface tables pertaining to the specified import process and load request ID.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              processName

                                              string

                                              ERP Interface options import job name.

                                              loadRequestId

                                              string

                                              Load Request ID.

                                              document

                                              {http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler

                                              User uploaded blobDomain with corrected interface table data.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              void

                                              importBulkData

                                              Uploads a file to the Oracle Universal Content Management server based on the document specified and submits the ESS jobs to import and process the uploaded file with multiple options.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              document

                                              Document Information SDO

                                              List of elements, each containing the details of the file to be uploaded. The details include the file content, file name, content type, file title, author, security group, and account.

                                              jobDetails

                                              Process Details

                                              List of elements, each containing the details of the ESS job to be submitted to import and process the uploaded file. The details include the job definition name, job package name, and list of parameters.

                                              notificationCode

                                              string

                                              Two digit code representing the type and when a notification is to be sent.

                                              callbackURL

                                              string

                                              The callback URL of the service implemented by the customers to receive the ESS job status on job completion.

                                              jobOptions

                                              string

                                              A web service operation input parameter. It designates the specific inbound bulk data processing variation selected and the output file type that will be generated upon completion of the data processing.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              long

                                              Returns response code containing error details

                                              extractAndPurge

                                              Submits ESS jobs to upload the load and import job output to the Universal Content Management server and purge interface tables with callback and notification.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              requestIds

                                              string

                                              The request Ids of load job and import jobs.

                                              notificationCode

                                              string

                                              Two digit code representing the type and when a notification is to be sent.

                                              callbackURL

                                              string

                                              The callback URL of the service implemented by the customers to receive the ESS job status on job completion.

                                              jobOptions

                                              string

                                              A web service operation input parameter which will allow new attributes to be used for future enhancements to ensure data model flexibility.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              long

                                              Returns the request ID of the first submitted ESS job.

                                              exportBulkData

                                              Submits an ESS job to export and uploads the job output to the Universal Content Management server with callback and notification.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              jobName

                                              string

                                              The ESS job package name and definition name for the ESS job that must be submitted.

                                              parameterList

                                              string

                                              Parameters used to invoke the ESS job.

                                              jobOptions

                                              string

                                              A web service operation input parameter which will allow new attributes to be used for future enhancements to ensure data model flexibility.

                                              callbackURL

                                              string

                                              The callback URL of the service implemented by the customers to receive the ESS job status on job completion.

                                              notificationCode

                                              string

                                              Two digit code representing the type and when a notification is to be sent.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              long

                                              Returns the request ID of the submitted ESS job.

                                              getESSExecutionDetails

                                              Provides the Job Execution details as a Json string.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              requestId

                                              long

                                              The request ID of the submitted ESS job.

                                              jobOptions

                                              string

                                              A web service operation input parameter which will allow new attributes to be used for future enhancements to ensure data model flexibility.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              string

                                              Json string that contains Job Execution details

                                              getDfltObjAttrHints

                                              An operation to retrieve user interface hints, such as the service data object label and object attribute labels, for the specified service data object and locale. As a prerequisite, call the getEntityList operation defined on this service to get the list of possible values for the viewName request payload element.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Element Name Type Description

                                              viewName

                                              string

                                              The service view usage name, an internal name for the service data object. Specify the value of the name element from the getEntityList operation response payload.

                                              localeName

                                              string

                                              The locale to use when evaluating locale-based user interface hints. The localeName is in the ISO 639-1 format.

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              {http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

                                              The label and user interface hints for the specified service data object and its attributes in a name and value paired format.

                                              getServiceLastUpdateTime

                                              An operation that returns the date and time when the schema files last changed.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                              The date and time when the service definition last changed in the ISO 8601 format.

                                              getEntityList

                                              An operation that retrieves the list of service data objects associated with the ERP Integration Service.

                                              Life Cycle Status: Active

                                              Request Payload

                                              Response Payload

                                              Element Name Type Description

                                              result

                                              {http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

                                              A list of service data objects defined on this service. For each service data object, the result includes the QName, internal name, and boolean values indicating whether create, update, merge, or delete operations can be performed on the object.

                                                Document Information

                                                The document information that is uploaded to the Oracle Universal Content Management Server including the filename, content type, content, and author.

                                                QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}DocumentDetails

                                                Relationships

                                                The following table describes how this service data object is related to other service data objects or business object services.

                                                Relationship Type Object or Service

                                                Handled by

                                                ERP Integration Service

                                                Handled by

                                                ERP Object Descriptive Flexfield Update Service

                                                Attributes

                                                The following table describes attributes in the service data object.

                                                Name Type Description

                                                Content

                                                {http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler

                                                Content of the document.

                                                ContentType

                                                string

                                                Content type of the document.

                                                DocumentAccount

                                                string

                                                The account to which the document belongs to.

                                                DocumentAuthor

                                                string

                                                The author of the document.

                                                DocumentId

                                                string

                                                The document identifier.

                                                DocumentName

                                                string

                                                The name of the document.

                                                DocumentSecurityGroup

                                                string

                                                The security group that secures the document.

                                                DocumentTitle

                                                string

                                                The title of the document.

                                                FileName

                                                string

                                                The name of the file specified by the document.
                                                • Primary Key

                                                  Document Information SDO

                                                  The document information that is uploaded to the Oracle Universal Content Management. For example, filename, content type, content, and author.

                                                  QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}DocumentDetail

                                                  Relationships

                                                  The following table describes how this service data object is related to other service data objects or business object services.

                                                  Relationship Type Object or Service

                                                  Handled by

                                                  ERP Integration Service

                                                  Attributes

                                                  The following table describes attributes in the service data object.

                                                  Name Type Description

                                                  Content

                                                  {http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler

                                                  The attribute holds the content of the document.

                                                  ContentType

                                                  string

                                                  The attribute holds the content type of the document.

                                                  DocumentAccount

                                                  string

                                                  The attribute holds the account the document should belong to.

                                                  DocumentAuthor

                                                  string

                                                  The attribute holds the name of the author of the document.

                                                  DocumentId

                                                  string

                                                  The attribute holds the document identifier.

                                                  DocumentName

                                                  string

                                                  The attribute holds the name of the document.

                                                  DocumentSecurityGroup

                                                  string

                                                  The attribute holds the name of the security group securing the document.

                                                  DocumentTitle

                                                  string

                                                  The attribute holds the title of the document.

                                                  FileName

                                                  string

                                                  The attribute holds the name of the file specified by the document.
                                                  • Primary Key

                                                    Process Details

                                                    Enterprise Scheduling Service job information that includes key information such as the job definition name, job package name, and job parameters.

                                                    QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}EssJob

                                                    Relationships

                                                    The following table describes how this service data object is related to other service data objects or business object services.

                                                    Relationship Type Object or Service

                                                    Handled by

                                                    ERP Integration Service

                                                    Attributes

                                                    The following table describes attributes in the service data object.

                                                    Name Type Description

                                                    JobName

                                                    string

                                                    The Enterprise Scheduling Service job package and the job name, delimited by a semicolon, for the job that must be submitted.

                                                    JobRequestId

                                                    string

                                                    The request ID of the submitted Enterprise Scheduling Service job.
                                                    • Primary Key

                                                    ParameterList

                                                    string

                                                    Comma separated list of parameters used to invoke the Enterprise Scheduling Service job. The order of the parameters is maintained per the list. The corresponding entry in the list should be blank when a given parameter is not passed.

                                                      ERP Object Attachment Service

                                                      Provides external operations to upload text, file, and URL attachments for those business objects that support attachments.

                                                      Life Cycle Status: Active

                                                      QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}ErpObjectAttachmentService

                                                      Service WSDL URL: https://servername/fscmService/ErpObjectAttachmentService?WSDL

                                                      Relationships

                                                      The following table describes how this service data object is related to other service data objects or business object services.

                                                      Relationship Type Object or Service

                                                      Handles

                                                      Attachment Information SDO

                                                      Handles

                                                      Attachment Download Details SDO

                                                      Handles

                                                      Attachment Details SDO

                                                      Operations

                                                      downloadAttachment

                                                      Download attachment corresponding to the attachment details passed.

                                                      Life Cycle Status: Active

                                                      Request Payload

                                                      Element Name Type Description

                                                      attachment

                                                      Attachment Details SDO

                                                      Element containing the details of the Attachment to be downloaded. The details include the entity name, category name and user keys.

                                                      Response Payload

                                                      Element Name Type Description

                                                      result

                                                      Attachment Download Details SDO

                                                      Downloaded Attachment Details. Details include Attachment Type and Attachment Content

                                                      uploadAttachment

                                                      Uploads an attachment zip file for a particular Universal Content Management Server account and updates the attachment tables for the relevant business object.

                                                      Life Cycle Status: Active

                                                      Request Payload

                                                      Element Name Type Description

                                                      entityName

                                                      string

                                                      Entity Name for Single/Multiple Attachment upload

                                                      categoryName

                                                      string

                                                      Category Name for Single/Multiple Attachment upload

                                                      allowDuplicate

                                                      string

                                                      User option to specify whether duplicates are allowed.

                                                      attachmentRows

                                                      Attachment Information

                                                      List of elements, each containing the details of the Attachment to be uploaded.

                                                      Response Payload

                                                      Element Name Type Description

                                                      result

                                                      string

                                                      The request ID associated with the corresponding Enterprise Scheduling Service job used to perform the upload of attachments for a business object.

                                                      Security

                                                      The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

                                                      Service Operations to Privileges Mapping

                                                      Operation Name Privilege Code Privilege Name Privilege Description

                                                      All Operations

                                                      FUN_FSCM_LOAD_INTERFACES_PRIV

                                                      Load Interface File for Import

                                                      Allows a user to load interface file for import

                                                      Privileges to Duty Roles Mapping

                                                      Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

                                                      FUN_FSCM_LOAD_INTERFACES_PRIV

                                                      ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

                                                      FSCM Load Interface Administration

                                                      Manages load interface file for import

                                                        Attachment Details SDO

                                                        Elements containing the details of the Attachment to be downloaded

                                                        QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}DownloadAttachmentDtls

                                                        Relationships

                                                        The following table describes how this service data object is related to other service data objects or business object services.

                                                        Relationship Type Object or Service

                                                        Handled by

                                                        ERP Object Attachment Service

                                                        Attributes

                                                        The following table describes attributes in the service data object.

                                                        Name Type Description

                                                        CategoryName

                                                        string

                                                        Category Name for Attachment download

                                                        EntityName

                                                        string

                                                        Entity Name for Attachment downlaod
                                                        • Primary Key

                                                        UserKeyA

                                                        string

                                                        User Key to derive PK1

                                                        UserKeyB

                                                        string

                                                        User Key to derive PK2

                                                        UserKeyC

                                                        string

                                                        User Key to derive PK3

                                                        UserKeyD

                                                        string

                                                        User Key to derive PK4

                                                        UserKeyE

                                                        string

                                                        User Key to derive PK5

                                                          Attachment Download Details SDO

                                                          Elements containing the details of the downloaded Attachment

                                                          QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}DownloadedAttachment

                                                          Relationships

                                                          The following table describes how this service data object is related to other service data objects or business object services.

                                                          Relationship Type Object or Service

                                                          Handled by

                                                          ERP Object Attachment Service

                                                          Attributes

                                                          The following table describes attributes in the service data object.

                                                          Name Type Description

                                                          AttachmentContent

                                                          string

                                                          Downloaded Attachment TEXT/URL/FILE Content
                                                          • Primary Key

                                                          AttachmentType

                                                          string

                                                          Type of Attachment Downloaded
                                                          • Primary Key

                                                          FileName

                                                          string

                                                          File Name of the Downloaded Attachment

                                                            Attachment Information

                                                            The listing of information related to specific business object attachments.

                                                            QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}AttachmentDetails

                                                            Relationships

                                                            The following table describes how this service data object is related to other service data objects or business object services.

                                                            Relationship Type Object or Service

                                                            Handled by

                                                            ERP Object Attachment Service

                                                            Attributes

                                                            The following table describes attributes in the service data object.

                                                            Name Type Description

                                                            AttachmentType

                                                            string

                                                            Indicates the specific type of attachment to be uploaded. The supported attachment types are FILE, TEXT, or URL.

                                                            Content

                                                            string

                                                            Attachment Text/Url

                                                            Title

                                                            string

                                                            Indicates the title of the attachment. Attachments of any file type such as FILE, TEXT, or URL must have a title.
                                                            • Primary Key

                                                            UserKeyA

                                                            string

                                                            Indicates the one of up to five values of the corresponding to the business entity attribute through which an attachment can be uploaded and associated. This value does not correspond to any column in the table, it is only for reference. For example, in order to upload attachments to the header level of a supplier invoice, it may be necessary to provide the business unit in order to be able to upload and associate an attachment at the header level. The values populated in the user key columns are dependent upon the seeded data provided by distinct product application areas of specific business entities.

                                                            UserKeyB

                                                            string

                                                            Indicates the one of up to five values of the corresponding to the business entity attribute through which an attachment can be uploaded and associated. This value does not correspond to any column in the table, it is only for reference. For example, in order to upload attachments to the header level of a supplier invoice, it may be necessary to provide the business unit in order to be able to upload and associate an attachment at the header level. The values populated in the user key columns are dependent upon the seeded data provided by distinct product application areas of specific business entities.

                                                            UserKeyC

                                                            string

                                                            Indicates the one of up to five values of the corresponding to the business entity attribute through which an attachment can be uploaded and associated. This value does not correspond to any column in the table, it is only for reference. For example, in order to upload attachments to the header level of a supplier invoice, it may be necessary to provide the business unit in order to be able to upload and associate an attachment at the header level. The values populated in the user key columns are dependent upon the seeded data provided by distinct product application areas of specific business entities.

                                                            UserKeyD

                                                            string

                                                            Indicates the one of up to five values of the corresponding to the business entity attribute through which an attachment can be uploaded and associated. This value does not correspond to any column in the table, it is only for reference. For example, in order to upload attachments to the header level of a supplier invoice, it may be necessary to provide the business unit in order to be able to upload and associate an attachment at the header level. The values populated in the user key columns are dependent upon the seeded data provided by distinct product application areas of specific business entities.

                                                            UserKeyE

                                                            string

                                                            Indicates the one of up to five values of the corresponding to the business entity attribute through which an attachment can be uploaded and associated. This value does not correspond to any column in the table, it is only for reference. For example, in order to upload attachments to the header level of a supplier invoice, it may be necessary to provide the business unit in order to be able to upload and associate an attachment at the header level. The values populated in the user key columns are dependent upon the seeded data provided by distinct product application areas of specific business entities.

                                                              ERP Object Descriptive Flexfield Update Service

                                                              Provides external operations to update descriptive or global descriptive flexfield attributes.

                                                              Life Cycle Status: Active

                                                              QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}ErpObjectDFFUpdateService

                                                              Service WSDL URL: https://servername/fscmService/ErpObjectDFFUpdateService?WSDL

                                                              Relationships

                                                              The following table describes how this service data object is related to other service data objects or business object services.

                                                              Relationship Type Object or Service

                                                              Handles

                                                              Document Information SDO

                                                              Handles

                                                              Object Information SDO

                                                              Operations

                                                              updateDffEntityDetails

                                                              Updates specific descriptive or global descriptive flexfield attributes for supporting business objects.

                                                              Life Cycle Status: Active

                                                              Request Payload

                                                              Element Name Type Description

                                                              document

                                                              Document Information

                                                              The prerequisite input that contains the file content, file name, content type, file title, author, security group, and account to update specific descriptive flexfield or global descriptive flexfield attributes using the available bulk batch update approach from the appropriate spreadsheet template. The document input will be NULL when the real-time calling of the web service is used as an alternative to the bulk update approach.

                                                              operationMode

                                                              string

                                                              Processing mode to designate whether a real-time single or a bulk batch update web service approach will be used to update specific descriptive or global descriptive flexfield attributes.

                                                              object

                                                              Object Information

                                                              List of elements, each containing the details of the ERP Object to be updated. The details include the entity name, context value, user key attribute values, DFF attribute name value pair.

                                                              notificationCode

                                                              string

                                                              The two-digit code which represents the type and timing when a notification will be sent.

                                                              callbackURL

                                                              string

                                                              The callback URL of the service implemented by customers to receive the Enterprise Scheduling Service job status on job completion.

                                                              Response Payload

                                                              Element Name Type Description

                                                              result

                                                              string

                                                              The request ID of the Enterprise Scheduling Service job in cases where the bulk batch update of specific descriptive or global descriptive flexfield attributes is used. Alternatively, the status value of success or failure in cases where the real-time single web service approach to update a specific descriptive flexfield or global descriptive flexfield attribute is used.

                                                                Document Information

                                                                The document information that is uploaded to the Oracle Universal Content Management Server including the filename, content type, content, and author.

                                                                QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}DocumentDetails

                                                                Relationships

                                                                The following table describes how this service data object is related to other service data objects or business object services.

                                                                Relationship Type Object or Service

                                                                Handled by

                                                                ERP Integration Service

                                                                Handled by

                                                                ERP Object Descriptive Flexfield Update Service

                                                                Attributes

                                                                The following table describes attributes in the service data object.

                                                                Name Type Description

                                                                Content

                                                                {http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler

                                                                Content of the document.

                                                                ContentType

                                                                string

                                                                Content type of the document.

                                                                DocumentAccount

                                                                string

                                                                The account to which the document belongs to.

                                                                DocumentAuthor

                                                                string

                                                                The author of the document.

                                                                DocumentId

                                                                string

                                                                The document identifier.

                                                                DocumentName

                                                                string

                                                                The name of the document.

                                                                DocumentSecurityGroup

                                                                string

                                                                The security group that secures the document.

                                                                DocumentTitle

                                                                string

                                                                The title of the document.

                                                                FileName

                                                                string

                                                                The name of the file specified by the document.
                                                                • Primary Key

                                                                  Object Information

                                                                  The metadata information such as product entities and their corresponding user keys required to leverage the ERP Integration Service.

                                                                  QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}ErpObjectDetails

                                                                  Relationships

                                                                  The following table describes how this service data object is related to other service data objects or business object services.

                                                                  Relationship Type Object or Service

                                                                  Handled by

                                                                  ERP Object Descriptive Flexfield Update Service

                                                                  Attributes

                                                                  The following table describes attributes in the service data object.

                                                                  Name Type Description

                                                                  ContextValue

                                                                  string

                                                                  A required value used by a descriptive flexfield to differentiate among various descriptive flexfield structures. Your descriptive flexfield uses this column to let users view different descriptive flexfield structures based on the data supplied by the user interface page or the user. You must have an attribute category value even if you only intend to use one descriptive flexfield structure. Failure to populate the attribute category will result in a failure during the update of a descriptive flexfield value and a missing attribute category will also prevent users from viewing a descriptive flexfield value in the front-end application.

                                                                  DFFAttributes

                                                                  string

                                                                  Descriptive flexfield attributes to be updated.

                                                                  EntityName

                                                                  string

                                                                  Indicates the product application business object name for which descriptive flexfield attributes need to be updated. Some examples include Receivables Invoice and Receivables Invoice Line.
                                                                  • Primary Key

                                                                  UserKeyA

                                                                  string

                                                                  Indicates one of up to five possible values corresponding to the business object name through which a descriptive flexfield value can be updated. This value does not correspond to any column in the table, it is only for reference purposes. For example, in order to update a descriptive flexfield value at the header level of a sales invoice, it may be necessary to provide the invoice business unit in order to be able to update a descriptive flexfield value at the header level of all sales invoices processed for that specific business unit. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                  UserKeyB

                                                                  string

                                                                  Indicates one of up to five possible values corresponding to the business object name through which a descriptive flexfield value can be updated. This value does not correspond to any column in the table, it is only for reference purposes. For example, in order to update a descriptive flexfield value at the header level of a sales invoice, it may be necessary to provide the invoice business unit in order to be able to update a descriptive flexfield value at the header level of all sales invoices processed for that specific business unit. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                  UserKeyC

                                                                  string

                                                                  Indicates one of up to five possible values corresponding to the business object name through which a descriptive flexfield value can be updated. This value does not correspond to any column in the table, it is only for reference purposes. For example, in order to update a descriptive flexfield value at the header level of a sales invoice, it may be necessary to provide the invoice business unit in order to be able to update a descriptive flexfield value at the header level of all sales invoices processed for that specific business unit. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                  UserKeyD

                                                                  string

                                                                  Indicates one of up to five possible values corresponding to the business object name through which a descriptive flexfield value can be updated. This value does not correspond to any column in the table, it is only for reference purposes. For example, in order to update a descriptive flexfield value at the header level of a sales invoice, it may be necessary to provide the invoice business unit in order to be able to update a descriptive flexfield value at the header level of all sales invoices processed for that specific business unit. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                  UserKeyE

                                                                  string

                                                                  Indicates one of up to five possible values corresponding to the business object name through which a descriptive flexfield value can be updated. This value does not correspond to any column in the table, it is only for reference purposes. For example, in order to update a descriptive flexfield value at the header level of a sales invoice, it may be necessary to provide the invoice business unit in order to be able to update a descriptive flexfield value at the header level of all sales invoices processed for that specific business unit. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                  UserKeyF

                                                                  string

                                                                  User key value

                                                                  UserKeyG

                                                                  string

                                                                  User key value

                                                                  UserKeyH

                                                                  string

                                                                  User key value

                                                                    ERP Object Inquiry Service

                                                                    Provides external operations to perform data retrieval for validation and other business flow integration functions.

                                                                    Life Cycle Status: Active

                                                                    QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}ErpObjectInquiryService

                                                                    Service WSDL URL: https://servername/fscmService/ErpObjectInquiryService?WSDL

                                                                    Operations

                                                                    getEntityDetails

                                                                    Provides an external operation to read user-specified attributes associated with Oracle ERP Cloud business application objects in order to fulfill a specific business need or activity. In practice, enterprise users often seek to seamlessly perform a specific task with regard to the automatic retrieval of particular master data or transaction data areas to manage a wide range of different business operations using the ERP Object Inquiry Service. For example, a business enterprise may need to verify whether a collection of newly created account code combinations in the Oracle ERP Cloud application is valid for integrating with another concurrently operated legacy financial host system.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    businessObject

                                                                    string

                                                                    Indicates the product application business object name for which an attribute or collection of attributes need to be retrieved and read. Some examples include receivables invoice and receivables invoice line.

                                                                    userKeyA

                                                                    string

                                                                    Indicates one of up to five possible values corresponding to the business object name for which an attribute or collection of attributes are retrieved and read. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                    userKeyB

                                                                    string

                                                                    Indicates one of up to five possible values corresponding to the business object name for which an attribute or collection of attributes are retrieved and read. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                    userKeyC

                                                                    string

                                                                    Indicates one of up to five possible values corresponding to the business object name for which an attribute or collection of attributes are retrieved and read. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                    userKeyD

                                                                    string

                                                                    Indicates one of up to five possible values corresponding to the business object name for which an attribute or collection of attributes are retrieved and read. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                    userKeyE

                                                                    string

                                                                    Indicates one of up to five possible values corresponding to the business object name for which an attribute or collection of attributes are retrieved and read. The values populated in the User Key columns are dependent upon the seeded data provided by distinct product application areas for specific business objects.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    string

                                                                    The response resulting from the retrieval and read processing of an attribute or collection of attributes. For example, if a particular account code combination is retrieved and read by the ERP Object Inquiry Service, a possible response may be either valid or invalid.

                                                                    Expense Item and Expense Report

                                                                    A service that enables you to create, update, delete, and retrieve expense items and expense reports.

                                                                    Life Cycle Status: Active

                                                                    QName: {http://xmlns.oracle.com/apps/financials/expenses/shared/common/expenseExternalService/}ExpenseService

                                                                    Service WSDL URL: https://servername/fscmService/ExpenseService?WSDL

                                                                    Logical Business Objects

                                                                    • Financials : Expenses : Expense

                                                                    • Financials : Expenses : Expense

                                                                    Relationships

                                                                    The following table describes how this service data object is related to other service data objects or business object services.

                                                                    Operations

                                                                    submitExpenseReport

                                                                    A process that enables you to submit an expense report that was previously created and is in saved status..

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expenseReportNumber

                                                                    string

                                                                    A parameter that specifies the report number of the expense report that has to be submitted

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    string

                                                                    A parameter that returns the status of report submission

                                                                    getExpense

                                                                    An operation that retrieves a specific expense item.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expenseId

                                                                    long

                                                                    A parameter that specifies the identifier for the expense item to be retrieved.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Item

                                                                    A parameter that returns the expense item that matches the expense item identifier.

                                                                    createExpense

                                                                    An operation that creates an expense item.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expense

                                                                    Expense Item

                                                                    A parameter that specifies the details for the new expense item to be created.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Item

                                                                    A parameter that returns the newly created expense item.

                                                                    updateExpense

                                                                    An operation that updates an expense item.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expense

                                                                    Expense Item

                                                                    A parameter that returns the updated expense item.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Item

                                                                    A parameter that specifies the expense item selected for update.

                                                                    deleteExpense

                                                                    An operation that deletes an expense item.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expense

                                                                    Expense Item

                                                                    A parameter that specifies the expense item to be deleted.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    void

                                                                    A parameter that returns the processed expense item.

                                                                    mergeExpense

                                                                    An operation that matches an expense item and creates a new one if a match does not exist, or updates an expense item if a match does exist.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expense

                                                                    Expense Item

                                                                    A parameter that specifies the expense item to be merged.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Item

                                                                    A parameter that returns the processed expense item.

                                                                    findExpense

                                                                    An operation that searches for expense items using specified criteria.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    findCriteria

                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                    A parameter that specifies the search criteria for expense items and the maximum records returned at a time.

                                                                    findControl

                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                    A parameter that controls the search for expense items. Not currently used.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Item

                                                                    A parameter that returns the list of expense items that satisfy the search criteria.

                                                                    processExpense

                                                                    An operation that processes expense items in bulk.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    changeOperation

                                                                    string

                                                                    A parameter that specifies the action to be performed on expense items, such as create, update, merge, or delete.

                                                                    expense

                                                                    Expense Item

                                                                    A parameter that specifies the list of expense items to be processed.

                                                                    processControl

                                                                    {http://xmlns.oracle.com/adf/svc/types/}ProcessControl

                                                                    A parameter that controls the bulk processing of expense items, such as whether to commit valid data if invalid data is present in the batch and whether to return the key attributes or the complete set of attributes. Not currently used.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Item

                                                                    A parameter that returns the list of processed expense items.

                                                                    processCSExpense

                                                                    An operation that sends processed expense items in bulk to another data source.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    processData

                                                                    {http://xmlns.oracle.com/adf/svc/types/}ProcessData

                                                                    A parameter that specifies the object, which represents the changes to expense items.

                                                                    processControl

                                                                    {http://xmlns.oracle.com/adf/svc/types/}ProcessControl

                                                                    A parameter that controls the bulk processing of expense items, such as whether to commit valid data if invalid data is present in the batch and whether to return the key attributes or the complete set of attributes. Not currently used.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    {http://xmlns.oracle.com/adf/svc/types/}ProcessData

                                                                    A parameter that returns the list of processed expense items with associated warnings and informational messages when applicable.

                                                                    getExpenseReport

                                                                    An operation that retrieves a specific expense report.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expenseReportId

                                                                    long

                                                                    A parameter that specifies the identifier for the expense report to be retrieved.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Report

                                                                    A parameter that returns the expense report that matches the expense report identifier.

                                                                    createExpenseReport

                                                                    An operation that creates an expense report.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expenseReport

                                                                    Expense Report

                                                                    A parameter that specifies the details for the new expense report to be created.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Report

                                                                    A parameter that returns the newly created expense report.

                                                                    updateExpenseReport

                                                                    An operation that updates an expense report.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expenseReport

                                                                    Expense Report

                                                                    A parameter that specifies the expense report selected for update.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Report

                                                                    A parameter that returns the updated expense report.

                                                                    deleteExpenseReport

                                                                    An operation that deletes an expense report.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expenseReport

                                                                    Expense Report

                                                                    A parameter that specifies the expense report to be deleted.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    void

                                                                    A parameter that returns the processed expense report.

                                                                    mergeExpenseReport

                                                                    An operation that merges an expense report, which creates an expense report if it does not exist and updates the expense report if it does exist.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    expenseReport

                                                                    Expense Report

                                                                    A parameter that specifies the expense report to be merged.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Report

                                                                    A parameter that returns the processed expense report.

                                                                    findExpenseReport

                                                                    An operation that searches for expense reports using specified criteria.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    findCriteria

                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                    A parameter that specifies the search criteria for expense reports and the maximum records that can be returned at a time.

                                                                    findControl

                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                    A parameter that controls the search for expense reports. Not currently used.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Report

                                                                    A parameter that returns the list of expense reports that satisfy the search criteria.

                                                                    processExpenseReport

                                                                    An operation that processes expense reports in bulk.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    changeOperation

                                                                    string

                                                                    A parameter that specifies the action to be performed on expense reports, such as create, update, merge, or delete.

                                                                    expenseReport

                                                                    Expense Report

                                                                    A parameter that specifies the list of expense reports to be processed.

                                                                    processControl

                                                                    {http://xmlns.oracle.com/adf/svc/types/}ProcessControl

                                                                    A parameter that controls the bulk processing of expense reports, such as whether to commit valid data if invalid data is present in the batch and whether to return the key attributes or the complete set of attributes. Not currently used.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    Expense Report

                                                                    A parameter that returns the list of processed expense reports.

                                                                    processCSExpenseReport

                                                                    An operation that sends processed expense reports in bulk to another data source.

                                                                    Life Cycle Status: Active

                                                                    Request Payload

                                                                    Element Name Type Description

                                                                    processData

                                                                    {http://xmlns.oracle.com/adf/svc/types/}ProcessData

                                                                    A parameter that specifies the object, which represents the changes to expense reports.

                                                                    processControl

                                                                    {http://xmlns.oracle.com/adf/svc/types/}ProcessControl

                                                                    A parameter that controls the bulk processing of expense reports, such as whether to commit valid data if invalid data is present in the batch and whether to return the key attributes or the complete set of attributes. Not currently used.

                                                                    Response Payload

                                                                    Element Name Type Description

                                                                    result

                                                                    {http://xmlns.oracle.com/adf/svc/types/}ProcessData

                                                                    A parameter that returns the list of processed expense reports with associated warnings and informational messages when applicable.

                                                                    Security

                                                                    The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

                                                                    Service Operations to Privileges Mapping

                                                                    Operation Name Privilege Code Privilege Name Privilege Description

                                                                    All Operations

                                                                    EXM_MANAGE_EXPENSE_REPORT_PRIV

                                                                    Manage Expense Report

                                                                    Allows creation of expense items and expense reports. Allows updating expense items and managing submitted expense reports. Allows tracking of expense reports, expense items, and payments.

                                                                    Privileges to Duty Roles Mapping

                                                                    Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

                                                                    EXM_MANAGE_EXPENSE_REPORT_PRIV

                                                                    ORA_EXM_EXPENSE_ENTRY_DUTY

                                                                    Expense Entry

                                                                    Creates and updates expense items and expense reports.

                                                                    Duty Roles to Duty or Job Roles Mapping

                                                                    Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

                                                                    ORA_EXM_EXPENSE_ENTRY_DUTY

                                                                    ORA_IBY_PAYEE_BANK_ACCOUNT_MANAGEMENT_DUTY

                                                                    Payee Bank Account Management

                                                                    Manages supplier bank accounts and other payment details.

                                                                    ORA_EXM_EXPENSE_ENTRY_DUTY

                                                                    ORA_XCC_TRANSACTIONAL_DUTY

                                                                    Transaction Entry with Budgetary Control

                                                                    Manages the budgetary control tasks by job roles who perform transactions that are subject to budgetary control, such as accounts payable manager.

                                                                      Expense Company Allocation

                                                                      Stores the amount charged to one or more companies for an expense item.

                                                                      QName: {http://xmlns.oracle.com/apps/financials/expenses/entry/shared/flex/companykff/}CompanyKff

                                                                      Relationships

                                                                      The following table describes how this service data object is related to other service data objects or business object services.

                                                                      Relationship Type Object or Service

                                                                      Contained by

                                                                      Expense Distribution

                                                                      Handled by

                                                                      Expense Item and Expense Report

                                                                      Attributes

                                                                      The following table describes attributes in the service data object.

                                                                      Name Type Description

                                                                      ExpenseDistId

                                                                      long

                                                                      Unique identifier of the expense distribution for a specific expense item.
                                                                      • Primary Key

                                                                      FND_ACFF_ConcatenatedStorage

                                                                      string

                                                                      Concatenated company flexfield.

                                                                      FND_ACFF_Delimiter

                                                                      string

                                                                      Delimiter used in a company flexfield.

                                                                      _FLEX_StructureInstanceCode

                                                                      string

                                                                      Chart of accounts code associated with the account combination.

                                                                      _FLEX_StructureInstanceId

                                                                      long

                                                                      Chart of accounts identifier associated with the account combination.

                                                                      _GL_5FGL_23_StructureInstanceNumber

                                                                      long

                                                                      Chart of accounts number associated with the account combination.

                                                                        Expense Cost Center Allocation

                                                                        Stores the amount charged to one or more cost centers for an expense item.

                                                                        QName: {http://xmlns.oracle.com/apps/financials/expenses/entry/shared/flex/costcenterkff/}CostCenterKff

                                                                        Relationships

                                                                        The following table describes how this service data object is related to other service data objects or business object services.

                                                                        Relationship Type Object or Service

                                                                        Contained by

                                                                        Expense Distribution

                                                                        Handled by

                                                                        Expense Item and Expense Report

                                                                        Attributes

                                                                        The following table describes attributes in the service data object.

                                                                        Name Type Description

                                                                        ExpenseDistId

                                                                        long

                                                                        Unique identifier of the expense distribution for a specific expense item.
                                                                        • Primary Key

                                                                        FND_ACFF_ConcatenatedStorage

                                                                        string

                                                                        Concatenated cost center flexfield.

                                                                        FND_ACFF_Delimiter

                                                                        string

                                                                        Delimiter used in a cost center flexfield.

                                                                        _FLEX_StructureInstanceCode

                                                                        string

                                                                        Chart of accounts code associated with the account combination.

                                                                        _FLEX_StructureInstanceId

                                                                        long

                                                                        Chart of accounts identifier associated with the account combination.

                                                                        _GL_5FGL_23_StructureInstanceNumber

                                                                        long

                                                                        Chart of accounts number associated with the account combination.

                                                                          Expense Descriptive Flexfield

                                                                          Stores company-specific additional information that is captured for an expense item.

                                                                          QName: {http://xmlns.oracle.com/apps/financials/expenses/entry/shared/flex/dff/}ExpenseDff

                                                                          Relationships

                                                                          The following table describes how this service data object is related to other service data objects or business object services.

                                                                          Relationship Type Object or Service

                                                                          Contained by

                                                                          Expense Item

                                                                          Handled by

                                                                          Expense Item and Expense Report

                                                                          Attributes

                                                                          The following table describes attributes in the service data object.

                                                                          Name Type Description

                                                                          ExpenseId

                                                                          long

                                                                          Unique identifier of a specific expense item.
                                                                          • Primary Key

                                                                          _FLEX_NumOfSegments

                                                                          int

                                                                          Number of segments in the descriptive flexfield for expense items.

                                                                          __FLEX_Context

                                                                          string

                                                                          Descriptive flexfield context that determines the segments displayed.

                                                                            Expense Distribution

                                                                            Stores the account and project distribution for an expense item. For example, the cost center or the projects to which the expense needs to be charged.

                                                                            QName: {http://xmlns.oracle.com/apps/financials/expenses/shared/common/expenseExternalService/}ExpenseDistribution

                                                                            Relationships

                                                                            The following table describes how this service data object is related to other service data objects or business object services.

                                                                            Relationship Type Object or Service

                                                                            Contains

                                                                            Project Expense Allocation

                                                                            Contains

                                                                            Expense Company Allocation

                                                                            Contains

                                                                            Expense Cost Center Allocation

                                                                            Contained by

                                                                            Expense Item

                                                                            Handled by

                                                                            Expense Item and Expense Report

                                                                            Attributes

                                                                            The following table describes attributes in the service data object.

                                                                            Name Type Description

                                                                            CodeCombinationId

                                                                            long

                                                                            The identifier of the account code combination to which the expense is charged.

                                                                            CompanyKFF

                                                                            Expense Company Allocation

                                                                            The key flexfield that captures the company to which the expense is charged.

                                                                            CostCenter

                                                                            string

                                                                            The cost center to which the expense is charged.

                                                                            CostCenterKFF

                                                                            Expense Cost Center Allocation

                                                                            The key flexfield that captures the cost center to which the expense is charged.

                                                                            ExpenseDistId

                                                                            long

                                                                            The identifier of the expense allocation for an expense.
                                                                            • Primary Key

                                                                            ExpenseId

                                                                            long

                                                                            The identifier of the expense.

                                                                            ExpenseReportId

                                                                            long

                                                                            The unique identifier of the expense report.

                                                                            ObjectVersionNumber

                                                                            int

                                                                            The versioning ability implemented for record locking. This number is incremented every time the record is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the record since it was queried.

                                                                            OrgId

                                                                            long

                                                                            The identifier of the business unit that is associated with the person named on the expense report.

                                                                            PJC_CONTEXT_CATEGORY

                                                                            string

                                                                            Project context, such as Expenses, for which project-specific information is provided.

                                                                            PJC_EXPENDITURE_ITEM_DATE

                                                                            {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                            The date of a project-related expense item.

                                                                            PJC_EXPENDITURE_TYPE_Id

                                                                            decimal

                                                                            The identifier of the project expense type.

                                                                            PJC_ORGANIZATION_Id

                                                                            decimal

                                                                            The identifier of the project business unit.

                                                                            PJC_PROJECT_Id

                                                                            decimal

                                                                            The identifier of the project descriptive flexfield for a project-related expense.

                                                                            PJC_TASK_Id

                                                                            decimal

                                                                            The identifier of the project task to which the expense is assigned.

                                                                            ProjectDFF

                                                                            Project Expense Allocation

                                                                            The descriptive flexfield that captures the project number, task number, and related information.

                                                                            ProjectNumber

                                                                            string

                                                                            The project number assigned to the expense.

                                                                            ReimbursableAmount

                                                                            {http://xmlns.oracle.com/adf/svc/types/}AmountType

                                                                            The amount reimbursable to the person named on the expense report.

                                                                            Segment1

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment10

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment11

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment12

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment13

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment14

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment15

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment16

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment17

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment18

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment19

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment2

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment20

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment21

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment22

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment23

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment24

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment25

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment26

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment27

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment28

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment29

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment3

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment30

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment4

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment5

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment6

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment7

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment8

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            Segment9

                                                                            string

                                                                            A segment of the key flexfield.

                                                                            TaskNumber

                                                                            string

                                                                            The task number assigned to the expense.

                                                                              Expense Item

                                                                              Stores a business expense incurred by an employee. For example, a stay at a hotel or a car rental on a business trip.

                                                                              QName: {http://xmlns.oracle.com/apps/financials/expenses/shared/common/expenseExternalService/}Expense

                                                                              Relationships

                                                                              The following table describes how this service data object is related to other service data objects or business object services.

                                                                              Relationship Type Object or Service

                                                                              Contains

                                                                              Expense Descriptive Flexfield

                                                                              Contains

                                                                              Expense Distribution

                                                                              Contained by

                                                                              Expense Report

                                                                              Handled by

                                                                              Expense Item and Expense Report

                                                                              Attributes

                                                                              The following table describes attributes in the service data object.

                                                                              Name Type Description

                                                                              AssignmentId

                                                                              long

                                                                              The unique identifier of the primary assignment of the person named on the expense report.

                                                                              CcPrepaidInvoiceId

                                                                              long

                                                                              The invoice identifier of the company pay corporate card transaction.

                                                                              CreditCardTrxnId

                                                                              long

                                                                              The identifier of the credit card transaction that is associated with the expense.

                                                                              DepartureLocationId

                                                                              long

                                                                              The identifier of the flight departure location.

                                                                              Description

                                                                              string

                                                                              The description of the expense.

                                                                              DestinationFrom

                                                                              string

                                                                              The departure location.

                                                                              DestinationTo

                                                                              string

                                                                              The arrival location.

                                                                              EmployeeDefaultCostCenter

                                                                              string

                                                                              The default cost center of the person named on the expense report.

                                                                              EndDate

                                                                              {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                              The end date of the expense.

                                                                              ExchangeRate

                                                                              decimal

                                                                              The exchange rate type used to retrieve the exchange rate of the expense.

                                                                              ExpenseCategoryCode

                                                                              string

                                                                              The expense category code, such as Business or Personal.

                                                                              ExpenseDFF

                                                                              Expense Descriptive Flexfield

                                                                              The descriptive flexfield values for the expense.

                                                                              ExpenseDistribution

                                                                              Expense Distribution

                                                                              The expense account distribution and the project distribution for the expense.

                                                                              ExpenseId

                                                                              long

                                                                              The unique identifier generated by the application for the expense item.
                                                                              • Primary Key

                                                                              ExpenseReportId

                                                                              long

                                                                              The unique identifier of the expense report.

                                                                              ExpenseSource

                                                                              string

                                                                              The source of the expense, such as cash or corporate card.

                                                                              ExpenseTemplateEntityId

                                                                              long

                                                                              The primary key identifier of the expense template.

                                                                              ExpenseTemplateId

                                                                              long

                                                                              The identifier of the expense report template.

                                                                              ExpenseTemplateName

                                                                              string

                                                                              The name of the expense template.

                                                                              ExpenseTypeCategoryCode

                                                                              string

                                                                              The expense type category code, such as Accommodations or Meals.

                                                                              ExpenseTypeEntityId

                                                                              long

                                                                              The primary key identifier for the expense type. The primary key identifier of the expense type.

                                                                              ExpenseTypeId

                                                                              long

                                                                              The identifier of the expense type.

                                                                              ExpenseTypeName

                                                                              string

                                                                              The expense type of the expense.

                                                                              FlightNumber

                                                                              string

                                                                              The flight number.

                                                                              FuncCurrencyAmount

                                                                              {http://xmlns.oracle.com/adf/svc/types/}AmountType

                                                                              The receipt amount of the expense in the functional currency of the business unit.

                                                                              ItemizationParentExpenseId

                                                                              long

                                                                              The unique identifier of the parent expense that is associated with the itemized expense.

                                                                              Justification

                                                                              string

                                                                              The justification for incurring the expense.

                                                                              JustificationRequiredFlag

                                                                              boolean

                                                                              Indicates whether the expense requires a justification.

                                                                              Location

                                                                              string

                                                                              The expense location.

                                                                              LocationId

                                                                              long

                                                                              The identifier of the expense location.

                                                                              MaskedCcNumber

                                                                              string

                                                                              Masked corporate card number that is obtained by scanning a transaction receipt for a cash expense.

                                                                              MerchantDocumentNumber

                                                                              string

                                                                              The receipt number provided by the merchant.

                                                                              MerchantName

                                                                              string

                                                                              The name of the merchant where the expense was incurred.

                                                                              MerchantReference

                                                                              string

                                                                              The reference number on the receipt that is provided by the merchant.

                                                                              MerchantTaxRegNumber

                                                                              string

                                                                              The tax registration number of the merchant where the expense was incurred.

                                                                              MerchantTaxpayerId

                                                                              string

                                                                              The taxpayer identifier of the merchant where the expense was incurred.

                                                                              ObjectVersionNumber

                                                                              int

                                                                              The versioning ability implemented for record locking. This number is incremented every time the record is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the record since it was queried. This version number is for the expense item record.

                                                                              ObjectVersionNumber1

                                                                              int

                                                                              The versioning ability implemented for record locking. This number is incremented every time the record is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the record since it was queried. This version number is for the expense type record used in the expense item.

                                                                              ObjectVersionNumber2

                                                                              int

                                                                              The versioning ability implemented for record locking. This number is incremented every time the record is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the record since it was queried. This version number is for the expense template record used in the expense item.

                                                                              OrgId

                                                                              long

                                                                              The identifier of the business unit that is associated with the person named on the expense report.

                                                                              OrigReimbursableAmount

                                                                              {http://xmlns.oracle.com/adf/svc/types/}AmountType

                                                                              The original amount reimbursable to the person named on the expense report before any adjustments are made.

                                                                              PersonId

                                                                              long

                                                                              The identifier of the person named on the expense report.

                                                                              PolicyViolatedFlag

                                                                              boolean

                                                                              Indicates whether the expense violated the company policies.

                                                                              PreparerId

                                                                              long

                                                                              The person identifier of the expense report preparer.

                                                                              ReceiptAmount

                                                                              {http://xmlns.oracle.com/adf/svc/types/}AmountType

                                                                              The receipt amount of the expense.

                                                                              ReceiptCurrencyCode

                                                                              string

                                                                              The currency code of the receipt amount.

                                                                              ReceiptMissingFlag

                                                                              boolean

                                                                              Indicates whether the expense report preparer specified that the receipt is missing.

                                                                              ReceiptRequiredFlag

                                                                              boolean

                                                                              Indicates whether a receipt is required for this expense.

                                                                              ReceiptVerifiedFlag

                                                                              boolean

                                                                              Indicates whether the receipt is verified by the auditor.

                                                                              ReimbursableAmount

                                                                              {http://xmlns.oracle.com/adf/svc/types/}AmountType

                                                                              The amount reimbursable to the person named on the expense report.

                                                                              ReimbursementCurrencyCode

                                                                              string

                                                                              The currency code of the reimbursable amount.

                                                                              StartDate

                                                                              {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                              The start date of the expense.

                                                                              TaxClassificationCode

                                                                              string

                                                                              The tax code associated with the expense.

                                                                              TicketClassCode

                                                                              string

                                                                              The class of the ticket, such as Business or Economy.

                                                                              TicketNumber

                                                                              string

                                                                              The flight ticket number.

                                                                              TravelType

                                                                              string

                                                                              The type of travel, such as domestic or international.

                                                                                Expense Report

                                                                                Stores the general information for an expense report, such as the report number, purpose of the report, and the person for whom the report is prepared.

                                                                                QName: {http://xmlns.oracle.com/apps/financials/expenses/shared/common/expenseExternalService/}ExpenseReport

                                                                                Relationships

                                                                                The following table describes how this service data object is related to other service data objects or business object services.

                                                                                Relationship Type Object or Service

                                                                                Contains

                                                                                Expense Report Descriptive Flexfield SDO

                                                                                Contains

                                                                                Expense Item

                                                                                Handled by

                                                                                Expense Item and Expense Report

                                                                                Attributes

                                                                                The following table describes attributes in the service data object.

                                                                                Name Type Description

                                                                                AssignmentId

                                                                                long

                                                                                The unique identifier of the primary assignment for the person named on the expense report.

                                                                                BothpayFlag

                                                                                boolean

                                                                                Indicates whether the expense report contains both pay corporate card transactions.

                                                                                CashExpensePaidDate

                                                                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                The date on which cash expenses are reimbursed to the person named on the expense report.

                                                                                CurrentApproverId

                                                                                long

                                                                                The identifier of the current approver for the expense report.

                                                                                ExchangeRateType

                                                                                string

                                                                                The exchange rate type used to retrieve the exchange rate for the expense.

                                                                                ExpReportProcessingId

                                                                                long

                                                                                The unique identifier of a specific instance of the expense report status and change date.

                                                                                Expense

                                                                                Expense Item

                                                                                The expense item included in an expense report.

                                                                                ExpenseHeaderDffVL

                                                                                Expense Report Descriptive Flexfield SDO

                                                                                The view link to the expense report header DFF.

                                                                                ExpenseReportDate

                                                                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                The date of the expense report.

                                                                                ExpenseReportId

                                                                                long

                                                                                The unique identifier of the expense report.
                                                                                • Primary Key

                                                                                ExpenseReportNumber

                                                                                string

                                                                                The number assigned to the expense report.

                                                                                ExpenseReportTotal

                                                                                decimal

                                                                                The total amount of the expense report.

                                                                                ExpenseStatusCode

                                                                                string

                                                                                The status of the expense report at a point in time.

                                                                                ExpenseStatusDate

                                                                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                The date on which the expense report obtained a specific status.

                                                                                ExportRejectCode

                                                                                string

                                                                                The reason the expense report is rejected by Oracle Fusion Payables.

                                                                                ExportRequestId

                                                                                long

                                                                                The identifier of the Oracle Fusion Payables process that creates documents payable for the expense report.

                                                                                FinalApprovalDate

                                                                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                The final approval date of the expense report.

                                                                                ObjectVersionNumber

                                                                                int

                                                                                The versioning ability implemented for record locking. This number is incremented every time the record is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the record since it was queried.

                                                                                OrgId

                                                                                long

                                                                                The identifier of the business unit for the person named on the expense report.

                                                                                OverrideApproverId

                                                                                long

                                                                                The person identifier of the overriding approver.

                                                                                ParentExpenseReportId

                                                                                long

                                                                                The identifier of an expense report that generates a related both pay corporate card issuer expense report.

                                                                                PaymentMethodCode

                                                                                string

                                                                                The payment method code selected for reimbursing the person named on the expense report.

                                                                                PersonId

                                                                                long

                                                                                The identifier of the person named on the expense report.

                                                                                PreparerId

                                                                                long

                                                                                The identifier of the person who submitted the expense report.

                                                                                Purpose

                                                                                string

                                                                                The purpose of the expense report.

                                                                                ReceiptsReceivedDate

                                                                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                The date on which the receipt is received.

                                                                                ReceiptsStatusCode

                                                                                string

                                                                                The receipt status of the expense report, such as Receipt Required and Receipt Missing.

                                                                                ReimbursementCurrencyCode

                                                                                string

                                                                                The currency code of the reimbursable amount.

                                                                                ReportSubmitDate

                                                                                {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                The expense report submission date.

                                                                                  Expense Report Descriptive Flexfield SDO

                                                                                  Stores company-specific additional information that is captured for an expense report.

                                                                                  QName: {http://xmlns.oracle.com/apps/flex/financials/expenses/entry/shared/flex/headerdff/}ExpenseHeaderDff

                                                                                  Relationships

                                                                                  The following table describes how this service data object is related to other service data objects or business object services.

                                                                                  Relationship Type Object or Service

                                                                                  Contained by

                                                                                  Expense Report

                                                                                  Handled by

                                                                                  Expense Item and Expense Report

                                                                                  Attributes

                                                                                  The following table describes attributes in the service data object.

                                                                                  Name Type Description

                                                                                  ExpenseReportId

                                                                                  long

                                                                                  Unique identifier of a specific expense report.
                                                                                  • Primary Key

                                                                                  _FLEX_NumOfSegments

                                                                                  int

                                                                                  Number of segments in the descriptive flexfield for expense reports.

                                                                                  __FLEX_Context

                                                                                  string

                                                                                  Descriptive flexfield context that determines the segments displayed.

                                                                                  __FLEX_Context_DisplayValue

                                                                                  string

                                                                                  Descriptive flexfield context segments display value.

                                                                                    Project Expense Allocation

                                                                                    Stores the amount charged to one or more projects and tasks for an expense item.

                                                                                    QName: {http://xmlns.oracle.com/apps/financials/expenses/entry/shared/flex/pjcdff/}PJCDFF

                                                                                    Relationships

                                                                                    The following table describes how this service data object is related to other service data objects or business object services.

                                                                                    Relationship Type Object or Service

                                                                                    Contained by

                                                                                    Expense Distribution

                                                                                    Handled by

                                                                                    Expense Item and Expense Report

                                                                                    Attributes

                                                                                    The following table describes attributes in the service data object.

                                                                                    Name Type Description

                                                                                    ExpenseDistId

                                                                                    long

                                                                                    Unique identifier of the expense distribution for a specific expense item.
                                                                                    • Primary Key

                                                                                    _FLEX_NumOfSegments

                                                                                    int

                                                                                    Number of segments in the descriptive flexfield for projects.

                                                                                    __FLEX_Context

                                                                                    string

                                                                                    Descriptive flexfield context that indicates the flexfield is for project capture.

                                                                                      External Bank Account

                                                                                      Service that creates or updates the external bank account details of the customer.

                                                                                      Life Cycle Status: Active

                                                                                      QName: {http://xmlns.oracle.com/apps/financials/payments/shared/bankAccounts/bankAccountServiceV2/}ExternalBankAccountService

                                                                                      Service WSDL URL: https://servername/fscmService/ExternalBankAccountServiceV2?WSDL

                                                                                      Relationships

                                                                                      The following table describes how this service data object is related to other service data objects or business object services.

                                                                                      Operations

                                                                                      confirmBankAccountExistence

                                                                                      An operation that confirms whether the bank account already exists.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Element Name Type Description

                                                                                      bankId

                                                                                      string

                                                                                      A parameter that specifies the bank identifier that confirms the existence of the bank account.

                                                                                      branchId

                                                                                      decimal

                                                                                      A parameter that specifies the branch identifier that confirms the existence of the bank account.

                                                                                      bankAccountNumber

                                                                                      string

                                                                                      A parameter that specifies the bank account number that confirms the existence of the bank account.

                                                                                      accountName

                                                                                      string

                                                                                      A parameter that specifies the bank account name that confirms the existence of the bank account.

                                                                                      currency

                                                                                      string

                                                                                      A parameter that specifies the currency code that confirms the existence of the bank account.

                                                                                      countryCode

                                                                                      string

                                                                                      A parameter that specifies the country code of the bank account that confirms the existence of the bank account.

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      long

                                                                                      A parameter that returns the bank account identifier that confirms the existence of the bank account.

                                                                                      getExternalBankAccountOwnerRemote

                                                                                      An operation that retrieves the external bank account owner details.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Element Name Type Description

                                                                                      accountOwnerId

                                                                                      long

                                                                                      A parameter that specifies the account owner identifier of the external bank account owner to be retrieved.

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      External Bank Account Owner

                                                                                      A parameter that returns the external bank account owner that matches the account owner.

                                                                                      findExternalBankAccountOwnerRemote

                                                                                      An operation that searches for the remote external bank account owner using specified criteria.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Element Name Type Description

                                                                                      findCriteria

                                                                                      {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                                      A parameter that specifies the search criteria for the remote external bank account owner and the maximum records returned at a time.

                                                                                      findControl

                                                                                      {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                                      A parameter that controls the search for the remote external bank account owner.

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      External Bank Account Owner

                                                                                      A parameter that returns the remote external bank account owner that satisfies the search criteria.

                                                                                      getIntermediaryBankAccountRemote

                                                                                      An operation that retrieves a specific remote intermediary bank account.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Element Name Type Description

                                                                                      intermediaryAccountId

                                                                                      long

                                                                                      A parameter that specifies the identifier for the remote intermediary bank account to be retrieved.

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      Intermediary Bank Account Owner

                                                                                      A parameter that returns the remote intermediary bank account that matches the intermediary bank account identifier.

                                                                                      findIntermediaryBankAccountRemote

                                                                                      An operation that searches a remote intermediary bank account using specified criteria.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Element Name Type Description

                                                                                      findCriteria

                                                                                      {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                                      A parameter that specifies the search criteria for remote intermediary bank accounts and the maximum records returned at a time.

                                                                                      findControl

                                                                                      {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                                      A parameter that controls the search for a remote intermediary bank account.

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      Intermediary Bank Account Owner

                                                                                      A parameter that returns the remote intermediary bank account that satisfies the search criteria.

                                                                                      getExternalBankAccountDetails

                                                                                      An operation that retrieves a specific external bank account.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Element Name Type Description

                                                                                      externalBankAccountId

                                                                                      long

                                                                                      A parameter that specifies the identifier of the external bank account to be retrieved.

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      External Bank Account

                                                                                      A parameter that returns the external bank account details that matches the external bank account identifier.

                                                                                      processExternalBankAccount

                                                                                      An operation that creates or updates an external bank account of the supplier or customer.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Element Name Type Description

                                                                                      externalBankAccount

                                                                                      External Bank Account

                                                                                      A parameter that specifies the external bank account that is to be created or updated.

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      External Bank Account

                                                                                      A parameter that returns the newly created or updated external bank account.

                                                                                      findExternalBankAccount

                                                                                      An operation that searches for external bank accounts using specified criteria.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Element Name Type Description

                                                                                      findCriteria

                                                                                      {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                                      A parameter that specifies the search criteria for external bank accounts and the maximum records returned at a time.

                                                                                      findControl

                                                                                      {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                                      A parameter that controls the search for external bank accounts.

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      External Bank Account

                                                                                      A parameter that returns the external bank account.

                                                                                      getDfltObjAttrHints

                                                                                      An operation that retrieves the default object attribute hints.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Element Name Type Description

                                                                                      viewName

                                                                                      string

                                                                                      A parameter that specifies the name of the view for the default object attribute hints to be retrieved.

                                                                                      localeName

                                                                                      string

                                                                                      A parameter that specifies the locale name of the view for the default object attribute hints to be retrieved.

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      {http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

                                                                                      A parameter that returns the default object attribute hints that matches the view and local name.

                                                                                      getServiceLastUpdateTime

                                                                                      An operation that retrieves the last update time of the service.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                      A parameter that returns the last update time of the service.

                                                                                      getEntityList

                                                                                      An operation that retrieves the entity list.

                                                                                      Life Cycle Status: Active

                                                                                      Request Payload

                                                                                      Response Payload

                                                                                      Element Name Type Description

                                                                                      result

                                                                                      {http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

                                                                                      A parameter that returns the entity list.

                                                                                      Security

                                                                                      The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

                                                                                      Service Operations to Privileges Mapping

                                                                                      Operation Name Privilege Code Privilege Name Privilege Description

                                                                                      All Operations

                                                                                      IBY_MANAGE_EXTERNAL_PAYER_PAYMENT_DETAILS_PRIV

                                                                                      Manage External Payer Payment Details

                                                                                      Allows management of payer payment details.

                                                                                      All Operations

                                                                                      IBY_MANAGE_THIRD_PARTY_BANK_ACCOUNT_PRIV

                                                                                      Manage Third Party Bank Account

                                                                                      Allows update of external bank accounts.

                                                                                      Privileges to Duty Roles Mapping

                                                                                      Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

                                                                                      IBY_MANAGE_THIRD_PARTY_BANK_ACCOUNT_PRIV

                                                                                      ORA_IBY_PAYEE_BANK_ACCOUNT_MANAGEMENT_DUTY

                                                                                      Payee Bank Account Management

                                                                                      Manages supplier bank accounts and other payment details.

                                                                                      IBY_MANAGE_THIRD_PARTY_BANK_ACCOUNT_PRIV

                                                                                      ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY

                                                                                      Customer Payment Instrument Management

                                                                                      Manages customer bank accounts and credit cards and other payment details.

                                                                                      IBY_MANAGE_EXTERNAL_PAYER_PAYMENT_DETAILS_PRIV

                                                                                      ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY

                                                                                      Customer Payment Instrument Management

                                                                                      Manages customer bank accounts and credit cards and other payment details.

                                                                                      Duty Roles to Duty or Job Roles Mapping

                                                                                      Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

                                                                                      ORA_IBY_PAYEE_BANK_ACCOUNT_MANAGEMENT_DUTY

                                                                                      ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

                                                                                      FSCM Load Interface Administration

                                                                                      Manages load interface file for import

                                                                                        External Bank Account Owner

                                                                                        Stores the details of the external bank account owner.

                                                                                        QName: {http://xmlns.oracle.com/apps/financials/payments/shared/bankAccounts/bankAccountServiceV2/}ExternalBankAccountOwner

                                                                                        Relationships

                                                                                        The following table describes how this service data object is related to other service data objects or business object services.

                                                                                        Relationship Type Object or Service

                                                                                        Contained by

                                                                                        External Bank Account

                                                                                        Handled by

                                                                                        External Payer

                                                                                        Handled by

                                                                                        External Bank Account

                                                                                        Attributes

                                                                                        The following table describes attributes in the service data object.

                                                                                        Name Type Description

                                                                                        AccountOwnerId

                                                                                        long

                                                                                        Identifier of the bank account owner.
                                                                                        • Primary Key

                                                                                        AccountOwnerPartyId

                                                                                        long

                                                                                        Identifier of the bank account owner who is associated with the external bank account.

                                                                                        CreatedBy

                                                                                        string

                                                                                        User who created the record.

                                                                                        CreationDate

                                                                                        {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                        Date and time of the record creation.

                                                                                        EndDate

                                                                                        {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                        Date when the bank account becomes inactive.

                                                                                        EndDateDisp

                                                                                        {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                        Displayed end date associated with the external bank account.

                                                                                        ExternalBankAccountId

                                                                                        long

                                                                                        Identifier of the external bank account.

                                                                                        LastUpdateDate

                                                                                        {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                        Date and time of the last record update.

                                                                                        LastUpdateLogin

                                                                                        string

                                                                                        The session login associated with the user who last updated the record.

                                                                                        LastUpdatedBy

                                                                                        string

                                                                                        User who last updated the record.

                                                                                        ObjectVersionNumber

                                                                                        int

                                                                                        Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

                                                                                        PartyId

                                                                                        long

                                                                                        Trading Community Hierarchy (TCA) party identifier of the external bank account owner.

                                                                                        PartyName

                                                                                        string

                                                                                        Name of the bank account owner of the external bank account.

                                                                                        PartyNameAlt

                                                                                        string

                                                                                        Alternate party name of the external bank account owner.

                                                                                        PartyNameId

                                                                                        long

                                                                                        Party name identifier of the external bank account owner.

                                                                                        PartyNameType

                                                                                        string

                                                                                        Party name type of the external bank account owner.

                                                                                        PrimaryFlag

                                                                                        boolean

                                                                                        Indicates whether the external bank account is the primary default bank account.

                                                                                        StartDate

                                                                                        {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                        Date when the bank account becomes active.

                                                                                          External Bank Account

                                                                                          Stores the details of the external bank account.

                                                                                          QName: {http://xmlns.oracle.com/apps/financials/payments/shared/bankAccounts/bankAccountServiceV2/}ExternalBankAccount

                                                                                          Relationships

                                                                                          The following table describes how this service data object is related to other service data objects or business object services.

                                                                                          Relationship Type Object or Service

                                                                                          Contains

                                                                                          Intermediary Bank Account Owner SDO

                                                                                          Contains

                                                                                          External Bank Account SDO

                                                                                          Contains

                                                                                          External Bank Account Owner SDO

                                                                                          Contained by

                                                                                          Bank Account Assignment

                                                                                          Handled by

                                                                                          External Payer

                                                                                          Handled by

                                                                                          External Bank Account

                                                                                          Attributes

                                                                                          The following table describes attributes in the service data object.

                                                                                          Name Type Description

                                                                                          AccountClassification

                                                                                          string

                                                                                          This column is no longer in use.

                                                                                          AccountSuffix

                                                                                          string

                                                                                          Suffix used for the bank account.

                                                                                          AgencyLocationCode

                                                                                          string

                                                                                          A code assigned by a company's Treasury Financial Management Service (FMS) that is used exclusively for Treasury reporting purposes. The agency location code identifies the source of financial transactions, such as an agency, bureau, or other reporting entity.

                                                                                          BAMaskSetting

                                                                                          string

                                                                                          Current bank account masking setting. Values taken from lookup IBY_INSTRUMENT_MASK_SETTING.

                                                                                          BAUnmaskLength

                                                                                          int

                                                                                          Number of digits to expose in the masking of the external bank account.

                                                                                          BankAccountName

                                                                                          string

                                                                                          Name of bank account.

                                                                                          BankAccountNameAlt

                                                                                          string

                                                                                          Internal alternate name of the supplier's bank account.

                                                                                          BankAccountNumber

                                                                                          string

                                                                                          Number of the bank account.

                                                                                          BankAccountNumberElectronic

                                                                                          string

                                                                                          This column is no longer in use.

                                                                                          BankAccountType

                                                                                          string

                                                                                          Type of bank account, such as savings or checking.

                                                                                          BankBranchName

                                                                                          string

                                                                                          Name of the bank branch.

                                                                                          BankId

                                                                                          long

                                                                                          Identifier of the bank to which the bank branch belongs.

                                                                                          BankName

                                                                                          string

                                                                                          Name of the bank.

                                                                                          BankNumber

                                                                                          string

                                                                                          Unique number that identifies a bank.

                                                                                          BankPartyId

                                                                                          long

                                                                                          Trading Community Hierarchy (TCA) party identifier of the bank associated with the bank account.

                                                                                          BranchId

                                                                                          long

                                                                                          Identifier of the bank branch to which this bank account belongs.

                                                                                          BranchNumber

                                                                                          string

                                                                                          The number assigned to the bank branch by the banking authority.

                                                                                          BranchPartyId

                                                                                          long

                                                                                          Trading Community Hierarchy (TCA) party identifier of the bank branch associated with the bank account.

                                                                                          CheckDigits

                                                                                          string

                                                                                          A single digit used to validate an identifier.

                                                                                          CountryCode

                                                                                          string

                                                                                          Country code of the bank account.

                                                                                          CreatedBy

                                                                                          string

                                                                                          User who created the record.

                                                                                          CreationDate

                                                                                          {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                          Date and time of the record creation.

                                                                                          CurrencyCode

                                                                                          string

                                                                                          The three-letter ISO code associated with a currency.

                                                                                          Description

                                                                                          string

                                                                                          Internal description of the supplier's bank account.

                                                                                          EFTSWIFTCode

                                                                                          string

                                                                                          An electronic fund transfer SWIFT (Society for Worldwide Interbank Financial Telecommunication) code.

                                                                                          EndDate

                                                                                          {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                          Date when the bank account becomes inactive.

                                                                                          EndDateDisp

                                                                                          {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                          Date when the bank account becomes inactive

                                                                                          EndId

                                                                                          long

                                                                                          This column is no longer in use.

                                                                                          ExchangeRate

                                                                                          decimal

                                                                                          The ratio used to convert the principal unit of one currency into another currency.

                                                                                          ExchangeRateAgreementNumber

                                                                                          string

                                                                                          Identifier of the exchange rate agreement between the supplier and the supplier's bank.

                                                                                          ExchangeRateAgreementType

                                                                                          string

                                                                                          Type of agreement that specifies the exchange rate. Values are validated against the lookup IBY_XCHG_RATE_AGREEMENT.

                                                                                          ExtBankAcctDffVLA

                                                                                          External Bank Account

                                                                                          External bank account descriptive flexfield.

                                                                                          ExternalBankAccountId

                                                                                          long

                                                                                          Identifier of the external bank account.
                                                                                          • Primary Key

                                                                                          ExternalBankAccountOwner

                                                                                          External Bank Account Owner

                                                                                          Owner of the external bank account.

                                                                                          ForeignPaymentUseFlag

                                                                                          boolean

                                                                                          Indicates whether this bank account can be used for foreign payments or domestic payments.

                                                                                          HedgingContractReference

                                                                                          string

                                                                                          Identifier of the agreement between supplier and supplier's bank that specifies the hedging details.

                                                                                          IBAN

                                                                                          string

                                                                                          An alphanumeric sequence that conforms to the ISO standard for uniquely identifying a bank account number internationally. The standard IBAN carries all the routing information needed to get a payment from one bank to another.

                                                                                          IntermediaryBankAccount

                                                                                          Intermediary Bank Account Owner

                                                                                          An intermediary account that is used to transfer funds between the originator's bank and the beneficiary's bank.

                                                                                          LastUpdateDate

                                                                                          {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                          Date and time of the last record update.

                                                                                          LastUpdateLogin

                                                                                          string

                                                                                          The session login associated with the user who last updated the record.

                                                                                          LastUpdatedBy

                                                                                          string

                                                                                          User who last updated the record.

                                                                                          MaskedBankAccountNumber

                                                                                          string

                                                                                          Partially or completely concealed digits of a bank account number that are used for display purposes.

                                                                                          MaskedIBAN

                                                                                          string

                                                                                          Partially or completely concealed digits of an IBAN value that are used for display purposes.

                                                                                          Name

                                                                                          string

                                                                                          The name of the supplier bank account.

                                                                                          ObjectVersionNumber

                                                                                          int

                                                                                          Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

                                                                                          PaymentFactorFlag

                                                                                          boolean

                                                                                          Indicates whether this is a payment factor bank account.

                                                                                          SecondaryAccountReference

                                                                                          string

                                                                                          Additional account number reference information, such as a building society roll number.

                                                                                          ShortAccountName

                                                                                          string

                                                                                          Short account name of the supplier's bank account.

                                                                                          StartDate

                                                                                          {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                          Date when the bank account becomes active.

                                                                                          StartId

                                                                                          long

                                                                                          This column is no longer in use.

                                                                                          TerritoryCode

                                                                                          string

                                                                                          This column is no longer in use.

                                                                                          TerritoryShortName

                                                                                          string

                                                                                          This column is no longer in use.

                                                                                            External Bank Account

                                                                                            Stores the details of the external bank account.

                                                                                            QName: {http://xmlns.oracle.com/apps/financials/payments/shared/bankAccounts/flex/bankAccountDff/}ExternalBankAccount

                                                                                            Relationships

                                                                                            The following table describes how this service data object is related to other service data objects or business object services.

                                                                                            Relationship Type Object or Service

                                                                                            Contained by

                                                                                            External Bank Account

                                                                                            Handled by

                                                                                            External Payer

                                                                                            Handled by

                                                                                            External Bank Account

                                                                                            Attributes

                                                                                            The following table describes attributes in the service data object.

                                                                                            Name Type Description

                                                                                            ExtBankAccountId

                                                                                            long

                                                                                            Identifier of the external bank account.
                                                                                            • Primary Key

                                                                                            _FLEX_NumOfSegments

                                                                                            int

                                                                                            Number of segments in the descriptive flexfield for an external bank account.

                                                                                            _FLEX_ValidationDate

                                                                                            {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                            Date the descriptive flexfield was created or updated.

                                                                                            __FLEX_Context

                                                                                            string

                                                                                            Context of the descriptive flexfield. The context indicates the flexfield is for an external bank account.

                                                                                              Intermediary Bank Account Owner

                                                                                              Stores the details of the intermediary bank account.

                                                                                              QName: {http://xmlns.oracle.com/apps/financials/payments/shared/bankAccounts/bankAccountServiceV2/}IntermediaryBankAccount

                                                                                              Relationships

                                                                                              The following table describes how this service data object is related to other service data objects or business object services.

                                                                                              Relationship Type Object or Service

                                                                                              Contained by

                                                                                              External Bank Account

                                                                                              Handled by

                                                                                              External Payer

                                                                                              Handled by

                                                                                              External Bank Account

                                                                                              Attributes

                                                                                              The following table describes attributes in the service data object.

                                                                                              Name Type Description

                                                                                              AccountNumber

                                                                                              string

                                                                                              Number of the bank account.

                                                                                              BIC

                                                                                              string

                                                                                              The identifier code used by SWIFT to identify a bank or bank branch. The BIC is a universal method of identifying financial institutions to facilitate the automated processing of telecommunication messages in banking and related financial environments.

                                                                                              BankAccountId

                                                                                              long

                                                                                              Identifier of the intermediary bank account.

                                                                                              BankCode

                                                                                              string

                                                                                              Short code for the bank. The bank code can be different depending on the country of the bank branch. For example, if the country is US, then bank codes can be CH or FW. Bank codes are validated against lookup type BANK_CODE.

                                                                                              BankName

                                                                                              string

                                                                                              Name of the bank.

                                                                                              BranchNumber

                                                                                              string

                                                                                              Number of the bank branch.

                                                                                              CheckDigits

                                                                                              string

                                                                                              Bank account check digits.

                                                                                              City

                                                                                              string

                                                                                              City of the intermediary bank account.

                                                                                              Comments

                                                                                              string

                                                                                              Comments related to the intermediary bank account owner.

                                                                                              CountryCode

                                                                                              string

                                                                                              The standard two-character code used to represent each country.

                                                                                              CreatedBy

                                                                                              string

                                                                                              User who created the record.

                                                                                              CreationDate

                                                                                              {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                              Date and time of the record creation.

                                                                                              IBAN

                                                                                              string

                                                                                              An alphanumeric sequence that conforms to the ISO standard for uniquely identifying a bank account number internationally. The standard IBAN carries all the routing information needed to get a payment from one bank to another, wherever it may be.

                                                                                              IntermediaryAccountId

                                                                                              long

                                                                                              Identifier of the intermediary account.
                                                                                              • Primary Key

                                                                                              InternalBankAccountId

                                                                                              long

                                                                                              Identifier of the internal bank account.

                                                                                              LastUpdateDate

                                                                                              {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                              Date and time of the last record update.

                                                                                              LastUpdateLogin

                                                                                              string

                                                                                              The session login associated with the user who last updated the record.

                                                                                              LastUpdatedBy

                                                                                              string

                                                                                              User who last updated the record.

                                                                                              ObjectVersionNumber

                                                                                              int

                                                                                              Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

                                                                                              TerritoryCode

                                                                                              string

                                                                                              This column is no longer in use.

                                                                                              TerritoryShortName

                                                                                              string

                                                                                              This column is no longer in use.

                                                                                                External Cash Transaction

                                                                                                The cash management service used to create, update, and query transactions related to cash activity that was not recorded within the application. For example, transactions created from bank statement lines for bank charges, interests, fees, or other third party transactions.

                                                                                                Life Cycle Status: Active

                                                                                                QName: {http://xmlns.oracle.com/apps/financials/cashManagement/cashTransactions/service/}ExternalTransactionServiceService

                                                                                                Service WSDL URL: https://servername/fscmService/ExternalTransactionServiceService?WSDL

                                                                                                Relationships

                                                                                                The following table describes how this service data object is related to other service data objects or business object services.

                                                                                                Relationship Type Object or Service

                                                                                                Handles

                                                                                                External Cash Transactions SDO

                                                                                                Operations

                                                                                                getExternalTransaction

                                                                                                The service method to get the external transaction SDO based on the primary key.

                                                                                                Life Cycle Status: Active

                                                                                                Request Payload

                                                                                                Element Name Type Description

                                                                                                externalTransactionId

                                                                                                long

                                                                                                The service method parameter for the primary key external transaction ID.

                                                                                                Response Payload

                                                                                                Element Name Type Description

                                                                                                result

                                                                                                {http://xmlns.oracle.com/apps/financials/cashManagement/cashTransactions/service/}ExternalTransactionsVOSDOResult

                                                                                                The external transaction SDO that is returned by the service method.

                                                                                                createExternalTransaction

                                                                                                The service method to create a new external transaction record in the application.

                                                                                                Life Cycle Status: Active

                                                                                                Request Payload

                                                                                                Element Name Type Description

                                                                                                externalTransactions1

                                                                                                External Cash Transactions

                                                                                                The external transaction SDO parameter that contains the new external transaction to be created.

                                                                                                Response Payload

                                                                                                Element Name Type Description

                                                                                                result

                                                                                                {http://xmlns.oracle.com/apps/financials/cashManagement/cashTransactions/service/}ExternalTransactionsVOSDOResult

                                                                                                The external transaction SDO parameter that contains the newly created external transaction.

                                                                                                updateExternalTransaction

                                                                                                The service method to update an existing external transaction record.

                                                                                                Life Cycle Status: Active

                                                                                                Request Payload

                                                                                                Element Name Type Description

                                                                                                externalTransactions1

                                                                                                External Cash Transactions

                                                                                                The external transaction SDO parameter that contains the external transaction to be updated.

                                                                                                Response Payload

                                                                                                Element Name Type Description

                                                                                                result

                                                                                                {http://xmlns.oracle.com/apps/financials/cashManagement/cashTransactions/service/}ExternalTransactionsVOSDOResult

                                                                                                The external transaction SDO parameter that contains the updated external transaction.

                                                                                                findExternalTransactions

                                                                                                The service method to find external transactions for the given criteria.

                                                                                                Life Cycle Status: Active

                                                                                                Request Payload

                                                                                                Element Name Type Description

                                                                                                findCriteria

                                                                                                {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                                                The criteria used to limit your query results, such as the and the fetch size.

                                                                                                findControl

                                                                                                {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                                                Find control.

                                                                                                Response Payload

                                                                                                Element Name Type Description

                                                                                                result

                                                                                                External Cash Transactions

                                                                                                The list of matching external transaction SDOs returned for the given criteria.

                                                                                                findExternalTransactionFindByTransactionId

                                                                                                The service method to find an external transaction for a given transaction number.

                                                                                                Life Cycle Status: Active

                                                                                                Request Payload

                                                                                                Element Name Type Description

                                                                                                findCriteria

                                                                                                {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                                                The criteria used to limit your query results, such as the and the fetch size.

                                                                                                transactionId

                                                                                                long

                                                                                                The transaction ID parameter of the external cash transaction.

                                                                                                findControl

                                                                                                {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                                                Find control.

                                                                                                Response Payload

                                                                                                Element Name Type Description

                                                                                                result

                                                                                                External Cash Transactions

                                                                                                The external transaction SDO returned by the method.

                                                                                                getDfltObjAttrHints

                                                                                                The service method that returns the UI hints for a given service data object and its attributes.

                                                                                                Life Cycle Status: Active

                                                                                                Request Payload

                                                                                                Element Name Type Description

                                                                                                viewName

                                                                                                string

                                                                                                The view name parameter of the service method.

                                                                                                localeName

                                                                                                string

                                                                                                The locale name parameter of the service method.

                                                                                                Response Payload

                                                                                                Element Name Type Description

                                                                                                result

                                                                                                {http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

                                                                                                The list of service data object attribute hints returned by the method.

                                                                                                getServiceLastUpdateTime

                                                                                                The service method that returns the last date and time when the service was updated.

                                                                                                Life Cycle Status: Active

                                                                                                Request Payload

                                                                                                Response Payload

                                                                                                Element Name Type Description

                                                                                                result

                                                                                                {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                                The last updated time stamp of the service.

                                                                                                getEntityList

                                                                                                The service method that returns a list of service data objects defined on the service interface.

                                                                                                Life Cycle Status: Active

                                                                                                Request Payload

                                                                                                Response Payload

                                                                                                Element Name Type Description

                                                                                                result

                                                                                                {http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

                                                                                                The list of service data objects defined on the service.

                                                                                                Security

                                                                                                The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

                                                                                                Service Operations to Privileges Mapping

                                                                                                Operation Name Privilege Code Privilege Name Privilege Description

                                                                                                All Operations

                                                                                                CE_MANAGE_EXTERNAL_CASH_TRANSACTION_PRIV

                                                                                                Manage External Cash Transaction

                                                                                                Allows create, review, update, and delete of external cash transactions.

                                                                                                Privileges to Duty Roles Mapping

                                                                                                Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

                                                                                                CE_MANAGE_EXTERNAL_CASH_TRANSACTION_PRIV

                                                                                                ORA_CE_BANK_STATEMENT_AND_RECONCILIATION_DUTY

                                                                                                Bank Statement and Reconciliation

                                                                                                Reconciles bank statements and transactions. Also manages setup information for bank statement processing and reconciliation.

                                                                                                CE_MANAGE_EXTERNAL_CASH_TRANSACTION_PRIV

                                                                                                ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

                                                                                                Cash Positioning and Forecasting Management

                                                                                                Manages cash positioning and forecasting

                                                                                                Duty Roles to Duty or Job Roles Mapping

                                                                                                Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

                                                                                                ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

                                                                                                ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

                                                                                                Customer Account Inquiry

                                                                                                View customer account details.

                                                                                                ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

                                                                                                ORA_IBY_DISBURSEMENT_DATA_MANAGEMENT_DUTY

                                                                                                Disbursement Data Management

                                                                                                Manages supplier payments, customer refunds, and employee expense payments.

                                                                                                ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

                                                                                                ORA_IBY_DISBURSEMENT_PROCESS_MANAGEMENT_DUTY

                                                                                                Disbursement Process Management

                                                                                                Assigns payment process attributes to documents payable, resolves document and payment validation errors, and reviews proposed payments. Views items that were rejected or removed from a payment process request.

                                                                                                ORA_CE_BANK_STATEMENT_AND_RECONCILIATION_DUTY

                                                                                                ORA_XLA_SUBLEDGER_ACCOUNTING_MANAGER_DUTY

                                                                                                Subledger Accounting Manager

                                                                                                Creates accounting for transactions, reviews journal entries, and runs account analysis, journal entries, and period close exceptions reports.

                                                                                                ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

                                                                                                ORA_XLA_SUBLEDGER_ACCOUNTING_MANAGER_DUTY

                                                                                                Subledger Accounting Manager

                                                                                                Creates accounting for transactions, reviews journal entries, and runs account analysis, journal entries, and period close exceptions reports.

                                                                                                ORA_CE_BANK_STATEMENT_AND_RECONCILIATION_DUTY

                                                                                                ORA_XLA_SUBLEDGER_ACCOUNTING_REPORTING_DUTY

                                                                                                Subledger Accounting Reporting

                                                                                                Runs all subledger accounting reports, and reviews journal entries.

                                                                                                ORA_CE_CASH_POSITION_AND_FORECAST_MANAGEMENT_DUTY

                                                                                                ORA_XLA_SUBLEDGER_ACCOUNTING_REPORTING_DUTY

                                                                                                Subledger Accounting Reporting

                                                                                                Runs all subledger accounting reports, and reviews journal entries.

                                                                                                  External Cash Transactions

                                                                                                  The Oracle Fusion Cash Management transactions related to cash activity that was not recorded within the application. For example, transactions created from bank statement lines for bank charges.

                                                                                                  QName: {http://xmlns.oracle.com/apps/financials/cashManagement/cashTransactions/service/}ExternalTransactionsVOSDO

                                                                                                  Relationships

                                                                                                  The following table describes how this service data object is related to other service data objects or business object services.

                                                                                                  Relationship Type Object or Service

                                                                                                  Handled by

                                                                                                  External Cash Transaction

                                                                                                  Attributes

                                                                                                  The following table describes attributes in the service data object.

                                                                                                  Name Type Description

                                                                                                  AccountingFlag

                                                                                                  boolean

                                                                                                  Indicates if accounting should be enabled for the external transaction.

                                                                                                  Amount

                                                                                                  {http://xmlns.oracle.com/adf/svc/types/}AmountType

                                                                                                  The transaction amount of the external transaction.

                                                                                                  AssetCcid

                                                                                                  long

                                                                                                  The Asset GL Account ID of the external transaction.

                                                                                                  Attribute1

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute10

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute11

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute12

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute13

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute14

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute15

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute2

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute3

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute4

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute5

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute6

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute7

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute8

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  Attribute9

                                                                                                  string

                                                                                                  The descriptive flexfield attribute of the external transaction.

                                                                                                  AttributeCategory

                                                                                                  string

                                                                                                  The descriptive flexfield attribute category of the external transaction.

                                                                                                  AttributeDate1

                                                                                                  {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                  Descriptive flex field attribute

                                                                                                  AttributeDate2

                                                                                                  {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                  Descriptive flex field attribute

                                                                                                  AttributeDate3

                                                                                                  {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                  Descriptive flex field attribute

                                                                                                  AttributeDate4

                                                                                                  {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                  Descriptive flex field attribute

                                                                                                  AttributeDate5

                                                                                                  {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                  Descriptive flex field attribute

                                                                                                  AttributeNumber1

                                                                                                  decimal

                                                                                                  Descriptive flex field attribute

                                                                                                  AttributeNumber2

                                                                                                  decimal

                                                                                                  Descriptive flex field attribute

                                                                                                  AttributeNumber3

                                                                                                  decimal

                                                                                                  Descriptive flex field attribute

                                                                                                  AttributeNumber4

                                                                                                  decimal

                                                                                                  Descriptive flex field attribute

                                                                                                  AttributeNumber5

                                                                                                  decimal

                                                                                                  Descriptive flex field attribute

                                                                                                  BankAccountId

                                                                                                  long

                                                                                                  The bank account ID of the external transaction.

                                                                                                  BusinessUnitId

                                                                                                  long

                                                                                                  The business unit ID of the external transaction.

                                                                                                  ClearedDate

                                                                                                  {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                  The transaction cleared date of the external transaction.

                                                                                                  CurrencyCode

                                                                                                  string

                                                                                                  The currency code of the transaction amount entered for the external transaction.

                                                                                                  Description

                                                                                                  string

                                                                                                  The transaction description of the external transaction.

                                                                                                  ExternalTransactionId

                                                                                                  long

                                                                                                  The unique primary key for the external transaction generated by the application.
                                                                                                  • Primary Key

                                                                                                  LegalEntityId

                                                                                                  long

                                                                                                  The legal entity ID of the external transaction.

                                                                                                  ObjectVersionNumber

                                                                                                  int

                                                                                                  The attribute tracking the number of updates to the record which is automatically updated.

                                                                                                  OffsetCcid

                                                                                                  long

                                                                                                  The Offset GL Account ID of the external transaction.

                                                                                                  ReconHistoryId

                                                                                                  long

                                                                                                  The transaction reconciliation history ID of the external transaction.

                                                                                                  ReferenceText

                                                                                                  string

                                                                                                  The transaction reference of the external transaction.

                                                                                                  Source

                                                                                                  string

                                                                                                  he transaction source of the external transaction. Valid values are Imported, Manual, Bank Statement, and Ad Hoc Payments.

                                                                                                  StatementLineId

                                                                                                  long

                                                                                                  The bank statement line ID that generated the external transaction.

                                                                                                  Status

                                                                                                  string

                                                                                                  The external transaction status. Valid values are Reconciled, Unreconciled, and Voided.

                                                                                                  TransactionDate

                                                                                                  {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                  The transaction date of the external transaction.

                                                                                                  TransactionId

                                                                                                  long

                                                                                                  The sequential number of the external transaction.

                                                                                                  TransactionType

                                                                                                  string

                                                                                                  The transaction type of the external transaction. Valid values are Fee, Check, Interest, and Electronic Funds Transfer (EFT).

                                                                                                  ValueDate

                                                                                                  {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                  The value date of the external transaction.

                                                                                                    External Payer

                                                                                                    Service that creates or updates payer and payment instrument assignment.

                                                                                                    Life Cycle Status: Active

                                                                                                    QName: {http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/externalPayerServiceV2/}PayerDetailService

                                                                                                    Service WSDL URL: https://servername/fscmService/PayerDetailServiceV2?WSDL

                                                                                                    Relationships

                                                                                                    The following table describes how this service data object is related to other service data objects or business object services.

                                                                                                    Operations

                                                                                                    processPayerPaymentCard

                                                                                                    An operation that assigns the payment card.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Element Name Type Description

                                                                                                    payer

                                                                                                    External Payer

                                                                                                    A parameter that specifies the external payer.

                                                                                                    creditCard

                                                                                                    Credit Card

                                                                                                    A parameter that specifies the credit card.

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    Credit Card Assignment

                                                                                                    A parameter that returns the credit card assignment.

                                                                                                    findAssignedInstrumentsByPayer

                                                                                                    An operation that searches for assigned instruments by payer using specified criteria.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Element Name Type Description

                                                                                                    partyId

                                                                                                    long

                                                                                                    A parameter that specifies the party identifier for searching the instrument assignments.

                                                                                                    customerAccountId

                                                                                                    long

                                                                                                    A parameter that specifies the customer account identifier for searching the instrument assignments.

                                                                                                    accountSiteUseId

                                                                                                    long

                                                                                                    A parameter that specifies the use of the account site identifier for searching the instrument assignments.

                                                                                                    orgId

                                                                                                    long

                                                                                                    A parameter that specifies the organization identifier for searching the instrument assignments.

                                                                                                    orgType

                                                                                                    string

                                                                                                    A parameter that specifies the organization type for searching the instrument assignments.

                                                                                                    paymentFunction

                                                                                                    string

                                                                                                    A parameter that specifies the payment function for searching the instrument assignments.

                                                                                                    instrumentType

                                                                                                    string

                                                                                                    A parameter that specifies the instrument type for searching the instrument assignments.

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    Assigned Payment Instrument

                                                                                                    A parameter that returns the list of instrument assignments that satisfies the search criteria.

                                                                                                    processPayerBankAccount

                                                                                                    An operation that merges two bank accounts.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Element Name Type Description

                                                                                                    payer

                                                                                                    External Payer

                                                                                                    A parameter that specifies the external payer to perform the merge operation for the bank account.

                                                                                                    bankAccount

                                                                                                    External Bank Account

                                                                                                    A parameter that specifies the bank account details to create or update the bank account.

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    Bank Account Assignment

                                                                                                    A parameter that returns the bank account assignment that satisfies the search criteria.

                                                                                                    getPayerDetails

                                                                                                    A parameter that retrieves the payer details.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Element Name Type Description

                                                                                                    externalPayerId

                                                                                                    long

                                                                                                    A parameter that specifies the identifier of the external payer to be retrieved.

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    External Payer

                                                                                                    A parameter that returns the external payer that matches the external payer identifier.

                                                                                                    findPayer

                                                                                                    An operation that searches for a payer using specified criteria.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Element Name Type Description

                                                                                                    findCriteria

                                                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                                                    A parameter that specifies the search criteria for a payer and the maximum records that can be returned at a time.

                                                                                                    findControl

                                                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                                                    A parameter that controls the search for the payer.

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    External Payer

                                                                                                    A parameter that returns the list of external payers that satisfy the search criteria.

                                                                                                    findInstrumentsOwnedByParty

                                                                                                    An operation that searches for instruments owned by a party using specified criteria.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Element Name Type Description

                                                                                                    findCriteria

                                                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                                                    A parameter that specifies the search criteria for instruments owned by a party and the maximum records that can be returned at a time.

                                                                                                    BindPayerPartyId

                                                                                                    long

                                                                                                    Identifier of the party.

                                                                                                    BindInstrumentType

                                                                                                    string

                                                                                                    Type of payment instrument, such as credit card or bank account transfer.

                                                                                                    findControl

                                                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                                                    A parameter that controls the search for instruments owned by a party.

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    Party-Owned Payment Instrument

                                                                                                    A parameter that returns the list of payment instruments that satisfies the search criteria.

                                                                                                    getAssignedInstrumentDetails

                                                                                                    An operation that retrieves the details of an assigned instrument.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Element Name Type Description

                                                                                                    instrAssignmentId

                                                                                                    long

                                                                                                    A parameter that specifies the identifier of the instrument assignment to be retrieved.

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    Assigned Payment Instrument

                                                                                                    A parameter that returns the instrument assignment record.

                                                                                                    findAssignedInstrumentsByPayer

                                                                                                    Find instrument assignments by payer

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Element Name Type Description

                                                                                                    findCriteria

                                                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindCriteria

                                                                                                    Find criteria

                                                                                                    BindPayerId

                                                                                                    long

                                                                                                    External Payer Id

                                                                                                    BindInstrumentType

                                                                                                    string

                                                                                                    Instrument Type

                                                                                                    findControl

                                                                                                    {http://xmlns.oracle.com/adf/svc/types/}FindControl

                                                                                                    Find Control

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    Assigned Payment Instrument

                                                                                                    List of instrument assignments

                                                                                                    getDfltObjAttrHints

                                                                                                    An operation that retrieves the default object attribute hints.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Element Name Type Description

                                                                                                    viewName

                                                                                                    string

                                                                                                    A parameter that specifies the name of the view for the default object attribute hints to be retrieved.

                                                                                                    localeName

                                                                                                    string

                                                                                                    A parameter that specifies the locale name of the view for the default object attribute hints to be retrieved.

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    {http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

                                                                                                    A parameter that returns the default object attribute hints that matches the view and local name.

                                                                                                    getServiceLastUpdateTime

                                                                                                    An operation that retrieves the last update time of the service.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                                    A parameter that returns the last update time of the service.

                                                                                                    getEntityList

                                                                                                    An operation that retrieves the entity list.

                                                                                                    Life Cycle Status: Active

                                                                                                    Request Payload

                                                                                                    Response Payload

                                                                                                    Element Name Type Description

                                                                                                    result

                                                                                                    {http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

                                                                                                    A parameter that returns the entity list.

                                                                                                    Security

                                                                                                    The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

                                                                                                    Service Operations to Privileges Mapping

                                                                                                    Operation Name Privilege Code Privilege Name Privilege Description

                                                                                                    All Operations

                                                                                                    IBY_MANAGE_EXTERNAL_PAYER_PAYMENT_DETAILS_PRIV

                                                                                                    Manage External Payer Payment Details

                                                                                                    Allows management of payer payment details.

                                                                                                    Privileges to Duty Roles Mapping

                                                                                                    Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

                                                                                                    IBY_MANAGE_EXTERNAL_PAYER_PAYMENT_DETAILS_PRIV

                                                                                                    ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY

                                                                                                    Customer Payment Instrument Management

                                                                                                    Manages customer bank accounts and credit cards and other payment details.

                                                                                                      Assigned Payment Instrument

                                                                                                      Stores details of instrument assignment associated with a payer.

                                                                                                      QName: {http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/externalPayerServiceV2/}AssignedPmtInstrument

                                                                                                      Relationships

                                                                                                      The following table describes how this service data object is related to other service data objects or business object services.

                                                                                                      Relationship Type Object or Service

                                                                                                      Handled by

                                                                                                      External Payer

                                                                                                      Attributes

                                                                                                      The following table describes attributes in the service data object.

                                                                                                      Name Type Description

                                                                                                      AccountNumber

                                                                                                      string

                                                                                                      Number of the bank account.

                                                                                                      AccountSiteUseId

                                                                                                      long

                                                                                                      The account site of the external payer.

                                                                                                      AssignmentEndDate

                                                                                                      {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                      End date of the assignment.

                                                                                                      AssignmentLastUpdate

                                                                                                      {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                                      Date and time of the last assignment update.

                                                                                                      AssignmentStartDate

                                                                                                      {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                      Start date of the assignment.

                                                                                                      BICNumber

                                                                                                      string

                                                                                                      The identifier code used by SWIFT to identify a bank or bank branch. The BIC is a universal method of identifying financial institutions to facilitate the automated processing of telecommunication messages in banking and related financial environments.

                                                                                                      BankName

                                                                                                      string

                                                                                                      Name of the bank.

                                                                                                      BankNumber

                                                                                                      string

                                                                                                      Number of the bank.

                                                                                                      BranchName

                                                                                                      string

                                                                                                      Name of the branch associated with the bank account.

                                                                                                      BranchNumber

                                                                                                      string

                                                                                                      Number of the bank branch associated with the bank account.

                                                                                                      CardBillingAddressId

                                                                                                      decimal

                                                                                                      Identifier of the card billing address.

                                                                                                      CardExpirydate

                                                                                                      {http://xmlns.oracle.com/adf/svc/types/}date-Date

                                                                                                      Expiration date of the card.

                                                                                                      CardFiName

                                                                                                      string

                                                                                                      Name of the financial institution on the card.

                                                                                                      CardHolderName

                                                                                                      string

                                                                                                      Name of the cardholder.

                                                                                                      CardInformationOnlyFlag

                                                                                                      boolean

                                                                                                      Yes or No indicates whether the credit card is registered for information use only.

                                                                                                      CardIssuerCode

                                                                                                      string

                                                                                                      Card issuer code if known. Otherwise UNKNOWN.

                                                                                                      CardIssuerName

                                                                                                      string

                                                                                                      Name of the bank that issues corporate credit cards.

                                                                                                      CardNumber

                                                                                                      string

                                                                                                      The numeric credit card number.

                                                                                                      CardSingleUseFlag

                                                                                                      boolean

                                                                                                      Yes or No indicates whether the credit card is to be used only once.

                                                                                                      CreatedBy

                                                                                                      string

                                                                                                      User who created the record.

                                                                                                      CreationDate

                                                                                                      {http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

                                                                                                      Date and time of the record creation.

                                                                                                      CurrencyCode

                                                                                                      string

                                                                                                      The three-letter ISO code associated with a currency.

                                                                                                      CustomerAccountId