SaveSavedRemoved 1

Oracle Forms Interview Questions|2021

Before we see Oracle Forms Interview Questions let's get some background. Oracle Forms is a great UI development tool from Oracle Corp and has been in use for decades. It is very useful to develop on-premise custom screen for transaction handling and processing. Oracle forms was also called developer 2000 in ...

READ MORE +

SaveSavedRemoved 0

15 Important Oracle Workflow tables

EBS is an old war horse in managing enterprise business and with focus shifting to cloud applications, co-existence with Oracle Ebusiness suite is Key. Troubleshooting business processes requires knowledge of oracle workflow tables. Either its integration with cloud application or customizing EBS, you will need to ...

READ MORE +

SaveSavedRemoved 0

50+ New Oracle Apps Technical Interview Questions

Welcome ! If you are starting out in Oracle E-business Suite aka Oracle EBS there are lot of technical area you may need to cover. Even if you have gone through some training these Oracle Apps Technical Interview Questions will help you to get an understanding of what is expected from a apps technical resource in ...

READ MORE +

Check it Out

SaveSavedRemoved 0

How to Insert Image in BI Publisher Report in Fusion and EBS

Insert Image in BI Publisher Report: Inserting or adding images in the RTF of BI Publisher is a requirement that is frequently asked during developing reports. Since it requires some specific codes to be embedded, it's worth keeping a note of it. There are some scenarios where an image is required to be embedded ...

READ MORE +

SaveSavedRemoved 0

7 Key Difference between CASE and DECODE in Oracle

Sometimes Difference between CASE and DECODE in Oracle is a little puzzling as to what to use and when. While working with data you may need to write SQL for complex reporting which requires CASE and DECODE functionalities. Most of the PL SQL developers have this question of when to use CASE and ...

READ MORE +

SaveSavedRemoved 0

Create Order Hold in EBS

OE_HOLDS_PUB.Apply_Holds There are times when business wants to put a sales order on hold based on some specific conditions. There are public apis available for applying hold on an order. you can execute the oe_holds_pub.Apply_Holds api for a sales order and it can be called from your calling programs like ...

READ MORE +

SaveSavedRemoved 31

Oracle EBS Integration Interfaces

Oracle EBS has an enormous footprint with Enterprise Customers and with the advent of Cloud, there are many businesses looking to migrate to Cloud SaaS products. Obviously, businesses have strong reasons to move to the cloud but most of the migration path will require the on-premise applications to still run till ...

READ MORE +

SaveSavedRemoved 0

Supplier Upload EBS

Using hz_imp_parties_int interface CREATE OR REPLACE PACKAGE idc_supplier_upload_pkg AS PROCEDURE idc_supplier_insert (P_BATCH_ID VARCHAR2, P_SYSTEM VARCHAR2, P_SUPPLIER VARCHAR2, P_PARTY_NAME VARCHAR2, P_ADDRESS VARCHAR2, P_CITY VARCHAR2, P_STATE VARCHAR2, P_POSTAL VARCHAR2, P_COUNTRY VARCHAR2, P_CONTACT ...

READ MORE +

SaveSavedRemoved 0

Billing Extension using Pa_Billing_Pub

Package Specification CREATE OR REPLACE PACKAGE IDC_Billing_Ext AS /*Procedure GetCurrentRevenue( X_project_id NUMBER, X_task_Id NUMBER DEFAULT NULL, X_revenue_amount OUT NOCOPY REAL); Procedure GetCurrentINVAmount( X_project_id NUMBER, X_task_Id ...

READ MORE +