1. To change the orientation of a report, navigate to Layout Model > Main Section. Bring up Property Palette. Change the Report Width and Report Height under Character Mode e.g. 132 x 66.
2. To view the output as it would appear in Oracle Applications, navigate to Data Model > System Parameters > MODE. Set the Initial Value under Parameter to Character.
3. For Oracle reports that will be registered in Oracle Applications, set the format of the date parameter in the Oracle report to Input Mask:
RRRR/MM/DD HH24:MI:SS
4. Set the corresponding parameter’s format in the Oracle Application concurrent program definition to Date (FND_STANDARD_DATE).
5. When using date parameters in the Where clause of the query, use:
LAST_UPDATE_DATE >= :P_START_DATE
Not TO_CHAR (:P_START_DATE) or TO_DATE(:P_START_DATE)
6. Colour each frame with a different background to easily identify and distinguish them.
7. To break the page on a frame, change the property ‘Maximum Records per Page’ from 0 to 1.
8. Ensure that the Token field for the Parameter for the Concurrent program matches the user parameters for the Oracle Report.
9. To reset page numbers on a group, insert a field in the layout. Set the source at Physical page number. In the properties for the field you will see field Page Numbering below format mask field. Here you can reset the page numbers according to the group for PO.
10. To get a summary field by group name, in the Data Model view, click on the Summary Column button and then click on the group to enter it in.
11. REP-1212: Object ‘Body’ is not fully enclosed by its enclosing object ”.
Set the Output Style in the Concurrent Program definition for the report to a wider style (either Landscape or Landwide).
0 Comments.