7Business Object Services

Account Combination Validation Service

Name of the external web service to validate account combinations created in third-party applications.

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

A method to validate account combinations created in third party applications.

Life Cycle Status: Active

Request Payload

Element Name Type Description

validationInputRowList

Service Input Parameters

The service data object account validation input is the input to the service this operation.

Response Payload

Element Name Type Description

result

Service Output

The service data object account validation output is the output of the service this operation.

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.

    Service Output

    Output provided by the Account Combination Validation web service.

    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

    Unique key for an 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 input for the EBS integration was Ledger ID. But cloud customers would prefer to use Ledger Name instead of Ledger ID. Therefore the service will accept either Ledger ID or Ledger Name. If neither Ledger ID nor Ledger Name is provided, then the service returns an error message. We use the ledger information to derive the Chart of Accounts.
    • Primary Key

    Segment1

    string

    Used to store the segment1 value of the account combination.

    Segment10

    string

    Used to store the segment10 value of the account combination.

    Segment11

    string

    Used to store the segment11 value of the account combination.

    Segment12

    string

    Used to store the segment12 value of the account combination.

    Segment13

    string

    Used to store the segment13 value of the account combination.

    Segment14

    string

    Used to store the segment14 value of the account combination.

    Segment15

    string

    Used to store the segment15 value of the account combination.

    Segment16

    string

    Used to store the segment16 value of the account combination.

    Segment17

    string

    Used to store the segment17 value of the account combination.

    Segment18

    string

    Used to store the segment18 value of the account combination.

    Segment19

    string

    Used to store the segment19 value of the account combination.

    Segment2

    string

    Used to store the segment2 value of the account combination.

    Segment20

    string

    Used to store the segment20 value of the account combination.

    Segment21

    string

    Used to store the segment21 value of the account combination.

    Segment22

    string

    Used to store the segment22 value of the account combination.

    Segment23

    string

    Used to store the segment23 value of the account combination.

    Segment24

    string

    Used to store the segment24 value of the account combination.

    Segment25

    string

    Used to store the segment25 value of the account combination.

    Segment26

    string

    Used to store the segment26 value of the account combination.

    Segment27

    string

    Used to store the segment27 value of the account combination.

    Segment28

    string

    Used to store the segment28 value of the account combination.

    Segment29

    string

    Used to store the segment29 value of the account combination.

    Segment3

    string

    Used to store the segment3 value of the account combination.

    Segment30

    string

    Used to store the segment30 value of the account combination.

    Segment4

    string

    Used to store the segment4 value of the account combination.

    Segment5

    string

    Used to store the segment5 value of the account combination.

    Segment6

    string

    Used to store the segment6 value of the account combination.

    Segment7

    string

    Used to store the segment7 value of the account combination.

    Segment8

    string

    Used to store the segment8 value of the account combination.

    Segment9

    string

    Used to store the segment9 value of the account combination.

    Status

    string

    Status of the account combination formed by using the segment values provided. Possible values: Valid or Invalid.

    ToDate

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

    Used to store the end date of the account combination.

      Cash Positioning and Forecasting Options

      Cash Position Service Application Module

      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

      Create manual dimension member

      Life Cycle Status: Active

      Request Payload

      Element Name Type Description

      dimMemberName

      string

      Dimension member name parameter

      Response Payload

      Element Name Type Description

      result

      string

      returns "SUCCESS" or error message on failure

      getDfltObjAttrHints

      Get default object attribute hints

      Life Cycle Status: Active

      Request Payload

      Element Name Type Description

      viewName

      string

      view name parameter

      localeName

      string

      locale name parameter

      Response Payload

      Element Name Type Description

      result

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

      Object attribute hints returned

      getServiceLastUpdateTime

      Get Service Last Update Time method

      Life Cycle Status: Active

      Request Payload

      Response Payload

      Element Name Type Description

      result

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

      Time of the last service update returned

      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

      entity list returned

      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 transitions.

      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.

      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 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 doesn't already exist.

      Life Cycle Status: Active

      Request Payload

      Element Name Type Description

      creditCard

      Credit Card SDO

      Credit card to be created or updated

      Response Payload

      Element Name Type Description

      result

      Credit Card SDO

      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 your query result, such as the filter (where clause), the fetch size, etc.

      findControl

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

      Find Control. Not currently used.

      Response Payload

      Element Name Type Description

      result

      Credit Card SDO

      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 SDO

        Updates the descriptive flexfields of 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 SDO

        Contained by

        Credit Card SDO

        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

        Payment instrument identifier
        • Primary Key

        _FLEX_NumOfSegments

        int

        Number of credit card flexfield segments

        __FLEX_Context

        string

        Context of credit card flexfields

          Credit Card SDO

          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 lookup IBY_CARD_PURPOSE

          Ccnumber

          string

          The credit card number. It must be numeric.

          Chname

          string

          Card holder name

          CreditCardDFFVLA

          Credit Card Attributes SDO

          Context value

          Description

          string

          Description of the payment instrument

          EndDate

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

          Date until which card is available for use

          Expirydate

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

          Expiration date of the card

          Finame

          string

          Financial institution name

          FormattedAddress

          string

          Formatted billing address

          InformationOnlyFlag

          boolean

          Flag indicating 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; to be used for display

          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

          Flag to indicate whether the 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 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 SDO

            Handles

            Credit Card Tokenization SDO

            Handles

            Credit Card Billing Address SDO

            Handles

            Credit Card Attributes 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 party Id

            Response Payload

            Element Name Type Description

            result

            long

            Instrument Id

            getTokenizationRequest

            Get Tokenization Request

            Life Cycle Status: Active

            Request Payload

            Element Name Type Description

            ccRow

            Credit Card Tokenization SDO

            Credit Card

            Response Payload

            Element Name Type Description

            result

            Credit Card Tokenization SDO

            Credit Card

            isTokenizationEnabled

            Check if Payment Card Tokenization is Enabled.

            Life Cycle Status: Active

            Request Payload

            Response Payload

            Element Name Type Description

            result

            boolean

            True if tokenization is enabled. False otherwise

            getPaymentCardDetails

            GetByKey operation for Credit Card SDO

            Life Cycle Status: Active

            Request Payload

            Element Name Type Description

            instrid

            long

            Instrument Id

            Response Payload

            Element Name Type Description

            result

            Credit Card SDO

            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

            Response Payload

            Element Name Type Description

            result

            Credit Card SDO

            List of Payment Cards

            findBillingAddressesByParty

            Find existing billing addresses for the 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 Id

            findControl

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

            Find Criteria

            Response Payload

            Element Name Type Description

            result

            Credit Card Billing Address SDO

            List of applicable billing addresses for the 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 SDO

              Updates the descriptive flexfields of 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 SDO

              Contained by

              Credit Card SDO

              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

              Payment instrument identifier
              • Primary Key

              _FLEX_NumOfSegments

              int

              Number of credit card flexfield segments

              __FLEX_Context

              string

              Context of credit card flexfields

                Credit Card Billing Address SDO

                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 Id

                PartySiteUseId

                long

                Billing Address Id
                • Primary Key

                PostalCode

                string

                Postal Code

                Province

                string

                Billing Province

                State

                string

                Billing State

                  Credit Card SDO

                  CreditCard SDO

                  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 SDO

                  Contained by

                  Credit Card Assignment SDO

                  Handled by

                  External Payer

                  Handled by

                  Credit Card

                  Attributes

                  The following table describes attributes in the service data object.

                  Name Type Description

                  Accttypeid

                  int

                  Account Type Id

                  Addressid

                  long

                  Address Id

                  BillAddrTerritoryCode

                  string

                  Billing Address Territory Code

                  BillAddressCity

                  string

                  Billing address City

                  BillAddressCounty

                  string

                  Billing address County

                  BillAddressFirstLine

                  string

                  Billing address line 1

                  BillAddressFourthLine

                  string

                  Billing address Line 4

                  BillAddressProvince

                  string

                  Billing address province

                  BillAddressSecondLine

                  string

                  Billing address line 2

                  BillAddressState

                  string

                  Billing address State

                  BillAddressThirdLine

                  string

                  Billing address line 3

                  BillingAddrPostalCode

                  string

                  Billing Address Postal Code

                  CardIssuerCode

                  string

                  Card Issuer Code

                  CardIssuerName

                  string

                  Card Issuer Name

                  CardMaskSetting

                  string

                  Card Mask Setting

                  CardOwnerId

                  long

                  Owner Party Id

                  CardPurpose

                  string

                  Card Purpose

                  CardUnmaskLength

                  int

                  Card Unmask Length

                  CcIssuerRangeId

                  long

                  Card Issuer Range Id

                  CcNumberLength

                  int

                  Card Number Length

                  Ccnumber

                  string

                  Card Number

                  Chname

                  string

                  Card holder name

                  CreatedBy

                  string

                  Created By

                  CreationDate

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

                  Creation Date

                  CreditCardDffVLA

                  Credit Card Attributes SDO

                  Credit Card DFF

                  Description

                  string

                  Instrument Description

                  EndDate

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

                  End Date

                  EndDateDisp

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

                  End Date Display

                  ExpiredFlag

                  boolean

                  Expired Flag

                  Expirydate

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

                  Expiration Date

                  ExpirydateDisp

                  string

                  Expiry Date Display

                  Finame

                  string

                  FI Name

                  FormattedBillingAddress

                  string

                  Formatted Billing Address

                  InformationOnlyFlag

                  boolean

                  Information Only Flag

                  Instrbuf

                  string

                  Instrument Buffer

                  Instrid

                  long

                  Instrument Id
                  • Primary Key

                  Instrname

                  string

                  Instrument Name

                  InstrumentType

                  string

                  Instrument Type

                  LastUpdateDate

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

                  Last Update Date

                  LastUpdateLogin

                  string

                  Last Update Login

                  LastUpdatedBy

                  string

                  Last Updated By

                  MaskedCcNumber

                  string

                  Masked card Number

                  ObjectVersionNumber

                  int

                  Object Version Number

                  PartyId

                  long

                  Party Id

                  PartyName

                  string

                  Party name

                  PurchasecardFlag

                  boolean

                  Purchase card Flag

                  PurchasecardSubtype

                  string

                  Purchase Card Subtype

                  SingleUseFlag

                  boolean

                  Single Use Flag

                  StartDate

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

                  Start Date

                  Subtype

                  string

                  Card Subtype

                  TokenResponseBody

                  string

                  Token response Body

                  TokenResponseHeaders

                  string

                  Token Response Headers

                    Credit Card Tokenization SDO

                    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

                    Address Id

                    CardIssuerCode

                    string

                    Card Issuer Code

                    CardOwnerId

                    long

                    Card Owner Id

                    CardPurpose

                    string

                    Card Purpose

                    Chname

                    string

                    Card holder name

                    Description

                    string

                    Card description

                    Expirydate

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

                    Expiry Date

                    Finame

                    string

                    FI Name

                    Instrid

                    long

                    Instrument Id
                    • Primary Key

                    PANLength

                    int

                    PAN Length

                    PurchasecardFlag

                    boolean

                    Purchase Card Flag

                    PurchasecardSubtype

                    string

                    Purchase Card Subtype

                    SubstituteBodyFlag

                    boolean

                    Substitute Body Flag

                    SubstituteHeadersFlag

                    boolean

                    Substitute Headers Flag

                    TokenProviderURL

                    string

                    Token Provider URL

                    TokenRequestBody

                    string

                    Token request Body

                    TokenRequestHeaders

                    string

                    Token Request Headers

                      Customer Profile Service

                      Service for creating 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 SDO

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

                      Response Payload

                      Element Name Type Description

                      result

                      Customer Profile SDO

                      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 Customer Profile

                      Life Cycle Status: Active

                      Request Payload

                      Element Name Type Description

                      customerProfile

                      Customer Profile SDO

                      Service Data Object for create customer operations.

                      Response Payload

                      Element Name Type Description

                      result

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

                      Result Object for the customer profile service

                      updateCustomerProfile

                      Asynchronous service for Update customer Operations.

                      Life Cycle Status: Active

                      Request Payload

                      Element Name Type Description

                      customerProfile

                      Customer Profile SDO

                      Service Data Object for customer profile creations

                      Response Payload

                      Element Name Type Description

                      result

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

                      Result Object from 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 Service

                        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 SDO

                          Service SDO for the flexfield of the receivables customer profile.

                          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 SDO

                          Handled by

                          Customer Profile Service

                          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 SDO

                            Service Data Object for creating 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.

                            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

                            Receivables Customer Profile Global Flexfield SDO

                            Contains

                            Customer Profile Flexfield SDO

                            Handled by

                            Customer Profile Service

                            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 SDO

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

                            CustomerProfileGdf

                            Receivables Customer Profile Global Flexfield SDO

                            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 SDO

                              Service SDO for the global flexfield of the Receivables Customer Profile

                              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 SDO

                              Handled by

                              Customer Profile Service

                              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 web service operations for ERP integration scenarios.

                                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 SDO

                                Handles

                                Document Information SDO

                                Handles

                                Process Details SDO

                                Operations

                                getESSJobStatus

                                Obtains the request status of the submitted ESS job.

                                Life Cycle Status: Active

                                Request Payload

                                Element Name Type Description

                                requestId

                                long

                                The request ID of the submitted ESS job.

                                Response Payload

                                Element Name Type Description

                                result

                                string

                                Returns the current status of the ESS job.

                                submitESSJobRequest

                                Submits an ESS job request for the specified job definition.

                                Life Cycle Status: Active

                                Request Payload

                                Element Name Type Description

                                jobPackageName

                                string

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

                                jobDefinitionName

                                string

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

                                paramList

                                string

                                List of parameters used to invoke the ESS job. The order of the parameters is maintained as 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 ESS job.

                                submitJobWithOutput

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

                                Life Cycle Status: Active

                                Request Payload

                                Element Name Type Description

                                jobPackageName

                                string

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

                                jobDefinitionName

                                string

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

                                callbackURL

                                string

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

                                paramList

                                string

                                List of parameters used to invoke the ESS job. The order of the parameters is maintained as 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 ESS 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 used to search for the files that start with a specificed prefix.

                                account

                                string

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

                                comments

                                string

                                The parameter is used to pass the comments. Files that do not have the comments are retreived.

                                Response Payload

                                Element Name Type Description

                                result

                                string

                                Returns a list of document Identifiers.

                                getDocumentForDocumentId

                                The operation is used 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 SDO

                                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 used to search for the files that start with a specificed prefix.

                                account

                                string

                                The account parameter used 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 SDO

                                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 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.

                                Response Payload

                                Element Name Type Description

                                result

                                string

                                Returns the document ID of the uploaded file.

                                downloadESSJobExecutionDetails

                                Downloads the ESS job output and the logs as a zip file.

                                Life Cycle Status: Active

                                Request Payload

                                Element Name Type Description

                                requestId

                                string

                                The request ID of the submitted ESS job.

                                fileType

                                string

                                The file type used to determine the execution details to download. Specify the file type as log to download the log file. Specify the file type as out to download the output file. Download both the log files and output files when file type is specified as all or when no file type is specified.

                                Response Payload

                                Element Name Type Description

                                result

                                Document Information SDO

                                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

                                downloadExportOutput

                                The method downloads the output of ESS job

                                Life Cycle Status: Deprecated

                                Request Payload

                                Element Name Type Description

                                requestId

                                string

                                The parameter is used to pass the request id of the ESS job.

                                Response Payload

                                Element Name Type Description

                                result

                                Document Information SDO

                                The list of document details for the document is returned

                                loadAndImportData

                                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.

                                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.

                                jobList

                                Process Details SDO

                                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.

                                interfaceDetails

                                string

                                The interface whose data is to be loaded.

                                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.

                                Response Payload

                                Element Name Type Description

                                result

                                long

                                Returns response code containing error details

                                confirmExtractConsumption

                                Retrieves the comment for a file with a document identifier from the Universal Content Manager,and then sends it to retrieve the incremental date. This date is finally updated in the database.

                                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 SDO

                                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, 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 <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 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.

                                  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

                                    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/}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

                                    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 SDO

                                      Ess Job information that contains information with respect to Ess job like job definition name, job package name and paramter list.

                                      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 ESS job package and the ESS job name, delimited by a semicolon, for the ESS job that must be submitted.

                                      JobRequestId

                                      string

                                      The request ID of the submitted ESS job.
                                      • Primary Key

                                      ParameterList

                                      string

                                      Comma separated list of parameters used to invoke the ESS job. The order of the parameters is maintained as 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 web service operations for ERP Attachment scenarios

                                        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 Details SDO

                                        Handles

                                        Attachment Download Details SDO

                                        Handles

                                        Attachment Information 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 the Attachments Zip file on UCM Account and also updates the corresponding Attachments tables

                                        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 allow Duplicates or not.

                                        attachmentRows

                                        Attachment Information SDO

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

                                        Response Payload

                                        Element Name Type Description

                                        result

                                        string

                                        Request Id of the Ess Job submitted for Attachments upload in asynchronous manner

                                        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 SDO

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

                                              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

                                              Attachment Type

                                              Content

                                              string

                                              Attachment Text/Url

                                              Title

                                              string

                                              Attachment Title
                                              • Primary Key

                                              UserKeyA

                                              string

                                              User Key to derive the PK1

                                              UserKeyB

                                              string

                                              User Key to derive the PK2

                                              UserKeyC

                                              string

                                              User Key to derive the PK3

                                              UserKeyD

                                              string

                                              User Key to derive the PK4

                                              UserKeyE

                                              string

                                              User Key to derive the PK5

                                                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/}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

                                                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

                                                  Object Information SDO

                                                  Object details containing information like entity name,context value, user key values and name value pairs of DFF atributes

                                                  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

                                                  Context value of the DFF Object

                                                  DFFAttributes

                                                  string

                                                  List of name value pairs of DFF attributes to be updated

                                                  EntityName

                                                  string

                                                  Entity Name of the ERP Object
                                                  • Primary Key

                                                  UserKeyA

                                                  string

                                                  User key value

                                                  UserKeyB

                                                  string

                                                  User key value

                                                  UserKeyC

                                                  string

                                                  User key value

                                                  UserKeyD

                                                  string

                                                  User key value

                                                  UserKeyE

                                                  string

                                                  User key value

                                                  UserKeyF

                                                  string

                                                  User key value

                                                  UserKeyG

                                                  string

                                                  User key value

                                                  UserKeyH

                                                  string

                                                  User key value

                                                    ERP Object Inquiry Service

                                                    Web service will have operation for read business object attributes

                                                    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

                                                    Read the Attributes of a particular Business Object

                                                    Life Cycle Status: Active

                                                    Request Payload

                                                    Element Name Type Description

                                                    businessObject

                                                    string

                                                    Business Object Name for which Attribute to be read

                                                    userKeyA

                                                    string

                                                    User Key value

                                                    userKeyB

                                                    string

                                                    User Key value

                                                    userKeyC

                                                    string

                                                    User Key value

                                                    userKeyD

                                                    string

                                                    User Key value

                                                    userKeyE

                                                    string

                                                    User Key value

                                                    Response Payload

                                                    Element Name Type Description

                                                    result

                                                    string

                                                    List of Attribute Name-Value details.

                                                    Expense Item and Expense Report

                                                    A process 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 to retrieve 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 to create 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 to update 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 to delete 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 to merge an expense item which creates an expense item if it does not exist and updates the expense item if it exists.

                                                    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 to process 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 such as create, update, merge, and delete expense items.

                                                    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 to send 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 representing 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 and associated warning and informational messages when applicable.

                                                    getExpenseReport

                                                    An operation to retrieve 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 to create 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 to update 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 to delete 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 to merge an expense report which creates an expense report if it does not exist and updates the expense report if it exists.

                                                    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 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 to process 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 such as create, update, merge, and delete expense reports.

                                                    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 to send 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 representing 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 and associated warning 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 SDO

                                                      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 of a specific expense item.
                                                      • Primary Key

                                                      FND_ACFF_ConcatenatedStorage

                                                      string

                                                      Concatenated company flexfield.

                                                      FND_ACFF_Delimiter

                                                      string

                                                      Delimiter used in company flexfield.

                                                      _FLEX_StructureInstanceCode

                                                      string

                                                      Structure instance code for the company flexfield.

                                                      _FLEX_StructureInstanceId

                                                      long

                                                      Structure instance identifier for the company flexfield.

                                                      _GL_5FGL_23_StructureInstanceNumber

                                                      long

                                                      Structure instance number for the company flexfield.

                                                        Expense Cost Center Allocation SDO

                                                        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 of a specific expense item.
                                                        • Primary Key

                                                        FND_ACFF_ConcatenatedStorage

                                                        string

                                                        Concatenated cost center flexfield.

                                                        FND_ACFF_Delimiter

                                                        string

                                                        Delimiter used in cost center flexfield.

                                                        _FLEX_StructureInstanceCode

                                                        string

                                                        Structure instance code for the cost center flexfield.

                                                        _FLEX_StructureInstanceId

                                                        long

                                                        Structure instance identifier for the cost center flexfield.

                                                        _GL_5FGL_23_StructureInstanceNumber

                                                        long

                                                        Structure instance number for the cost center flexfield.

                                                          Expense Descriptive Flexfield SDO

                                                          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

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

                                                            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

                                                            Expense Cost Center Allocation SDO

                                                            Contains

                                                            Project Expense Allocation SDO

                                                            Contains

                                                            Expense Company Allocation SDO

                                                            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 for the account code combination to which the expense is charged.

                                                            CompanyKFF

                                                            Expense Company Allocation SDO

                                                            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 SDO

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

                                                            ExpenseDistId

                                                            long

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

                                                            ExpenseId

                                                            long

                                                            The identifier for the expense.

                                                            ExpenseReportId

                                                            long

                                                            The unique identifier for 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 for the business unit of the person on the expense report.

                                                            PJC_CONTEXT_CATEGORY

                                                            string

                                                            The project context category.

                                                            PJC_EXPENDITURE_ITEM_DATE

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

                                                            The project expenditure item date.

                                                            PJC_EXPENDITURE_TYPE_Id

                                                            decimal

                                                            The identifier for the project expenditure type.

                                                            PJC_ORGANIZATION_Id

                                                            decimal

                                                            The identifier for the project business unit.

                                                            PJC_PROJECT_Id

                                                            decimal

                                                            The identifier for the project descriptive flexfield for project related expense.

                                                            PJC_TASK_Id

                                                            decimal

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

                                                            ProjectDFF

                                                            Project Expense Allocation SDO

                                                            The descriptive flex field that captures the project number, task number, and the 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 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

                                                              A business expense incurred by an employee. For example, stay at a hotel on a business trip 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 Distribution

                                                              Contains

                                                              Expense Descriptive Flexfield SDO

                                                              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 for the primary assignment of the person on the expense report.

                                                              CcPrepaidInvoiceId

                                                              long

                                                              The invoice identifier for the company pay corporate card transaction.

                                                              CreditCardTrxnId

                                                              long

                                                              The identifier for the credit card transaction associated with the expense.

                                                              DepartureLocationId

                                                              long

                                                              The identifier for 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 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 for retrieving the exchange rate for the expense.

                                                              ExpenseCategoryCode

                                                              string

                                                              The expense category code such as business and personal.

                                                              ExpenseDFF

                                                              Expense Descriptive Flexfield SDO

                                                              The descriptive flex field 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 for the expense report.

                                                              ExpenseSource

                                                              string

                                                              The source of the expense such as Cash or Corporate Card.

                                                              ExpenseTemplateEntityId

                                                              long

                                                              The primary key identifier for the expense template.

                                                              ExpenseTemplateId

                                                              long

                                                              The identifier for the expense report template.

                                                              ExpenseTemplateName

                                                              string

                                                              The name of the expense template.

                                                              ExpenseTypeCategoryCode

                                                              string

                                                              The expense type category code such as Accommodations and Meals.

                                                              ExpenseTypeEntityId

                                                              long

                                                              The primary key identifier for the expense type.

                                                              ExpenseTypeId

                                                              long

                                                              The identifier for the expense type.

                                                              ExpenseTypeName

                                                              string

                                                              The expense type for the expense.

                                                              FlightNumber

                                                              string

                                                              The flight number.

                                                              FuncCurrencyAmount

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

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

                                                              ItemizationParentExpenseId

                                                              long

                                                              The unique identifier for the parent expense of the itemized expense.

                                                              Justification

                                                              string

                                                              The justification for incurring the expense.

                                                              JustificationRequiredFlag

                                                              boolean

                                                              The flag that indicates whether the expense requires a justification.

                                                              Location

                                                              string

                                                              The expense location.

                                                              LocationId

                                                              long

                                                              The identifier for 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 provided by the merchant on the receipt.

                                                              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 is 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 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 for the business unit of the person on the expense report.

                                                              OrigReimbursableAmount

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

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

                                                              PersonId

                                                              long

                                                              The identifier of the person on the expense report.

                                                              PolicyViolatedFlag

                                                              boolean

                                                              The flag that 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

                                                              The flag that indicates whether the expense report preparer indicated that the receipt is missing.

                                                              ReceiptRequiredFlag

                                                              boolean

                                                              The flag that indicates whether a receipt is required for this expense.

                                                              ReceiptVerifiedFlag

                                                              boolean

                                                              The flag that indicates whether the receipt is verified by the auditor.

                                                              ReimbursableAmount

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

                                                              The amount reimbursable to the person 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 and Economy.

                                                              TicketNumber

                                                              string

                                                              The flight ticket number.

                                                              TravelType

                                                              string

                                                              The type of travel such as domestic or international.

                                                                Expense Report

                                                                The general information for expense report, such as the report number, purpose of the report, and the person on the expense report.

                                                                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 Item

                                                                Contains

                                                                Expense Report Descriptive Flexfield SDO

                                                                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 for the primary assignment of the person on the expense report.

                                                                BothpayFlag

                                                                boolean

                                                                The flag that 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 expense is reimbursed to the person on the expense report.

                                                                CurrentApproverId

                                                                long

                                                                The identifier for the current approver of the expense report.

                                                                ExchangeRateType

                                                                string

                                                                The exchange rate type used for retrieving the exchange rate for the expense.

                                                                ExpReportProcessingId

                                                                long

                                                                The identifier for a specific instance of the expense report status and the status 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 for 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 given 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 why the expense report is rejected by Oracle Fusion Payables.

                                                                ExportRequestId

                                                                long

                                                                The identifier for the process that created payables document for the expense report in Oracle Fusion Payables.

                                                                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 for the business unit of the person on the expense report.

                                                                OverrideApproverId

                                                                long

                                                                The person identifier for the overriding approver.

                                                                ParentExpenseReportId

                                                                long

                                                                The parent expense identifier for a both pay corporate card issuer report.

                                                                PaymentMethodCode

                                                                string

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

                                                                PersonId

                                                                long

                                                                The identifier of the person 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 for 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 SDO

                                                                    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 of 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 that the flexfield is for project capture.

                                                                      External Bank Account

                                                                      External Bank Account

                                                                      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

                                                                      Confirm if the bank account already exists

                                                                      Life Cycle Status: Active

                                                                      Request Payload

                                                                      Element Name Type Description

                                                                      bankId

                                                                      string

                                                                      bank Id

                                                                      branchId

                                                                      decimal

                                                                      Branch Id

                                                                      bankAccountNumber

                                                                      string

                                                                      Bank Account Number

                                                                      accountName

                                                                      string

                                                                      Bank Account Name

                                                                      currency

                                                                      string

                                                                      Currency Code

                                                                      countryCode

                                                                      string

                                                                      Country Code

                                                                      Response Payload

                                                                      Element Name Type Description

                                                                      result

                                                                      long

                                                                      Bank Account Id

                                                                      getExternalBankAccountOwnerRemote

                                                                      get External Bank Account Owner Remote SDO

                                                                      Life Cycle Status: Active

                                                                      Request Payload

                                                                      Element Name Type Description

                                                                      accountOwnerId

                                                                      long

                                                                      Account Owner ID

                                                                      Response Payload

                                                                      Element Name Type Description

                                                                      result

                                                                      External Bank Account Owner SDO

                                                                      Return Value

                                                                      findExternalBankAccountOwnerRemote

                                                                      find External Bank Account Owner Remote SDO

                                                                      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

                                                                      Response Payload

                                                                      Element Name Type Description

                                                                      result

                                                                      External Bank Account Owner SDO

                                                                      return value

                                                                      getIntermediaryBankAccountRemote

                                                                      get Intermediary Bank Account Remote SDO

                                                                      Life Cycle Status: Active

                                                                      Request Payload

                                                                      Element Name Type Description

                                                                      intermediaryAccountId

                                                                      long

                                                                      Intermediary Account Id

                                                                      Response Payload

                                                                      Element Name Type Description

                                                                      result

                                                                      Intermediary Bank Account Owner SDO

                                                                      return intermediary bank account

                                                                      findIntermediaryBankAccountRemote

                                                                      find Intermediary Bank Account Remote SDO

                                                                      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

                                                                      Response Payload

                                                                      Element Name Type Description

                                                                      result

                                                                      Intermediary Bank Account Owner SDO

                                                                      return value

                                                                      getExternalBankAccountDetails

                                                                      get External Bank Account SDO

                                                                      Life Cycle Status: Active

                                                                      Request Payload

                                                                      Element Name Type Description

                                                                      externalBankAccountId

                                                                      long

                                                                      External bank account id

                                                                      Response Payload

                                                                      Element Name Type Description

                                                                      result

                                                                      External Bank Account SDO

                                                                      return value

                                                                      processExternalBankAccount

                                                                      process External Bank Account

                                                                      Life Cycle Status: Active

                                                                      Request Payload

                                                                      Element Name Type Description

                                                                      externalBankAccount

                                                                      External Bank Account SDO

                                                                      External Bank Account

                                                                      Response Payload

                                                                      Element Name Type Description

                                                                      result

                                                                      External Bank Account SDO

                                                                      return value

                                                                      findExternalBankAccount

                                                                      find External Bank Account SDO

                                                                      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

                                                                      Response Payload

                                                                      Element Name Type Description

                                                                      result

                                                                      External Bank Account SDO

                                                                      return value

                                                                      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_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_PAY_REST_SERVICE_ACCESS_WORKER_BANK_ACCOUNTS_FSCM

                                                                      Use REST Service - Worker Bank Accounts

                                                                      Allows the user to manage worker bank accounts using REST.

                                                                      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 SDO

                                                                        External Bank AccountOwner SDO

                                                                        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 SDO

                                                                        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

                                                                        Account Owner Id
                                                                        • Primary Key

                                                                        AccountOwnerPartyId

                                                                        long

                                                                        Account Owner Party Id

                                                                        CreatedBy

                                                                        string

                                                                        Created By

                                                                        CreationDate

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

                                                                        Creation Date

                                                                        EndDate

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

                                                                        End Date

                                                                        EndDateDisp

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

                                                                        End Date Disp

                                                                        ExternalBankAccountId

                                                                        long

                                                                        External Bank Account ID

                                                                        LastUpdateDate

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

                                                                        Last Update Date

                                                                        LastUpdateLogin

                                                                        string

                                                                        Last Update Login

                                                                        LastUpdatedBy

                                                                        string

                                                                        Last Update By

                                                                        ObjectVersionNumber

                                                                        int

                                                                        Object Version Number

                                                                        PartyId

                                                                        long

                                                                        Party ID

                                                                        PartyName

                                                                        string

                                                                        Party Name

                                                                        PartyNameAlt

                                                                        string

                                                                        Party Name1

                                                                        PartyNameId

                                                                        long

                                                                        PArty Name Id

                                                                        PartyNameType

                                                                        string

                                                                        Party Name Type

                                                                        PrimaryFlag

                                                                        boolean

                                                                        Priamry Flag

                                                                        StartDate

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

                                                                        Start Date

                                                                          External Bank Account SDO

                                                                          External Bank Account SDO

                                                                          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

                                                                          External Bank Account SDO

                                                                          Contains

                                                                          External Bank Account Owner SDO

                                                                          Contains

                                                                          Intermediary Bank Account Owner SDO

                                                                          Contained by

                                                                          Bank Account Assignment SDO

                                                                          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

                                                                          Account Classification

                                                                          AccountSuffix

                                                                          string

                                                                          Account Suffix

                                                                          AgencyLocationCode

                                                                          string

                                                                          Agency Location Code

                                                                          BAMaskSetting

                                                                          string

                                                                          Bank Account Mask Setting

                                                                          BAUnmaskLength

                                                                          int

                                                                          Bank Account UnMask Length

                                                                          BankAccountName

                                                                          string

                                                                          Bank Account Name

                                                                          BankAccountNameAlt

                                                                          string

                                                                          Bank Account Name Alternate

                                                                          BankAccountNumber

                                                                          string

                                                                          Bank Account Number

                                                                          BankAccountNumberElectronic

                                                                          string

                                                                          Bank Account Number Electronic

                                                                          BankAccountType

                                                                          string

                                                                          Bank Account Type

                                                                          BankBranchName

                                                                          string

                                                                          Bank Branch Name

                                                                          BankId

                                                                          long

                                                                          Bank Id

                                                                          BankName

                                                                          string

                                                                          Bank Name

                                                                          BankNumber

                                                                          string

                                                                          Bank Number

                                                                          BankPartyId

                                                                          long

                                                                          Bank Party ID

                                                                          BranchId

                                                                          long

                                                                          Branch ID

                                                                          BranchNumber

                                                                          string

                                                                          Branch Number

                                                                          BranchPartyId

                                                                          long

                                                                          Branch Party ID

                                                                          CheckDigits

                                                                          string

                                                                          Check Digits

                                                                          CountryCode

                                                                          string

                                                                          Country Code

                                                                          CreatedBy

                                                                          string

                                                                          Created By

                                                                          CreationDate

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

                                                                          Creation Date

                                                                          CurrencyCode

                                                                          string

                                                                          Currency Code

                                                                          Description

                                                                          string

                                                                          Description of the bank account

                                                                          EFTSWIFTCode

                                                                          string

                                                                          EFT SWIFT Code

                                                                          EndDate

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

                                                                          End Date

                                                                          EndDateDisp

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

                                                                          End Date Display

                                                                          EndId

                                                                          long

                                                                          End Id

                                                                          ExchangeRate

                                                                          decimal

                                                                          Exchange Rate

                                                                          ExchangeRateAgreementNumber

                                                                          string

                                                                          Exchange Rate Agreement Number

                                                                          ExchangeRateAgreementType

                                                                          string

                                                                          Exchange Rate Agreement Type

                                                                          ExtBankAcctDffVLA

                                                                          External Bank Account SDO

                                                                          External bank account DFF VLA

                                                                          ExternalBankAccountId

                                                                          long

                                                                          External Bank Account ID
                                                                          • Primary Key

                                                                          ExternalBankAccountOwner

                                                                          External Bank Account Owner SDO

                                                                          External Bank Account Owner

                                                                          ForeignPaymentUseFlag

                                                                          boolean

                                                                          Foreign Payment Use Flag

                                                                          HedgingContractReference

                                                                          string

                                                                          Hedging Contract Reference

                                                                          IBAN

                                                                          string

                                                                          Internationl Bank Account Number

                                                                          IntermediaryBankAccount

                                                                          Intermediary Bank Account Owner SDO

                                                                          Intermediary Bank Account

                                                                          LastUpdateDate

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

                                                                          Last Update Date

                                                                          LastUpdateLogin

                                                                          string

                                                                          Last Update Login

                                                                          LastUpdatedBy

                                                                          string

                                                                          Last Updated By

                                                                          MaskedBankAccountNumber

                                                                          string

                                                                          Masked Bank Account Number

                                                                          MaskedIBAN

                                                                          string

                                                                          Masked IBAN

                                                                          Name

                                                                          string

                                                                          Name of the bank account

                                                                          ObjectVersionNumber

                                                                          int

                                                                          Object Version Number

                                                                          PaymentFactorFlag

                                                                          boolean

                                                                          Payment Factor Flag

                                                                          SecondaryAccountReference

                                                                          string

                                                                          Secondary Account Reference

                                                                          ShortAccountName

                                                                          string

                                                                          Short Account Name

                                                                          StartDate

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

                                                                          Start Date

                                                                          StartId

                                                                          long

                                                                          Start Id

                                                                          TerritoryCode

                                                                          string

                                                                          Territory Code

                                                                          TerritoryShortName

                                                                          string

                                                                          Territory Short Name

                                                                            External Bank Account SDO

                                                                            External bank account VO

                                                                            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 SDO

                                                                            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

                                                                            External bank account id
                                                                            • Primary Key

                                                                            _FLEX_NumOfSegments

                                                                            int

                                                                            Number of segments

                                                                            _FLEX_ValidationDate

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

                                                                            Validate date

                                                                            __FLEX_Context

                                                                            string

                                                                            Context

                                                                              Intermediary Bank Account Owner SDO

                                                                              Intermediary Bank Account SDO

                                                                              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 SDO

                                                                              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

                                                                              Account Number

                                                                              BIC

                                                                              string

                                                                              Branch identification code

                                                                              BankAccountId

                                                                              long

                                                                              Bank Account ID

                                                                              BankCode

                                                                              string

                                                                              Bank Code

                                                                              BankName

                                                                              string

                                                                              Bank Name

                                                                              BranchNumber

                                                                              string

                                                                              Branch Number

                                                                              CheckDigits

                                                                              string

                                                                              Check Digits

                                                                              City

                                                                              string

                                                                              City of the intermediary

                                                                              Comments

                                                                              string

                                                                              Comments for the intermediary

                                                                              CountryCode

                                                                              string

                                                                              Country Code

                                                                              CreatedBy

                                                                              string

                                                                              Created By

                                                                              CreationDate

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

                                                                              Creation Date

                                                                              IBAN

                                                                              string

                                                                              Internationl bank account number

                                                                              IntermediaryAccountId

                                                                              long

                                                                              Intermediary Account Id
                                                                              • Primary Key

                                                                              InternalBankAccountId

                                                                              long

                                                                              Ineternal Bank Account ID

                                                                              LastUpdateDate

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

                                                                              Last Update Date

                                                                              LastUpdateLogin

                                                                              string

                                                                              Last Update Login

                                                                              LastUpdatedBy

                                                                              string

                                                                              Last Updated By

                                                                              ObjectVersionNumber

                                                                              int

                                                                              Object Version Number

                                                                              TerritoryCode

                                                                              string

                                                                              Territory Code

                                                                              TerritoryShortName

                                                                              string

                                                                              Territory Short Name

                                                                                External Cash Transaction

                                                                                The cash management transactions related to cash activity that was not recorded within the system. For example, transactions created from bank statement lines for bank charges.

                                                                                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

                                                                                Gets external transactions record for the given criteria

                                                                                Life Cycle Status: Active

                                                                                Request Payload

                                                                                Element Name Type Description

                                                                                externalTransactionId

                                                                                long

                                                                                External transaction system generated Id

                                                                                Response Payload

                                                                                Element Name Type Description

                                                                                result

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

                                                                                External transaction SDO retrieved

                                                                                createExternalTransaction

                                                                                Creates a new external transaction record in the system

                                                                                Life Cycle Status: Active

                                                                                Request Payload

                                                                                Element Name Type Description

                                                                                externalTransactions1

                                                                                External Cash Transactions SDO

                                                                                External transaction SDO to be created

                                                                                Response Payload

                                                                                Element Name Type Description

                                                                                result

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

                                                                                External transaction SDO created

                                                                                updateExternalTransaction

                                                                                Updates External transaction record

                                                                                Life Cycle Status: Active

                                                                                Request Payload

                                                                                Element Name Type Description

                                                                                externalTransactions1

                                                                                External Cash Transactions SDO

                                                                                External transaction SDO to be updated

                                                                                Response Payload

                                                                                Element Name Type Description

                                                                                result

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

                                                                                External transaction SDO updated

                                                                                findExternalTransactions

                                                                                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 result, such as the filter (where clause), the fetch size, etc.

                                                                                findControl

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

                                                                                Find control specification. Not currently used

                                                                                Response Payload

                                                                                Element Name Type Description

                                                                                result

                                                                                External Cash Transactions SDO

                                                                                External transaction SDO retrieved

                                                                                findExternalTransactionFindByTransactionId

                                                                                Find an external transaction for the 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 result, such as the filter (where clause), the fetch size, etc.

                                                                                transactionId

                                                                                long

                                                                                Transaction Id of the external cash transaction

                                                                                findControl

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

                                                                                Find control specification. Not currently used

                                                                                Response Payload

                                                                                Element Name Type Description

                                                                                result

                                                                                External Cash Transactions SDO

                                                                                External transaction SDO retrieved

                                                                                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

                                                                                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 SDO

                                                                                  The cash management transactions related to cash activity that was not recorded within the system. 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

                                                                                  Accounting enable flag

                                                                                  Amount

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

                                                                                  Transaction Amount

                                                                                  AssetCcid

                                                                                  long

                                                                                  Asset GL Account Id

                                                                                  Attribute1

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute10

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute11

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute12

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute13

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute14

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute15

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute2

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute3

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute4

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute5

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute6

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute7

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute8

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  Attribute9

                                                                                  string

                                                                                  Descriptive flex field attribute

                                                                                  AttributeCategory

                                                                                  string

                                                                                  Descriptive flex field attribute category

                                                                                  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

                                                                                  Bank Account Identifier

                                                                                  BusinessUnitId

                                                                                  long

                                                                                  Business Unit Identifier

                                                                                  ClearedDate

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

                                                                                  Transaction Cleared Date

                                                                                  CurrencyCode

                                                                                  string

                                                                                  Currency Code of the Transaction Amount

                                                                                  Description

                                                                                  string

                                                                                  Transaction Description

                                                                                  ExternalTransactionId

                                                                                  long

                                                                                  Auto updated upon record update
                                                                                  • Primary Key

                                                                                  LegalEntityId

                                                                                  long

                                                                                  Legal Entity Identifier

                                                                                  ObjectVersionNumber

                                                                                  int

                                                                                  Auto updated upon record update

                                                                                  OffsetCcid

                                                                                  long

                                                                                  Offset GL Account Id

                                                                                  ReconHistoryId

                                                                                  long

                                                                                  Transaction reconciliation history Id

                                                                                  ReferenceText

                                                                                  string

                                                                                  Transaction Reference

                                                                                  Source

                                                                                  string

                                                                                  Transaction Source

                                                                                  StatementLineId

                                                                                  long

                                                                                  Bank Statement Line Id

                                                                                  Status

                                                                                  string

                                                                                  Transaction Status

                                                                                  TransactionDate

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

                                                                                  Transaction Date of the transaction

                                                                                  TransactionId

                                                                                  long

                                                                                  Sequential Transaction Number of the external transaction

                                                                                  TransactionType

                                                                                  string

                                                                                  Transaction Type Code

                                                                                  ValueDate

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

                                                                                  Value Date of the transaction

                                                                                    External Payer

                                                                                    Funds Capture Payer

                                                                                    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

                                                                                    Merge operation for Payment card

                                                                                    Life Cycle Status: Active

                                                                                    Request Payload

                                                                                    Element Name Type Description

                                                                                    payer

                                                                                    External Payer SDO

                                                                                    External Payer

                                                                                    creditCard

                                                                                    Credit Card SDO

                                                                                    Credit Card

                                                                                    Response Payload

                                                                                    Element Name Type Description

                                                                                    result

                                                                                    Credit Card Assignment SDO

                                                                                    Credit Card Assignment

                                                                                    findAssignedInstrumentsByPayer

                                                                                    Find instrument assignments by payer

                                                                                    Life Cycle Status: Active

                                                                                    Request Payload

                                                                                    Element Name Type Description

                                                                                    partyId

                                                                                    long

                                                                                    Party Id

                                                                                    customerAccountId

                                                                                    long

                                                                                    Customer Account Id

                                                                                    accountSiteUseId

                                                                                    long

                                                                                    Account Site Use Id

                                                                                    orgId

                                                                                    long

                                                                                    Organization Id

                                                                                    orgType

                                                                                    string

                                                                                    Organization Type

                                                                                    paymentFunction

                                                                                    string

                                                                                    Payment Function

                                                                                    instrumentType

                                                                                    string

                                                                                    Instrument Type

                                                                                    Response Payload

                                                                                    Element Name Type Description

                                                                                    result

                                                                                    Assigned Payment Instrument SDO

                                                                                    List of instrument assignments

                                                                                    processPayerBankAccount

                                                                                    Merge operation for Bank account

                                                                                    Life Cycle Status: Active

                                                                                    Request Payload

                                                                                    Element Name Type Description

                                                                                    payer

                                                                                    External Payer SDO

                                                                                    External Payer

                                                                                    bankAccount

                                                                                    External Bank Account SDO

                                                                                    Bank Account

                                                                                    Response Payload

                                                                                    Element Name Type Description

                                                                                    result

                                                                                    Bank Account Assignment SDO

                                                                                    Bank Account Assignment

                                                                                    getPayerDetails

                                                                                    GetByKey operation on External Payer

                                                                                    Life Cycle Status: Active

                                                                                    Request Payload

                                                                                    Element Name Type Description

                                                                                    externalPayerId

                                                                                    long

                                                                                    External Payer Id

                                                                                    Response Payload

                                                                                    Element Name Type Description

                                                                                    result

                                                                                    External Payer SDO

                                                                                    External Payer

                                                                                    findPayer

                                                                                    Find Operation on Payer

                                                                                    Life Cycle Status: Active

                                                                                    Request Payload

                                                                                    Element Name Type Description

                                                                                    findCriteria

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

                                                                                    Find View Criteria

                                                                                    findControl

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

                                                                                    Find Control

                                                                                    Response Payload

                                                                                    Element Name Type Description

                                                                                    result

                                                                                    External Payer SDO

                                                                                    List of external Payers

                                                                                    findInstrumentsOwnedByParty

                                                                                    Find Payment instruments owned by a party

                                                                                    Life Cycle Status: Active

                                                                                    Request Payload

                                                                                    Element Name Type Description

                                                                                    findCriteria

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

                                                                                    Find Criteria

                                                                                    BindPayerPartyId

                                                                                    long

                                                                                    Party Id

                                                                                    BindInstrumentType

                                                                                    string

                                                                                    Instrument Type

                                                                                    findControl

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

                                                                                    Find Control

                                                                                    Response Payload

                                                                                    Element Name Type Description

                                                                                    result

                                                                                    Party-Owned Payment Instrument SDO

                                                                                    List of Payment Instruments

                                                                                    getAssignedInstrumentDetails

                                                                                    getByKey operation on Instrument assignment

                                                                                    Life Cycle Status: Active

                                                                                    Request Payload

                                                                                    Element Name Type Description

                                                                                    instrAssignmentId

                                                                                    long

                                                                                    Instrument assignment Id

                                                                                    Response Payload

                                                                                    Element Name Type Description

                                                                                    result

                                                                                    Assigned Payment Instrument SDO

                                                                                    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 SDO

                                                                                    List of instrument assignments

                                                                                    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_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 SDO

                                                                                      Assigned Payment Instrument

                                                                                      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

                                                                                      Account Number

                                                                                      AccountSiteUseId

                                                                                      long

                                                                                      Account Site Use Id

                                                                                      AssignmentEndDate

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

                                                                                      Assignment End Date

                                                                                      AssignmentLastUpdate

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

                                                                                      Assignment Last Update

                                                                                      AssignmentStartDate

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

                                                                                      Assignment Start Date

                                                                                      BICNumber

                                                                                      string

                                                                                      BIC Number

                                                                                      BankName

                                                                                      string

                                                                                      Bank name

                                                                                      BankNumber

                                                                                      string

                                                                                      bank Number

                                                                                      BranchName

                                                                                      string

                                                                                      Branch Name

                                                                                      BranchNumber

                                                                                      string

                                                                                      Branch Number

                                                                                      CardBillingAddressId

                                                                                      decimal

                                                                                      Card Billing address Id

                                                                                      CardExpirydate

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

                                                                                      Card Expiry Date

                                                                                      CardFiName

                                                                                      string

                                                                                      Card FI Name

                                                                                      CardHolderName

                                                                                      string

                                                                                      Card Holder Name

                                                                                      CardInformationOnlyFlag

                                                                                      boolean

                                                                                      Card Info Only Flag

                                                                                      CardIssuerCode

                                                                                      string

                                                                                      Card Issuer Code

                                                                                      CardIssuerName

                                                                                      string

                                                                                      Card Issuer name

                                                                                      CardNumber

                                                                                      string

                                                                                      Card Number

                                                                                      CardSingleUseFlag

                                                                                      boolean

                                                                                      Card Single Use Flag

                                                                                      CreatedBy

                                                                                      string

                                                                                      Created By

                                                                                      CreationDate

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

                                                                                      Creation Date

                                                                                      CurrencyCode

                                                                                      string

                                                                                      Currency Code

                                                                                      CustomerAccountId

                                                                                      long

                                                                                      Customer Account Id

                                                                                      Description

                                                                                      string

                                                                                      Bank Account Description

                                                                                      ExternalPayerId

                                                                                      long

                                                                                      External Payer Id

                                                                                      InstrAssignmentId

                                                                                      long

                                                                                      Instrument Assignment Id
                                                                                      • Primary Key

                                                                                      InstrumentId

                                                                                      long

                                                                                      Instrument Id

                                                                                      InstrumentType

                                                                                      string

                                                                                      Instrument Type

                                                                                      LastUpdateDate

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

                                                                                      Last Update Date

                                                                                      LastUpdateLogin

                                                                                      string

                                                                                      Last Update Login

                                                                                      LastUpdatedBy

                                                                                      string

                                                                                      Last Updated By

                                                                                      ObjectVersionNumber

                                                                                      int

                                                                                      Object Version Number

                                                                                      PartyId

                                                                                      long

                                                                                      Party Id

                                                                                      PaymentFunction

                                                                                      string

                                                                                      Payment Function

                                                                                      PrimaryFlag

                                                                                      boolean

                                                                                      Primary Flag

                                                                                      PurchasecardSubtype

                                                                                      string

                                                                                      Purchase card Subtype

                                                                                        Bank Account Assignment SDO

                                                                                        Bank Account Assignment

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

                                                                                        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

                                                                                        External Payer SDO

                                                                                        Contains

                                                                                        Instrument Use Attributes SDO

                                                                                        Contains

                                                                                        External Bank Account SDO

                                                                                        Handled by

                                                                                        External Payer

                                                                                        Attributes

                                                                                        The following table describes attributes in the service data object.

                                                                                        Name Type Description

                                                                                        CreatedBy

                                                                                        string

                                                                                        Created By

                                                                                        CreationDate

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

                                                                                        Creation Date

                                                                                        DebitAuthBegin

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

                                                                                        Debit Auth Begin

                                                                                        DebitAuthEnd

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

                                                                                        Debit Auth End

                                                                                        DebitAuthFlag

                                                                                        boolean

                                                                                        Debit Auth Flag

                                                                                        DebitAuthMethod

                                                                                        string

                                                                                        Debit Auth Method

                                                                                        DebitAuthReference

                                                                                        string

                                                                                        Debit Auth Reference

                                                                                        EndDate

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

                                                                                        End Date

                                                                                        EndDateDisp

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

                                                                                        End date Display

                                                                                        ExternalBankAccount

                                                                                        External Bank Account SDO

                                                                                        External Bank Account

                                                                                        ExternalPayer

                                                                                        External Payer SDO

                                                                                        External Payer

                                                                                        ExternalPmtPartyId

                                                                                        long

                                                                                        External Payer Id

                                                                                        InstallmentUpdNewBAFlag

                                                                                        boolean

                                                                                        Installment Update New Bank Account Flag

                                                                                        InstallmentUpdateFlag

                                                                                        boolean

                                                                                        Installment Update Flag

                                                                                        InstrumentId

                                                                                        long

                                                                                        Instrument Id

                                                                                        InstrumentPaymentUseId

                                                                                        long

                                                                                        Instrument Assignment Id
                                                                                        • Primary Key

                                                                                        InstrumentType

                                                                                        string

                                                                                        Instrument Type

                                                                                        InstrumentUseDFFVLA

                                                                                        Instrument Use Attributes SDO

                                                                                        Instrument Assignment DFF

                                                                                        LastUpdateDate

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

                                                                                        Last Update Date

                                                                                        LastUpdateLogin

                                                                                        string

                                                                                        Last Update Login

                                                                                        LastUpdatedBy

                                                                                        string

                                                                                        Last Updated By

                                                                                        ObjectVersionNumber

                                                                                        int

                                                                                        Object Version Number

                                                                                        PaymentFlow

                                                                                        string

                                                                                        Payment Flow

                                                                                        PaymentFunction

                                                                                        string

                                                                                        Payment Function

                                                                                        PrimaryFlag

                                                                                        boolean

                                                                                        Primary Flag

                                                                                        StartDate

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

                                                                                        Start Date

                                                                                          Credit Card Assignment SDO

                                                                                          Credit Card Assignment

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

                                                                                          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

                                                                                          External Payer SDO

                                                                                          Contains

                                                                                          Instrument Use Attributes SDO

                                                                                          Contains

                                                                                          Credit Card SDO

                                                                                          Handled by

                                                                                          External Payer

                                                                                          Attributes

                                                                                          The following table describes attributes in the service data object.

                                                                                          Name Type Description

                                                                                          CreatedBy

                                                                                          string

                                                                                          Created By

                                                                                          CreationDate

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

                                                                                          Creation Date

                                                                                          CreditCard

                                                                                          Credit Card SDO

                                                                                          Credit Card

                                                                                          DebitAuthBegin

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

                                                                                          Debit Authorization Begin

                                                                                          DebitAuthEnd

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

                                                                                          Debit Authorization End

                                                                                          DebitAuthFlag

                                                                                          boolean

                                                                                          Debit Authorization Flag

                                                                                          DebitAuthMethod

                                                                                          string

                                                                                          Debit Authorization Method

                                                                                          DebitAuthReference

                                                                                          string

                                                                                          Debit Authorization Reference

                                                                                          EndDate

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

                                                                                          End Date

                                                                                          EndDateDisp

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

                                                                                          End Date Display

                                                                                          ExternalPayer

                                                                                          External Payer SDO

                                                                                          External Payer

                                                                                          ExternalPmtPartyId

                                                                                          long

                                                                                          External Payer Id

                                                                                          InstallmentUpdNewBAFlag

                                                                                          boolean

                                                                                          Installment Update New bank account Flag

                                                                                          InstallmentUpdateFlag

                                                                                          boolean

                                                                                          Installment Update Flag

                                                                                          InstrumentId

                                                                                          long

                                                                                          Instrument Id

                                                                                          InstrumentPaymentUseId

                                                                                          long

                                                                                          Instrument Assignment Id
                                                                                          • Primary Key

                                                                                          InstrumentType

                                                                                          string

                                                                                          Instrument Type

                                                                                          InstrumentUseDFFVLA

                                                                                          Instrument Use Attributes SDO

                                                                                          Instrument Assignment DFF

                                                                                          LastUpdateDate

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

                                                                                          Last Update Date

                                                                                          LastUpdateLogin

                                                                                          string

                                                                                          Last Update Login

                                                                                          LastUpdatedBy

                                                                                          string

                                                                                          Last Updated By

                                                                                          ObjectVersionNumber

                                                                                          int

                                                                                          Object Version Number

                                                                                          PaymentFlow

                                                                                          string

                                                                                          Payment Flow

                                                                                          PaymentFunction

                                                                                          string

                                                                                          Payment Function

                                                                                          PrimaryFlag

                                                                                          boolean

                                                                                          Primary Flag

                                                                                          StartDate

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

                                                                                          Start Date

                                                                                            Credit Card Attributes SDO

                                                                                            Updates the descriptive flexfields of 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 SDO

                                                                                            Contained by

                                                                                            Credit Card SDO

                                                                                            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

                                                                                            Payment instrument identifier
                                                                                            • Primary Key

                                                                                            _FLEX_NumOfSegments

                                                                                            int

                                                                                            Number of credit card flexfield segments

                                                                                            __FLEX_Context

                                                                                            string

                                                                                            Context of credit card flexfields

                                                                                              Credit Card SDO

                                                                                              CreditCard SDO

                                                                                              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 SDO

                                                                                              Contained by

                                                                                              Credit Card Assignment SDO

                                                                                              Handled by

                                                                                              External Payer

                                                                                              Handled by

                                                                                              Credit Card

                                                                                              Attributes

                                                                                              The following table describes attributes in the service data object.

                                                                                              Name Type Description

                                                                                              Accttypeid

                                                                                              int

                                                                                              Account Type Id

                                                                                              Addressid

                                                                                              long

                                                                                              Address Id

                                                                                              BillAddrTerritoryCode

                                                                                              string

                                                                                              Billing Address Territory Code

                                                                                              BillAddressCity

                                                                                              string

                                                                                              Billing address City

                                                                                              BillAddressCounty

                                                                                              string

                                                                                              Billing address County

                                                                                              BillAddressFirstLine

                                                                                              string

                                                                                              Billing address line 1

                                                                                              BillAddressFourthLine

                                                                                              string

                                                                                              Billing address Line 4

                                                                                              BillAddressProvince

                                                                                              string

                                                                                              Billing address province

                                                                                              BillAddressSecondLine

                                                                                              string

                                                                                              Billing address line 2

                                                                                              BillAddressState

                                                                                              string

                                                                                              Billing address State

                                                                                              BillAddressThirdLine

                                                                                              string

                                                                                              Billing address line 3

                                                                                              BillingAddrPostalCode

                                                                                              string

                                                                                              Billing Address Postal Code

                                                                                              CardIssuerCode

                                                                                              string

                                                                                              Card Issuer Code

                                                                                              CardIssuerName

                                                                                              string

                                                                                              Card Issuer Name

                                                                                              CardMaskSetting

                                                                                              string

                                                                                              Card Mask Setting

                                                                                              CardOwnerId

                                                                                              long

                                                                                              Owner Party Id

                                                                                              CardPurpose

                                                                                              string

                                                                                              Card Purpose

                                                                                              CardUnmaskLength

                                                                                              int

                                                                                              Card Unmask Length

                                                                                              CcIssuerRangeId

                                                                                              long

                                                                                              Card Issuer Range Id

                                                                                              CcNumberLength

                                                                                              int

                                                                                              Card Number Length

                                                                                              Ccnumber

                                                                                              string

                                                                                              Card Number

                                                                                              Chname

                                                                                              string

                                                                                              Card holder name

                                                                                              CreatedBy

                                                                                              string

                                                                                              Created By

                                                                                              CreationDate

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

                                                                                              Creation Date

                                                                                              CreditCardDffVLA

                                                                                              Credit Card Attributes SDO

                                                                                              Credit Card DFF

                                                                                              Description

                                                                                              string

                                                                                              Instrument Description

                                                                                              EndDate

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

                                                                                              End Date

                                                                                              EndDateDisp

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

                                                                                              End Date Display

                                                                                              ExpiredFlag

                                                                                              boolean

                                                                                              Expired Flag

                                                                                              Expirydate

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

                                                                                              Expiration Date

                                                                                              ExpirydateDisp

                                                                                              string

                                                                                              Expiry Date Display

                                                                                              Finame

                                                                                              string

                                                                                              FI Name

                                                                                              FormattedBillingAddress

                                                                                              string

                                                                                              Formatted Billing Address

                                                                                              InformationOnlyFlag

                                                                                              boolean

                                                                                              Information Only Flag

                                                                                              Instrbuf

                                                                                              string

                                                                                              Instrument Buffer

                                                                                              Instrid

                                                                                              long

                                                                                              Instrument Id
                                                                                              • Primary Key

                                                                                              Instrname

                                                                                              string

                                                                                              Instrument Name

                                                                                              InstrumentType

                                                                                              string

                                                                                              Instrument Type

                                                                                              LastUpdateDate

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

                                                                                              Last Update Date

                                                                                              LastUpdateLogin

                                                                                              string

                                                                                              Last Update Login

                                                                                              LastUpdatedBy

                                                                                              string

                                                                                              Last Updated By

                                                                                              MaskedCcNumber

                                                                                              string

                                                                                              Masked card Number

                                                                                              ObjectVersionNumber

                                                                                              int

                                                                                              Object Version Number

                                                                                              PartyId

                                                                                              long

                                                                                              Party Id

                                                                                              PartyName

                                                                                              string

                                                                                              Party name

                                                                                              PurchasecardFlag

                                                                                              boolean

                                                                                              Purchase card Flag

                                                                                              PurchasecardSubtype

                                                                                              string

                                                                                              Purchase Card Subtype

                                                                                              SingleUseFlag

                                                                                              boolean

                                                                                              Single Use Flag

                                                                                              StartDate

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

                                                                                              Start Date

                                                                                              Subtype

                                                                                              string

                                                                                              Card Subtype

                                                                                              TokenResponseBody

                                                                                              string

                                                                                              Token response Body

                                                                                              TokenResponseHeaders

                                                                                              string

                                                                                              Token Response Headers

                                                                                                External Bank Account Owner SDO

                                                                                                External Bank AccountOwner SDO

                                                                                                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 SDO

                                                                                                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

                                                                                                Account Owner Id
                                                                                                • Primary Key

                                                                                                AccountOwnerPartyId

                                                                                                long

                                                                                                Account Owner Party Id

                                                                                                CreatedBy

                                                                                                string

                                                                                                Created By

                                                                                                CreationDate

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

                                                                                                Creation Date

                                                                                                EndDate

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

                                                                                                End Date

                                                                                                EndDateDisp

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

                                                                                                End Date Disp

                                                                                                ExternalBankAccountId

                                                                                                long

                                                                                                External Bank Account ID

                                                                                                LastUpdateDate

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

                                                                                                Last Update Date

                                                                                                LastUpdateLogin

                                                                                                string

                                                                                                Last Update Login

                                                                                                LastUpdatedBy

                                                                                                string

                                                                                                Last Update By

                                                                                                ObjectVersionNumber

                                                                                                int

                                                                                                Object Version Number

                                                                                                PartyId

                                                                                                long

                                                                                                Party ID

                                                                                                PartyName

                                                                                                string

                                                                                                Party Name

                                                                                                PartyNameAlt

                                                                                                string

                                                                                                Party Name1

                                                                                                PartyNameId

                                                                                                long

                                                                                                PArty Name Id

                                                                                                PartyNameType

                                                                                                string

                                                                                                Party Name Type

                                                                                                PrimaryFlag

                                                                                                boolean

                                                                                                Priamry Flag

                                                                                                StartDate

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

                                                                                                Start Date

                                                                                                  External Bank Account SDO

                                                                                                  External Bank Account SDO

                                                                                                  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

                                                                                                  External Bank Account SDO

                                                                                                  Contains

                                                                                                  External Bank Account Owner SDO

                                                                                                  Contains

                                                                                                  Intermediary Bank Account Owner SDO

                                                                                                  Contained by

                                                                                                  Bank Account Assignment SDO

                                                                                                  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

                                                                                                  Account Classification

                                                                                                  AccountSuffix

                                                                                                  string

                                                                                                  Account Suffix

                                                                                                  AgencyLocationCode

                                                                                                  string

                                                                                                  Agency Location Code

                                                                                                  BAMaskSetting

                                                                                                  string

                                                                                                  Bank Account Mask Setting

                                                                                                  BAUnmaskLength

                                                                                                  int

                                                                                                  Bank Account UnMask Length

                                                                                                  BankAccountName

                                                                                                  string

                                                                                                  Bank Account Name

                                                                                                  BankAccountNameAlt

                                                                                                  string

                                                                                                  Bank Account Name Alternate

                                                                                                  BankAccountNumber

                                                                                                  string

                                                                                                  Bank Account Number

                                                                                                  BankAccountNumberElectronic

                                                                                                  string

                                                                                                  Bank Account Number Electronic

                                                                                                  BankAccountType

                                                                                                  string

                                                                                                  Bank Account Type

                                                                                                  BankBranchName

                                                                                                  string

                                                                                                  Bank Branch Name

                                                                                                  BankId

                                                                                                  long

                                                                                                  Bank Id

                                                                                                  BankName

                                                                                                  string

                                                                                                  Bank Name

                                                                                                  BankNumber

                                                                                                  string

                                                                                                  Bank Number

                                                                                                  BankPartyId

                                                                                                  long

                                                                                                  Bank Party ID

                                                                                                  BranchId

                                                                                                  long

                                                                                                  Branch ID

                                                                                                  BranchNumber

                                                                                                  string

                                                                                                  Branch Number

                                                                                                  BranchPartyId

                                                                                                  long

                                                                                                  Branch Party ID

                                                                                                  CheckDigits

                                                                                                  string

                                                                                                  Check Digits

                                                                                                  CountryCode

                                                                                                  string

                                                                                                  Country Code

                                                                                                  CreatedBy

                                                                                                  string

                                                                                                  Created By

                                                                                                  CreationDate

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

                                                                                                  Creation Date

                                                                                                  CurrencyCode

                                                                                                  string

                                                                                                  Currency Code

                                                                                                  Description

                                                                                                  string

                                                                                                  Description of the bank account

                                                                                                  EFTSWIFTCode

                                                                                                  string

                                                                                                  EFT SWIFT Code

                                                                                                  EndDate

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

                                                                                                  End Date

                                                                                                  EndDateDisp

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

                                                                                                  End Date Display

                                                                                                  EndId

                                                                                                  long

                                                                                                  End Id

                                                                                                  ExchangeRate

                                                                                                  decimal

                                                                                                  Exchange Rate

                                                                                                  ExchangeRateAgreementNumber

                                                                                                  string

                                                                                                  Exchange Rate Agreement Number

                                                                                                  ExchangeRateAgreementType

                                                                                                  string

                                                                                                  Exchange Rate Agreement Type

                                                                                                  ExtBankAcctDffVLA

                                                                                                  External Bank Account SDO

                                                                                                  External bank account DFF VLA

                                                                                                  ExternalBankAccountId

                                                                                                  long

                                                                                                  External Bank Account ID
                                                                                                  • Primary Key

                                                                                                  ExternalBankAccountOwner

                                                                                                  External Bank Account Owner SDO

                                                                                                  External Bank Account Owner

                                                                                                  ForeignPaymentUseFlag

                                                                                                  boolean

                                                                                                  Foreign Payment Use Flag

                                                                                                  HedgingContractReference

                                                                                                  string

                                                                                                  Hedging Contract Reference

                                                                                                  IBAN

                                                                                                  string

                                                                                                  Internationl Bank Account Number

                                                                                                  IntermediaryBankAccount

                                                                                                  Intermediary Bank Account Owner SDO

                                                                                                  Intermediary Bank Account

                                                                                                  LastUpdateDate

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

                                                                                                  Last Update Date

                                                                                                  LastUpdateLogin

                                                                                                  string

                                                                                                  Last Update Login

                                                                                                  LastUpdatedBy

                                                                                                  string

                                                                                                  Last Updated By

                                                                                                  MaskedBankAccountNumber

                                                                                                  string

                                                                                                  Masked Bank Account Number

                                                                                                  MaskedIBAN

                                                                                                  string

                                                                                                  Masked IBAN

                                                                                                  Name

                                                                                                  string

                                                                                                  Name of the bank account

                                                                                                  ObjectVersionNumber

                                                                                                  int

                                                                                                  Object Version Number

                                                                                                  PaymentFactorFlag

                                                                                                  boolean

                                                                                                  Payment Factor Flag

                                                                                                  SecondaryAccountReference

                                                                                                  string

                                                                                                  Secondary Account Reference

                                                                                                  ShortAccountName

                                                                                                  string

                                                                                                  Short Account Name

                                                                                                  StartDate

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

                                                                                                  Start Date

                                                                                                  StartId

                                                                                                  long

                                                                                                  Start Id

                                                                                                  TerritoryCode

                                                                                                  string

                                                                                                  Territory Code

                                                                                                  TerritoryShortName

                                                                                                  string

                                                                                                  Territory Short Name

                                                                                                    External Bank Account SDO

                                                                                                    External bank account VO

                                                                                                    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 SDO

                                                                                                    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

                                                                                                    External bank account id
                                                                                                    • Primary Key

                                                                                                    _FLEX_NumOfSegments

                                                                                                    int

                                                                                                    Number of segments

                                                                                                    _FLEX_ValidationDate

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

                                                                                                    Validate date

                                                                                                    __FLEX_Context

                                                                                                    string

                                                                                                    Context

                                                                                                      External Payer SDO

                                                                                                      External Payer

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

                                                                                                      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 Assignment SDO

                                                                                                      Contained by

                                                                                                      Bank Account Assignment SDO

                                                                                                      Handled by

                                                                                                      External Payer

                                                                                                      Attributes

                                                                                                      The following table describes attributes in the service data object.

                                                                                                      Name Type Description

                                                                                                      AccountSiteUseId

                                                                                                      long

                                                                                                      Account Site Use Id

                                                                                                      BankChargeBearerCode

                                                                                                      string

                                                                                                      Bank Charge Bearer Code

                                                                                                      CreatedBy

                                                                                                      string

                                                                                                      Created By

                                                                                                      CreationDate

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

                                                                                                      Creation Date

                                                                                                      CustomerAccountId

                                                                                                      long

                                                                                                      Customer Account Id

                                                                                                      DebitAdviceDeliveryMethod

                                                                                                      string

                                                                                                      Debit advice delivery method

                                                                                                      DebitAdviceEmail

                                                                                                      string

                                                                                                      Debit advice email

                                                                                                      DebitAdviceFax

                                                                                                      string

                                                                                                      Debit advice fax

                                                                                                      DefaultPaymentMethodCode

                                                                                                      string

                                                                                                      Default payment method code

                                                                                                      DirdebInstructionCode

                                                                                                      string

                                                                                                      Direct Debit Instruction Code

                                                                                                      ExternalPayerId

                                                                                                      long

                                                                                                      External Payer Id
                                                                                                      • Primary Key

                                                                                                      LastUpdateDate

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

                                                                                                      Last Update Date

                                                                                                      LastUpdateLogin

                                                                                                      string

                                                                                                      Last Update Login

                                                                                                      LastUpdatedBy

                                                                                                      string

                                                                                                      Last Updated By

                                                                                                      Localinstr

                                                                                                      string

                                                                                                      Local Instrument

                                                                                                      ObjectVersionNumber

                                                                                                      int

                                                                                                      Object version Number

                                                                                                      PartyId

                                                                                                      long

                                                                                                      Party Id

                                                                                                      PartyName

                                                                                                      string

                                                                                                      Party Name

                                                                                                      PartyNumber

                                                                                                      string

                                                                                                      Party Number

                                                                                                      PartyType

                                                                                                      string

                                                                                                      Party Type

                                                                                                      PaymentFunction

                                                                                                      string

                                                                                                      Payment Function

                                                                                                      PurposeCode

                                                                                                      string

                                                                                                      Purpose Code

                                                                                                      ServiceLevel

                                                                                                      string

                                                                                                      Service Level

                                                                                                        Instrument Use Attributes SDO

                                                                                                        Instrument Use Attributes SDO

                                                                                                        QName: {http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/flex/instrumentUseDff/}InstrumentUse

                                                                                                        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 Assignment SDO

                                                                                                        Contained by

                                                                                                        Bank Account Assignment SDO

                                                                                                        Handled by

                                                                                                        External Payer

                                                                                                        Attributes

                                                                                                        The following table describes attributes in the service data object.

                                                                                                        Name Type Description

                                                                                                        InstrumentPaymentUseId

                                                                                                        long

                                                                                                        Instrument Payment Use Id
                                                                                                        • Primary Key

                                                                                                        _FLEX_NumOfSegments

                                                                                                        int

                                                                                                        Number of instrument use flexfield segments

                                                                                                        _FLEX_ValidationDate

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

                                                                                                        Flexfield validation date

                                                                                                        __FLEX_Context

                                                                                                        string

                                                                                                        Context of instrument use flexfields

                                                                                                          Intermediary Bank Account Owner SDO

                                                                                                          Intermediary Bank Account SDO

                                                                                                          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 SDO

                                                                                                          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

                                                                                                          Account Number

                                                                                                          BIC

                                                                                                          string

                                                                                                          Branch identification code

                                                                                                          BankAccountId

                                                                                                          long

                                                                                                          Bank Account ID

                                                                                                          BankCode

                                                                                                          string

                                                                                                          Bank Code

                                                                                                          BankName

                                                                                                          string

                                                                                                          Bank Name

                                                                                                          BranchNumber

                                                                                                          string

                                                                                                          Branch Number

                                                                                                          CheckDigits

                                                                                                          string

                                                                                                          Check Digits

                                                                                                          City

                                                                                                          string

                                                                                                          City of the intermediary

                                                                                                          Comments

                                                                                                          string

                                                                                                          Comments for the intermediary

                                                                                                          CountryCode

                                                                                                          string

                                                                                                          Country Code

                                                                                                          CreatedBy

                                                                                                          string

                                                                                                          Created By

                                                                                                          CreationDate

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

                                                                                                          Creation Date

                                                                                                          IBAN

                                                                                                          string

                                                                                                          Internationl bank account number

                                                                                                          IntermediaryAccountId

                                                                                                          long

                                                                                                          Intermediary Account Id
                                                                                                          • Primary Key

                                                                                                          InternalBankAccountId

                                                                                                          long

                                                                                                          Ineternal Bank Account ID

                                                                                                          LastUpdateDate

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

                                                                                                          Last Update Date

                                                                                                          LastUpdateLogin

                                                                                                          string

                                                                                                          Last Update Login

                                                                                                          LastUpdatedBy

                                                                                                          string

                                                                                                          Last Updated By

                                                                                                          ObjectVersionNumber

                                                                                                          int

                                                                                                          Object Version Number

                                                                                                          TerritoryCode

                                                                                                          string

                                                                                                          Territory Code

                                                                                                          TerritoryShortName

                                                                                                          string

                                                                                                          Territory Short Name

                                                                                                            Party-Owned Payment Instrument SDO

                                                                                                            Party Owned Payment Instrument

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

                                                                                                            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

                                                                                                            Account Number

                                                                                                            BICNumber

                                                                                                            string

                                                                                                            BIC Number

                                                                                                            BankName

                                                                                                            string

                                                                                                            Bank name

                                                                                                            BankNumber

                                                                                                            string

                                                                                                            Bank Number

                                                                                                            BranchName

                                                                                                            string

                                                                                                            Branch Name

                                                                                                            BranchNumber

                                                                                                            string

                                                                                                            Branch Number

                                                                                                            CardBillingAddressId

                                                                                                            decimal

                                                                                                            Card Billing Address Id

                                                                                                            CardExpirydate

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

                                                                                                            Card Expiry Date

                                                                                                            CardFiName

                                                                                                            string

                                                                                                            Card FI Name

                                                                                                            CardHolderName

                                                                                                            string

                                                                                                            Card Holder name

                                                                                                            CardIssuerCode

                                                                                                            string

                                                                                                            Card Issuer Code

                                                                                                            CardIssuerName

                                                                                                            string

                                                                                                            Card Issuer Name

                                                                                                            CardNumber

                                                                                                            string

                                                                                                            Card Number

                                                                                                            CardSingleUseFlag

                                                                                                            boolean

                                                                                                            card Single Use Flag

                                                                                                            CurrencyCode

                                                                                                            string

                                                                                                            Currency Code

                                                                                                            Description

                                                                                                            string

                                                                                                            Account Description

                                                                                                            InstrumentId

                                                                                                            long

                                                                                                            Instrument Id
                                                                                                            • Primary Key

                                                                                                            InstrumentType

                                                                                                            string

                                                                                                            Instrument Type
                                                                                                            • Primary Key

                                                                                                            PartyId

                                                                                                            long

                                                                                                            Party Id
                                                                                                            • Primary Key

                                                                                                            PurchasecardSubtype

                                                                                                            string

                                                                                                            Purchase card Subtype

                                                                                                              Financial Reporting Service for Coexistence with E-Business Suite

                                                                                                              A web service for Oracle Fusion Financials to transfer balances from Oracle E-Business Suite.

                                                                                                              Life Cycle Status: Active

                                                                                                              QName: {http://xmlns.oracle.com/apps/financials/generalLedger/inquiry/coexistence/publicService/}CoexistenceService

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

                                                                                                              Operations

                                                                                                              registerEBSInstance

                                                                                                              This operation registers the E-Business Suite instance on Oracle Fusion Cloud instance.

                                                                                                              Life Cycle Status: Active

                                                                                                              Request Payload

                                                                                                              Element Name Type Description

                                                                                                              systemId

                                                                                                              long

                                                                                                              The E-Business Suite system identification number.

                                                                                                              name

                                                                                                              string

                                                                                                              The E-Business Suite system identification name.

                                                                                                              drilldownURL

                                                                                                              string

                                                                                                              The E-Business Suite URL for drill down from Oracle Fusion Cloud Instance.

                                                                                                              Response Payload

                                                                                                              Element Name Type Description

                                                                                                              result

                                                                                                              string

                                                                                                              The status of the registration is returned.

                                                                                                              transfer

                                                                                                              This operation transfers balances from Oracle E-Business Suite to Oracle Fusion Cloud.

                                                                                                              Life Cycle Status: Active

                                                                                                              Request Payload

                                                                                                              Element Name Type Description

                                                                                                              transferId

                                                                                                              long

                                                                                                              The internal identification number of the balance transfer.

                                                                                                              systemId

                                                                                                              long

                                                                                                              The E-Business Suite system identification number.

                                                                                                              transferTypeCode

                                                                                                              string

                                                                                                              The code for the transfer type. Valid values are LEDGER_CONFIG and TRANSFER_BALANCES.

                                                                                                              totalNumberOfFiles

                                                                                                              long

                                                                                                              The total number of data files to be transferred to Oracle Fusion for this particular balance transfer.

                                                                                                              currentChunkNumber

                                                                                                              long

                                                                                                              The sequence number of the data file that is currently being transferred by this service operation.

                                                                                                              configFile

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

                                                                                                              The setup data file.

                                                                                                              periodStatusFile

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

                                                                                                              The period status data file.

                                                                                                              balanceFile

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

                                                                                                              The balances data file.

                                                                                                              ledgerId

                                                                                                              long

                                                                                                              The unique identifier for the ledger.

                                                                                                              Response Payload

                                                                                                              Element Name Type Description

                                                                                                              result

                                                                                                              string

                                                                                                              The submission status of the balance transfer is returned.

                                                                                                              reverseTransfer

                                                                                                              This operation reverses a previous balance transfer request from Oracle E-Business Suite to Oracle Fusion Accounting Hub Reporting Cloud Service.

                                                                                                              Life Cycle Status: Active

                                                                                                              Request Payload

                                                                                                              Element Name Type Description

                                                                                                              transferId

                                                                                                              long

                                                                                                              The internal identification number of the balance transfer to be reversed.

                                                                                                              systemId

                                                                                                              long

                                                                                                              The E-Business Suite system identification number.

                                                                                                              ledgerId

                                                                                                              long