Step 9 – Apex Developer Day - Editing Application Objects

Although the Master-Detail form is fully functional, the presentation can be improved. In this topic you change the names of the Page Title, Region Title and change the format an item on the Master Report. Additionally, you print the Projects report in the PDF format. Lastly, you change the sequence of items in the Projects and Tasks page using the Drag and Drop feature. Perform the following steps:

	1. Select 4 - APEX PROJECT LOOKUP.
	2. Select the Report link under Regions.
	3. Click the Edit () icon next to PROJECT_DEADLINE.
	4. Under Column Formatting, enter MM/DD/YYYY for the Number/Date Format field and click Apply Changes.
	5. Click Apply Changes.
	6. Click the Edit () icon for the Page 4.
	7. In the Name section, enter Projects for the Name. In the Display Attributes section, enter Projects for the Title. Then click Apply Changes.
	8. Click Run.
	9. Notice that the Title in your Browser is set to Projects and the format of the PROJECT_DEADLINE has changed. You notice that the Region title is still set to APEX_PROJECT_LOOKUP. Click Show Edit Links in the Developer links area.
	10. Click the Edit () icon next to the Obe Projects Region title.
	11. Change the title to Projects and click Apply Changes.
	12. Click Cancel to close the Page Region window.
	13. Refresh your browser to show the change you just made. 14. Click Hide Edit Links in the Developer Links.
	15. Click the Edit Page 4 link in the developer tool bar.
	16. Click the Report link next to the Projects region.
	17. Click the Print Attributes tab.
	18. Select Yes in the Enable Report Printing drop-down menu and select Portrait in the Orientation drop-down menu under Page Attributes. Then click the Page Header tab.
	19. Enter Project Report for Page Header and set the Alignment to center. Click Apply Changes.
	20. Notice that now Print appears to the right of the Report link since you have enabled Report Printing. Click Run.
	21. Notice the Print link at the bottom of the report. Click the Print link.
	22. Click the Save to Disk radio button and click OK to view the report in PDF format. 23. Save it in the Desktop and open it with “Adobe Reader 9” 24. An error like this must show up. Let’s investigate why this error is happening. Click OK. If not go step 36 25. Try open the document with a Text Editor 26. Choose Text Editor and Click Open An error ORA-29273 must be in the file. 27. It error is just because we have not initiated BI Publisher or It has not been configured. Make the configuration for BI Publisher.It will integrate Bi Publisher as the report server of APEX Open a New Tab in the browser, and click the APEX Admin button. 28. Enter Username Admin and Password Oracle 29. Click Manage Service – Instance Settings 30. Complete Report Printingwith these information; Print Server Advance (Requires Oracle BI Publisher), Print Server Protocol HTTP, Print Server Host Address localhost, Print Server Port 9704, Print Server Script /xmlpserver/convert (In case not information is in there) 31.Click Apply Changes 32. Now we have configured the BI Publisher as the report server for our APEX Instance. Start BI Publisher in the Desktop You will see the BI Publisher screening and the word initialized at the end of the window. 33. Return the original TAB and run the report again. 34. Save the report again. It probably will save as Projects(2).pdf in the Desktop 35. Open the Projects(2).pdf with “Adobe Reader 9”
	36. The Projects report is displayed in the PDF format. Now you can close the report and continue with the workshop.
	37. Click the Edit Page 4 link in the developer tool bar.
	38. Click the > arrow to navigate to the page definition for the Projects and Tasks page (Page 5).
39.	The page definition for Page 5 is displayed. To reorder the sequencing of items in this page, click the Items tab.
40.	Click the Drag and drop icon in the Items section.
41.	The Drag and Drop layout is displayed. You can use this intuitive graphical layout to edit, create, or delete items in this page.
42.	In order for the Project Priority item to appear above Project Deadline item in Page 5, drag and drop the P5_PROJECT_ PRIORITY item above the P5_PROJECT_ DEADLINE item and click Next>.
43.	Click Apply Changes.
44.	Click Run. Login If it is requested.
45.	Note how the Project Priority field now appears above the Project Deadline field. Click the Application <n> link in the developer tool bar. NOTE: Only In case the APEX TASKS do not show up as the screen above, Please Click Projects Edit any Project, as example Maintain Satisfaction Survey We will see the page completed 46. If you have only 2GB RAM I recommend stop the BI Publisher. Just go to the BI Publisher Window and press Ctrl+C that will stop the BI Publisher. A shutting Down OC4J message will show up and the window will close automatically.