Payables and Cash Management - EBS (MOSC)

MOSC Banner

How can i update item_description in ap_expense_report_lines_all?

Hi

I've got an in-house oracle procedure that produces an staff expenses report based on an input parameter. The parameter can be either the "prompt" or "web friendly prompt" from the ap_expense_report_params table and the report brings back data from the ap expense report lines all table based on a match between the "item description" and the "prompt" or "web friendly prompt" from the ap expense report params table.

The issue i'm having is that the business have updated the values in the "prompt" and "web friendly prompt" from the ap_expense_report_params table so that if they now run a report based on the new value its not bringing any historic data back due to the item description in ap expense report lines all holding the old value.

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