Home » Applications » Oracle Fusion Apps & E-Business Suite » Expense Report R12 vs 11i
Expense Report R12 vs 11i [message #421722] Thu, 10 September 2009 02:07 Go to next message
myura
Messages: 66
Registered: July 2007
Location: Malaysia
Member

Good day all,

My client requires me to change the Expense Report at R12 same as 11i. which means, they want all the data that entered using ESS User (expenses home) can also view via Expenses Report in R12. I have tried to change the code, but seems that nothing happend at the form. I know that in R12 they have a new table which is ap_exp_report_dists_all but i dnt know where to change the code, so that the data can grab from there. Anyone hv idea?
Re: Expense Report R12 vs 11i [message #421835 is a reply to message #421722] Thu, 10 September 2009 23:38 Go to previous messageGo to next message
myura
Messages: 66
Registered: July 2007
Location: Malaysia
Member

Already solved this issue.
Re: Expense Report R12 vs 11i [message #421837 is a reply to message #421835] Fri, 11 September 2009 00:11 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's really good. Though, it would be even better if you shared the solution so that other people might benefit from it.
Re: Expense Report R12 vs 11i [message #421843 is a reply to message #421722] Fri, 11 September 2009 00:40 Go to previous message
myura
Messages: 66
Registered: July 2007
Location: Malaysia
Member

By changing the where clause at Employee block and some additional select statement at query_master_details procedure (this query is to grab gl_account from ap_exp_report_dists_all).
Previous Topic: Problem in Bursting Engine, Oracle R12
Next Topic: Issue in Project Resource Management...Adding Role
Goto Forum:
  


Current Time: Fri Dec 09 03:34:19 CST 2016

Total time taken to generate the page: 0.05450 seconds