Posts by Venkatesh Balasubramanian

Oracle Sql to get Profile Option Values at Responsibility level

Introduction This Post illustrates the steps required to get Profile Option Values at Responsibility level in Oracle EBS R12 Script to get Profile Option Values at Responsibility level SELECT frv.responsibility_name, fpo.profile_option_name, fpot.user_profile_option_name,…

Read More

How to Convert Comma Separated Values into Table using ‘REGEXP_SUBSTR.’

Introduction This Post is about to  Convert Comma Separated Values into Table using WITH CSV’ REGEXP_SUBSTR.’ AS (SELECT ‘AA,BB,CC,D33D,EE,FFDD,MM,GG’ AS csvdata FROM DUAL) SELECT REGEXP_SUBSTR (csv.csvdata, ‘[^,]+’, 1, LEVEL) pivot_char…

Read More

API to Update Customer Account in TCA R12

Introduction This Post is about to Update Customer Account in TCA R12.   Script to Update Customer account in TCA R12. DECLARE p_cust_account_rec      HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE; p_object_version_number NUMBER; x_return_status   …

Read More

Report Will Fetch All Vat Details In The Ap Module

Introduction This Post is about to Report Will Fetch All VAT details in the AP Module in Oracle EBS-R12.   <dataTemplate name=”IRNGLBFRTVAAP” version=”1.0″> <parameters> <parameter name=”P_ACCT_FROM_DT” dataType=”DATE”/> <parameter name=”P_ACCT_TO_DT” dataType=”DATE”/>…

Read More

Query for Employee data extraction based on business group

Introduction This Post illustrates the steps required to Extract the employee data based on business group in Oracle EBS R12 Script to Employee data extraction based on business group SELECT hou.name                business_unit,…

Read More

Query for PO Blanket details along with receipt and Indian tax details

Introduction This Post illustrates the steps required to PO Blanket details along with receipt and Indian tax details in Oracle EBS R12.   Script to PO Blanket details along with…

Read More

REVENUE TRANSFER REPORT (FUSION)

Introduction This Post illustrates the steps required to get the Revenue Transfer Report in Fusion Application. Script to REVENUE TRANSFER REPORT (FUSION) Purpose of this report is to derive all projects…

Read More

Untitled

Introduction This Post illustrate steps required to India AR GST tax report in Oracle EBS R12.   Query to India AR GST tax report . WITH Parameter AS (SELECT :Transaction_Start_Date…

Read More

Script to get Oracle i-expense Line attachments

Introduction This Post illustrates steps required to get Oracle i-expense Line attachments in Oracle EBS R12.   SELECT fl.* FROM apps.fnd_documents_tl        fdtl, apps.fnd_documents         …

Read More

Receivables to GL Link in 11i

Introduction This Post is about to Receivables to GL Link in 11i.   SELECT je_header_id, line_number, trx_number, myrank, item_number,customer_number, customer_name, SOURCE, CATEGORY, batch_name,transaction_date, posted_date, period_name, currency_code,account_number, description, CASE WHEN my…

Read More