Jump to

• Request
• Response

Get all expense entertainment policies

get

/fscmRestApi/resources/11.13.18.05/expenseEntertainmentPolicies

Request

Query Parameters

• expand: string
  When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
• fields: string
  This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
  
  Format: ?fields=Attribute1,Attribute2
  
  Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
• finder: string
  Used as a predefined finder to search the collection.
  
  Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
  
  The following are the available finder names and corresponding finder variables
  
  

  • PrimaryKey Finds the expense entertainment policy record that matches the primary key criteria specified.
    Finder Variables
    • EntertainmentPolicyId; integer; The unique identifier of the expense entertainment policy record.
• limit: integer
  This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
• links: string
  This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
  
  Example:
  self,canonical
  
• offset: integer
  Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
• onlyData: boolean
  The resource item payload will be filtered in order to contain only data (no links section, for example).
• orderBy: string
  This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
• q: string
  This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
  
  Format: ?q=expression1;expression2
  
  You can use these queryable attributes to filter this collection resource using the q query parameter:
  

  • AttendeeTypesFlag; boolean; Indicates whether attendee type is used to determine expense policy rates. Valid values are Yes and No.
  • CreatedBy; string; User who created the row.
  • CreationDate; string; Date and time when the row was created.
  • Currency; string; Currency of an entertainment expense policy when rates are defined in a single currency.
  • CurrencyCode; string; Currency code for an entertainment expense policy when rates are defined in a single currency.
  • CurrencyOption; string; Entertainment expense policy defined for a single currency or for multiple currencies.
  • CurrencyOptionCode; string; Indicates the entertainment expense policy defined for a single currency or for multiple currencies. Values are from the lookup EXM_CURRENCY_OPTION.
  • Description; string; Description of the entertainment expense policy.
  • DispWarningToUserFlag; boolean; Indicates whether an entertainment expense policy warning is displayed to the user.
  • EmployeeAttendeeAmount; string; Indicates whether employee attendee amount is required, optional, or hidden.
  • EmployeeAttendeeAmountCode; string; Code that indicates whether employee attendee amount is required, optional, or hidden. Values are from the look up EXM_FIELD_BEHAVIOUR.
  • EmployeeAttendeeInformationFlag; boolean; Indicates whether employee attendee-related fields display during entertainment expense entry. Employee attendee-related fields include Employee Name and Title.
  • EmployeeRateDeterminant; string; Indicates whether employee is used as the entertainment policy rate determinant.
  • EmployeeRateDeterminantFlag; boolean; Indicates whether employee is used as the entertainment policy rate determinant. Values are from the lookup EXM_YES_NO.
  • EmployeeRequiredAsAttendeeFlag; boolean; Indicates whether user needs to enter at least one employee name as attendee while creating an attendee in expense entry.
  • EmployerCreation; string; Indicates whether user can create nonemployee employer.
  • EmployerCreationFlag; boolean; Indicates whether user can create nonemployee employer. Values are from the lookup EXM_YES_NO.
  • EnabledRateLimitFlag; boolean; Indicates whether entertainment expense policy rate limits are enforced.
  • EntertainmentPolicyId; integer; The unique identifier of the entertainment expense policy.
  • ErrorTolerance; number; Percentage added to the entertainment expense policy amount limit to obtain the maximum allowable limit for expense report submission.
  • IndividAttendeeAmountFlag; boolean; Indicates whether the employee is required to enter the amount for individual event attendees.
  • LastUpdateDate; string; Date and time when the row was last updated
  • LastUpdateLogin; string; Session login of user who last updated the row.
  • LastUpdatedBy; string; User who last updated the row.
  • NonEmployeeAttendeeAddrs; string; Indicates whether nonemployee employer address is required, optional, or hidden.
  • NonEmployeeAttendeeAddrsCode; string; Code that indicates whether nonemployee employer address is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.
  • NonEmployeeAttendeeAmount; string; Indicates whether nonemployee attendee amount is required, optional, or hidden.
  • NonEmployeeAttendeeAmountCode; string; Code that indicates whether nonemployee attendee amount is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.
  • NonEmployeeAttendeeInformationFlag; boolean; Indicates whether nonemployee attendee-related fields display during entertainment expense entry. Nonemployee attendee-related fields include Name, Employer, and Address.
  • NonEmployeeAttendeeType; string; Indicates whether nonemployee attendee type is required, optional, or hidden.
  • NonEmployeeAttendeeTypeCode; string; Code that indicates whether nonemployee attendee type is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.
  • NonEmployeeCreation; string; Indicates whether the user can create a nonemployee.
  • NonEmployeeCreationFlag; boolean; Indicates whether the user can create a nonemployee. Values are from the lookup EXM_YES_NO.
  • NonEmployeeJobTitle; string; Indicates whether nonemployee job title is required, optional, or hidden.
  • NonEmployeeJobTitleCode; string; Code that indicates whether nonemployee job title is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.
  • NonEmployeeRateDeterminant; string; Indicates whether nonemployee is used as the entertainment policy rate determinant.
  • NonEmployeeRateDeterminantFlag; boolean; Indicates whether nonemployee is used to determine the entertainment policy rate. Values are from the lookup EXM_YES_NO.
  • NonEmployeeRequiredAttendee; string; Indicates whether the user is required to enter at least one nonemployee as attendee.
  • NonEmployeeRequiredAttendeeFlag; boolean; Indicates whether the user is required to enter at least one nonemployee as attendee. Values are from the lookup EXM_YES_NO.
  • NumberOfAttendeesAmount; number; Amount above which capturing the number of attendees is mandatory.
  • NumberOfAttendeesCurrencyCode; string; Currency code for the amount above which capturing the number of attendees is mandatory.
  • NumberOfAttendeesFlag; boolean; Indicates whether capturing the number of attendees is mandatory.
  • PeriodDay; integer; Start date from which entertainment expense policy annual rate limit is counted. Values are from the lookup DAY.
  • PeriodMonth; string; Starting month from which entertainment expense policy annual rate limit is counted. Values are from the lookup MONTH.
  • PolicyEnforcement; string; Type of entertainment expense policy enforcement applied.
  • PolicyEnforcementCode; string; Indicates the type of entertainment expense policy enforcement applied. Values are from the lookup ORA_EXM_ENTERT_POL_ENFORCEM.
  • PolicyName; string; Name of the entertainment expense policy.
  • PolicyViolationFlag; boolean; Indicates whether employees are warned when they submit expenses that exceed the defined entertainment expense policy rate limit.
  • PreventSubmissionFlag; boolean; Indicates whether expense report submission is prevented if an entertainment expense policy violation occurs.
  • RateLimitType; string; Indicates whether policy rate limit is defined per expense type or per attendee.
  • RateLimitTypeCode; string; Code that indicates whether policy rate limit is defined per expense type or per attendee. Values are from the lookup ORA_EXM_LIMIT_TYPE.
  • SingleInstanceLimitFlag; boolean; Indicates whether entertainment expense policy limits are enforced by each submitted instance of an entertainment expense item.
  • Status; string; Status of entertainment expense policy. Valid values are Draft, Valid, Invalid, and Active.
  • StatusCode; string; Indicates the status of entertainment expense policy. Values are from lookup EXM_POLICY_STATUS.
  • WarningTolerance; number; Percentage added to entertainment expense policy amount limit to obtain the maximum allowable limit for a policy warning violation.
  • YearlyLimitFlag; boolean; Indicates whether entertainment expense policy limits are enforced by maximum permitted annual amount. Valid values are Yes and No.
