Payables and Cash Management - EBS (MOSC)

MOSC Banner

Problem with Spend Report query ?

edited May 5, 2015 10:03AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered

Hello,

We are on R12.1.3 and we use Vanilla oracle with no customisations.

We wrote this query on spend analysis report.

This query should bring out the details of all payments made on expense items ( we do not use inventory ) between certain date ranges.

However the below query is bringing an unsually large amount which is 5 times our spend.

Please help me in finding the problem with the query.

SELECT gcc.segment1 Fund,

    gcc.segment2 COST_CENTRE,

    sup.vendor_name supplier_name,

    sup.segment1 Supplier_number,

    sup.vendor_type_lookup_code,

    SUP.attribute11 SUPP_CLASSIFICATION1,

    SUP.attribute12 LEVEL_2,

    SUP.attribute13 LEVEL_3,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Payables Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center