Identify table details of Custom Object In – Application Composer – Oracle Fusion
by admin
•Using : adf_extensible_table Table Approach * SNO Table Detail Column Description 1 ADF_EXTENSIBLE_TABLE_USAGE ENTITYDEF_FULLNAME Custom Object Name 2 ADF_EXTENSIBLE_TABLE TABLE_ID Join with TABLE_ID of Table Mentioned in SNO 1 3 ADF_EXTENSION_COLUMN_USAGE TABLE_USAGE_ID Join with TABLE_USAGE_ID of Table Mentioned in SNO 2 4 ADF_EXTENSION_COLUMN COLUMN_ID Join with COLUMN_ID of Table Mentioned in SNO 3 →Read more
Submit Concurrent Program (XML Report) Using PLSQL in Oracle E-Business Suite
Settings -> Preferences -> General -> Tab bar -> Multi-line →Read more
APPS_TS_TX_DATA — Workflow Table Space Error
by admin
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
by admin
•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
by admin
•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
by admin
•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