ExpenseReports
The expense reports resource contains information about an expense report.
Table Specific Information
Select
The 本製品 uses the Oracle Fusion Cloud Financials API to process some of the filters having queryable=true in metadata. The 本製品 processes other filters within the 本製品.
For example, the following query is processed server side:
SELECT * FROM ExpenseReports WHERE ExpenseReportId = 10003
Insert
Create an expense report record.
INSERT INTO ExpenseReports (ReimbursementCurrencyCode) VALUES ('USD')
If you want to add child views/tables along with the parent table, you can add the child in following ways:
-
Using TEMP table:
INSERT into ExpenseReportsExpense#TEMP(Location,ReceiptTime,StartDate,NumberPeople,PassengerAmount,ReceiptRequiredFlag) values ('India','2024-10-10 23:12:15','2024-02-05',25,25.35,true); INSERT INTO ExpenseReports (ReimbursementCurrencyCode,expense) VALUES ('USD','ExpenseReportsExpense#TEMP');
-
Directly providing the aggregate:
INSERT INTO ExpenseReports (ReimbursementCurrencyCode,expense) VALUES ('USD','[ { "Location": "India", "NumberPeople": 25, "PassengerAmount": 25.35, "ReceiptRequiredFlag": true, "StartDate": "2024-02-05", "ReceiptTime": "2024-10-10T23:12:15.000-04:00" } ]');
Update
Update an expense report record for a specific expense report identifier.
The Oracle Fusion Cloud Financials API uses ExpenseReportUniqId instead of ExpenseReportId as a path parameter in the URL to update the expense report.
If you want to update a record directly using the id (without any other filter), you can update the record in the following way:
Update ExpenseReports set ReimbursementCurrencyCode='EUR' where ExpenseReportUniqId=12457;
Note: This does not require any extra GET request to retrieve the UniqId.
Alternatively, if you want to apply any other filter. Please use ExpenseReportId instead of ExpenseReportUniqId. You can update the record in the following way:
Update ExpenseReports set ReimbursementCurrencyCode='EUR' where ExpenseReportId=12457 and PersonId=45442;
Note : Update on aggregates are not allowed by API, use the child tables to add/update/delete aggregates.
Columns
Name | Type | ReadOnly | Description |
AssignmentId | Long | False |
Identifier of the assignment of the person on the expense report. |
AuditCode | String | False |
Audit type for the expense report based on receipt requirements, such as original receipt-based audit and imaged receipt-based audit. |
AuditReturnReasonCode | String | False |
Reason why the expense report was returned to the individual during audit. |
BothpayFlag | Bool | False |
Indicator of whether the expense report contains corporate card transactions with Both Pay payment liability. |
CurrentApproverId | Long | False |
Identifier of the current approver of the expense report. |
ExchangeRateType | String | False |
Conversion rate type used for calculating the reimbursable amount. |
ExpenseReportDate | Date | False |
Month, day, and year in which an expense report is saved or submitted. |
ExpenseReportId [KEY] | Long | False |
Identifier of the expense report. |
ExpenseReportUniqId [KEY] | String | True |
Identifier of the expense report. Use this column's value in insert, update and delete operations, wherever applicable, instead of ExpenseReportId |
ExpenseReportNumber | String | False |
Unique number that references an expense report and follows the numbering policies of the company. |
ExpenseReportTotal | Decimal | False |
Total amount of the expense report in reimbursement currency. Amount in approver preferred currency is also shown if approver has a different preferred currency. |
ExpenseStatusCode | String | False |
Expense report approval status, such as Approved, Pending Manager Approval, or Paid. |
ExpenseStatusDate | Date | False |
Date when expense report acquired the current status. |
FinalApprovalDate | Date | False |
Date when final approval is obtained. |
ImagedReceiptsReceivedDate | Date | False |
Date when an imaged receipt is received for an expense report. |
ImagedReceiptsStatusCode | String | False |
Code that indicates status of the imaged receipts for an expense report, such as Required, Missing, and Received. |
MissingImagesReason | String | False |
Reason imaged receipts aren't submitted with the expense report. |
OrgId | Long | False |
Indicates the identifier of the business unit associated to the row. |
OverrideApproverId | Long | False |
Identifier of the person chosen as the initial approver by the individual. |
ParentExpenseReportId | Long | False |
Identifier of the parent expense report. |
PaymentMethodCode | String | False |
Method of payment for this expense report such as check, cash, or credit. |
PersonId | Long | False |
Value that uniquely identifies the person who owns the expense report. |
PreparerId | Long | False |
Value that uniquely identifies the person who created the expense report. |
Purpose | String | False |
Business activities that justify the expense report. |
ReceiptsFilingNumber | String | False |
Receipt filing number that's manually entered by the expense auditor. |
ReceiptsReceivedDate | Date | False |
Date when receipts for the expense report are received. |
ReceiptsStatusCode | String | False |
Receipt status of an expense report, such as Missing, Required, and Received. |
ReimbursementCurrencyCode | String | False |
Code that indicates the currency of the amount to be reimbursed to the individual for expenses incurred. |
ReportCreationMethodCode | String | False |
Method of expense report creation, such as mobile iOS device or mobile Android device. |
ReportSubmitDate | Date | False |
Month, day, and year in which an expense report is submitted. |
TripId | Long | False |
Business trip for which report was created. |
UnappliedAdvancesJust | String | False |
Justification for not applying an outstanding cash advance against this expense report. |
UnappliedCashAdvReason | String | False |
Reason outstanding cash advances aren't applied to this expense report. |
CreatedBy | String | True |
Who column: indicates the user who created the row. |
CreationDate | Datetime | True |
Who column: indicates the date and time of the creation of the row. |
LastUpdateDate | Datetime | True |
Who column: indicates the date and time of the last update of the row. |
LastUpdateLogin | String | True |
Session login associated to the user who last updated the row. |
LastUpdatedBy | String | True |
Indicates the user who last updated the row. |
BusinessUnit | String | False |
Indicates the identifier of the business unit associated with the row. |
SubmitReport | String | False |
Indicates whether the expense report can be created and submitted. |
MatchExpenses | String | False |
Identifies whether corporate card transactions can be matched against expenses. |
SubmitErrors | String | False |
Identifies whether errors occurred during submission of the expense report. |
PersonName | String | True |
Name of the person for whom the expense report is created. |
OriginalReceiptsStatus | String | True |
Status of the original receipts for an expense report, such as Required, Missing, and Received. |
ImagedReceiptsStatus | String | True |
Status of the imaged receipts for an expense report, such as Required, Missing, and Received. |
ExpenseReportStatus | String | True |
Status of the expense report. |
AuditCodeName | String | True |
Lookup meaning of Audit Code. |
CurrentApprovers | String | True |
List of persons with whom expense report approval is pending. |
Expense | String | False |
This column can only be used for Insert. For update and delete, use child table's operations, if applicable. |
ExpenseReportDff | String | False |
This column can only be used for Insert. For update and delete, use child table's operations, if applicable. |
processingDetails | String | False |
This column can only be used for Insert. For update and delete, use child table's operations, if applicable. |
ExpensePayment | String | False |
This column can only be used for Insert. For update and delete, use child table's operations, if applicable. |
expenseNotes | String | False |
This column can only be used for Insert. For update and delete, use child table's operations, if applicable. |
Finder | String | True |
finder |
SysEffectiveDate | String | True |
syseffectivedate |
EffectiveDate | Date | True |
This query parameter is used to fetch resources which are effective dated as of the specified start date. |