Logging Level - Select the level of detail to record in the concurrent request log file. The available logging levels, in order from the highest level recording the least detail to the lowest level recording the most detail, are Unexpected , Error , Exception , Event , Procedure , and Statement. For production instances, the recommended logging level is Error. You can use lower logging levels for testing and debugging purposes if needed.
After the concurrent request completes, check the request output file to review the results of the transfer operation. If the output file includes error or warning messages, check the request log file for additional information. If the FrmFsgImages directory has not been created yet on the target instance, then you should create it now.
Additionally, to enable the image to be rendered in HTML or PDF report output, you must also restart the application tier services using the adstpall. After performing the transfer, you can submit reports in the target instance using the transferred templates.
If you chose to overwrite an existing template in the target instance with a different version of that template from the source instance, then you may need to perform an additional step for reports that use this template, depending on the output formats you need. For Microsoft Excel, the transferred template takes effect immediately when users view the Microsoft Excel report output.
For HTML and PDF, you must first resubmit the reports that use this template to make the transferred template take effect and render any included image. If the existing report was submitted through Regular FSG Submission and is stored in the Reports Repository, then when you resubmit the report, save it in the same location in the repository and choose the option to overwrite the existing report.
For reports submitted through Simplified FSG Submission, which are not managed in the repository, resubmit the report through Simplified FSG Submission to generate output using the transferred template. You can use many native Microsoft Word features to apply to your report template to achieve richly formatted reports directly out of Oracle E-Business Suite. Oracle XML Publisher provides a plug-in to Microsoft Word that enables you to quickly insert and manipulate report elements in your Word document.
These guides are available from My Oracle Support Document Generic Templates Oracle Report Manager provides three generic templates that you can use to publish any report. For a custom generic template, you can make the following changes: Change the background color. Change the logo image. For a custom report-specific template, you can make the following changes: Add and remove report elements. Change the location of report elements on the page.
Modify row and column sizes. Change the background color. Insert text that remains static in the report. Add images. Supported image file types are png, gif, jpg, and bmp. Include hyperlinks. Move columns. Insert blank rows. Change the page margins and orientation. For a report-specific template only, select the Language for the template.
When you are ready to upload, select the Oracle ribbon tab and then select Upload. Template Editing Features This section describes the layout features that are available to customize the report presentation in a template. Template Editing Features for Generic Templates and Report-Specific Templates The following features can be customized in both generic and report-specific templates.
Changing Font Style, Size, Color, and Alignment Use Excel standard functionality to customize font style, font size, colors, and alignment. Inserting Images For a generic template, you can insert a different image to replace the standard logo image. Height - 46 pt Width - pt Use standard Excel functionality to insert images in your template. For example: To select the required image setting in Microsoft Excel , , and Choose the File tab, and then choose Options.
Select the Cut, copy, and sort inserted objects with their parent cells option. After selecting this setting, you can insert images into your template. To insert an image: Click on the cell where you want to position the top left hand corner of your image.
For a report-specific template, size the image as desired. Note: Watermarks and background images are not supported.
Template Editing Features for Report-Specific Templates Only The following features can be customized only in report-specific templates. Adding, Deleting, and Moving Report Objects Use the Oracle menu to perform the following edits to the generated template: Move line items right Move line items left Delete current line item Delete current column Insert report fields defined in data Insert column elements defined in data Insert row elements defined in data Note that the Insert Fields button group on the Oracle tab displays available report objects and data fields that you can insert into your template.
Changing Row and Column Sizes Use Excel standard functionality for changing row heights and column widths in your template.
Changing General Page Settings Use Excel standard functionality to modify the following page settings: Page Margins Top, Left, Bottom, Right, Header and Footer Orientation Portrait or Landscape Cell Formatting You can apply many of the native Microsoft Excel cell formatting options to a particular cell or group of cells in the template, and at runtime the formatting will be applied to all cells that correspond to the data intersection.
Formatting Negative Numbers To apply special formatting to the appearance of negative numbers in your report, you can use the Excel functionality as follows: Select the cells for which you want the negative number formatting applied.
Choose the Number tab. Identifying Templates to Transfer On the source instance, identify the custom templates that you want to transfer to the target instance. Specify the following parameters for the program: Source Template Name - Use one of the following options to specify the templates in the source instance that you want to transfer to the target instance. For example: Summary Income Statement Enter a partial value to transfer all templates in the source instance whose names begin with that value.
Note: This field is case-sensitive. Database Link - Select the database link that you defined to connect to the source instance. Thanks once more for all the details.
Thank you for the update, very nice site.. Cool stuff you have got and you keep update all of us. You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us to read this There are two required components in defining a report: Row set and Column set. Step 1 : To define Row set column:. Add each line header in line item field. Indent field used to space from left side. All property like line to skip , Underline character and page break used before and after we can set for our current line item.
To show balance for current line item you need to assign account code combination for this particular account. Income Line item comes under account code which is 6th segment as per my current setup for code combination in GL Accounting Flexfield. You can set n number of line header for one FSG report.
We can perform Addition and deletion operation on summary of group of line item. For this we need to click on Calculation Button instead of Account assignment button. Enter Name and description and then click on Define Columns button. Position column is important in column set. When the report XML data is generated, it is sent to the Oracle Report Manager repository where it is stored and available for presentation to viewers.
Note that the template can be changed at any time when viewing the published report from the repository. Determine the location in the repository to store the report. If the report exists in the repository you can choose a new location or overwrite it. If you wish to publish the report to a menu item on the Oracle E-Business Suite Home page, you can apply presentation parameters to define where in the menu structure the report appears. Place a Summary Income Statement under a responsibility called Financial Reports that was created by your system administrator.
Review all of your report parameters. Submit the report. A confirmation page displays your concurrent program request ID. You can monitor this request until it has successfully completed.
Note that when you submit the report, two requests are submitted to the concurrent manager: the request to generate the data and the request to publish the data. When you monitor your report you will see your submitted request and the Publish and Presentation Program.
Your report will not be available for viewing until both requests have completed successfully. If you chose a reviewer for the report, the reviewer views the report and approves it, making the report available to all others with access. If you chose to publish the report to a menu item of a responsibility, then all users who have that responsibility and menu will see the report listed. Following the same example in step 6, users with access to the Financial Reports responsibility can navigate to that responsibility and view the Summary Income Statement.
Timeframes and expansion values for example, department are available in lists. The viewer selects the time and expansion value to view. Security can restrict the expansion values a particular user can view for example department only. Sagar Kumbhar. San-J January 15, at AM. Unknown September 24, at AM.
0コメント