Thursday, 9 January 2025

BIP Report VS OTBI Report

›
Oracle Fusion we have inbuilt feature Oracle Business Intelligence Enterprise Edition(OBIEE). In OBIEE we can create BIP Report and OTBI Rep...
Sunday, 29 December 2024

Accounts Payable (AP) period closing Process

›
In P2P cycle, Close Payables before closing Procurement to ensure that purchasing accruals are accounted for at period-end, especially for a...
Tuesday, 24 December 2024

Multiperiod accounting Concept in Oracle Fusion

›
Multiperiod accounting enables you to create accounting entries across more than one accounting period for a single accounting event. The fu...
Sunday, 17 December 2023

Basic SQL Queries

›
Delivery Tax Accounting entry extract query SELECT C.Name, C.JE_BATCH_ID, j.trx_id transaction_id,j.trx_number GRN,c.je_source, c.je_categor...
Monday, 20 November 2023

IRN Number generated/E- Invoicing proces

›
Perquisite:  Master India Connectivity Establishment Process Transaction Completion Trigger point Based on which Payload generate  In Json l...
Wednesday, 19 October 2022

FA Retirement Accounting Entry in Oracle apps R12

›
               Retirement:                 The following the accounting entry generated at FA Module Level and code combination           ...
Saturday, 6 August 2022

Project Module Concurrent Program handy

›
 The following concurrent Program should be run post entering Miscellaneous Cost in Project Module The following is the process to transfer ...
Sunday, 5 June 2022

Period Close Dependencies Modules in EBS R12

›
                                       Period Close Dependencies Modules The following is the Module wise sequence for the period closure i...
Monday, 8 November 2021

SQL Queries used for Data Import from Oracle Receivables

›
Query to exact  AR Invoice Data. SELECT  distinct hou.NAME OU_NAME,--HOU.organization_id, (select DISTINCT NAME from ra_batch_sources_all   ...
Friday, 27 December 2019

How to diagnose the performance issue in oracle apps R12.

›
1.   Trace - We run the trace based on particular activity. We require to generate trace based on particular activity like concurrent rep...
2 comments: