Introduction: This Post illustrates the steps required to On Hand Quantity with Available To Transact in Oracle EBS. Script to Fetch the On Hand Quantity with Available To Transact Step-1…
Read MoreIntroduction: This Post illustrates the steps required to fetch data from AR to GL in Oracle EBS 11i. Script SELECT je_header_id, line_number, trx_number, item_number, customer_number, customer_name, SOURCE, CATEGORY, batch_name,…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Open work orders in Oracle EBS. Query to Fetch the Open Work Orders SELECT DISTINCT a.job, a.item item, a.item_description, a.product_category,…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Open sales orders in Oracle EBS. Script to Fetch the Open sales Orders SELECT customer_number, customer_name, organization_code, sku, request_date, schedule_ship_date,…
Read MoreIntroduction This Post illustrate steps required to Change the Item Cost Groups in Oracle EBS. Script to Change the Item Cost Groups DECLARE p_item VARCHAR2; p_organization_id NUMBER; p_subinventory VARCHAR2; p_locater…
Read MoreIntroduction This Post illustrate steps required to import bank account details of the suppliers in Oracle EBS R12. Script to import Bank account details for suppliers. PROCEDURE create_banks_accounts (p_change_type VARCHAR2)…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Leases which are Expired but not terminated in Oracle EBS R12. Script to Leases Expired but not terminated SELECT GCC.segment4 SOL_ID…
Read MoreBelow is the function to get current operating unit Timezone. FUNCTION convert_to_ou_tz(p_date DATE, p_org_id NUMBER DEFAULT fnd_global.org_id) RETURN DATE IS l_timezone VARCHAR2(50); l_new_date DATE; BEGIN SELECT attribute8 INTO l_timezone FROM…
Read MoreYou can find correct jdeveloper version using following link. https://support.oracle.com/portal/ Search as Jdev with OA Extension.
Read MoreBy using following tag we can remove entire column in RTF. <?if@column:ORG_ID!=XXX?>Sales Order/Cust PO<?end if?>
Read More