Call Oracle package in Oracle BI Publisher 10g
Call Oracle package in Oracle BI Publisher 10g Introduction This Post is about Oracle BI Publisher is just a reporting tool. From which we can download excel, CSV, XML, RTF,…
Read MoreeAM-Asset Number Conversion
Description: The eAM Asset Number Open Interface enables you to import Asset Numbers into eAM, using a batch process. Optionally import Asset Number attributes. You can create new Asset…
Read MoreAP Pre Payments Query: AP XLA GL
Description: The below post describe the steps to create AP Pre payments Query: AP XLA GL SELECT glcc.segment1 COMPANY, glcc.segment2 LOCATION, glcc.segment3 COST_CENTER, glcc.segment4 ACCOUNT, glcc.segment5 PRODUCT_LINE, glcc.segment6 CHANNEL,…
Read MoreAP Distribution Query: AP XLA GL
Description: The below process guide to create AP Distribution Query in AP XLA GL SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product_line, glcc.segment6 channel, glcc.segment7 project,…
Read MoreOracle 12c accessible by clause
Introduction This Post illustrates steps required to Oracle 12c accessible by clause in Oracle EBS R12. PACKAGE Helper authed Definer accessible BY(Good_Unit, BAD_UNIT IS PROCEDURE p; END Helper; PACKAGE body…
Read MoreAP Invoice On Hold Report
Introduction Invoice on Hold Report is used to review detailed information about invoices on hold. You can submit the Approval process before submitting this report to obtain the most up-to-date…
Read MoreMultiple indexes for same column
Introduction This post is about to create multiple indexes for the same column in Oracle EBS R12. Script to create multiple indexes for the same column. SQL>CREATE TABLE t3…
Read MoreTrial Balance – Detail Report
Introduction Oracle General Ledger Trial Balance report is used to satisfy legal, statutory, and internal management reporting requirements in Portugal. There are five separate reports with a standard layout; however,…
Read MoreQuery for Create or Update HR location in oracle apps
Introduction This Post illustrates the steps required to Create or Update HR location in oracle application. Script to Create or Update HR location in oracle apps SET DEFINE OFF; CREATE…
Read MoreQuery to get Normalized Exp Amount from Property Manager
Introduction This Post illustrates the steps required to get Normalized Exp Amount from Property Manager Script to get Normalized Exp Amount from Property Manager CREATE OR REPLACE FUNCTION APPS.PN_NORM_EXP(p_payment_item_id number,…
Read More