Financials Accounting Hub (FAH) in R12

Oracle Financials Accounting Hub (FAH) allows us to create detailed, auditable, reconcilable accounting from a variety of source systems, later FAH can be integrated with PeopleSoft GL or Oracle GL based on the requirement. Assumption is that we would loading the data from the 3rd Party System/Application into our Custom defined Headers and Line Tables … Continue reading

Exposing Custom PL/SQL Package as Oracle REST Web Service

With this article would like to share the information on how a Custom PL/SQL Package or Data can be exposed using Oracle Provided REST Web Service. Click the Link: Exposing Custom PLSQL Package as Oracle REST Web Service Thanks!!!!!!! Please share the feedback for the information shared…!!!!

File Comparison in RUN and PATCH Edition for Oracle r12.2.* File System

Here I am going to help you all with a simple Shell Script that would compare the two file system available. As you all are aware that with Oracle R12.2.* upgrade, Oracle has introduced and come up with two File System one is RUN and the other one is PATCH. Now in my project I … Continue reading

Oracle Provided PATCH Analyzer for Oracle Provided PATCH’s

Hey, With this article of mine I would like to guide you through the steps that are involved to analyze a PATCH that is suggested by Oracle for the impact set of files in our current working system. Note the Patch Analyzer is a built in tool provided by oracle I am just guiding through … Continue reading

Oracle Project Accounting R12 Basics

Hey, Here is an article for understanding and gaining the basics of Oracle Project Accounting R12. Link: Project Accounting Basic Details Thanks !!!

Difference Between Oracle R12.2 and R12.1 Release

Some difference that I came across between Oracle R12.2.5 and R12.1.3, Though these are simple differences and many might be aware of these changes. But wanted to bring it forward with these few bullet points below: Online Patching – R12.2 has 3 File System – RUN – FS1, PATCH – FS2 and FS_NE FS Non Edition … Continue reading

Simple Debugging Mechanism for PL/SQL Code Pack.

This article would help us while we trying to debug any existing package or trying to understand the functionality of a existing PL/SQL Object. Though its very simple but this 3 steps would easy guide you to debug when asked to do so. — Table Creation Script CREATE TABLE apps.xx_log_tbl ( name VARCHAR2 (100), msg … Continue reading

Password Protection for PDF Output (XML Publisher Output) Generated from a Concurrent Program

How to enable Password Protection for a PDF Output when invoked from a Concurrent Program which is build using XML Publisher Tool Link: Password Protect PDF Output generated from Concurrent Program Please do share your feedbacks its highly appreciated…  Thanks…

Masking the Data for a Column for a Specific Schema using the RLS Policy

Here is the link Masking the Data for a Column for a Specific Schema using the RLS Policy Thanks !!!!!

Setting MOAC Compliance using RLS Policy for a Custom Object

Continuing with the concept of MOAC that was shared in my earlier article “MOAC (MULTI ORG ACCESS CONTROL)”,going forward if by any chance you would like to add a Custom Created Object to MOAC Compliance. Refer the Link: Setting MOAC Compliance using RLS Policy for a Custom Object Thanks….