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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction This post is about to upload and Download of Files from Server Step 1: Create a File browse item. Step 2: Create a directory in database. Step 3: Create…
Read MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction This Post illustrates the steps required to Extract for Payments – Check and EFT in Oracle EBS R12. Script to used for Extract for Payments – Check and…
Read MoreIntroduction The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the issues occur in the approval of the purchasing…
Read More