Yearly Archives: 2021

Oracle Time Entries Creation Using REST API

Oracle Time and Labor (OTL) – Time Entries Creation Using REST API   When we have a requirement to integrate Oracle Time and Labor with external clocks of employee IN/OUT…

Read More

Script to extract the accounting rule and source wise AR invoice counts

Introduction: This script will extract the accounting rule and trx source wise invoice counts. SELECT C.NAME RULE_NAME, D.NAME SOURCE_NAME, count(A.TRX_NUMBER), DECODE(A.ORG_ID,’XX’,’IM US OU’,’XXX’,’IM CANADA OU’) OU_NAME FROM RA_CUSTOMER_TRX_ALL A ,…

Read More

how to define currency in oracle r12

To define a new currency: Go to GL Responsibility Navigate to the Currencies window. Setup >> Currencies >>Define

Read More

Calendar creation

Path: General ledger super user > Setup > Financials > Calendars > Types Step 1: Creating calendar type S1: while entering into types it will open automatically S2: Enter period…

Read More

Add Shortcut key to Apex IG

1. Overview This document will be helpful to add shortcut key for Add row and filter in Interactive Grid. 2. Technologies and Tools Used The technology used is JavaScript 3.Architecture Steps…

Read More

API for Supplier/ Vendor Site Creation in R12

Overview:- In this post , I am sharing the example how to create Supplier Site through Oracle Standard API. You can refer this code to create suppliers through backend in…

Read More

API for Supplier/ Vendor Creation in R12

Overview:- In this post , I am sharing the example how to create Supplier through Oracle Standard API. You can refer this code to create suppliers through backend in oracle…

Read More

AP Aging Report Query in Oracle Apps

Overview:- In this post , We will discuss about AP aging report query in oracle apps. The AP aging report helps us to identify the creditor aging which is due…

Read More

WEB ADI Run-time error 91”

When the users trying to open the downloaded web adi template, they are getting the run time error 91 …when opening web adi .We need to follow the below procedure…

Read More

Working With Oracle APEX_LANG

1. Overview This document talks about how to use the APEX_LANG.MESSAGE API & also teach how can we define a message for each desired language. 2. Technologies and Tools Used The following technology has…

Read More