ERPstuff - Oracle EBS Community

Version R12/11i? = R12 Hello, I want to query all menues/Submenues and its functions and also its related html-functions in a hierachical structure concerning to a responsibility. Is there any report in R12 which shows me the tree and its relatives? Or can someoneone help me by creating the sql stat...

Hi, you can develop rdf via Oracle Reports and Reports version depends on Applications version. Additionally on rdf you print the Layout via BI-Publisher or independently to Oracle Reports only create your reports with BI-Publisher Desktop Version. There is also an XML-Publisher Administrator respon...

Hello, i'm new at E-Business Suite and its APIs in R12. Therefore i have some questions about them: 1. Is it it possible to load supplier and sites via API or open interface? 2. Is it it possible to load bank and branches via API or open interface? 3. Is it it possible to load employees via API or o...

Hello,

i've two different reports version. Unfortunately there is no change description of the new report version.
Is there any possibility to compare two report versions(rdf-files) and with a listing of code differences?

Thanks a lot, Thomas

Hello Yudi, thanks for your reply. If i use monitor users within system administrator responsibility then i only get current activities and behind this form lays the view FND_SIGNON_AUDIT_VIEW. I need something like which user uses his assigned responsibilities during a period whether to make decisi...

Hi, i've found out, after setting the profile option Sign-On: Audit Level with value "form" auditing is possible. I can also use the view FND_SIGNON_AUDIT_VIEW and receive current active and logged in users. But I need a historical table where all this data is saved. Is something like this...

Hi folks,

i've no clue of sys tables and views in OA. But i have to write a select which
contains all users who are connected for the last 30 days and which responsibilities
they have used in this time.
I would be very appreciated if anyone can give some advices.

Thanks a lot and regards Thomas

Hi,

thanks for your reply.

It is very helpful.

Regards, Thomas

Hi Ali, thanks i build a new report with report builder and the xml-output works. But then i build a new package and have registered the concurrent program in OA and changed the output from text to xml. I tried the output FND_FILE.PUT_LINE() and without in hope that a xml would be generated. But it ...

Hello, i'm a newbie to BI Publisher in Oracle Apps R12. I've downloaded the BI-Publisher Desktop Version which gets integrated in Word. My question is now, is it possible to change the select statement inside this Desktop-Version? I've tried to use one report in OA with XML-output then use the BI-Pu...

Hello, i've downloaded Tutor patch from metalink 'D49191GC10 - R12 Implement Oracle Workflow' and want to do a certified exam but unfortunataly i haven't found for release 12 a suitable examination course. Additionally i couldn't find on website http://blogs.oracle.com/certification/2008/08/oracle_e...

Thank you very much for an answer. Additionally I search for Self Study CD-ROMs or the Patch.No. inside Oracle metalink to prepare for this examination. I can't find any sources only for version 11i. Is it because this examination has still a beta status? I would be appreciate for any clues. regards...

Hello, in Relase 11i, there is a certification called '11i E-Business Essentials for Implementers'. Is there the same one for Release 12 available? And if yes- which course number belongs to it because i couldn't find any courseware(Tutor) inside patches from metalink. Please help- thank you very much