The below is the query for AR Transaction Register Summary Report at Line Level SELECT hou.name ou_name, c.account_number “Customer Number”, ( SELECT party_name FROM apps.hz_parties WHERE party_id = c.party_id…
Read MoreEmployees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreError: Below Oracle Homes are already registered in the global inventory: /u01/oracle/R122/fs1/FMW_Home/oracle_common /u01/oracle/R122/fs1/FMW_Home/webtier /u01/oracle/R122/fs1/FMW_Home/Oracle_EBS-app1 Cause: The above Oracle Homes are already registered from the global inventory Solution: Make sure that…
Read MoreProblem: If adoacorectl.sh,adformsctl.sh,adoafmctl.sh not coming up after start the application services adoacorectl.sh: exiting with status 150 adformsctl.sh: exiting with status 150 adoafmctl.sh: exiting with status 150 Check the log file…
Read MoreProblem details: The Concurrent program is getting completed successfully, able to view output & logfile. But in the log file, it shows below error. Oracle error 20100: java.sql.SQLException: ORA-20100: Error:…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.8 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.3 to 12.1.0.1 [Release 10.2 to 12.1] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud…
Read MoreSales Order GST Tax Category Setup for Sales Order Transaction I will try to explain about Sales Order GST Tax SETUP using Oracle Financial for India and will do a…
Read MoreKIT ITEM and BOM Setup for Sales Order Transaction. I will try to explain about KIT SETUP using Inventory & BOM and will do a simple Sales Order Transaction using that Kit…
Read Moresecurity-rule-setup-in-fusion This post explains how to configure the security rule in Oracle cloud.
Read More