erpSchools

Tag: Oracle

  • Oracle Apps Custom Table with ORG Access Control policy

    Oracle RLS Policy to enable Multi org security for custom objects / tables

  • PO Matching Rules

    PO Matching Rules are applied at Purchase Order (PO) level and are used to validate AP Invoices before making the payment to suppliers. PO Matching rules can be configured at five different levels to default them on to purchase order. Once matching rule is defaulted on to PO we have the option to override them…

  • Procure to Pay (p2p) R12

    Procure to Pay process which is also known as P2P cycle is followed by any organization in any ERP system if they would like purchase any products (it could raw materials, office supplies, infrastructure etc). Of course when there is a purchase there should be a payment.  This entire process of purchasing a product and…

  • Get Version number for Oracle apps, Database, Workflow, XML, OS

    — Oracle Database version along with hostname and instance name SELECT instance_name, host_name, version, status, database_status FROM v$instance; — Database version along with operating system platform SELECT name, DB_UNIQUE_NAME, platform_name FROM v$database; — Oracle Apps version SELECT release_name, applications_system_name, aru_release_name FROM FND_PRODUCT_GROUPS; — Database Version, PLSQL Version, TNS Version SELECT * FROM v$version; — Oracle…

  • Inter-organization Transfer

    Business Requirement: Transfer material from Seattle Organization to Boston Organization. There are two ways to transfer material from one organization / warehouse to other organization. 1. We can transfer material across inventory organization through Internal Requisition / Internal Sales Orders 2. Inter-Organization Transfer from Inventory Application. Navigation: Inventory Responsibility > Transactions > Inter – Organization…

  • 3 Steps to setup jDeveloper for OAF Projects

    Step1: Identify the OAF Version required to install 1.1) First step is to identify the compatible version of OAF for your e-business suite. Not every version of OAF is compatible with every version of e-business suite. Also Note that OAF is only to be used with oracle e-business suite. You can not develop stand alone…