Yearly Archives: 2021

Lower Deduction Cost

Lower Deduction Cost Details Introduction: This report will provide LDC details. Cause of the issue: To get the remaining amount pan wise. How do we solve: So, extract the LDC…

Read More

Oracle EBS SSO Benefits ?

1. Users don’t have to remember dozens of passwords for Oracle e-Business Suite – 11i, 12.1, and 12.2. 2. Weak passwords in Applications are no longer allowed. Welcome123 and Oracle123…

Read More

Schedule Statspack Report Generation.

Declaration : In this scripts using for schedule statspack report generation for hourly, frequently and purge weekly snapshots. Statspack is instead of AWR because AWR report is licensed.   Script:…

Read More

How to Define a PROJECT in FUSION Applications

How to Define a PROJECT in FUSION Applications When we are implementing Fusion Applications for any of our client, we can refer this document, by looking at this document, we…

Read More

Oracle Fusion – How to Create an Implementation User

Oracle Fusion – How to Create an Implementation User   When we are implementing Fusion Applications for any of our client, we can refer this document, how we how we…

Read More

Plan Creation Flow in Config Snapshot

Plan Creation Flow in Config Snapshot   We have Config Snapshot tool to automate the migrations from one instance to another instance with less time and with minimal manual effort.…

Read More

Open Purchase Orders for specific OU or a Ledger

Open Purchase Orders for specific OU or a Ledger Below is the script which can be used to extract the Open Purchase Orders for a specific operating unit and the…

Read More

Creating Object Library OLB in Oracle D2k Form

Step – 1 Create a form in form builder and create objects like Data Block, Canvases, Windows, Program Units etc. as shown in below image. Step – 2 Then Highlight…

Read More

Script for Fixed Assets Books Close Status

Script for Fixed Assets Books Close Status In generally FA need to be closed before the GL is closed.. in some cases if the business is not following the process…

Read More

Create a New PL/SQL Library

The steps in this section will show you how to create a new PL/SQL library, then create a function that will live in this library. To create the library: Launch…

Read More