Item Where-Used Analysis Report (Excel – PL/SQL)
Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based report…
Read MoreProcedure to create Quality Test Values alone in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Test Values alone using oracle seeded API. Cause of the issue: Business will…
Read MoreProcedure to create Quality Spec WIP Validity Rule in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Spec WIP Validity Rule using oracle seeded API. Cause of the issue: Business…
Read MoreDiagnosing oacore stuck thread Issues in Oracle EBS 12.2
Overview: In Oracle EBS 12.2 environments, it’s not uncommon to face login failures or form loading issues. These are often caused by oacore server anomalies in WebLogic. This blog walks…
Read MoreCreating a New Modifier using Oracle API
When there is a business requirement to create a New modifier, we can make use of this code to Register as a Concurrent Program and create a new Modifier after…
Read MoreCustomizing the Hook Package IBY_FD_EXTRACT_EXT_PUB
Oracle Payments provides the IBY_FD_EXTRACT_EXT_PUB extensibility package to construct custom XML element structure that can be added to the payment XML extract generated by Oracle Payments. If there is…
Read MoreDelivery is Shipped Status but Order is Not Closed
Delivery is Shipped Status but Order is Not Closed Introduction In Oracle EBS, there are instances where a delivery reaches the Shipped status, but the associated Trip remains open. This…
Read MoreExtracting Data for Oracle Supply Chain Planning Cloud
Extracting Data for Oracle Supply Chain Planning Cloud – Steps to Customize the Integration Logic Introduction Oracle Supply Chain Planning (SCP) Cloud is a powerful tool for demand forecasting,…
Read MoreQuery to extract Active BOL_NOTES for all Active Customers
SELECT hp.party_name “CUSTOMER_NAME”, fdv.category_description “Catergory Description”, fdv.document_id, fdv.title, fdst.short_text, fdst.media_id, oarev.attribute_name, oarev.attribute_valfdst.short_textue FROM apps.fnd_documents_vl fdv, apps.fnd_documents_short_text fdst, apps.oe_attachment_rules_v oarv, apps.oe_attachment_rule_elements_v oarev, apps.hz_cust_site_uses_all hcsua, apps.hz_cust_acct_sites_all hcasa, apps.hz_cust_accounts hca, apps.hz_parties hp WHERE…
Read MoreQuery for Project & Change Order Approval Action History:
SELECT ROWNUM, ACTION_DATE, ACTION, from_user, from_role, to_user, to_role, Details, SEQUENCE, NOTIFICATION_ID, ACTION_TYPE FROM (SELECT ACTION_DATE, ACTION, from_user, from_role, to_user, to_role, Details, SEQUENCE, NOTIFICATION_ID, ACTION_TYPE FROM (SELECT c.comment_date DATE1, TO_CHAR(c.comment_date,’DD-MON-RRRR HH24:MI:SS’)…
Read More