SELECT ( SELECT organization_name FROM org_organization_definitions WHERE organization_id = msi.organization_id ) org_name, msi.segment1 item_number, msi.description item_description, msi.primary_unit_of_measure, –msi.item_type, ( SELECT flv.meaning FROM apps.mtl_system_items_b msb, apps.fnd_lookup_values flv WHERE lookup_type = ‘ITEM_TYPE’…
Read MoreSELECT gjjlv.period_name “Period Name”, gjb.name “Batch Name”, gjjlv.header_name “Journal Entry For”, gjjlv.je_source “Source”, gjjlv.je_category “Category”, glcc.concatenated_segments “Accounts”, nvl(gjjlv.line_entered_dr,0) “Entered Debit”, nvl(gjjlv.line_entered_cr,0) “Entered Credit”, nvl(gjjlv.line_accounted_dr,0) “Accounted Debit”, nvl(gjjlv.line_accounted_cr,0) “Accounted Credit”, gjjlv.currency_code…
Read MorePass the from and to date parameter. select USER_CONCURRENT_PROGRAM_NAME,REQUEST_DATE,CNTPERDAY,week_no, case when week_no=1 then sum(CNTPERDAY) OVER (PARTITION BY USER_CONCURRENT_PROGRAM_NAME,week_no) else 0 end week_no_1, case when week_no=2 then sum(CNTPERDAY) OVER (PARTITION BY…
Read MoreIntroduction This blog explains how to create user and add responsibility for a user from the backend. #Code# DECLARE lc_user_name VARCHAR2(100) := RAJAN_TEST’; lc_user_password VARCHAR2(100) := ‘Oracle123′; ld_user_start_date DATE :=…
Read MoreBy default IR region allows to either enable Download button to all users or disable Download button to all users. Suppose if there is a requirement to enable/disable download button…
Read MoreBy default the Interactive Reporting Region allows end users to customize reports. This interactive reporting region allows users to customize the layout of the data by choosing the columns they…
Read MoreOverview: Below query give the form personalization details. Query: SELECT DISTINCT a.ID, a.SEQUENCE, a.function_name, a.form_name, a.enabled, c.user_form_name, d.application_name, a.description, a.trigger_event, a.trigger_object, a.condition, ca.* FROM fnd_form_custom_rules a, fnd_form b, fnd_form_tl…
Read MorePL/SQL Anonymous Block to update Customer GST number: As we do not have any Standard API / Process to update the GST number in Oracle, the only way to correct…
Read MoreOracle AP/AR Netting allows you to net your Payable invoice balances against your Receivables invoice balances for those Customers who are also your Suppliers. If you have a customer who…
Read MoreInvoice Validate is also one another step to ensure/Validate the Invoice Data by the System user before it submits for the Payment. Invoice Validation also validates the required information that…
Read More