The Cool Fox

Sales Order Flow table details in Oracle Apps R12

on October 08, 2022

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

All Categories

Account Hierarchy1 Accounting Flexfields1 API2 ASCII1 Autonomous Database1 BIP7 BIP Refresh Time1 BIP Report1 Call Fusion BIP Report2 Change Password1

Code Combinations2 Compute Instance2 Data Aggregation2 Database5 Date Conversion1 DB Adapter2 Decryption1 Development1 EBS3 Encryption1 ESS Jobs3 Examine1 FBDI3 Fusion APIs1 Fusion BIP3 GIT2 GL3 GL Journals1 GL_DAILY_CONVERSION_TYPES1 GL_DAILY_RATES1 ICS1 Identity Domain1 Integrations1 Java1 Journal Import1 Keys1 LookupTypeLOV1 LOV1 LOVs1 MultiPartAPIs1 Networking1 NVL2 NVL in OIC2 OCI9 OCI Compute5 OCI Events Service1 OCI Free Tier2 OCI Notifification Service1 OCI Security1 OIC3 OIC Mapper2 Oracle17 Oracle ADF17 Oracle APEX1 Oracle Apps58 Oracle Apps R125 Oracle ATP1 Oracle BIP6 Oracle Cloud9 Oracle Cloud Free Tier1 Oracle cloud Infrastructure7 Oracle Cloud Security2 Oracle Cloud VM1 Oracle DB4 oracle ebs4 Oracle ERP2 Oracle ERP Adapter2 Oracle ERP Cloud6 Oracle financials2 Oracle Forms1 Oracle Fusion46 Oracle Fusion BIP2 Oracle Fusion ERP10 Oracle Fusion Financials10 Oracle Integration Cloud3 Oracle OAF17 Oracle OCI12 Oracle OIC21 Oracle SOA 12c10 Oracle SQL16 Oracle VBCS1 Oracle VBS2 Oracle Visual Builder Cloud Service1 Oracle Visual Builder Studio2 Oracle Workflow Notifications1 Others10 Properties1 R121 Register BIP as ESS Job1 Reset Password1 Responsibility1 REST3 Security List1 Site Map1 SOAP2 SOAP API2 SOAP UI3 SQL14 SQL Functions3 SQL Queries13 SQL Query8 SQL Tips3 SSH1 Value Sets1 VBCS1 Virtual Machine2 Virtual Machines1 XML1 XSLT1

Show more Show less

[Fusion] Passing Default Value to Date Parameters in Oracle BIP Reports

Oracle BIP Reports allow users to generate data-driven insights with dynamic parameters. One common requirement is to set default values for date parameters so users can run reports without manually selecting dates. This blog post explains how to set default values for date parameters in Oracle BI Publisher (BIP) reports. Steps to Pass Default Value to Date Parameters For this demonstration, I have created a Data Model with below SQL Query: SELECT :P_DATE FROM DUAL Also, Updated the date format string to dd-MMM-yyyy to display dates in the format 15-Apr-2025 for better readability and consistency. When clicking on View Data , the data parameter is currently coming as blank To enhance functionality, we want it to automatically populate with the current system date if no value is provided. To achieve this functionality we can write {$SYSDATE()$} in the Default Value text box: Now, when you click on View Data you will see the current date automat...

Changing preference to open pages in Source View instead of Design View in Oracle jDeveloper

Whenever we open files like JSP Page Fragments, JSP Pages, HTML code, etc. they always open in Design view instead of source code which makes large files or files with many components to load slower. So, do we have any way which enables Jdeveloper to open files directly in Source Code view instead of opening the Design editor? Yes, we can change this default setting. To change this setting follow these steps: Go to Tools Menu, then click Preferences Preferences dialog will appear. In files Files Types section, switch to Default Editors Tab. Select the file type for which you want to change the default editor and then change the editor from Default Editor drop down at the bottom. For example, here we have changed the default editor of JSP Source file type to Source. So from now whenever you open any file of type JSP Source, JDeveloper will open its source code instead of design view.

Use Fast Swap feature in Oracle Jdeveloper to speed up the development

You can use Fast Swap feature in Oracle Jdeveloper to speed up the development. To enable this feature use the below steps: Go to Tools Menu, then click Preferences Preferences dialog will appear. Click Run -> Weblogic and select Fast Swap radio button.

Boost up Oracle JDeveloper Performance

