Yearly Archives: 2024

Cisco – Hot Standby Router Protocol (HSRP)

Introduction: This blog explains about the Cisco Hot Standby Router Protocol (HSRP) feature. What is HSRP? HSRP stands for Hot Standby Router Protocol. This is a Cisco proprietary protocol. HSRP…

Read More

Query to get details of all Concurrent programs used by a Request Set

Introduction:-This script will provide all concurrent programs under request set Code:- SELECT rs.user_request_set_name “Set_Name”, rs.request_set_name “Set_code”, rs.description “Description”, rss.display_sequence Seq, cp.user_concurrent_program_name “Conc_Program”, ap.application_name “Application”, e.executable_name “Executable”, e.execution_file_name “Executable File”, lv.meaning…

Read More

Country wise Catalog and Non Catalog Po’s in Oracle EBS

Introduction:- Using the below SQL script we can get the Catalog and Non Catalog Po’s details from country wise. Code:- SELECT P.SEGMENT1 “PO Number” ,PL.LINE_NUM “PO Line”,TO_CHAR(P.CREATION_DATE,’DD-MON-RRRR HH24:MI:SS’) “PO Created…

Read More

XML Publisher Bursting Barcode Font is Ignored

In XML Publisher Bursting Barcode Font is Ignored. An XML Publisher concurrent program that produces a PDF output with barcodes works when running the concurrent program and viewing the output.…

Read More

BoM Interface

BoM-Interface

Read More

BoM Components Drill Down Query

bom-components-drill-down-query

Read More

Corporate Card Transaction amount is not appearing amount field.

Introduction: Corporate card transaction amount is not showing in the user’s profile. The user should have these two roles of access in their account: travel manager or employee. Why we…

Read More

To update the invoice distribution accounting date. 

To update the invoice distribution accounting date.  The business mistakenly entered the GL accounting date Jun-26 instead of Nov-23 and the invoice is cancelled. We are updating the invoice distribution…

Read More

Remove all BU access in the Cash Management

Introduction/ Issue: Cash Management data security is NOT partitioned by Business Unit, therefore its security policies allow access to all BUs. Why we need to do We noticed that when…

Read More

To create a new check payment template

To create a new check payment template  Prerequisites setup to create a new check payment template:  Create a new “payment document” in bank account   Create a new “Payment Process Profile” …

Read More