Skip to main content

The Cool Fox

Oracle Cloud Technologies Blog

Home
Site Map
Oracle OCI
Oracle OIC
Oracle VBCS
Oracle Fusion
Oracle VBS
Oracle ADF
Oracle SOA
Oracle Apps
Oracle OAF
Oracle SQL

Showing posts with the label Oracle

Posts

[Fusion] REST API to upload attachments to AP Invoices in Oracle Fusion

on April 06, 2026

Oracle Oracle ERP Oracle ERP Cloud Oracle Fusion

+

Get link
Facebook
X
Pinterest
Email
Other Apps

[Fusion] How to Query Lookup Types and Values in Oracle Fusion Cloud?

on February 24, 2026

Fusion BIP Oracle Oracle Cloud Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials

+

Get link
Facebook
X
Pinterest
Email
Other Apps

[Fusion] Important FND_APPLICATION in Oracle Fusion

on November 07, 2025

Oracle Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials

+

Get link
Facebook
X
Pinterest
Email
Other Apps

[OCI] How to Disable Multi-Factor Authentication (MFA) in Oracle Cloud Infrastructure (OCI)?

on May 20, 2025

OCI OCI Security Oracle Oracle cloud Infrastructure Oracle OCI

+

Get link
Facebook
X
Pinterest
Email
Other Apps

[OCI] How to Reset Multi-Factor Authentication (MFA) in Oracle Cloud Infrastructure (OCI)?

on May 11, 2025

OCI OCI Security Oracle Oracle cloud Infrastructure Oracle OCI

+

Get link
Facebook
X
Pinterest
Email
Other Apps

[OCI] Create an ATP Database instance in Oracle Cloud

on May 11, 2025

Autonomous Database Compute Instance OCI OCI Compute Oracle Oracle ATP Oracle cloud Infrastructure Oracle OCI Virtual Machine

+

Get link
Facebook
X
Pinterest
Email
Other Apps

[OAF] Run Programmatic Code When a Drop-Down Value Changes in Oracle OAF

on April 19, 2025

Oracle Oracle Apps Oracle Apps R12 Oracle OAF

+

Get link
Facebook
X
Pinterest
Email
Other Apps

All Categories

Account Hierarchy1 Accounting Flexfields1 AP Invoices1 API2 ASCII1 Autonomous Database1 BIP7 BIP Refresh Time1 BIP Report1 Business Unit1

Call Fusion BIP Report2 Change Password1 Code Combinations2 Compute Instance2 Customer1 Data Aggregation2 Database5 Date Conversion1 DB Adapter2 Decryption1 Development1 EBS4 Encryption1 ESS Jobs3 Examine1 FBDI3 Fusion APIs1 Fusion BIP4 GIT2 GL3 GL Journals1 GL_DAILY_CONVERSION_TYPES1 GL_DAILY_RATES1 ICS1 Identity Domain1 Integrations1 Java1 Journal Import1 Keys1 Legal Entity1 LookupTypeLOV1 LOV1 LOVs1 MultiPartAPIs1 Networking1 NVL2 NVL in OIC2 OCI10 OCI Compute5 OCI Events Service1 OCI Free Tier2 OCI Notifification Service1 OCI Security2 OIC4 OIC Mapper2 Oracle21 Oracle ADF17 Oracle APEX1 Oracle Apps59 Oracle Apps R126 Oracle ATP1 Oracle BIP7 Oracle Cloud10 Oracle Cloud Free Tier1 Oracle cloud Infrastructure8 Oracle Cloud Security2 Oracle Cloud VM1 Oracle DB4 oracle ebs5 Oracle ERP3 Oracle ERP Adapter2 Oracle ERP Cloud7 Oracle financials2 Oracle Forms1 Oracle Fusion55 Oracle Fusion BIP3 Oracle Fusion ERP15 Oracle Fusion Financials16 Oracle Integration Cloud3 Oracle OAF17 Oracle OCI13 Oracle OIC22 Oracle SOA 12c10 Oracle SQL16 Oracle VBCS1 Oracle VBS2 Oracle Visual Builder Cloud Service1 Oracle Visual Builder Studio2 Oracle Workflow Notifications1 Others10 Payables Import1 Properties1 R121 Register BIP as ESS Job1 Reset Password1 Responsibility1 REST4 Security List1 Site Map1 SOAP2 SOAP API2 SOAP UI3 SQL15 SQL Functions3 SQL Queries14 SQL Query8 SQL Tips3 SSH1 TCA1 Value Sets1 VBCS1 Virtual Machine2 Virtual Machines1 XML1 XSLT1

