Home » Applications » Oracle Fusion Apps & E-Business Suite » Retrieve AR transaction that has been "Created Accounting" (accounted)
Retrieve AR transaction that has been "Created Accounting" (accounted) [message #490706] Wed, 26 January 2011 19:00 Go to next message
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
Re: Retrieve AR transaction that has been "Created Accounting" (accounted) [message #490716 is a reply to message #490706] Wed, 26 January 2011 22:59 Go to previous messageGo to next message
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
Re: Retrieve AR transaction that has been "Created Accounting" (accounted) [message #490722 is a reply to message #490716] Thu, 27 January 2011 00:12 Go to previous message
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
Previous Topic: Oracle E- Biz Form Personalization
Next Topic: Facing problem with Forms customization
Goto Forum:
  


Current Time: Thu Mar 28 16:57:28 CDT 2024