Creating 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 MoreAPI to Load Values in Value Set
API to Load Values into Value Sets DECLARE —————————-Local Variables————————— l_enabled_flag VARCHAR2 (2); l_summary_flag VARCHAR2 (2); l_who_type FND_FLEX_LOADER_APIS.WHO_TYPE; l_user_id NUMBER := FND_GLOBAL.USER_ID; l_login_id NUMBER := FND_GLOBAL.LOGIN_ID; l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; l_value_set_value FND_FLEX_VALUES.FLEX_VALUE%TYPE;…
Read MoreEmployee Import API
CREATE OR REPLACE PACKAGE BODY XX_IMPORT_EMPLOYEES_NEW IS PROCEDURE XX_create_employee IS CURSOR Cur0 IS SELECT MESSAGE,ROWID FROM XX_PER_ALL_PEOPLE_F_INT WHERE TO_CHAR(INTERFACE_DATE,’DD-MON-YY’) …
Read MoreGL & XLA Queries
— GL & XLA Query SELECT glcc.concatenated_segments ACCOUNT, ac.customer_number, ac.customer_name, xlal.currency_code, xlal.accounted_dr accounted_dr, xlal.accounted_cr accounted_cr, xlal.entered_dr, xlal.entered_cr, h.je_category transaction_type, xlal.accounting_class_code, xlal.accounting_date transaction_date, h.period_name je_period_name, xlate.transaction_number transaction_number FROM gl_je_batches b, gl_je_headers…
Read MoreUpdate the Project Status using API
Introduction: This blog has the SQL Script to update the Project Status using API along with each task. Cause of the issue: To update status of the project and…
Read More