oracle payables

Creating Zero Amount Payments in Oracle Fusion Payables

Introduction/ Issue:  In Oracle Fusion Payables, there are scenarios where invoices get fully adjusted through credit memos, prepayments, or rounding adjustments. Although the invoice balance becomes zero, the invoice may…

Read More

Create Bank and Bank Branch Using API

When 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 More

AP Pre Payments Query: AP XLA GL

SELECT glcc.segment1 COMPANY,  glcc.segment2 LOCATION,  glcc.segment3 COST_CENTER,  glcc.segment4 ACCOUNT,  glcc.segment5 PRODUCT_LINE,  glcc.segment6 CHANNEL,  glcc.segment7 PROJECT,  (SELECT flex_value    || ‘ ‘    || fvt.description  FROM apps.ap_invoices_all ap1,    apps.gl_code_combinations glc,    apps.fnd_flex_values fv,    apps.fnd_flex_values_tl…

Read More

AP Distribution Query: AP XLA GL

SELECT glcc.segment1 company, glcc.segment2 LOCATION,       glcc.segment3 cost_center, glcc.segment4 ACCOUNT,       glcc.segment5 product_line, glcc.segment6 channel,       glcc.segment7 project,       (SELECT flex_value || ‘ ‘ || fvt.description          FROM apps.ap_invoices_all ap1,               apps.gl_code_combinations glc,               apps.fnd_flex_values fv,               apps.fnd_flex_values_tl…

Read More