Welcome to Cool Fox! This blog has the following posts, click the link to open it:
Oracle OIC
- 01-Oracle Integration Cloud (OIC)-Create Oracle Cloud Free Account (Video)
- 02-Oracle Integration Cloud (OIC)-Create Oracle Integration Cloud Instance (Video)
- 03-Oracle Integration Cloud (OIC)-Integration Styles and Packages (Video)
- Date Formats in OIC Mapper
- Split String in OIC
- How to call BIP Report from Oracle Integration Cloud (OIC)?
- How to add new line character in Oracle Integration Cloud (OIC) Mapper?
- [OIC] How to use NVL in SQL query while using DB Adapter in Oracle Integration Cloud?
- [OIC] How to create REST Integration with Pagination in Oracle Integration Cloud?
- [OIC] Purge Oracle Fusion Interface Data using OIC
- [OIC] Working with OAuth and Multi Part payloads in OIC
- [OIC] How to wait for the completion of the previous job triggered in Oracle Fusion before submitting the next job using OIC Integration?
- Sign Up for Oracle Cloud Free Tier Account
- [OCI] How to create new Identity Domain in Oracle Cloud Infrastructure (OCI)?
- [OCI] Working with Notification Service in OCI
- [OCI] Working with Event Service in OCI
- [OCI] How to create Linux based Compute Instance (Virtual Machine) and SSH to it in OCI?
- [OCI] How to use cloud shell to SSH to Linux VM in OCI?
Oracle Fusion
- SQL to get list of ledgers in given Ledger Set in Oracle Fusion
- Second Last Workday Query in Oracle Fusion
- Creating ATP Database
- SQL to get Business Unit Name or ID in Oracle Fusion
- SQL to get email address of Requisition Preparer in Oracle Fusion
- SQL to get roles assigned to user in Oracle Fusion
- Understanding Oracle Fusion Roles, Roles Hierarchy, Function Privileges
- Assigning Data Access Set to a user in Oracle Fusion
- How to set NLS DATE LANGUAGE in SQL query?
- Mapping between AP, XLA and GL tables in Oracle Fusion
- Importing AP Invoices using FBDI process in Oracle Fusion
- Create user in Oracle Fusion (Backend table details included). Know how to view First Name, Last Name, Email of fusion user.
- SQL to get first name, last name, email of user in Oracle Fusion
- How to call Oracle Fusion BIP Report from SOAP UI?
- Segment qualifiers in Oracle Fusion Financials Cloud
- How to hide buttons like Escalate, Suspend, Withdraw from Workflow Notification in Oracle Fusion Cloud?
- How to initiate Invoice Account Coding workflow in Oracle Fusion?
- Change workflow notifications refresh time in Oracle Fusion
- Import Segment Values and Segment Value Hierarchy in Oracle Fusion Cloud
- Understanding .properties file for ERP Bulk Import Jobs in Oracle Integration Cloud (OIC)
- Oracle Fusion Organization Classifications
- SQL Query to fetch Exchange Rates/Daily Rates (using GL_DAILY_RATES and GL_DAILY_CONVERSION_TYPES) in Oracle Fusion Financials
- SQL Query to get Concatenated Segments in Oracle Fusion (Invoice Tables)
- [Fusion] SQL query to get Bank Account Details of Supplier in Oracle Fusion
- [Fusion] How/Why to use PARTITION BY in Oracle SQL (GL BALANCE example)?
- [Fusion] How to use multi selection LOV in Oracle Fusion BIP Report?
- [Fusion] SQL Query to get BU Name, Legal Entity & Ledger Information of Customer Site in Oracle Fusion ERP
- [Fusion] SQL query to get GL Journal details of AP Invoice Payment in Oracle Fusion
- [Fusion] How to change password in Oracle Fusion?
Oracle SOA
Oracle Apps
- 1- Getting started with SOA 12c - Installation
- 2- Service Component Architecture (SCA) vs Service Oriented Architecture (SOA)
- 3- Mediator in Oracle SOA Suite 12c
- 4- Creating a new Oracle SOA 12c project
- 5- Installing SOA 12c - quick start
- 6- Oracle Mediator in SOA 12c (Routing and Transformation) and using File Adapter
- 7- Deploying and testing SOA Project
- 8- Oracle Mediator in SOA 12c- Validation (Using schematron file)
- How to access weblogic credential store in SOA?
- Generating Unique Identifier in SOA
Oracle Apps
- SQL to get concurrent program details in Oracle Apps
- SQL query to get all request stages of request set with Executable details in oracle apps
- SQL query to get custom top location in Oracle Apps
- Understanding Flex Fields with Accounting Flexfields(Chart of Accounts) in Oracle Apps (Presentation)
- Important SQL Queries of Flex Fields
- What is Messaging System? (Video and Presentation)
- Using Multiple WHEN clause in SQL Loader
- How to reset Oracle Apps user password through backend?
- How to set CLIENT_INFO in oracle apps?
- Profiles in Oracle Apps
- How to convert data in table to XML
- Using OKS_STATUS_CHANGE_PUB.change_status to change status of Service Contract
- Using OKS_IMPORT_HEADER_PUB.update_contract_header to update Description, Comments, Start Date and End Date of Service Contract
- Using OKS_IMPORT_LINE_PUB.update_contract_line to update Service Contract Line's Start and End Date
- Using OKS_CASCADE_ATTRIBUTES_PUB.oks_cascade_attributes to cascade line dates to sub line of Service Contract
- FND_CONCURRENT_REQUESTS.REQUEST_TYPE meanings
- SQL Query to get database version info and clone date in Oracle Apps
- Reset the password of user in Oracle apps
- Commonly Used Look Up Types in Oracle Apps
- Profile option to enable Help->Diagnostics->Examine in Oracle Apps
- SQL Query to get concurrent program's parameter details
- XML Publisher Concurrent Program explained (with SQL and tables)
- SQL Query to get EBS URL and EBS Version
- Difference between GV$SESSION and V$SESSION
- Troubleshooting Long Running Requests in Oracle Apps
- SQL Query to Get Request Group and Responsibility Name of concurrent program in Oracle Apps
- SQL to split the word in Oracle with specified delimiter (with example of GL segment qualifiers)
- SQL to insert lookup values from backend in Oracle Apps R12
- How to clear cache in Oracle EBS R12?
- Get on-hand, reserved & available to transact quantity of item for given order in Oracle Apps R12
- SQL to get profile option values at responsibility level in Oracle Apps R12
- SQL Query to get customer account email addresses in one row in Oracle Apps R12 - Demonstrating XMLAGG Function
- Order-level sales credit total () must equal 100% error while booking sales order if created using OE_ORDER_PUB.PROCESS_ORDER in Oracle Apps R12
- OE_ORDER_HEADERS_ALL Column Details in Oracle Apps
- Print functions available in any responsibility in Oracle Apps R12
- SQL Query to get Balance Due amount on AR Invoice
- Important SQL Queries of Order Management (OM) in oracle apps r12
- SQL query to get details of Installed Base (IB) record from Sales Order
- Workflow Background Process in Oracle Apps
- Important SQL Queries of Order Management (OM) in oracle apps r12
- Auto Invoice Program in Oracle Apps to create AR Invoices
- Sourcing Rules Technical (Backend) details in Oracle Apps R12
- Troubleshooting "SFM Event Manager Queue Service" in Oracle Apps R12
- Query To Get Bill To and Ship To details from Install Base (IB) Item Instance Number in Oracle Apps R12
- Install Base (IB) Important Queries in Oracle Apps R12
- HZ_RELATIONSHIPS SUBJECT_ID and OBJECT_ID explanation
- Skipping Export Screening for any order in Oracle Apps R12
- Sales Order Flow table details in Oracle Apps R12
- Open any URL from Oracle Apps Responsibility's Function
- [EBS] SQL Query to get Request Set Stages and Parameter Details
Oracle ADF
- Find Oracle Middleware Home Location used by jdeveloper
- Enable Java Heap Memory Monitor in JDeveloper
- Fix java.lang.OutOfMemory Java Heap Space error in JDeveloper
- Install Enterprise Manager (EM) in JDeveloper Integrated Weblogic Server at localhost
- Show Line numbers in Oracle jDeveloper Code Editor
- Oracle ADF one day training (Presentation)
- Changing preference to open pages in Source View instead of Design View in Oracle jDeveloper
- Collapse or Expand the source code block in Oracle JDeveloper
- Clearing Oracle JDeveloper temp and cache directory with hotkeys
- Change look and feel of Oracle JDeveloper to Windows
- Disabling features in Oracle JDeveloper to improve the performance
- Disable auto build on save in Oracle JDeveloper to improve performance
- Use Fast Swap feature in Oracle Jdeveloper to speed up the development
- Change the priority of Oracle JDeveloper to improve performance
- Boost up Oracle JDeveloper Performance
- Programmatically sorting the data of View Object in Oracle ADF
- Creating Login Page in Oracle ADF
Oracle OAF
- XMLImporter command for deploying the OAF Page
- 01-Getting started with OAF: Installing JDeveloper and Setting up OA Workspace
- 02- Hello World page in OAF
- 03-OAF Architecture
- 04-Search Pages in Oracle OAF
- 05-Result Based Search in Oracle OAF
- 06-Auto Customization Criteria Search in Oracle OAF
- 07-Manual Search in Oracle OAF
- 08-How to invoke Application Module Impl Java file's method from Controller Java File in Oracle OAF?
- 09-How to set where clause to the view object from Controller Java File in Oracle OAF?
- 10-How to create LOV (Independent) in Oracle OAF?
- 11-How to change default web browser used to run OAF Page in Jdeveloper?
- [EBS] OAF Profile Options in Oracle Apps
Others
- Setup hotkeys to remove temp files
- Change width of sidebar in Dynamic Views Template in blogger
- Important GIT Commands
- Test
- Show full context menu (like in Windows 10) in Windows 11
Comments
Post a Comment