SELECT r.je_header_id je_header_id, r.je_line_num je_line_num, 200 application_id, aeh.ledger_id set_of_books_id, ‘INV’ trx_class, l8.displayed_field trx_class_name, l1.displayed_field trx_type_name, i.invoice_type_lookup_code trx_type_c, i.invoice_num invoice_number, i.invoice_num trx_number_displayed, ael.description comments, fd.NAME doc_sequence_name,…
Read MoreAssignment Set: Once sourcing rules has been defined, you must assign them to particular items and/or organizations. These assignments are grouped together in assignment sets. In an assignment set you…
Read MoreSourcing Rule: Sourcing Rule Provides list of approved suppliers where we can rank the suppliers on a percentage basis. This is useful for the buyers/requestors at the time of making…
Read MoreStandard functionality in the SO Form, provides the On-Hand visibility of an Item at the Specific Inventory Org (Ship From Org) level. In case the Visibility is required as per…
Read MoreWhen performing Master Data Migration for Supplier or Customer business also needs the migration of Associated Banks and Bank Branches.In order to perform this we need to migrate Banks, Bank…
Read MoreValidating the Custom(User Entered) Exchange Rate à Need to Enable the setup in the Payable Options for Enabling the Exchange Rate or Functional Amount Columns if Exchange Type is “USER”…
Read Moreà Need to Create a new Procedure in the custom.pll à Need to find the Standard Lov name form the application by placing the cursor on the particular field form…
Read MoreDynamic Logo Chaining in BI Publisher Report Need to Created a Lookup where we can map the required Logo image names Need to create a formula column in report builder…
Read MoreSELECT TO_CHAR (trx_date, ‘DD-MON-YYYY’) ar_posting_date, TO_CHAR (jatt.excise_invoice_date, ‘DD-MON-YYYY’) excise_invoice_date, rcta.trx_number ar_trx_number, flv.meaning document_type, jatt.excise_invoice_no, hca.account_number cust_bill_to, hp.party_name cust_name,…
Read MoreStep1:Concurrent Program Create a Concurrent Program with Exceutable File Name as XDODTEXE Step:2 Data Xml Template Create a Data Xml Template for the Query Step:3 Data Definitions Create a Data…
Read More