LOV Changing Using Custom.pll
à Need to Create a new Procedure in the custom.pll à Need to find the Standard Lov name form the application by placing the cursor on the particular field form…
Read MoreDynamic Logo Chaining in BI Publisher Report
Dynamic Logo Chaining in BI Publisher Report Need to Created a Lookup where we can map the required Logo image names Need to create a formula column in report builder…
Read MoreAR Transactions and Tax Query – India Localization
SELECT TO_CHAR (trx_date, ‘DD-MON-YYYY’) ar_posting_date, TO_CHAR (jatt.excise_invoice_date, ‘DD-MON-YYYY’) excise_invoice_date, rcta.trx_number ar_trx_number, flv.meaning document_type, jatt.excise_invoice_no, hca.account_number cust_bill_to, hp.party_name cust_name,…
Read MoreBI Publisher Report with Excel Template
Step1:Concurrent Program Create a Concurrent Program with Exceutable File Name as XDODTEXE Step:2 Data Xml Template Create a Data Xml Template for the Query Step:3 Data Definitions Create a Data…
Read MoreRegion Interface – Shipping
Interface Tables: WSH_REGIONS_INTERFACE WSH_REGIONS_TL_INTERFACE Base Tables: WSH_REGIONS WSH_REGIONS_TL Create Country: Insert the following data into Interface tables Generate Sequence_ID and…
Read MoreReport Builder Components
Report Builder Components 1. Data Model 2. Layout Model 3. Object Navigator 4. Report Triggers 5. Parameter Form 6. Program Units 7. Attached Libraries Data Model The Report Editor’s Data…
Read MoreAIM Document Specifications
AIM Document Specifications: 1. Business Process Architecture (BP) 2. Business Requirements Definition (RD) 3. Business Requirements Mapping 4. Application and Technical Architecture (TA) BP.010 Define Business and Process Strategy BP.020…
Read MoreHow to find error messages while doing Oracle workflow activities from backend.
Finding error messages while doing workflow activities from backend. Approach: Find a workflow internal name Query the workflow table with…
Read MoreSetting Timeout for a Notification in Oracle Workflow
Requirement: Timeout period should be 48 hours for a notification. Approach: 1. Go to particular Notification Label 2. Select the properties 3. Select the Node tab 4. Change the Timeout …
Read MoreDisplaying subtotal and grand total based on the group column in BI Publisher Template
For Example Display the sub total values based on Account code and show grand total end of the report. The report has only one group (G_ACCT) and group columns like …
Read More