OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Expense Report R12 vs 11i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Expense Report R12 vs 11i [message #421722]

Thu, 10 September 2009 02:07

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?

Report message to a moderator

Re: Expense Report R12 vs 11i [message #421835 is a reply to message #421722]

Thu, 10 September 2009 23:38

myura
Messages: 66
Registered: July 2007
Location: Malaysia

Member

Already solved this issue.

Report message to a moderator

Re: Expense Report R12 vs 11i [message #421837 is a reply to message #421835]

Fri, 11 September 2009 00:11

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: Expense Report R12 vs 11i [message #421843 is a reply to message #421722]

Fri, 11 September 2009 00:40

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).

Report message to a moderator

Previous Topic:	Problem in Bursting Engine, Oracle R12
Next Topic:	Issue in Project Resource Management...Adding Role

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 18:08:39 CDT 2024