OPEN PO Details (Standard PO)
SELECT poh.type_lookup_code source_type, prh.segment1 pr_number, trunc(prh.creation_date) pr_date, (select action_date from po_action_history where object_type_code=’REQUISITION’ and action_code=’APPROVE’ and…
Read MoreSales Order Dispatch details (Link between Material Transactions and Invoice)
SELECT oola.line_number, oola.line_id, ooha.orig_sys_document_ref , ooha.order_source_id, ooha.order_number sale_order_no, trunc(ooha.ordered_date) sale_order_date, hp_ship.party_name customer_name, –hl_ship.address1, …
Read MoreOnHand Quantity – With Serial number and Locator
select ohd.item, ohd.item_desc, ohd.org_code, ohd.org_name, ohd.sub_inventory, ohd.locator, msn.serial_number, ohd.item_status, ohd.uom, NVL2(msn.serial_number,1,ohd.total_onhand_qty) onhand_qty, ohd.total_onhand_qty, ohd.total_reserve_qty, ohd.total_transact_qty, mmt.transaction_date stock_in_date, mst.transaction_source_type_name stock_in_type from (SELECT msi.inventory_item_id , (select max(mq.create_transaction_id) from mtl_onhand_quantities mq…
Read MoreAn Introduction to Report Manager in Oracle EBS R12
This article describes Report Manager functionality in Oracle R12 which allows users to primarily publish and store Financial Statements/reports that are written using Financial Statement Generator (FSGs). Note that Report…
Read MoreCROSS VALIDATION RULE EBS R12
What are Cross Validation Rules Cross Validation Rules are used to restrict the combination between the segments of a particular Chart of Accounts. As per our Example, we have the…
Read MoreHow to Update the Web Adi Template
How to Update the Web Adi Template: This document target is ADI template update required Purpose As per the business requirement user had requested to add the some fields to…
Read MoreHow to Define a Chart of Accounts Instance in FUSION Applications
1 Define a Chart of Accounts Instance Please find the below steps to define a Chart of Accounts Step1: Login as Application User Step2: you will be in home page as below…
Read MoreHow to Define a Chart of Accounts in FUSION Applications
Please find the below steps to define a Chart of Accounts Step1: Login as Application User Step2: you will be in home page as below Step3: we need to navigate…
Read MoreCreating the Legal Entity and Assign legal Entity to Primary Leger in Oracle Fusion Applications
Please find the below steps for creating the Legal Entity Step1: Login as Application User Step2: you will be in home page as below Step3: we need to navigate to…
Read MoreCreate Bank, Bank Branch, Bank Account in Oracle Fusion Applications
Please find the below steps to define a Bank,Bank Branch and Bank Account Step1: Login as Application User Step2: you will be in home page as below Step3: we need…
Read More