Have you ever faced performance issues while working in Oracle JDeveloper like slowness, memory errors, etc? If yes then following steps can improve and boost up your Oracle JDeveloper performance 1. Clearing Oracle JDeveloper temp and cache directory with hotkeys Oracle JDeveloper keeps on creating temp, cache and history files. So as a best practice to boost up your JDeveloper performance keep deleting the files frequently. Every time you can't go these directories to manually delete the files, so you can assign hotkeys to perform this delete operation. Click here to see how? 2. Changing preference to open pages in Source View instead of Design View in Oracle JDeveloper Whenever we open files like JSP Page Fragments, JSP Pages, HTML code, etc. they always open in Design view instead of source code which makes large files or files with many components to load slower. So, do we have any way which enables Jdeveloper to open files directly in Source Code view ins...

[VBCS] Creating Oracle Visual Builder Cloud Service (VBCS) instance?

Oracle Visual Builder Cloud Service (VBCS) is a cloud-based development platform that allows developers to rapidly create and deploy web and mobile applications with a low-code approach. Use Cases: Custom Application Development - For organizations looking to develop tailored applications quickly without extensive coding. Extension of Oracle SaaS Applications - Enhancing and extending the capabilities of existing Oracle SaaS applications like Oracle Fusion Applications. Rapid Prototyping - Quickly building and iterating on application prototypes to validate ideas and gather feedback. To start working with VBCS, we need an instance. There are two ways we can provision VBCS instance, by: Enabling VBCS for an OIC instance Creating standalone VBCS instance Enabling VBCS for an OIC instance Login to the OCI console and navigate to already created OIC instance. Follow this link to know how to create OIC instance. Below is the instance that we have alrea...

Clearing Oracle JDeveloper temp and cache directory with hotkeys

Oracle JDeveloper keeps on creating temp, cache and history files. So as a best practice to boost up your JDeveloper performance keep deleting the files frequently. Every time you can't go these directories to manually delete the files, so you can assign hotkeys to perform this delete operation. Follow the below steps to setup hotkeys: Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto Help -> About -> Properties Tab and search for ide.system.dir this is system directory In the system directory, there are two directories which need to be cleaned: .diagnostics and .history Now create the following batch file (.bat) with above-copied directories....

Change look and feel of Oracle JDeveloper to Windows

To change the look and feel of Oracle JDeveloper to Windows, follow these steps: Go to Tools Menu, then click Preferences Preferences dialog will appear. In the Environment section, change the Look and Feel from Oracle to Windows

How to create List Of Values (LOV) using SQL Query in BIP ESS Job in Oracle Fusion?

In this post we will look at how to create List Of Values (LOV) using SQL Query in BIP ESS Job In previous post we had defined an ESS Job from BIP Report with one parameter Invoice Source. Now we will make this parameter as LOV. In Manage Enterprise Scheduler Job Definitions , go to Manage List of Values Sources tab and click on Add button Select the Application Name as Application Toolkit , LOVType as User Defined . Enter the LOV Source Name, description and enter below query then click Save and Close button SELECT rownum AS LOV_ID , NAME FROM ( SELECT DISTINCT source NAME FROM ap_invoices_all ) ORDER BY 2 LOV will be saved with LOV Definition Name as sessiondef.oracle.apps.atk.essMeta.model.publicView.INV_SRCAtkEssLOVVO Now we can assign this LOV to o...

Disable auto build on save in Oracle JDeveloper to improve performance

By default whenever you save any file, Oracle JDeveloper will build your code which can reduce the performance if you frequently click Save. To disable this follow the below steps: Go to Tools Menu, then click Preferences Goto Code Editor Section and select Save Action. Make sure that there is no action in both the areas: before and after. If there is any action in these areas, delete it using the delete buttons.

[OCI] Understanding Network Security Group in Oracle Cloud (OCI)

When designing secure and flexible cloud architectures in Oracle Cloud Infrastructure (OCI), Network Security Groups (NSGs) are one of the most powerful tools you can use. If you've worked with Security Lists before, think of NSGs as the more flexible and precise version, giving you fine-grained control over traffic at the resource level . 🛡️ What is a Network Security Group (NSG)? A Network Security Group (NSG) is like a private security team assigned to specific cloud resources in OCI—like virtual machines (VMs), databases, and load balancers. Instead of applying broad traffic rules across an entire subnet (like Security Lists), NSGs let you define custom security rules for individual resources or groups of resources . 🏠 Real-World Analogy Imagine you live in a housing society: The main gate rules (e.g., all guests must sign in) apply to everyone—this is like a Security List for the whole subnet. But you also hire your own private guard just for your house wit...

Powered by Blogger

Sales Order Flow table details in Oracle Apps R12

Comments

Post a Comment

All Categories