Technology Stack - EBS (MOSC)

MOSC Banner

How to download ALL attachments of a type to ALL expense reports for a period in iexpenses

edited Aug 20, 2021 11:52AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Example:

Period: 1 April 2017 to 31 March 2018 (inclusive) [Period: Period of review is based on the Expense Report Submitted Date (EXPPENSE_SUBMITTED_DATE)]

We basically would like only the documents relating to below (Based on "EXPENSE_LINE_TYPE_DESCRIPTION")

I will use 1 example to demonstrate. For Report EXP-482925 ("EXPENSE_REPORT_NUMBER"),  I would like to obtain PDF receipts that support Meal - Employee Travelling ( "EXPENSE_LINE_TYPE_DESCRIPTION") which is 52 ("LINE_AMOUNT").

To do this in a mass scale, would it be easier if I provided you with:

a) the expense report numbers and you extract all PDF data ? EXP-482925 ("EXPENSE_REPORT_NUMBER"),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center