• totalResults: boolean
  The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".

Header Parameters

• Metadata-Context: string
  If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
• REST-Framework-Version: string
  The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

Default Response

The following table describes the default response for this task.

Headers

• Metadata-Context:
  If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
• REST-Framework-Version:
  The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

Body ()

Root Schema : expenseEntertainmentPolicies

Type: object

Show Source

• count(required): integer
  The number of resource instances returned in the current range.
• hasMore(required): boolean
  Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
• items: array Items
  Title: Items

  The items in the collection.
• limit(required): integer
  The actual paging size used by the server.
• links(required): array Links
  Title: Links

  The link relations associated with the resource instance.
• offset(required): integer
  The offset value used in the current page.
• totalResults: integer
  The estimated row count when "?totalResults=true", otherwise the count is not included.

{
    "required":[
        "count",
        "hasMore",
        "limit",
        "links",
        "offset"
    ],
    "type":"object",
    "properties":{
        "totalResults":{
            "type":"integer",
            "description":"The estimated row count when \"?totalResults=true\", otherwise the count is not included."
        },
        "offset":{
            "type":"integer",
            "description":"The offset value used in the current page."
        },
        "count":{
            "type":"integer",
            "description":"The number of resource instances returned in the current range."
        },
        "hasMore":{
            "type":"boolean",
            "description":"Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false."
        },
        "limit":{
            "type":"integer",
            "description":"The actual paging size used by the server."
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "items":{
            "title":"Items",
            "type":"array",
            "description":"The items in the collection.",
            "items":{
                "$ref":"#/components/schemas/expenseEntertainmentPolicies-item-response"
            }
        }
    },
    "x-hints":{
        "usage":"BusinessObject"
    }
}

Nested Schema : Items

Type: array

Title: Items

The items in the collection.

Show Source

• Array of: object expenseEntertainmentPolicies-item-response

{
    "title":"Items",
    "type":"array",
    "description":"The items in the collection.",
    "items":{
        "$ref":"#/components/schemas/expenseEntertainmentPolicies-item-response"
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : expenseEntertainmentPolicies-item-response

Type: object

Show Source

• AttendeeTypesFlag: boolean
  Title: Nonemployee Attendee Types

  Maximum Length: 1

  Indicates whether attendee type is used to determine expense policy rates. Valid values are Yes and No.
• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  User who created the row.
• CreationDate: string (date-time)
  Read Only: true

  Date and time when the row was created.
• Currency: string
  Title: Description

  Read Only: true

  Maximum Length: 240

  Currency of an entertainment expense policy when rates are defined in a single currency.
• CurrencyCode: string
  Title: Currency

  Maximum Length: 15

  Currency code for an entertainment expense policy when rates are defined in a single currency.
• CurrencyOption: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Entertainment expense policy defined for a single currency or for multiple currencies.
• CurrencyOptionCode: string
  Title: Rate Currency

  Maximum Length: 30

  Indicates the entertainment expense policy defined for a single currency or for multiple currencies. Values are from the lookup EXM_CURRENCY_OPTION.
• Description: string
  Title: Description

  Maximum Length: 240

  Description of the entertainment expense policy.
• DispWarningToUserFlag: boolean
  Title: Display Warning to User

  Maximum Length: 1

  Indicates whether an entertainment expense policy warning is displayed to the user.
• EmployeeAttendeeAmount: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether employee attendee amount is required, optional, or hidden.
• EmployeeAttendeeAmountCode: string
  Title: Attendee Amount

  Maximum Length: 30

  Code that indicates whether employee attendee amount is required, optional, or hidden. Values are from the look up EXM_FIELD_BEHAVIOUR.
• EmployeeAttendeeInformationFlag: boolean
  Title: Display employee attendee information

  Maximum Length: 1

  Indicates whether employee attendee-related fields display during entertainment expense entry. Employee attendee-related fields include Employee Name and Title.
• EmployeeRateDeterminant: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether employee is used as the entertainment policy rate determinant.
• EmployeeRateDeterminantFlag: boolean
  Title: Employee

  Maximum Length: 1

  Indicates whether employee is used as the entertainment policy rate determinant. Values are from the lookup EXM_YES_NO.
• EmployeeRequiredAsAttendeeFlag: boolean
  Title: Require at least one employee as attendee

  Maximum Length: 1

  Indicates whether user needs to enter at least one employee name as attendee while creating an attendee in expense entry.
• EmployerCreation: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether user can create nonemployee employer.
• EmployerCreationFlag: boolean
  Title: Enable Employer Creation

  Maximum Length: 1

  Indicates whether user can create nonemployee employer. Values are from the lookup EXM_YES_NO.
• EnabledRateLimitFlag: boolean
  Title: Enable rate limit

  Maximum Length: 1

  Indicates whether entertainment expense policy rate limits are enforced.
• EntertainmentPolicyId: integer (int64)
  The unique identifier of the entertainment expense policy.
• ErrorTolerance: number
  Title: Error Tolerance Percentage

  Percentage added to the entertainment expense policy amount limit to obtain the maximum allowable limit for expense report submission.
• expenseEntertainmentPolicyLines: array Expense Entertainment Policy Lines
  Title: Expense Entertainment Policy Lines

  The expense entertainment policy lines resource is used to view entertainment expense policy line records.
• IndividAttendeeAmountFlag: boolean
  Title: Require attendee amount

  Maximum Length: 1

  Indicates whether the employee is required to enter the amount for individual event attendees.
• LastUpdateDate: string (date-time)
  Read Only: true

  Date and time when the row was last updated
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User who last updated the row.
• LastUpdateLogin: string
  Read Only: true

  Maximum Length: 32

  Session login of user who last updated the row.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• NonEmployeeAttendeeAddrs: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether nonemployee employer address is required, optional, or hidden.
• NonEmployeeAttendeeAddrsCode: string
  Title: Employer Address

  Maximum Length: 30

  Code that indicates whether nonemployee employer address is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.
• NonEmployeeAttendeeAmount: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether nonemployee attendee amount is required, optional, or hidden.
• NonEmployeeAttendeeAmountCode: string
  Title: Attendee Amount

  Maximum Length: 30

  Code that indicates whether nonemployee attendee amount is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.
• NonEmployeeAttendeeInformationFlag: boolean
  Title: Display nonemployee attendee information

  Maximum Length: 1

  Indicates whether nonemployee attendee-related fields display during entertainment expense entry. Nonemployee attendee-related fields include Name, Employer, and Address.
• NonEmployeeAttendeeType: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether nonemployee attendee type is required, optional, or hidden.
• NonEmployeeAttendeeTypeCode: string
  Title: Attendee Type

  Maximum Length: 30

  Code that indicates whether nonemployee attendee type is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.
• NonEmployeeCreation: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether the user can create a nonemployee.
• NonEmployeeCreationFlag: boolean
  Title: Enable nonemployee creation

  Maximum Length: 1

  Indicates whether the user can create a nonemployee. Values are from the lookup EXM_YES_NO.
• NonEmployeeJobTitle: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether nonemployee job title is required, optional, or hidden.
• NonEmployeeJobTitleCode: string
  Title: Job Title

  Maximum Length: 30

  Code that indicates whether nonemployee job title is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.
• NonEmployeeRateDeterminant: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether nonemployee is used as the entertainment policy rate determinant.
• NonEmployeeRateDeterminantFlag: boolean
  Title: Nonemployee

  Maximum Length: 1

  Indicates whether nonemployee is used to determine the entertainment policy rate. Values are from the lookup EXM_YES_NO.
• NonEmployeeRequiredAttendee: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether the user is required to enter at least one nonemployee as attendee.
• NonEmployeeRequiredAttendeeFlag: boolean
  Title: Require at least one nonemployee as attendee

  Maximum Length: 1

  Indicates whether the user is required to enter at least one nonemployee as attendee. Values are from the lookup EXM_YES_NO.
• NumberOfAttendeesAmount: number
  Amount above which capturing the number of attendees is mandatory.
• NumberOfAttendeesCurrencyCode: string
  Maximum Length: 15

  Currency code for the amount above which capturing the number of attendees is mandatory.
• NumberOfAttendeesFlag: boolean
  Maximum Length: 1

  Indicates whether capturing the number of attendees is mandatory.
• PeriodDay: integer (int32)
  Title: Period Start Day

  Start date from which entertainment expense policy annual rate limit is counted. Values are from the lookup DAY.
• PeriodMonth: string
  Title: Period Start Month

  Maximum Length: 30

  Starting month from which entertainment expense policy annual rate limit is counted. Values are from the lookup MONTH.
• PolicyEnforcement: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Type of entertainment expense policy enforcement applied.
• PolicyEnforcementCode: string
  Maximum Length: 30

  Indicates the type of entertainment expense policy enforcement applied. Values are from the lookup ORA_EXM_ENTERT_POL_ENFORCEM.
• PolicyName: string
  Title: Policy Name

  Maximum Length: 60

  Name of the entertainment expense policy.
• PolicyViolationFlag: boolean
  Title: Policy violation warning

  Maximum Length: 1

  Indicates whether employees are warned when they submit expenses that exceed the defined entertainment expense policy rate limit.
• PreventSubmissionFlag: boolean
  Title: Prevent report submission

  Maximum Length: 1

  Indicates whether expense report submission is prevented if an entertainment expense policy violation occurs.
• RateLimitType: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Indicates whether policy rate limit is defined per expense type or per attendee.
• RateLimitTypeCode: string
  Title: Enable Rate Limit

  Maximum Length: 30

  Code that indicates whether policy rate limit is defined per expense type or per attendee. Values are from the lookup ORA_EXM_LIMIT_TYPE.
• SingleInstanceLimitFlag: boolean
  Title: Single instance limit

  Maximum Length: 1

  Indicates whether entertainment expense policy limits are enforced by each submitted instance of an entertainment expense item.
• Status: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Status of entertainment expense policy. Valid values are Draft, Valid, Invalid, and Active.
• StatusCode: string
  Title: Status

  Maximum Length: 30

  Indicates the status of entertainment expense policy. Values are from lookup EXM_POLICY_STATUS.
• WarningTolerance: number
  Title: Warning Tolerance Percentage

  Percentage added to entertainment expense policy amount limit to obtain the maximum allowable limit for a policy warning violation.
• YearlyLimitFlag: boolean
  Title: Yearly limit

  Maximum Length: 1

  Indicates whether entertainment expense policy limits are enforced by maximum permitted annual amount. Valid values are Yes and No.

{
    "type":"object",
    "properties":{
        "EnabledRateLimitFlag":{
            "title":"Enable rate limit",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether entertainment expense policy rate limits are enforced.",
            "nullable":true,
            "x-queryable":true
        },
        "CreationDate":{
            "type":"string",
            "description":"Date and time when the row was created.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "SingleInstanceLimitFlag":{
            "title":"Single instance limit",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether entertainment expense policy limits are enforced by each submitted instance of an entertainment expense item.",
            "nullable":true,
            "x-queryable":true
        },
        "WarningTolerance":{
            "title":"Warning Tolerance Percentage",
            "type":"number",
            "description":"Percentage added to entertainment expense policy amount limit to obtain the maximum allowable limit for a policy warning violation.",
            "nullable":true,
            "x-queryable":true
        },
        "StatusCode":{
            "title":"Status",
            "maxLength":30,
            "type":"string",
            "description":"Indicates the status of entertainment expense policy. Values are from lookup EXM_POLICY_STATUS.",
            "nullable":true,
            "x-queryable":true
        },
        "CurrencyCode":{
            "title":"Currency",
            "maxLength":15,
            "type":"string",
            "description":"Currency code for an entertainment expense policy when rates are defined in a single currency.",
            "nullable":true,
            "x-queryable":true
        },
        "EmployeeRequiredAsAttendeeFlag":{
            "title":"Require at least one employee as attendee",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether user needs to enter at least one employee name as attendee while creating an attendee in expense entry.",
            "nullable":true,
            "x-queryable":true
        },
        "IndividAttendeeAmountFlag":{
            "title":"Require attendee amount",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether the employee is required to enter the amount for individual event attendees.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeAttendeeInformationFlag":{
            "title":"Display nonemployee attendee information",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether nonemployee attendee-related fields display during entertainment expense entry. Nonemployee attendee-related fields include Name, Employer, and Address.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeRequiredAttendeeFlag":{
            "title":"Require at least one nonemployee as attendee",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether the user is required to enter at least one nonemployee as attendee. Values are from the lookup EXM_YES_NO.",
            "nullable":true,
            "x-queryable":true
        },
        "Currency":{
            "title":"Description",
            "maxLength":240,
            "type":"string",
            "description":"Currency of an entertainment expense policy when rates are defined in a single currency.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "NumberOfAttendeesCurrencyCode":{
            "maxLength":15,
            "type":"string",
            "description":"Currency code for the amount above which capturing the number of attendees is mandatory.",
            "nullable":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "ErrorTolerance":{
            "title":"Error Tolerance Percentage",
            "type":"number",
            "description":"Percentage added to the entertainment expense policy amount limit to obtain the maximum allowable limit for expense report submission.",
            "nullable":true,
            "x-queryable":true
        },
        "PreventSubmissionFlag":{
            "title":"Prevent report submission",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether expense report submission is prevented if an entertainment expense policy violation occurs.",
            "nullable":true,
            "x-queryable":true
        },
        "YearlyLimitFlag":{
            "title":"Yearly limit",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether entertainment expense policy limits are enforced by maximum permitted annual amount. Valid values are Yes and No.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeJobTitleCode":{
            "title":"Job Title",
            "maxLength":30,
            "type":"string",
            "description":"Code that indicates whether nonemployee job title is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.",
            "nullable":true,
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who last updated the row.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "Status":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Status of entertainment expense policy. Valid values are Draft, Valid, Invalid, and Active.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "EmployerCreation":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether user can create nonemployee employer.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "EmployeeAttendeeAmount":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether employee attendee amount is required, optional, or hidden.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "DispWarningToUserFlag":{
            "title":"Display Warning to User",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether an entertainment expense policy warning is displayed to the user.",
            "nullable":true,
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who created the row.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "EmployerCreationFlag":{
            "title":"Enable Employer Creation",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether user can create nonemployee employer. Values are from the lookup EXM_YES_NO.",
            "nullable":true,
            "x-queryable":true
        },
        "EmployeeRateDeterminantFlag":{
            "title":"Employee",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether employee is used as the entertainment policy rate determinant. Values are from the lookup EXM_YES_NO.",
            "nullable":true,
            "x-queryable":true
        },
        "NumberOfAttendeesFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether capturing the number of attendees is mandatory.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeAttendeeAmountCode":{
            "title":"Attendee Amount",
            "maxLength":30,
            "type":"string",
            "description":"Code that indicates whether nonemployee attendee amount is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeRequiredAttendee":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether the user is required to enter at least one nonemployee as attendee.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CurrencyOptionCode":{
            "title":"Rate Currency",
            "maxLength":30,
            "type":"string",
            "description":"Indicates the entertainment expense policy defined for a single currency or for multiple currencies. Values are from the lookup EXM_CURRENCY_OPTION.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeAttendeeAddrsCode":{
            "title":"Employer Address",
            "maxLength":30,
            "type":"string",
            "description":"Code that indicates whether nonemployee employer address is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.",
            "nullable":true,
            "x-queryable":true
        },
        "PeriodMonth":{
            "title":"Period Start Month",
            "maxLength":30,
            "type":"string",
            "description":"Starting month from which entertainment expense policy annual rate limit is counted. Values are from the lookup MONTH.",
            "nullable":true,
            "x-queryable":true
        },
        "EmployeeAttendeeInformationFlag":{
            "title":"Display employee attendee information",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether employee attendee-related fields display during entertainment expense entry. Employee attendee-related fields include Employee Name and Title.",
            "nullable":true,
            "x-queryable":true
        },
        "PolicyEnforcementCode":{
            "maxLength":30,
            "type":"string",
            "description":"Indicates the type of entertainment expense policy enforcement applied. Values are from the lookup ORA_EXM_ENTERT_POL_ENFORCEM.",
            "nullable":true,
            "x-queryable":true
        },
        "AttendeeTypesFlag":{
            "title":"Nonemployee Attendee Types",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether attendee type is used to determine expense policy rates. Valid values are Yes and No.",
            "nullable":true,
            "x-queryable":true
        },
        "PolicyName":{
            "title":"Policy Name",
            "maxLength":60,
            "type":"string",
            "description":"Name of the entertainment expense policy.",
            "nullable":false,
            "x-queryable":true
        },
        "NonEmployeeAttendeeAmount":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether nonemployee attendee amount is required, optional, or hidden.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "RateLimitType":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether policy rate limit is defined per expense type or per attendee.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Session login of user who last updated the row.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Description":{
            "title":"Description",
            "maxLength":240,
            "type":"string",
            "description":"Description of the entertainment expense policy.",
            "nullable":true,
            "x-queryable":true
        },
        "EmployeeAttendeeAmountCode":{
            "title":"Attendee Amount",
            "maxLength":30,
            "type":"string",
            "description":"Code that indicates whether employee attendee amount is required, optional, or hidden. Values are from the look up EXM_FIELD_BEHAVIOUR.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeAttendeeType":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether nonemployee attendee type is required, optional, or hidden.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "NonEmployeeAttendeeAddrs":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether nonemployee employer address is required, optional, or hidden.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "PeriodDay":{
            "title":"Period Start Day",
            "type":"integer",
            "description":"Start date from which entertainment expense policy annual rate limit is counted. Values are from the lookup DAY.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":2
            },
            "x-queryable":true
        },
        "expenseEntertainmentPolicyLines":{
            "title":"Expense Entertainment Policy Lines",
            "type":"array",
            "description":"The expense entertainment policy lines resource is used to view entertainment expense policy line records.",
            "items":{
                "$ref":"#/components/schemas/expenseEntertainmentPolicies-expenseEntertainmentPolicyLines-item-response"
            }
        },
        "NonEmployeeRateDeterminant":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether nonemployee is used as the entertainment policy rate determinant.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "NonEmployeeRateDeterminantFlag":{
            "title":"Nonemployee",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether nonemployee is used to determine the entertainment policy rate. Values are from the lookup EXM_YES_NO.",
            "nullable":true,
            "x-queryable":true
        },
        "PolicyViolationFlag":{
            "title":"Policy violation warning",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether employees are warned when they submit expenses that exceed the defined entertainment expense policy rate limit.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeCreation":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether the user can create a nonemployee.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CurrencyOption":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Entertainment expense policy defined for a single currency or for multiple currencies.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "PolicyEnforcement":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Type of entertainment expense policy enforcement applied.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "RateLimitTypeCode":{
            "title":"Enable Rate Limit",
            "maxLength":30,
            "type":"string",
            "description":"Code that indicates whether policy rate limit is defined per expense type or per attendee. Values are from the lookup ORA_EXM_LIMIT_TYPE.",
            "nullable":true,
            "x-queryable":true
        },
        "EmployeeRateDeterminant":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether employee is used as the entertainment policy rate determinant.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "NonEmployeeAttendeeTypeCode":{
            "title":"Attendee Type",
            "maxLength":30,
            "type":"string",
            "description":"Code that indicates whether nonemployee attendee type is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeCreationFlag":{
            "title":"Enable nonemployee creation",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether the user can create a nonemployee. Values are from the lookup EXM_YES_NO.",
            "nullable":true,
            "x-queryable":true
        },
        "NonEmployeeJobTitle":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Indicates whether nonemployee job title is required, optional, or hidden.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "EntertainmentPolicyId":{
            "type":"integer",
            "description":"The unique identifier of the entertainment expense policy.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "NumberOfAttendeesAmount":{
            "type":"number",
            "description":"Amount above which capturing the number of attendees is mandatory.",
            "nullable":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Date and time when the row was last updated",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        }
    }
}

Nested Schema : Expense Entertainment Policy Lines

Type: array

Title: Expense Entertainment Policy Lines

The expense entertainment policy lines resource is used to view entertainment expense policy line records.

Show Source

• Array of: object expenseEntertainmentPolicies-expenseEntertainmentPolicyLines-item-response

{
    "title":"Expense Entertainment Policy Lines",
    "type":"array",
    "description":"The expense entertainment policy lines resource is used to view entertainment expense policy line records.",
    "items":{
        "$ref":"#/components/schemas/expenseEntertainmentPolicies-expenseEntertainmentPolicyLines-item-response"
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : expenseEntertainmentPolicies-expenseEntertainmentPolicyLines-item-response

Type: object

Show Source

• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  User who created the row.
• CreationDate: string (date-time)
  Read Only: true

  Date and time when the row was created.
• Currency: string
  Title: Description

  Read Only: true

  Maximum Length: 240

  Currency of an entertainment expense policy line.
• CurrencyCode: string
  Title: Currency

  Maximum Length: 15

  Currency code for entertainment expense policies with multiple currencies.
• EndDate: string (date)
  Title: End Date

  End date of entertainment expense policy line.
• EntertainmentPolicyId: integer (int64)
  The unique identifier of the entertainment expense policy.
• InvalidCode: string
  Maximum Length: 30

  Indicates why an entertainment expense policy line has the invalid status.
• LastUpdateDate: string (date-time)
  Read Only: true

  Date and time when the row was last updated
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User who last updated the row.
• LastUpdateLogin: string
  Read Only: true

  Maximum Length: 32

  Session login of user who last updated the row.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• PolicyLineId: integer (int64)
  The unique identifier of the entertainment expense policy line.
• SingleInstanceLimit: number
  Title: Single instance limit

  Single instance reimbursement limit for entertainment expenses.
• StartDate: string (date)
  Title: Start Date

  Start date of the entertainment expense policy line.
• Status: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Status of the entertainment expense policy line. Valid values are draft, valid, and invalid.
• StatusCode: string
  Title: Status

  Maximum Length: 30

  Indicates the status of the entertainment expense policy line. Values are from the lookup EXM_POLICY_STATUS.
• TypeOfAttende: string
  Title: Meaning

  Read Only: true

  Maximum Length: 80

  Type of event attendee for this entertainment policy line.
• TypeOfAttendeCode: string
  Title: Nonemployee Attendee Types

  Maximum Length: 30

  Indicates the type of event attendee for this entertainment policy line. Values are from the lookup EXM_ATTENDEE_TYPES.
• YearlyLimit: number
  Title: Yearly limit

  Annual reimbursement limit for entertainment expenses.

{
    "type":"object",
    "properties":{
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who last updated the row.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "Status":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Status of the entertainment expense policy line. Valid values are draft, valid, and invalid.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CreationDate":{
            "type":"string",
            "description":"Date and time when the row was created.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who created the row.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "SingleInstanceLimit":{
            "title":"Single instance limit",
            "type":"number",
            "description":"Single instance reimbursement limit for entertainment expenses.",
            "nullable":true,
            "x-queryable":true
        },
        "EndDate":{
            "title":"End Date",
            "type":"string",
            "description":"End date of entertainment expense policy line.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "PolicyLineId":{
            "type":"integer",
            "description":"The unique identifier of the entertainment expense policy line.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "StatusCode":{
            "title":"Status",
            "maxLength":30,
            "type":"string",
            "description":"Indicates the status of the entertainment expense policy line. Values are from the lookup EXM_POLICY_STATUS.",
            "nullable":true,
            "x-queryable":true
        },
        "CurrencyCode":{
            "title":"Currency",
            "maxLength":15,
            "type":"string",
            "description":"Currency code for entertainment expense policies with multiple currencies.",
            "nullable":true,
            "x-queryable":true
        },
        "StartDate":{
            "title":"Start Date",
            "type":"string",
            "description":"Start date of the entertainment expense policy line.",
            "format":"date",
            "nullable":false,
            "x-queryable":true
        },
        "TypeOfAttendeCode":{
            "title":"Nonemployee Attendee Types",
            "maxLength":30,
            "type":"string",
            "description":"Indicates the type of event attendee for this entertainment policy line. Values are from the lookup EXM_ATTENDEE_TYPES.",
            "nullable":true,
            "x-queryable":true
        },
        "InvalidCode":{
            "maxLength":30,
            "type":"string",
            "description":"Indicates why an entertainment expense policy line has the invalid status.",
            "nullable":true,
            "x-queryable":true
        },
        "TypeOfAttende":{
            "title":"Meaning",
            "maxLength":80,
            "type":"string",
            "description":"Type of event attendee for this entertainment policy line.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "Currency":{
            "title":"Description",
            "maxLength":240,
            "type":"string",
            "description":"Currency of an entertainment expense policy line.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "YearlyLimit":{
            "title":"Yearly limit",
            "type":"number",
            "description":"Annual reimbursement limit for entertainment expenses.",
            "nullable":true,
            "x-queryable":true
        },
        "EntertainmentPolicyId":{
            "type":"integer",
            "description":"The unique identifier of the entertainment expense policy.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Date and time when the row was last updated",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Session login of user who last updated the row.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : link

Type: object

Show Source

• href: string
  Title: hyperlink reference

  The URI to the related resource.
• kind: string
  Title: kind

  Allowed Values: [ "collection", "item", "describe", "other" ]

  The kind of the related resource.
• name: string
  Title: name

  The name of the link to the related resource.
• properties: object properties
• rel: string
  Title: relation

  Allowed Values: [ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]

  The name of the relation to the resource instance. Example: self.

{
    "type":"object",
    "properties":{
        "kind":{
            "title":"kind",
            "type":"string",
            "description":"The kind of the related resource.",
            "enum":[
                "collection",
                "item",
                "describe",
                "other"
            ]
        },
        "rel":{
            "title":"relation",
            "type":"string",
            "description":"The name of the relation to the resource instance.  Example: self.",
            "enum":[
                "self",
                "lov",
                "parent",
                "canonical",
                "child",
                "enclosure",
                "action",
                "custom"
            ]
        },
        "name":{
            "title":"name",
            "type":"string",
            "description":"The name of the link to the related resource."
        },
        "href":{
            "title":"hyperlink reference",
            "type":"string",
            "description":"The URI to the related resource."
        },
        "properties":{
            "type":"object",
            "properties":{
                "changeIndicator":{
                    "type":"string",
                    "description":"Change indicator or the ETag value of the resource instance."
                }
            }
        }
    }
}

Nested Schema : properties

Type: object

Show Source

• changeIndicator: string
  Change indicator or the ETag value of the resource instance.

{
    "type":"object",
    "properties":{
        "changeIndicator":{
            "type":"string",
            "description":"Change indicator or the ETag value of the resource instance."
        }
    }
}

Back to Top