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 MoreIntroduction 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 MoreIntroduction 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 More1. 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreDescription 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 MoreIntroduction To fetch the Purchase Order along with Requisition Preparer details, we can use the following queries. /* Query 1 To Fetch Cancel PO*/ SELECT action_date cancel_po_date FROM po_action_history pah WHERE pah.object_id = :poh_po_header_id AND ( ( …
Read MoreIntroduction This script is used Queries to get AR Selected Invoices. Query to using for AR Selected Invoices print. /* Adjustments */ SELECT line_adjusted adj_line, tax_adjusted adj_tax, freight_adjusted adj_freight, adj.amount adj_amount, l1.meaning…
Read More