ERPstuff - Oracle EBS Community

Hello Pirzada,

Maybe this will help you to solve your problem;

-- used tables
, ra_cust_trx_line_gl_dist_all rctlgd
, mtl_material_transactions mmt
there is also a standard view in oracle but you have to set the client, it contains a lot of info for AR view; ra_customer_trx_v rctv

-- link ...

Hello alamaijaz,

Are you using a standard report in oracle gl or do you want to query directly on the database.
I have a query for you if you want to check if there is indeed an amount stored in the database for the ccid.

Regards,

Wim van der Veer
Capgemini Belgium

Hello Musman,

You have to create a new responsibilty and assign the single report to it. I had the same problem and it is the only way to give a small group of people access to the reports since you need to protect the report being used by the wring users.

Regards,

Wim van der Veer
Capgemini ...

Hello keerti,

If you want more examples you can also add the responsibilty 'XML Publisher' to your username so wil get access to the examples stored in the oracle database by oracle themselve, like fsg report or purchase.
If you want I can send you the printscreens I made for others to create new ...