ERPstuff - Oracle EBS Community

Hi Radha, You can define the name and parameters either on the report Header Section so that it will be visible only on the report header, or if you want to place them in the Main Section then place these fields in a fixed frame and then set the frame property to display on first page. Regards, Ali ...

Asalam-o-Alaikum I want help in making a hierarchical report in General Ledger. I want a hierarchy wise report showing full parent child relationship of any desired segment. I have used the connect by clause but am not able to get the desired result. I would appreciate it if any one can share his ex...

Hi, I want to know that how it is possible to execute a work flow on a particular event. Like if a user enters a new Item in Inventory i want my work flow to execute on insertion of that item. I have tested a sample work flow through the Developer Studio and it works fine, but i am unable to figure ...

Hi All,
I need to know that if it is possible to send a notification to a users worklist through Oracle Alerts. I have sent email to users using alerts but i want to send a notification to the users worklist rather than an email.
Can anyone guide me how to this ca be achieved.

Regards,
Ali Pirzada

Hi,
For Query 2 you need to check if there are employees defined against a particular user id, then you can join both the tables fnd_user and per_all_people_f.

fnd_user.employee_id = per_all_people_f.person_id

Regards,
Ali Pirzada

Dear Naveed,
use the nvl clause in your report, like

table.column = nvl(parameter, table.column)

Regards,
Ali Pirzada

Hi Aimam, just navigate to Application Developer --> Concurrent --> Define, query the report and go to Parameters. Add a new parameter, define its Seq No. and Name and in the value set you can select 20 characters, below that is Default Type and in that LOV select Profile and in Default Value write ...

Dear Imran, you can get your required data from AR_PAYMENT_SCHEDULES_ALL for Receivables and AP_PAYMENT_SCHEDULES_ALL for payables, but it does not store the data month wise, you will need to query it month wise on the basis of TRX_DATE and amount can be picked from AMOUNT_DUE_REMAINING. Regards, Al...

Hi,
You can pass the USERID or USERNAME from the application by a parameter.
Add a parameter , set default type as profile and default value as USERNAME or whatever profile value you need to pass.

Regards,
Ali Pirzada

Hi Zain, You will require to install Application Server on a server system and then during the installation of BI Publisher Enterprise Edition you will need to give the Home Directory of the Application Server. Then you can access the BI Publisher from the client by using the URL for the BI webpage....

Hi,
Follow this article, this might be helpfull
http://www.erpschools.com/Oracle_Applic ... lisher.asp

Regards,
Ali Pirzada

Instructor Led Training ? Register Now: Oracle E-Business Suite R12 Database Administrator Level 1 This 2-days hands-on workshop will guide you towards the skills required to become an Oracle Applications Database Administrator. This workshop will teach how to install and maintain an Oracle EBS R12 ...

Hi,
you can build a new report from report builder, register it in the application and set the output to xml then attach a template using XML Publisher Responsibilty.
You can also write a procedure that generates an XML output and use the XML data in your template.

Regards,
Ali Pirzada

Hi,
If you need to download the .rtf template for BI Publisher the go to
XML Publisher responsibilty --> Template and search the template name, you can then download it from there.

How can i create the linux forms environment on windows, such as if i want to import all the libraries and packages of Oracle EBS forms and use them on windows. I want to develop the whole form on windows paltform and just paste and re-compile it on linux. What will be the steps ? Regards, Ali Pirzada