Oracle Apps Quick Reference

This BLOG might be helpful for oracle application beginners and technical developers. The BLOG post’s screen shots & source codes may distinguish from versions. If the code/steps fail please check with oracle guides or meta-links.

Monday, December 5, 2022

Oracle Cloud Fusion: Supplier Bank Accounts Query

SELECT (SELECT NAME FROM hr_operating_units WHERE organization_id = pssm.prc_bu_id) BU_name, ps.segment1 supplier_nu...

Oracle Cloud Fusion: Query to get the Supplier/Site Attachment Details

-------------------------------------------------------------------- -- Supplier Attachment ------------------------------------------------...

Friday, April 5, 2019

Fusion: How To Exclude the BI Report’s Schedule Frequency From Holidays

BI Report scheduling frequency can be skipped based on the localized public holidays or weekends using by report triggers. Pre-Requisites ...

Saturday, March 9, 2019

Fusion: How To Create Password Protected BI Publisher Report

Goal How to create password protected BI publisher report outputs (pdf). Solution There are two types of password protected outputs (pdf) c...

Wednesday, February 1, 2017

Employee / Contingent Worker Termination API (Sample Script)

EMPLOYEE Termination DECLARE -- --Common Variables l_terminate_emp_flag VARCHAR2 ( 1 ) ...

View web version

About Me

Sankar Balu: Chennai, Tamil Nadu, India

View my complete profile

Powered by Blogger.