Description: The below Post indicates the responsibility to check the AR Transactions Query on AR XLA GL SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product, glcc.segment6…
Read MoreDescription: Go to Shared Components, then click the images link and upload the image to the application. Click the Definition write the image name to logo text field as #WORKSPACE_IMAGES#company_logo.gif. Go to Page Template and add the LOGO prefix at the table.…
Read MoreDescription: The Interactive Reporting Region is an innovative new technology that allows end users to customize reports. By putting more power in the hands of users it reduces development time…
Read MoreDescription: This page explains the steps involved in generating the Colombia Third-party report balances. This process ensures the passage of the third party details to GL. This is mandatory…
Read MoreDescription: ICS is a global format for calendar files widely being utilized by various calendar and email programs, including Google Calendar, Apple iCal, and Microsoft Outlook. These files enable users…
Read MoreDescription: Oracle XML/BI Publisher is a very good reporting tool, which outputs reports into many formats like Word, Excel, PowerPoint, PDF and even to Adobe Flash. This can deliver reports…
Read MoreDescription: Query to get the details of invoice with tax information’s select ctx.customer_trx_id, case when ( hrloc.address_line_1 is not null and ( hrloc.address_line_2 is not null or hrloc.address_line_3 is not…
Read MoreDescription: Query to fetch Customer Statement of Account Details SELECT rc.customer_name “Customer_Name”, rc.customer_number “Customer_Number”, hou.NAME operating_unit, DECODE (ps.CLASS, ‘INV’, ‘Invoice’, ‘DM’, ‘Debit Memo’, ‘DEP’, ‘Deposit’, ‘CM’, ‘Credit Memo’, ‘PMT’, ‘Receipts’…
Read MoreDescription: Create items to set count of rows and display Step:1: Create items to set count of rows and display Item to represent pagination. Also, create buttons to navigate different…
Read MoreDescription: Losing Data During Validation In Apex Tabular Form Step:1: On Submit, Before Computation and Validation – Insert into Collections. BEGIN apex_collection.add_member (p_collection_name => ‘PDVD_MASTER_ITEM_DTLS’, p_c001 => apex_application.g_f03 (i), p_c002 …
Read More