How to get previous year and future year value using EXTRACT and CONNECT BY LEVEL in Oracle Database
How to pass comma separated values as input parameter in BIP – Oracle Fusion Applications
Sample Code →Read more
how to show tabs in multiples rows in Notepad++
Settings -> Preferences -> General -> Tab bar -> Multi-line →Read more
APPS_TS_TX_DATA — Workflow Table Space Error
ORA-01653: unable to extend table APPLSYS.WF_NOTIFICATION_ATTRIBUTES by 1024 in tablespace APPS_TS_TX_DATA [[WFENG_ERR_PROC_ERROR]: ORA-01403: no data found] where TABLESPACE_NAME=’APPS_TS_TX_DATA’; select bytes from V$DATAFILE where NAME =’/u01/oracle/VIS/data/tx_data27.dbf’; alter databasedatafile ‘/u01/oracle/VIS/data/tx_data27.dbf’ resize 2000M; →Read more
DrillDown/DeepLinks in OTBI
•Deep Links are URL links that can be distributed outside of Fusion Applications and allow users to open pages without navigating through a menu structure. •In order to see a complete list of the available Deep Links, use the Deep Links work area (Navigator > Tools > Deeps Links) within Fusion Applications. •In order to […] →Read more
Oracle APEX Print Report- 24.1 Latest Feature
•Applications à Shared Componentsà Files and Reports •Report Layout •Report Queries •Generic Columns à Layout is generated by APEX automatically •Named Columns à Layout should be designed explicitly in (docs/rtf) format and to be uploaded Report Queries Create Button – Action : Print Report →Read more
Oracle APEX Metadata Views
•APEX Views are data dictionary views that expose the metadata for applications. •There are two ways of getting the view names : •1. App Builder à Workspace Utilities à Oracle APEX Views 2.Using DB View : apex_dictionary →Read more
Bulk Upload Lookup Types and Lookup Codes – Oracle Fusion ERP
Lookup Type File. Header Description Required or Optional LookupType This value displays the lookup type. Required Meaning This value displays the name of the lookup type. Required Description This value displays the description of the lookup type. Optional ModuleType This value displays the module associated with the lookup type. Required ModuleKey This value displays the […] →Read more
Sample Test
https://sg2plzcpnl492052.prod.sin2.secureserver.net:2096/cpsess1268546195/webmail/jupiter/index.html?login=1&post_login=7705580283162 paul@oratrainings.com qNh=!kuO&P_E sdfasd – IOD_ORGANIZATION_NAME SUBINVENTORYIOD_ORGANIZATION_NAMECIT_SUBINVENTORY_CODE INVENTORY_ORG_CODE →Read more