Region Interface – Shipping
Description: The post and steps describe the process of Region Interface – Shipping to create the country, state, city, and area Pincode with the help of interface and base tables.…
Read MoreParsing Comma Separated string in WHERE Clause of SQL Statement in Oracle Forms
Description: In some cases, we get a comma-separated string as output (say from another select statement or block) that we would need to pass to the IN clause of a…
Read MoreMTL Material Transactions Interface
Description: This blog explains the technical approach for creating an automated interface to accept user-supplied material transactions from External Systems and to import these transactions to Oracle as Material Transactions.…
Read MoreHow to programmatically close PO using PO_ACTIONS API
Introduction This post is about to close PO using PO_ACTIONS API programmatically. PO_ACTIONS.CLOSE_PO is the API used to programmatically close/final close Purchase Order. We have to pass P_ACTION parameter value…
Read MoreSplit by count excel report in Oracle BI Publisher 10g
Introduction To create a template to split records in excel sheet in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Open the Excel. (See below image) Step 2: Go…
Read MoreData template in Oracle BI Publisher 10g
Introduction Customer has given a requirement to develop the report in OBIP. While developing it, the developer came to know two datasets of SQL queries required to complete the report.…
Read MoreDBF file Generate in Oracle Directory Using Oracle PL/SQL.
Introduction The customer asks us to generate a database file format report in oracle directory itself; from there customer will download the report. Step 1: Call the PL/SQL procedure to…
Read MoreGenerate CSV file in Oracle Directory Using Oracle PL/SQL
Introduction The customer asks us to generate excel report in oracle directory itself; from there customer will download the report. The report should be in the format of CSV. …
Read MoreMultiple sheet excel report template generation in Oracle BI Publisher 10g
Introduction This post is about how to create a template for generating multiple sheet excel in Oracle BI Publisher 10g. Template Creation – EXCEL Step 1: Excel contains the below…
Read MorePerformance Using hint
Introduction This post is about Performance Using hint in Oracle EBS R12. The issue was due to joins across remote sites where oracle optimizer might Wrongly choose the driving site. This can be resolved by using driving site hint. It is always good to do all manipulations in one site and fetch the final Results to the target site. QUERY EXECUTED IN DATABASE 2 Select t1.column1, t2.column2, t2.column3 From table1 t1, xxsc.table2@db1todb2 t2 Where t1.column1 = t2.column1 Query, which was taking…
Read More