Show more Show less

Gurpreet Singh - Oracle ACE.

Total Pageviews

Search This Blog

Popular Posts

Understanding .properties file for ERP Bulk Import Jobs in Oracle Integration Cloud (OIC)

In this post, we will understand how to import FBDI files using OIC and how to create .properties file for the process. To import FBDI file using OIC we need two files: FBDI zip file .properties file While working with ERP Adapter in OIC, we select the below option to Import FBDI in Oracle Fusion Cloud. Then we select the Bulk Import Process name Here we selected Import Journals process. Make a note of Import Job Name and...

[Fusion] How to Import Payables Invoices in Oracle Fusion Cloud?

Importing Payables invoices is a common requirement in every Oracle Fusion implementation — especially during data migration or when integrating with external systems like OIC, third-party ERPs, or legacy platforms. In this post, I’ll walk you through the complete process of importing Payables invoices , including key interface tables , required jobs , and troubleshooting tips . 🧩 Step 1: Load Data into Interface Tables Before importing, your invoice data must be inserted into the Payables Open Interface Tables : Table Name Purpose AP_INVOICES_INTERFACE Holds invoice header information such as Supplier, Invoice Number, Invoice Date, Amount, etc. AP_INVOICE_LINES_INTERFACE Holds invoice line-level details such as Item, Description, Amount, Distribution Account, Tax, etc. These ta...

SQL Query to get Code Combination Segment Value Description in Oracle Fusion (Invoice Tables)

In this post, we will see how to get Segments Description in Oracle Fusion. For this, we will take example of Code Combination available on AP_INVOICES_ALL table in column ACCTS_PAY_CODE_COMBINATION_ID . We can also use other Code Combination columns available in other Invoices table: To get the concatenated segments we can use the below function: GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL ( v_chart_of_account_id , v_segment_number , v_segment_value ); So, to get segments descriptions for ACCTS_PAY_CODE_COMBINATION_ID in table AP_INVOICES_ALL use the below SQL: SELECT aia . invoice_id , aia . invoice_num , aia . description , aia . invoice_type_lookup_code , aia . source , aia . invoice_date , aia . invoice_amount , aia . accts_pay_code_combination_id , gcc .segment1 , gl_flexfields_pkg.get_description_sql( gcc . chart_of_accounts_id , 1 , gcc .segment1 ) segment1_desc , gcc .s...

[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...

[Fusion] SQL query to get GL Journal details of AP Invoice Payment in Oracle Fusion

This post will show how to get GL Journal details of AP Invoice Payment in Oracle Fusion, i.e. how to get details of accounting details of AP Invoice payment, by navigating from AP_INVOICES_ALL all the way to GL_JE_HEADERS We will start from AP_INVOICES_ALL and select one of the invoices: SELECT * FROM ap_invoices_all aia WHERE aia.INVOICE_ID = 2896 ; Use AP_INVOICE_LINES_ALL to get details of invoice lines by passing INVOICE_ID from above query: SELECT * FROM ap_invoice_lines_all aila WHERE aila.INVOICE_ID = 2896 ; AP_INVOICE_PAYMENTS_ALL contains records of invoice payments that you made to suppliers Use AP_INVOICE_PAYMENTS_ALL by passing INVOICE_ID from above query: SELECT * FROM ap_invoice_payments_all aipa WHERE aipa.INVOICE_ID = 2896 ; AP_CHECKS_ALL stores information about payments issued to suppliers or refunds received from suppliers Use AP_CHECKS_ALL by passing CHEC...

Powered by Blogger

All rights reserved