Yearly Archives: 2021

How to enable or disable the event oracle.apps.icx.security.session.created

How to enable or disable the event oracle.apps.icx.security.session.created   1. Login to E-Business and navigate to Workflow Administrator Web Application > Business Event.Search for oracle.apps.icx.security.session.created 2. Then click on clock…

Read More

Upload Blob Content without Page Submit

Overview This document talks about uploading Blob Content without Page Submit. This source code used in this document has been taken and modified from the following website, https://apexplained.wordpress.com/2016/09/12/chunked-multi-file-upload-with-ajax/. Technologies and…

Read More

Creating Customer in Oracle Fusion

creating-customer-in-oracle-fusion

Read More

AR Period Close Process and Open Close Accounting Periods in Oracle Fusion

This blog will describe about the AR period close process in Oracle Fusionar-period-close-process-and-open-close-accounting-periods-in-oracle-fusion

Read More

Apex Login Using Facebook (Social Sign In)

Assume that there is a requirement to set up a public login to an apex application using Facebook and Google. Using the Social Sign-In feature user can log in to…

Read More

How to Create New Responsibility In Oracle apps R12 ?

Navigation: System Administrator ? Security ? Responsibility ? Define   Enter the details   Responsibility Name: IM CO AP Period End Application: Payables Responibility_key: IM_CO_AP_PERIOD_END Description: IM CO AP Period…

Read More

OPM – Inventory Reconciliation Report

OPM – Inventory Reconciliation Report Introduction: This report will provide item wise inventory reconciliation value detail for period wise. Cause of the issue: Every month needs to be run the…

Read More

PLSQL Stored Procedure to calculate number of particular day between two input dates.

CREATE OR REPLACE PROCEDURE PR_TOT_DAYS ( P_START_DATE IN DATE, P_END_DATE IN DATE, P_DAY IN VARCHAR2, P_TOT_DAYS OUT NUMBER ) IS LV_LOOP NUMBER; LV_DATE DATE; LV_TOT_DAYS NUMBER := 0; BEGIN LV_LOOP…

Read More

How to set default value for Message Text Input

By using below command in controller, we can able to set default value to message Text Input.   import oracle.apps.fnd.framework.webui.beans.message.OAMessageTextInputBean; public void processRequest(OssAPageContext pageContext, OAWebBean webBean) { super.processRequest(pageContext, webBean); String…

Read More

Query to Fetch the Unapplied Receipts Report

Introduction This Query will help to Fetch the Unapplied Receipts Report Data SQL Query: SELECT COMPANY COMPANY, CASE WHEN CUSTOMER_NAME IS NULL THEN ‘ **** Unidentified’ ELSE CUSTOMER_NAME END CUSTOMER_NAME,…

Read More