Creating Expense reports in Oracle Fusion through OIC. What’s different in this?

Akshay Nayak
2 min readJan 4, 2025

--

Recently there was a requirement to create expense reports/expenses for employees in Oracle Fusion.

If we check Oracle documentation , you will find REST API’s to create expense reports. What’s different in this from the other REST API’s?

Lets read this short article to understand that.

There are REST API’s to create expense reports with multiple expenses under it as well there are API’s to create individual expense.

Refer to latest API documentation

However when you use service account in OIC to call these API’s, you won’t encounter any error but still employees for whom the expenses are created will not be able to see the expenses.

Reason is before creating expenses on behalf of the user , delegation has to be given from the employee to the service account.

Flow diagram for logic in OIC

Check if there is delegation record from the employee to service account for that day.

If there is no delegation record then call REST API to create delegation record.

If there already exists a delegation for that day then create expense reports.

GET https://XXXXX/fscmRestApi/resources/11.13.18.05/expenseDelegations

In the response important values to look at is
PersonId/PersonName - This represents the employee on behalf of
which expense report has to be created.
DelegatePersonId/DelegateName - This represents the service account name
and its person id
EndDate - When the delegation ends
POST https://XXXX/fscmRestApi/resources/11.13.18.05/expenseDelegations

Request Payload
{
"PersonId":"3000000044",
"DelegatePersonId":"3000000075",
"EndDate":"2024-09-10"

}

PersonId - Represents the person id for employee
DelegatePersonId - Represents the person id for service account
EndDate - Give sysdate to end the delegation the same day

Note- End date the delegation same date to avoid running into Audit issues.

Once the delegation is given then you can create expense reports or expense and the employees will be able to see expense reports when then login in Oracle Fusion.

Hope this was informative! Thanks for reading.

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

--

--

No responses yet

Write a response