Oracle Apps Technical Stuff
Tuesday, June 29, 2021
FA:SQL: Oralce Fusion Manufacturing Manage Scheduels/Schedule Exceptions/ Work Order Definition
›
REM Manage Schedules SELECT DISTINCT cal.schedule_name , zssp.schedule_id calendar_code , zssv.shift_id shift_n...
Friday, February 26, 2021
SQL to get the RMA Details In Oracle Fusion (Inventory/Order Management)
›
SELECT DISTINCT iop.organization_code warehouse_code , haotl.name warehouse_name , rt.subinventory ...
SQL to get Material Transaction Details (Oracle Fusion Inventory Management)
›
SQL to get Material Transaction Details SELECT iop.organization_code warehouse_code , ittv.transaction_type_name , flva.meaning t...
Monday, December 14, 2020
Oracle Fusion: Anonymous blocks (Procedural Call) data model in Oracle BI Publisher (Oracle Fusion)
›
BI Publisher supports executing PL/SQL anonymous blocks. You can perform calculations in the PL/SQL block and return the result set. BI Pub...
Wednesday, November 18, 2020
How to Enable Audit Trail On Tables
›
Example to enable Audit Trail on HZ_PARTIES and HZ_CUST_ACCOUNTS tables: a. Responsibility: System Administrator Navigation: Profile ...
‹
›
Home
View web version
