Why i am getting error : Table with name INEFFICIENCIES cannot be found?

Hi,

Just read documentation, flag as best answer and upvote if helped :)

Link1: https://docs.celonis.com/en/getting-started-with-the-accounts-payable-starter-kit.html

Link2: https://docs.celonis.com/en/activating-the-value-discovery-app.html#UUID-b5b44171-1124-49af-60a4-a807db6c82f5_UUID-e6430fcd-ba5c-db95-6e46-c82a33f78ba0

TLDR: create transformation, paste there below code, execute it, add created table into DM, reload DM.

Code:

DROP TABLE IF EXISTS INEFFICIENCIES;

CREATE TABLE INEFFICIENCIES (

  INEFFICIENCY_NAME VARCHAR(100),  

TIME_TO_VALUE VARCHAR(100),  

BUSINESS_OBJECTIVE VARCHAR(100))

;

INSERT INTO INEFFICIENCIES

(INEFFICIENCY_NAME,TIME_TO_VALUE,BUSINESS_OBJECTIVE)

SELECT 'Duplicate Invoices','A - Low','Spend' UNION

SELECT 'Lost Cash Discount','A - Low','Spend' UNION

SELECT 'Early Payments','B - Medium','Working Capital' UNION

SELECT 'Late Payments','A - Low','Labor Productivity' UNION

SELECT 'Manual Invoice Posting','C - High','Labor Productivity' UNION

SELECT 'Short Payment Terms','B - Medium','Working Capital' UNION

SELECT 'Manual Payment Block Changes','B - Medium','Labor Productivity' UNION

SELECT 'Manual Invoice Clearing','C - High','Labor Productivity' UNION

SELECT 'Manual Payment Term Changes','B - Medium','Labor Productivity' UNION

SELECT 'Invoices w/ Retrospective POs','A - Low','Spend' UNION

SELECT 'Invoices without Purchase Order','A - Low','Spend' UNION

SELECT 'Manual Baseline Date Changes','B - Medium','Labor Productivity' UNION

SELECT 'Baseline Date Decreases','B - Medium','Working Capital' UNION

SELECT 'Payment Term Decreases','B - Medium','Working Capital' UNION

SELECT 'Unfavorable Payment Terms','B - Medium','Working Capital' UNION

SELECT 'Multiple Payment Terms per Vendor','B - Medium','Working Capital'

Best Regards,

Mateusz Dudek

Thanks Mateusz!!

I have created the INEFFICIENCIES table using the given in document. Now I am getting error

"undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES_AUGMENTED_FRAMED_VALUE cannot be found."

Kindly help on this.

I have the same problem, after the creation of the INEFFICIENCIES table, I'm still have the error "Table could not be found. Table with name INEFFICIENCIES_AUGMENTED_FRAMED_VALUE cannot be found"

how can we solve this problem?

regards

Has Anyone Found the solution for this error

"undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES_AUGMENTED_FRAMED_VALUE cannot be found."

im facing the same issue Kindly help on this.