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

→Read more

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

→Read more

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

Oracle Cloud ERP Implementation Acronyms

CSM – Customer Success Managers ISM – Implementation Success Managers SI – System Integrators / Implementation Partners P2T – Production to Test Copy T2T – Test to Test Copy →Read more

Oracle BIP – RTF Template- Display Amount In Words

•<?xdofx:expression?> •<?xdofx:to_check_number(amount, precisionOrCurrency, caseType, decimalStyle)?> •<?xdofx:to_check_number(INVOICE_AMOUNT , INVOICE_CURRENCY_CODE, ‘CASE_INIT_CAP’, ‘DECIMAL_STYLE_WORDS’)?> Attribute Description Valid Value amount The number to be transformed. Any number or Column name precisionOrCurrency For this attribute you can specify either the precision, which is the number of digits after the decimal point; or the currency code, which will govern the number of […] →Read more

Query to get Project and Tasks Details in Oracle Fusion ERP

→Read more

Flex Related Value Set Values Query – Oracle Fusion

→Read more