OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Retrieve AR transaction that has been "Created Accounting" (accounted)

Home » Applications » Oracle Fusion Apps & E-Business Suite » Retrieve AR transaction that has been "Created Accounting" (accounted)

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

Retrieve AR transaction that has been "Created Accounting" (accounted) [message #490706]

Wed, 26 January 2011 19:00

xhyrruz
Messages: 14
Registered: June 2010
Location: Philippines

Junior Member

Hi Everyone,

Does anyone knows how to retrieve through plsql on R12 AR (Receivables) transactions that has been a been applied or created accounting (accounted transaction)? I used the apps.arpt_sql_func_util.get_posted_flag(a.customer_trx_id,c.post_to_gl,a.complete_flag) function, where "a" alias was ar.ra_customer_trx_all table and "c" alias was ar.ra_cust_trx_types_all table, to determine the accounted transaction but unfortunately it return "N" value even if the transaction was already "created accounting".

Any help much appreciated. Thanks

Cyrus

Report message to a moderator

Re: Retrieve AR transaction that has been "Created Accounting" (accounted) [message #490716 is a reply to message #490706]

Wed, 26 January 2011 22:59

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Check whether the following are true.
1. ra_cust_trx_line_gl_dist_all.gl_posted_date is not null
2. ra_customer_trx_all.complete_flag is Y.
3. ra_cust_trx_types_all.post_to_gl is Y or NULL

By
Vamsi

Report message to a moderator

Re: Retrieve AR transaction that has been "Created Accounting" (accounted) [message #490722 is a reply to message #490716]

Thu, 27 January 2011 00:12

xhyrruz
Messages: 14
Registered: June 2010
Location: Philippines

Junior Member

Hi Vamsi,

Your post helps me to solved the problem.

Thank you so much.

Cyrus

Report message to a moderator

Previous Topic:	Oracle E- Biz Form Personalization
Next Topic:	Facing problem with Forms customization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 10:54:11 CST 2024