Skip to content

Oracle Bytes

Sharing what I learnt!!

  • Home
  • Privacy Policy
  • Contact
  • Blog
  • Terms & Conditions
  • About Us
  • Affiliate Disclosure
  • ₹0.00 0 items

Tag: R12

R12

Excel File Reading using PL-SQL in Oracle R12

November 24, 2022December 22, 2022 Mohit Saxena

How to read the excel file in Oracle R12 using PL-SQL.

Tagged Excel, excel reading, how to read excel file in PL SQL, Oracle R12, PL-SQL, PLSQL, R12, read excel file in pl sql
R12

Purchasing Org of an Operating Unit in Oracle R12

July 27, 2022November 10, 2022 Mohit Saxena

How to set up and query the purchasing org of an operating unit in Oracle R12.

Tagged FINANCIALS_SYSTEM_PARAMS_ALL, hr_all_organization_units_tl, Item master, MTL_PARAMETERS In Oracle R12, Operating Unit, Oracle, Oracle R12, Purchasing Org of Operating Unit, query, R12
R12

Approved Supplier List( ASL) Creation Script in Oracle R12

July 5, 2022November 7, 2022 Mohit Saxena

PL-SQL Script for Approved Supplier List creation for item(s) In Oracle R12 using API po_asl_api_pub.create_update_asl

Tagged Approved Supplier List, Approved Supplier List Creation, ASL Creation Script, Oracle, Oracle R12, po_asl_api_pub.create_update_asl, R12, Script
R12

Item Assignment Script in Oracle R12

July 4, 2022November 7, 2022 Mohit Saxena

PL-SQL script to assign the items from one inventory org to another.

Tagged API, Assignment, ego_item_pub, Item Assignment, item assignment API, mtl_system_items_b, Oracle, process_item_org_assignments, R12, Script
R12

Item Details Query in Oracle R12 to Fetch Imp Columns

April 12, 2021November 7, 2022 Mohit Saxena

Query ( SQL) to fetch the item details such as Item number, lead time, planner code, min max quantity in Oracle R12

Tagged Item Details, Item Details in R12, Item Number, Item Query, Item Query in R12, planner code, R12, R12 Training1 Comment

Categories

Subscribe

Like the content of this website and would like to be the first to know? Then please subscribe.

Join 10 other subscribers
Proudly powered by WordPress | Theme: Dara by Automattic.