AP 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 MorePeriod End Processing of Oracle Inventory and Cost management in oracle apps
1. Description Oracle Inventory provides the features you need to summarize costs related to inventory and manufacturing activities for a given accounting period and distribute those costs to the general ledger…
Read MoreAR Aging 4 Bucket with project details in fusion
Introduction This Post illustrates the steps required to AR Aging 4 Bucket with project details in fusion application Script to AR Aging 4 Bucket with project details in fusion WITH …
Read MorePayables Accounting Entries Report
Introduction The report lists in detail any transactions that have been accounted for with error and all entries that could not be transferred to the general ledger interface. When a…
Read MoreHCKT Hard Limit Reached Events in Fusion
Introduction This Post illustrates the steps required to HCKT Hard Limit Reached Events in Fusion Script to HCKT Hard Limit Reached Events in Fusion Purpose Purpose of the report is to…
Read MoreAccounts Payable Trial Balance Report
Description Account Payable Trial Balance Report meant to verify that total accounts payable liabilities in Payables equal those in the general ledger. Before closing a period, you can compare the…
Read More