-
Report Creation through wizard
Objective: Create a report using wizard in Report Builder. Open Report Builder This is the first screen you will see. Select the first option “Use the Report Wizard” and click OK. Click Next Enter Report Title: erpschools_sample_report and then select “Tabular” option. As per name “Tabular” our output will be organized in a tabular way (rows and…
-
Shell Script Tutorial
Topics: Steps to Register Shell Script as a concurrent program Sample Shell Script to copy the file from source to destination Basic Shell Script Commands Steps to Register Shell Script as a concurrent program step 1: ======= Place the <name>.prog script under the bin directory for your applications top directory. For example, call the script ERPS_DEMO.prog…
-
Forms Personalization Tutorial
Why personalization? Oracle Supports personalization unlike customization Personalizations are stored in tables rather than files Will not have a bigger impact when you upgrade or apply patches to the environment Can be moved easily through FNDLOAD from one instance to other Can be restricted at site/responsibility/user level Easy to disable/enable with click of a button.…
-
Change displayed data in LOV using Forms Personalization
Goal: Change the LOV in “Supplier Name” field in the Find “Invoice Form (AP_APXINWKB)” Navigation: Payables Manager > Entry > Invoices Double Click it to open In the first filed, Supplier Name change LOV In such a way that no one can see the TaxPayerID in LOV. It should be masked with *’s. Navigation: Help Menu…
-
Workflow tutorial
Overview: This workflow tutorial will illustrate how to create or define a new workflow from scratch including attributes, notifications, messages, roles or users, functions, processes and last but not the least, how to launch a workflow from PL/SQL. The workflow concepts are better explained using an example. Business Requirement: When an item is created in inventory,…
-
Display and change images dynamically in XML publisher
This article discusses about how to display images dynamically using XML Publisher. COMPANY NAME ADDRESS REPORT TITLE CF_PRINTED 1. 2. 3. Customer No.. Customer Name Address Tax Category Number Name Address Tax Category Note :- We have to place Dummy Images on template like in above template. 1)In this option we placed image path Directly…
-
Handling multiple layouts in Xml Publisher (.Rtf)
Steps for handling multiple layouts in XML. After developing the Report definition file (.rdf) we have to add one more parameter like follows. This parameter value should be assigned to Place holder column(CP ) like follows We can assign Parameter value either after parameter form or before report Triggers. In this we assigned in Before…
-
Delimited Report Output using Report Builder
Overview: In this tutorial, we will see how to customize the existing standard Oracle report to get a delimited output file instead of the regular layout. Most business users prefer delimited report output as it can easily be imported into Excel where they can manipulate and perform calculations on the data easily. Report Builder is…
-
Customizing Self Service Applications using Personalizations
Release 11.5.10 provides a feature called Personalize Page, which gives us the ability to customize the look and feel of the Self Service Applications. Setting the Profile option Personalize Self-Service Defn to “Yes”, enables this feature. If it is set to “No”, the Personalize Page link will not be seen prohibiting you from customizing the…