Skip to content

oracleappshelp.com

Node.JS Blogs

  • MongoDB
  • Oracle R12
  • SOA Suite 12c
  • ADF 12c
  • Interview Questions
  • Node.js
  • ReactJS

Categories

  • ADF Issues
  • Angular JS
  • AP- Account Payables
  • Architecture
  • cloud computing
  • Databases
  • Devops
  • FA – Fixed Assets
  • Interview Questions
  • Java
  • Java Basics
  • Java Springs
  • JavaScript
  • JDeveloper
  • MongoDB tutorial
  • Node.js tutorial
  • OM- Order Managment
  • Oracle ADF
  • Oracle Apps
  • Oracle General Ledger
  • Oracle Receivables
  • Oracle SOA
  • ReactJS Tutorial
  • SQL Server
  • System Administrator
  • WebLogic
  • XML Tutorial

Popular Tutorials

  • MongoDB
  • Oracle R12
  • SOA Suite 12c
  • ADF 12c
  • Interview Questions
  • Node.js
  • ReactJS

Pages

  • MongoDB Tutorial for beginners
  • Oracle ADF 12c Tutorials for beginners
  • Oracle EBS R12 Tutorials
  • Oracle SOA Suite 12c Tutorials for beginners
  • React JS Programming Tutorial for beginners
  • RSS Feed
  • Style Components in React JS

Tag: AP_SELF_ASSESSED_TAX_DIST_ALL

Oracle EBS R12 SQL to get AP invoices posted to GL

18 Jun 2016 oracleappsadmin

The blog provides the Oracle EBS R12 SQL to get AP invoices posted to  General Ledger (GL). The Account Payables (AP) Invoices should be validated and Posted for AP reconciliation during month end period closure.  Few are the validations given below which are being used to ensure that the Invoice has been accounted with approved Status and Posting Status.

Oracle EBS R12 AP invoice Status

There are 4 invoice status asĀ  given below
‘S’ – Selected
‘P’ – Partial
‘N’ – Unposted
‘Y’ – Posted

  1. Check  and ensure that the Invoice Id entry should be in the table – AP_INVOICE_DISTRIBUTIONS_ALL
  2. Check  and ensure that the Invoice Id entry should be in the table – AP_SELF_ASSESSED_TAX_DIST_ALL
  3. Check if DIST VAR hold is placed on this invoice. DIST VAR Hold  could be placed  when no distributions exist and the invoice status should be NEEDS REAPPROVAL
  4. Check and ensure that there is NO Hold applied on the Invoice
  5. Check if the Invoice is NOT Cancelled
  6. Check Table – AP_INVOICE_DISTRIBUTIONS_ALL for the Invoice ID match_status_flag IS NOT NULL and count should be 0

SQL to get AP Invoices Validated but Not Posted to General Ledger (GL)

SELECT INVOICE_NUM
FROM AP_INVOICES_ALL
WHERE AP_INVOICES_PKG.GET_APPROVAL_STATUS
(INVOICE_ID,
INVOICE_AMOUNT,
PAYMENT_STATUS_FLAG,
INVOICE_TYPE_LOOKUP_CODE
) ='APPROVED'
AND AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID)='N

SQL Query to get AP Invoices Validated & Posted to General Ledger (GL)

SELECT INVOICE_NUM
FROM AP_INVOICES_ALL
WHERE AP_INVOICES_PKG.GET_APPROVAL_STATUS
(INVOICE_ID,
INVOICE_AMOUNT,
PAYMENT_STATUS_FLAG,
INVOICE_TYPE_LOOKUP_CODE
) ='APPROVED'
AND AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID)='P'

AP- Account Payables AP_INVOICE_DISTRIBUTIONS_ALL, AP_SELF_ASSESSED_TAX_DIST_ALL, DIST VAR status NEEDS REAPPROVAL, Invoice GET_APPROVAL_STATUS, Invoice ID match_status_flag IS NOT NULL

Meta

  • Register
  • Log in

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • July 2019
  • June 2019
  • May 2019
  • May 2018
  • April 2018
  • November 2017
  • April 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • June 2014
  • May 2014
  • March 2014
  • September 2013
  • May 2013
  • September 2012
  • June 2012

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • July 2019
  • June 2019
  • May 2019
  • May 2018
  • April 2018
  • November 2017
  • April 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • June 2014
  • May 2014
  • March 2014
  • September 2013
  • May 2013
  • September 2012
  • June 2012

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • July 2019
  • June 2019
  • May 2019
  • May 2018
  • April 2018
  • November 2017
  • April 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • June 2014
  • May 2014
  • March 2014
  • September 2013
  • May 2013
  • September 2012
  • June 2012

Powered by WordPress. Theme: Brawny by Webulous Themes

Recent Posts

  • How to create legal entity registration in Oracle Fusion
  • Query to get organization structure details in Oracle Fusion General Ledger
  • Assign Legal Entities and Balancing segments in Oracle Fusion
  • Create Legal Entity in Oracle Fusion
  • How to Create Implementation Project in Oracle Fusion
  • Purchase Requisition BPM Approval Workflow Tables in Oracle Fusion
  • Query to get Oracle Fusion Payables Cloud approver comments
  • How to create implementation user in Oracle Fusion
  • Functional Setup Manager in Oracle fusion
  • Top 50 AJAX Interview Questions and Answers