BI Publisher Bursting Report Output To UCM Channel
Data Model Bursting Query for UCM Report Please watch the below video for detailed discussion : →Read more
Dynamically Configure Oracle Fusion BIP Report URL – with : https://#{header[“host”]}
• https: Specifies the use of HTTPS protocol. •#{}: It is used to interpolate or inject dynamic content into strings. •header[“host”]: Refers to the value of the “host” key in the HTTP request’s header. The “Host” header field specifies the domain name of the server (or its IP address). •So, https://#{header[“host”]} will dynamically be replaced […] →Read more
OAF Cook Book
——-PO Report ——-LOV Value ———- SELECT segment1 FROM PO_HEADERS_ALL —Query SELECTpha.po_header_id, pha.segment1 po_number, pha.DOCUMENT_STATUS, pha.TYPE_LOOKUP_CODE,pla.list_price, pla.LINE_TYPE_ID, pla.LINE_NUM, pla.ITEM_DESCRIPTION, pla.UOM_CODE,pla.UNIT_PRICE, pla.QUANTITYFROM PO_HEADERS_ALL pha , PO_LINES_ALL plawhere 1=1and pha.po_header_id = pla.po_header_idAND (pha.segment1 IN (:P_PO_NUMBER) OR least(:P_PO_NUMBER) IS NULL) →Read more
How to design XML Report with Dependent ValueSet Parameters – Oracle E-Business Suite R12.*
Data Model XML ValueSet : XXORA_AR_INV_BU_ID ValueSet 2 : XXORA_AR_INV_CUST_ID Concurrent Program : XXORA AR Invoice XML Report Parameters : →Read more
Oracle Fusion User Details Based on Role Query
EBS Concurrent Program Error APPS-FND-01564: error 6502
It occurs due to the issue in the value set – make sure the lenght values are consistent in Concurrent Program and ValueSet Definition →Read more
Query to get Concurrent Program Details in Oracle EBS
How to create Concurrent Program based on PLSQL Procedure
Create PLSQL SPEC and Body as shown below Create Concurrent Executable Create Concurrent Program Assign the Concurrent Program to a request group (find the request group the responsibility) Run the Concurrent Program →Read more
Oracle E-Business Suite AOL Objects Queries
AOL Messages : Used for Warning, Information, Error Purposes in : PLSQL, Forms, OAF and Reports Lookup Values – Used in Reports, Workflow, Forms, OAF Pages etc ValueSet – Reports, Forms, Workflow, OAF Pages etc →Read more