Yearly Archives: 2021

GST P2P TRANSACTION SETUP

GST P2P TRANSACTION SETUP STEP 1 :-Define Purchase Tax Category Navigator:- Oracle Finance > Tax Configuration > Define Tax Category Create Tax Category same for other Categories. ( below is example for one category). STEP 2-Define Third Party Registration Navigator:- Oracle Finance > Party Registrations > Define Third Party Registration Select Party Type:- (Supplier) & then click on New. Fill all Registrations details & Reporting Code – Tax Type Intra State or Inter State Tax  and Save. STEP 3 -Define Item Classification  Navigator:-…

Read More

Oracle Fusion Configuration – General Ledger

Tile: Oracle Fusion Configuration – General Ledger Manage Currencies Manage Accounting Calendars Manage Chart of Accounts Value Sets Manage Chart of Accounts Structure —-> Create Segments —–> Assign Chart of…

Read More

Query to handle with zero if no onhand quantities in Inventory or onhand is NULL

Objective: Query to handle with zero if no onhand quantities in Inventory or onhand is NULL   SQL: Select NVL(MAX(COUNT(moq.TRANSACTION_QUANTITY)),0) –MAX(NVL(SUM(moq.TRANSACTION_QUANTITY),0)) from mtl_onhand_quantities moq, MTL_ITEM_LOCATIONS_KFV mil, mtl_system_items_b msib where moq.LOCATOR_ID…

Read More

If else xdoxslt function syntax -RTF

The normal behavior of if-else condition looks like If <contion> then <value> –for true condition else <value> end in RTF it can be achieved using following syntax <?xdoxslt:ifelse(condition,true,false)?> Example <?xdoxslt:ifelse(ADDRESS1=SENDOR_NAME,’’,ADDRESS1)?>

Read More

Interactive Grid Selected IDs based on selection

1. Overview This Document is used to get selected IDs from the Interactive grid based on selection. 2. Technologies and Tools Used The following technologies have been used to achieve…

Read More

Oracle Fusion Rapid Implementation: (Financials)

Oracle Fusion Rapid Implementation: (Financials) Rapid Implementation is an Excel (Spreadsheet). These features help to upload the setup data in Oracle Cloud in a more easy way. It will cover…

Read More

Exporting User Objects Using SQL developer

There will be scenarios like the developer wants to export the DDL/Data of user objects like Table, View, Packages, Functions, Procedures, Trigger, etc. Using SQL developer you can export all…

Read More

Steps to configure Oracle Database server with Apache tomcat

Step to configure Oracle Database server with Apache tom 1) Copy Oracle Jar file ojdbc14.jar (or) ojdbc6.jar till the lib directory to tomcat server 2) Modify the parameters in the…

Read More

Step to configure MYSQL with apache tomcat

Step to configure MYSQL with apache tomcat: 1) Copy mysql connection jar file to catalina_home lib directory 2) Configure that database parameter in server.xml file, resource name resource type, java…

Read More

Futuristic Benefits of EBS Migration to Cloud

The Oracle E-Business Suite (EBS) offers advanced business functionalities to various enterprises. With Oracle Cloud Infrastructure, you can reap enormous benefits such as faster execution, efficient performance, and cost-effective features.…

Read More